$2,198,000
$300K PRICE DROP

14700 N Locust Tree Rd Lodi, CA 95240

Estimated payment $12,733/month

Total Views 26,486
3 Beds
3 Baths
2,573 Sq Ft
$854 Price per Sq Ft

Highlights

  • Guest House
  • RV Access or Parking
  • View of Trees or Woods
  • Pool House
  • Custom Home
  • Built-In Refrigerator

About This Home

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.

Listing Agent

Lindsay Green

GUIDE Real Estate License #02082264 Listed on: 08/21/2025

GUIDE Real Estate

Co-Listing Agent

Olivia Barrett

GUIDE Real Estate License #01891361

Property Details

Home Type

  • Multi-Family

Est. Annual Taxes

  • $13,517

Year Built

  • Built in 1990

Lot Details

  • 7.99 Acre Lot
  • Private Lot

Parking

  • 15 Car Attached Garage
  • RV Access or Parking

Property Views

  • Woods
  • Forest

Home Design

  • Custom Home
  • Brick Exterior Construction
  • Slab Foundation
  • Tile Roof
  • Fiber Cement Roof

Interior Spaces

  • 2,573 Sq Ft Home
  • 1-Story Property
  • Cathedral Ceiling
  • Ceiling Fan
  • Raised Hearth
  • Stone Fireplace
  • Brick Fireplace
  • Family Room with Fireplace
  • 2 Fireplaces
  • Family Room Downstairs
  • Living Room

Kitchen

  • Walk-In Pantry
  • Double Oven
  • Gas Cooktop
  • Range Hood
  • Warming Drawer
  • Microwave
  • Built-In Refrigerator
  • Ice Maker
  • Dishwasher
  • Kitchen Island
  • Stone Countertops

Flooring

  • Wood
  • Parquet
  • Carpet
  • Stone
  • Concrete
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • 3 Full Bathrooms
  • Secondary Bathroom Double Sinks
  • Bathtub

Laundry

  • Laundry Room
  • Sink Near Laundry
  • Laundry Cabinets
  • Washer and Dryer Hookup

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Pool

  • Pool House
  • Cabana
  • Pool and Spa
  • In Ground Pool
  • Fence Around Pool

Outdoor Features

  • Outdoor Kitchen
  • Fire Pit
  • Gazebo
  • Pergola

Additional Homes

  • Guest House

Utilities

  • Central Heating and Cooling System
  • Cooling System Mounted In Outer Wall Opening
  • Window Unit Cooling System
  • 220 Volts
  • Well
  • Septic System

Community Details

  • No Home Owners Association
  • Controlled Access

Listing and Financial Details

  • Assessor Parcel Number 063-150-11

Property Details

Home Type

Multi-Family

Est. Annual Taxes

$13,517

Year Built

Built in 1990

Lot Details

0

Parking

15

Listing Details

  • Property Type: Residential
  • Subtype Description: Custom, Luxury
  • Property Subtype 1: 2 Houses on Lot
  • Remodeled Updated: Unknown
  • Stories: 1
  • Year Built: 1990
  • Levels: One
  • Special Features: None
  • Property Sub Type: MultiFamily

Interior Features

  • Appliances: Gas Cook Top, Built-In Refrigerator, Hood Over Range, Ice Maker, Dishwasher, Microwave, Double Oven, Warming Drawer
  • Interior Amenities: Cathedral Ceiling
  • Fireplace Features: Brick, Living Room, Raised Hearth, Family Room, Stone
  • Fireplaces: 2
  • Flooring: Carpet, Concrete, Stone, Tile, Wood, Parquet
  • Master Bathroom Features: Double Sinks, Tub
  • Master Bedroom Features: Ground Floor, Walk-In Closet
  • Total Bathrooms: 3
  • Bathroom Features: Double Sinks
  • Dining Room Features: Dining/Family Combo
  • Family Room Features: View
  • Kitchen Features: Pantry Closet, Slab Counter, Island, Stone Counter
  • Living Room Features: View
  • Lower Level: Bedroom(s), Living Room, Dining Room, Family Room, Master Bedroom, Full Bath(s), Garage, Kitchen
  • Main Level: Bedroom(s), Living Room, Dining Room, Family Room, Master Bedroom, Full Bath(s), Garage, Kitchen
  • Price Per Square Foot: 854.26
  • Square Footage: 2573.00

