Last Sold Price
3 beds2,573 sqft$709/sqft
14700 N Locust Tree Rd, Lodi, CA 95240

Description

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...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 CLOSED: 02/03/2026 12:00 AM

  1. Listed by Lindsay Green • DRE #02082264 • GUIDE Real Estate
    P: (916) 531-8879 lindsaygreenrealestate@gmail.com
  2. Listed by Olivia E. Barrett • DRE #01891361 • GUIDE Real Estate
    P: (916) 952-6953 teambarrett1@gmail.com

Property Details for 14700 North Locust Tree Road

Status
MLS #
225110528
Days on Compass
123
Taxes
-
HOA Fees
-
Condo/Co-op Fees
-
Property Type
MLS Type
Residential / 2 Houses on Lot
Year Built
1990
Lot Size
7.99 AC / 348,044 SF
Parking Features
Attached, Boat Storage, RV Access, Detached
Zoning
AG-40
View Description
Forest, Woods

Location

Listing Courtesy of GUIDE Real Estate, Lindsay Green, DRE #02082264; GUIDE Real Estate, Olivia E. Barrett, DRE #01891361

Sold By Non-MLS Office, Non-MLS Member, DRE #NMLSAGNT

Add your commute

Building Information for 14700 North Locust Tree Road

Stories1Year Built1990Building Size-Lot Size7.99 AC / 348,044 SF

Payment Calculator

Get preapproved with
OriginPoint Mortgage or Rocket Mortgage1

$10,402 per month

30 year fixed, 6.55% Interest

Principal and Interest

$9,276

Property Taxes

$1,126

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 14700 North Locust Tree Road

Summary
Location and General Information
  • Area/District: 20904
  • Area Short Display: 20904
  • Cross Street: Locust Tree
  • City: Lodi
  • County: San Joaquin
  • State: CA
  • Zip Code: 95240
  • Zip Plus 4: 9352
  • Directions to Property: Please see GPS.
Taxes and HOA Information
  • APN: 063-150-11
  • License Fee: $.00
  • City Transfer Tax Rate: .00%
  • County Transfer Tax Rate: .00%
  • Association: false
  • Association Fee: $.00
School Information
  • School District (County): San Joaquin
  • Elementary School District: Lodi Unified
  • Middle or Junior School District: Lodi Unified
  • Senior High School District: Lodi Unified
Parking
  • Covered Spaces: 0
  • Independent Parking Spaces: 0
  • Carport Spaces: 0
  • Garage Spaces: 15
  • Total Parking Spaces: 0
  • Tandem Parking Spaces: 0
  • Open Parking Spaces: 0
  • Parking Fee $: 0.0
Virtual Tour
  • Virtual Media Count: 0
Sale and Listing
  • On Market Date: 08-21-2025
Property
Lot Information
  • Square Footage: 0.0
  • Year Built Source: Assessor Auto-Fill
  • Minimum Bldg SqFt: 0.0
  • # of Lots: 0
  • Lot Size Acres: 7.99
  • Lot Size Source: Assessor Auto-Fill
  • Lot Size Square Feet: 348044.0
  • Lot Features: Private
  • Living Area: 2573.0
  • Price Per Square Foot: $709.29
  • Price Per Acre: $228,410.51
Property and Assessments
  • Home Warranty: false
  • Land Use: Vineyard
  • Irrigation: Agricultural Well
  • Year Built: 1990
  • Picture Count: 93
  • Photos Provided By: 3rd Party Photographer
  • Elevation: 0
  • Property Disclaimer: All data, photos, visualizations and information regarding a property, including all measurements and calculations of area, has been obtained from various sources and has not been, and will not be verified by the listing broker, except as required by the MLS Rules, or MLS. Information on this website may be from sources other than broker, sellers and/or MLS, may include information generated using artificial intelligence, digitally altered photographs or images, and is not guaranteed as complete, accurate or reliable. All data, photos, visualizations and information regarding a property is provided “AS IS” and without any warranty, express or implied, and should be independently reviewed and verified for accuracy.
  • Census Tract: 47.04
  • Bonds Assessments Taxes: Unknown
  • 2nd Unit SqFt Source: Not Verified
  • ADU/2nd Unit: true
  • Concessions: No
