Skip main navigation
Pending
  • Price cut: $109K (11/27)
    $2,089,000

    14700 N Locust Tree Rd, Lodi, CA 95240

    3beds
    2,573sqft
    : 
    Multi Family, Single Family Residence
    Built in 1990
    7.99 Acres Lot
    $1,961,500 Zestimate®
    $812/sqft
    $-- HOA

    What's special

    Sparkling poolPool houseLush vineyardBocce ball courtTemperature-controlled wine cellarBeautifully landscaped groundsDining area
    Welcome to your private estate, surrounded by your very own lush vineyard and beautifully landscaped grounds. At the heart you have the main residence offering 3 spacious bedrooms, including 2 ensuite retreats, and 3 full bathrooms. The chef's kitchen features premium appliances and a temperature-controlled wine cellar, while the expansive laundry room provides abundant cabinet storage and counter space. Step outside to a resort-style setting complete with a sparkling pool and pool house equipped with a full bathroom and fireplace plus a cabana, an outdoor kitchen/bar with pizza oven, and a bocce ball court for gatherings with family and friends. Car enthusiasts will appreciate the impressive garage space accommodating up to 15 vehicles, while every guest will enjoy the seamless blend of comfort and elegance throughout the property. Adding even more value, a two-story guest retreat features two large 1-bedroom, 1-bathroom residences, each with its own laundry room, luxurious kitchen, dining area, and living roomperfect for multifamily living, guests, or rental opportunities.
    159 days
    |
    211
    |
    0
    |

    Zillow last checked: 8 hours ago

    Listing updated: 18 hours ago

    Listed by:

    Lindsay Green DRE #02082264 916-531-8879,

    GUIDE Real Estate,

    Olivia Barrett DRE #01891361 916-952-6953,

    GUIDE Real Estate

    Source: MetroList Services of CA,MLS#: 225110528Originating MLS: MetroList Services, Inc.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 3
    • Full bathrooms: 3
    Primary bedroom
    • Features: Ground Floor, Walk-In Closet
    Primary bathroom
    • Features: Double Vanity, Tub
    Dining room
    • Features: Dining/Family Combo
    Kitchen
    • Features: Pantry Closet, Slab Counter, Kitchen Island, Stone Counters
    Heating
    • Central, Fireplace(s)
    Cooling
    • Ceiling Fan(s), Central Air, Wall Unit(s), Window Unit(s)
    Appliances
    • Included: Gas Cooktop, Built-In Refrigerator, Range Hood, Ice Maker, Dishwasher, Microwave, Double Oven, Warming Drawer
    • Laundry: Cabinets, Sink, Hookups Only, Inside, Inside Room
    Features
    • Flooring: Carpet, Concrete, Stone, Tile, Wood, Parquet
    • Number of fireplaces: 2
    • Fireplace features: Brick, Living Room, Raised Hearth, Family Room, Stone
    Interior area
    • Total interior livable area: 2,573 sqft

    Property

    Parking
    • Total spaces: 15
    • Parking features: Attached, Boat, Detached, Gated
    • Attached garage spaces: 15
    Features
    • Stories: 1
    • Exterior features: Outdoor Kitchen, Outdoor Grill, Fire Pit
    • Has private pool: Yes
    • Pool features: In Ground, Cabana, Pool/Spa Combo, Fenced
    • Fencing: Entry Gate,Gated Driveway/Sidewalks
    Lot
    • Size: 7.99 Acres
    • Features: Private
    Details
    • Additional structures: Cabana, Pool House, RV/Boat Storage, Pergola, Gazebo, Guest House
    • Parcel number: 063150110000
    • Zoning description: AG-40
    • Special conditions: Standard

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Multi Family, Single Family Residence
    Materials
    • Brick
    • Foundation: Slab
    • Roof: Cement,Tile
    Condition
    • Year built: 1990

    Utilities & green energy

    • Sewer: Septic Connected
    • Water: Well
    • Utilities for property: Sewer Connected

    Community & HOA

    Location
    • Region: Lodi

    Financial & listing details

    • Price per square foot: $812/sqft
    • Tax assessed value: $1,173,593
    • Annual tax amount: $13,517
    • Price range: $2.1M - $2.1M
    • Date on market: 8/22/2025
    Get pre-qualifiedBe ready to make an offer.
    Connect with an agentGet info on this home, tour, and more.
    Calculate monthly paymentSee if you can afford this home.

    Estimated market value

    $1,961,500

    $1.86M - $2.06M

    $1,640/mo

    Price history

    Price history
    DateEventPrice
    12/22/2025Pending sale$2,089,000$812/sqft
    Source: MetroList Services of CA #225110528 Report a problem
    11/27/2025Price change$2,089,000-5%$812/sqft
    Source: MetroList Services of CA #225110528 Report a problem
    10/19/2025Price change$2,198,000-12%$854/sqft
    Source: MetroList Services of CA #225110528 Report a problem
    8/22/2025Listed for sale$2,498,000+40.7%$971/sqft
    Source: MetroList Services of CA #225110528 Report a problem
    5/30/2024Listing removed--
    Source: Zillow Rentals Report a problem

    Public tax history

    Public tax history
    YearProperty taxesTax assessment
    2025$13,517 +2.6%$1,173,593 +2%
    2024$13,169 +1.9%$1,150,582 +2%
    2023$12,926 +2.2%$1,128,022 +2%

    Find assessor info on the county website

    BuyAbility℠ payment

    Est. payment
    $12,916/mo
    Principal & interest
    $10235
    Property taxes
    $1950
    Home insurance
    $731

      Climate risks

      Neighborhood: 95240

      Nearby schools

      GreatSchools rating

      Similar homes

      Skip to the end of the carouselSkip to the beginning of the carousel
      • Loading