$2,498,000

14700 N Locust Tree Rd Lodi, CA 95240

Estimated payment $14,708/month

Total Views 895
3 Beds
3 Baths
2,573 Sq Ft
$971 Price per Sq Ft

Highlights

  • Very Popular Property
  • Pool House
  • Custom Home
  • Guest House
  • RV Access or Parking
  • 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,169

Year Built

  • Built in 1990

Lot Details

  • 7.99 Acre Lot
  • Private Lot

Parking

  • 15 Car Garage
  • RV Access or Parking

Home Design

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

Interior Spaces

  • 2,573 Sq Ft Home
  • 1-Story Property
  • Brick Fireplace
  • Family Room with Fireplace
  • 2 Fireplaces
  • Family Room Downstairs
  • Living Room

Kitchen

  • Walk-In Pantry
  • Double Oven
  • Microwave
  • Built-In Refrigerator
  • Dishwasher
  • Kitchen Island

Flooring

  • Carpet
  • Stone
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Primary Bedroom located in the basement
  • Walk-In Closet
  • 3 Full Bathrooms
  • Secondary Bathroom Double Sinks
  • Bathtub

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Pool

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

Utilities

  • Central Heating and Cooling System
  • 220 Volts
  • Well
  • Septic System

Additional Features

  • Guest House
  • Vineyard

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,169

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: Built-In Refrigerator, Dishwasher, Microwave, Double Oven
  • Fireplace Features: Brick, Living Room, Family Room
  • Fireplaces: 2
  • Flooring: Carpet, Stone, Tile
  • 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
  • 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: 970.85
  • Square Footage: 2573.00

Exterior Features

  • Other Structures: Guest House
  • Construction Materials: Brick
  • Fencing: Entry Gate
  • Foundation: Slab
  • Home Warranty: No
  • Horse Property: No
  • Listing Price: 2498000.00
  • Lot Features: Private
  • New Construction: No
  • Pool Features: Built-In, Cabana, Pool House, Pool/Spa Combo
  • Pool: Yes
  • Roof: Cement, Tile
  • Spa Features: Spa/Hot Tub Built-In
  • Spa: Yes
  • Land Use: Vineyard
  • Second Unit Bedrooms: 2
  • Second Unit Estimated Sq Ft: 2000
  • Second Unit Full Bathrooms: 2
  • 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: Central
  • Electric: 220 Volts
  • Heating: Central
  • Laundry Features: Cabinets
  • 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:

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
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 Change Sq Ft Price
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
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