Green Features
  • Green Verification Year: 0
Utilities
  • Sewer: Septic Connected
  • Utilities: Sewer Connected
  • Water Source: Well
Interior and Exterior Features
Exterior Features
  • # of Floors: 0
  • # of Guest Space(s): 0
  • # Of Buildings: 0
  • Construction Materials: Brick
  • Driveway/Sidewalks: Gated
  • Fencing: Entry Gate
  • Foundation: Slab
  • Stories: 1
  • Levels: One
  • 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
  • Other Structures: Pergola, Gazebo, Guest House
  • Exterior Features: Kitchen, Built-In Barbeque, Fire Pit
  • Horse Property: false
  • Pool Features: Built-In, Cabana, Pool House, Pool/Spa Combo, Fenced
  • Pool: true
  • Roof: Cement, Tile
  • Senior Community: false
Interior Features
  • Interior Features: Cathedral Ceiling
  • Heating: Central, Fireplace(s)
  • Appliances: Gas Cook Top, Built-In Refrigerator, Hood Over Range, Ice Maker, Dishwasher, Microwave, Double Oven, Warming Drawer
  • Laundry Features: Cabinets, Sink, Hookups Only, Inside Area, Inside Room
  • Spa: true
  • Spa Features: Spa/Hot Tub Built-In, Spa/Hot Tub Personal
  • # of Fireplaces: 2
  • Bath Features: Double Sinks
  • Cooling: Ceiling Fan(s), Central, Wall Unit(s), Window Unit(s)
  • Electric: 220 Volts
  • Flooring: Carpet, Concrete, Stone, Tile, Wood, Parquet
  • Entry Level: 0
  • Fireplace Features: Brick, Living Room, Raised Hearth, Family Room, Stone
  • Possible Bedrooms: 0.0
  • Bedrooms: 3
  • Primary Bathroom Features: Double Sinks, Tub
  • Bathrooms: 3.0
  • Full Bathrooms: 3
  • Half Bathrooms: 0
  • # of Rooms: 0
Room Information
Master Bedroom
  • Primary Bedroom Features: Ground Floor, Walk-In Closet
Living
  • Living Room Features: View
Dining
  • Dining Room Features: Dining/Family Combo
Family Room
  • Family Room Features: View
Kitchen
  • Kitchen Features: Pantry Closet, Slab Counter, Island, Stone Counter
1 Bedroom Unit
  • # of 1 Bedroom Units: 0
  • 1 Bedroom Annual Occupancy: .00%
  • # of 1 Bedrooms Occupied: 0
2 Bedroom Unit
  • # of 2 Bedroom Units: 0
  • 2 Bedroom Annual Occupancy: .00%
  • # of 2 Bedrooms Occupied: 0
3 Bedroom Unit
  • # of 3 Bedroom Units: 0
  • 3 Bedroom Annual Occupancy: .00%
  • # of 3 Bedrooms Occupied: 0
4 Bedroom Unit
  • # of 4 Bedroom Units: 0
  • 4 Bedroom Annual Occupancy: .00%
  • # of 4 Bedrooms Occupied: 0
Multi Family
Multi-Family Information
  • # Commercial Units: 0
  • Total # Owner Occupied: 0
  • # Studios Occupied: 0
  • # of Studio Units: 0
Multi-Family Additional Information
  • 2nd Unit Approx SqFt: 3000.0
  • 2nd Unit Full Baths: 2
  • 2nd Unit Partial Baths: 0
  • 2nd Unit Kitchen: Yes
  • 2nd Unit Description: Two Story Guest Retreat
  • 2nd Unit Occupied: No
  • 2nd Unit Rents for: $.00
  • 2nd Unit Type: Detached
  • 2nd Unit Bedrooms: 2.0