Exterior Features

  • Other Structures: Pergola, Gazebo, Guest House
  • Construction Materials: Brick
  • Exterior Features: Kitchen, Built-In Barbeque, Fire Pit
  • Fencing: Entry Gate
  • Foundation: Slab
  • Home Warranty: No
  • Horse Property: No
  • Listing Price: 2198000.00
  • Lot Features: Private
  • New Construction: No
  • Pool Features: Built-In, Cabana, Pool House, Pool/Spa Combo, Fenced
  • Pool: Yes
  • Roof: Cement, Tile
  • Spa Features: Spa/Hot Tub Built-In, Spa/Hot Tub Personal
  • Spa: Yes
  • View Description: Forest, Woods
  • Land Use: Vineyard
  • Second Unit Kitchen: Yes

Garage/Parking

  • Garage Spaces: 15.00
  • Parking Features: Attached, Boat Storage, RV Access, Detached
  • Driveway/Sidewalks: Gated

Utilities

  • Security: Carbon Mon Detector, Smoke Detector, Secured Access
  • Sewer: Septic Connected
  • Utilities: Sewer Connected
  • Cooling: Ceiling Fan(s), Central, Wall Unit(s), Window Unit(s)
  • Electric: 220 Volts
  • Heating: Central, Fireplace(s)
  • Laundry Features: Cabinets, Sink, Hookups Only, Inside Area, Inside Room
  • Water Source: Well

Condo/Co-op/Association

  • Association: No
  • Senior Community: No

Fee Information

  • Land Lease: No

Schools

  • Senior High School District: Lodi Unified

Lot Info

  • Zoning: AG-40
  • Irrigation: Agricultural Well
  • Lot Size Acres: 7.9900
  • Lot Size Sq Ft: 348044.00

Multi Family

  • Unit 2 Partial Bathrooms: 0
  • Unit 2 Description: Two Story Guest Retreat
  • Unit 2 Occupied: No
  • Unit 2 Type: Detached

Tax Info

  • Assessor Parcel Number: 063-150-11
  • Bonds/Assessments/Taxes: Unknown

MLS Schools

  • School District (County): San Joaquin

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $13,517 $1,173,593 $295,445 $878,148
2024 $13,169 $1,150,582 $289,652 $860,930
2023 $12,926 $1,128,022 $283,973 $844,049
2022 $12,652 $1,105,904 $278,405 $827,499
2021 $12,568 $1,084,222 $272,947 $811,275
2020 $12,249 $1,073,106 $270,149 $802,957
2019 $12,010 $1,052,066 $264,852 $787,214
2018 $11,847 $1,031,438 $259,659 $771,779
2017 $11,590 $1,011,215 $254,568 $756,647
2016 $10,893 $991,885 $249,578 $742,307
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
10/19/2025 10/19/25 Price Changed $2,198,000 +83.5% $854 / Sq Ft
10/19/2025 10/19/25 Price Changed $1,198,000 -52.0% $466 / Sq Ft
08/21/2025 08/21/25 For Sale $2,498,000 +40.7% $971 / Sq Ft
09/21/2023 09/21/23 Sold $1,776,000 +5.7% $690 / Sq Ft View Prior Sale
09/20/2023 09/20/23 Price Changed $1,680,000 0.0% $653 / Sq Ft
07/22/2023 07/22/23 Pending -- -- --
07/17/2023 07/17/23 For Sale $1,680,000 -- $653 / Sq Ft
Source: MetroList

Purchase History

Date Type Sale Price Title Company
Grant Deed $1,776,000 Orange Coast Title
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $1,332,000 New Conventional
Source: Public Records

Source: MetroList

MLS Number: 225110528

MetroList

APN: 063-150-11