Unit 1
  • Unit 1 Bedrooms: 0
  • Unit 1 Full Baths: 0
  • Unit 1 Partial Baths: 0
  • Unit 1 Rent: $.00
  • Unit 1 Approx SqFt: 0.0
  • Unit 1 # of Rooms: 0
Unit 2
  • Unit 2 Bedrooms: 0
  • Unit 2 Full Baths: 0
  • Unit 2 Partial Baths: 0
  • Unit 2 Rent: $.00
  • Unit 2 Approx SqFt: 0.0
  • Unit 2 # of Rooms: 0
Unit 3
  • Unit 3 Bedrooms: 0
  • Unit 3 Full Baths: 0
  • Unit 3 Partial Baths: 0
  • Unit 3 Rent: $.00
  • Unit 3 Approx SqFt: 0.0
  • Unit 3 # of Rooms: 0
Unit 4
  • Unit 4 Bedrooms: 0
  • Unit 4 Full Baths: 0
  • Unit 4 Partial Baths: 0
  • Unit 4 Rent: $.00
  • Unit 4 Approx SqFt: 0.0
  • Unit 4 # of Rooms: 0
Mobile/Manufactured Home
  • Width: 0.0
  • Length: 0.0
  • Remodeled/Updated: Unknown
  • Berth Size Length: 0.0
  • Berth Size Width: 0.0
Rental
Rent Information
  • Land Lease: false
  • Studio Annual Occupancy: .00%
  • Current Rent: $.00

Property History for 14700 North Locust Tree Road

DateEvent & SourcePriceAppreciation
Feb 3, 2026

Sold

METROLIST #225110528

$2,089,000
Feb 3, 2026

Sold

METROLIST #225110528

$1,825,000
Jan 30, 2026

Sold (Public Record)

Public Record #1927773177

$1,825,000

+1.1% / yr

DateEvent & SourcePrice
02/03/2026

Sold

METROLIST #225110528

$2,089,000
02/03/2026

Sold

METROLIST #225110528

$1,825,000
01/30/2026

Sold (Public Record)

Public Record #1927773177

$1,825,000

+1.1% / yr

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 14700 North Locust Tree Road

Taxable ValueLand$295,445Additions$878,148Total$1,173,593
Tax Record2025$13,517 ($1,126 / month)
Home Facts
Beds4Total Finished SqFt2,573 SqFtAbove Grade Finished SqFt2,573 SqFtStories1Lot Size348,044 SqFtStyleMiscellaneous ResidentialYear Built1990ZoningGACountySAN JOAQUINAPN063-150-110-000Fireplace TypeHas Fireplace

Schools near 14700 North Locust Tree Road

This home is within Lodi Unified School District.
Rating
School
Type
Grades
Distance
Public - K to 6
Public - 7 to 8
Public - 9 to 12
Public - K to 8
Rating
School
Distance
Live Oak Elementary School
PublicK to 6

Morada Middle School
Public7 to 8

Tokay High School
Public9 to 12

Turner Academy at Tokay Colony
PublicK to 8

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

New listings in 95240

$535,000 | 729 South Pleasant Avenue, Lodi, CA 95240
1/37
Contingent

$535,000

3
Bedrooms
1,874
Square Feet
0.17
Acres
$3,400,000 | 12732 West Lane, Lodi, CA 95240
1/76

$3,400,000

6
Bedrooms
5,684
Square Feet
5
Acres
a front view of a house with a yard and porch
1/44

$634,999

4
Bedrooms
1,870
Square Feet
0.17
Acres
a front view of a house with a yard
1/14

$69,500

1
Bedrooms
394
Square Feet
Unavailable
Acres
a front view of a house with a yard
1/14

$69,500

1
Bedrooms
Unavailable
Square Feet
0.01
Acres
a front view of a house
1/8

$48,500

1
Bedrooms
616
Square Feet
Unavailable
Acres
$3,995,000 | 15757 East Sargent Road, Lodi, CA 95240
1/82

$3,995,000

3
Bedrooms
2,866
Square Feet
86.57
Acres
$2,299,900 | 12750 Live Oak Road, Lodi, CA 95240
1/97

$2,299,900

3
Bedrooms
3,974
Square Feet
5
Acres
front view of a house
1/27

$194,500

2
Bedrooms
1,580
Square Feet
Unavailable
Acres

Nearby home values

AddressSold priceBedsBathsSqftLot (Sqft)
This home: 14700 North Locust Tree Road, Lodi, CA 95240
$1,825,000
3
2,573
348,044
5
4,153
448,668
3
1,769
696,960
2
3
1,938
66,211

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of GUIDE Real Estate, Lindsay Green, DRE #02082264; GUIDE Real Estate, Olivia E. Barrett, DRE #01891361

1. The following are terms of a legal agreement between you, the person viewing and/or using this Internet site (“User”) and the operator ("Provider") of this Internet site ("Site"), By accessing, browsing and/or using this Site, User acknowledges that User has read, understood, and agrees to be bound by these terms and to comply with all applicable laws and regulations, including but not limited to U.S. export and re-export control laws and regulations. If User does not agree to these terms, User is not authorized to use this Site. The material provided on this Site is protected by law, including, but not limited to, United States Copyright law and international treaties. 2. User must be a prospective purchaser or seller of real estate with a bona fide interest in the purchase or sale of such real estate. 3. All real estate data and other informational content provided on this Site (including but not limited to descriptions, images, and other information constituting or relating to real estate listings) is strictly for the personal, private, non-commercial use of User and is not made available for redistribution, retransmission, reformatting, modification or copying. User may not sell or use any of the real estate data on this Site for any purpose other than attempting to evaluate houses or properties for sale or purchase by User. User acknowledges that the real estate data and other informational content on this Site is provided by MetroList Services, Inc., a California corporation (“MetroList”), and User acknowledges the validity of MetroList's copyright as to such data. User expressly acknowledges and agrees that MetroList is a third-party beneficiary of these Terms of Use, and that MetroList will be entitled to enforce these Terms of Use against User. 4. To the fullest extent permitted by law, the data on this Site is provided "as is," without warranty or representation of any kind, either express or implied, as to the nature, quality, characteristics or value of any property or information to which the data pertains. NEITHER PROVIDER NOR METROLIST MAKES ANY WARRANTIES, EXPRESS OR IMPLIED, REGARDING THE DATA DISPLAYED ON THIS SITE, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, OR AS TO THE TIMELINESS, ACCURACY AND/OR COMPLETENESS OF THE DATA. 5. NEITHER PROVIDER NOR METROLIST SHALL BE LIABLE FOR ANY INCIDENTAL, SPECIAL, CONSEQUENTIAL, INDIRECT, SPECIAL, PUNITIVE OR EXEMPLARY DAMAGES WHATSOEVER (INCLUDING WITHOUT LIMITATION, DAMAGES FOR LOSS OF BUSINESS INFORMATION, LOSS OF DATA, LOST PROFITS, LOSS OF CUSTOMERS OR OTHER PECUNIARY LOSS), ARISING OUT OF THE USE OR INABILITY TO USE THE DATA DISPLAYED ON THIS SITE, WHETHER THE CLAIM OR CAUSE OF ACTION ARISES IN TORT, CONTRACT, NEGLIGENCE, STRICT LIABILITY OR UNDER ANY OTHER LEGAL THEORY. 6. User agrees that the prevailing party or parties in any action brought to enforce or for breach of these Terms of Use shall be entitled to recover, in addition to any other relief, that party’s or those parties’ reasonable attorney’s fees and court costs incurred in such action from the non-prevailing party or parties.