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.
Closed
$1,825,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,817,800 Zestimate®
$709/sqft
$3,211 Estimated rent
Home value
$1,817,800
$1.65M - $2.00M
$3,211/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$3,211/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$3,211/mo
Rent Zestimate®
Refinance and save
$11,524/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$11,524/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked: 7 hours ago
Listing updated: February 03, 2026 at 05:53pm
Listed by:
Lindsay Green DRE #02082264 916-531-8879,
GUIDE Real Estate,
Olivia Barrett DRE #01891361 916-952-6953,
GUIDE Real Estate
Bought with:
Non-MLS Office
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 & neighborhood
Location
- Region: Lodi
Other
Other facts
- Price range: $1.8M - $1.8M
Price history
| Date | Event | Price |
|---|---|---|
| 2/3/2026 | Sold | $1,825,000-12.6%$709/sqft |
Source: MetroList Services of CA #225110528 Report a problem | ||
| 12/22/2025 | Pending sale | $2,089,000$812/sqft |
Source: MetroList Services of CA #225110528 Report a problem | ||
| 11/27/2025 | Price change | $2,089,000-5%$812/sqft |
Source: MetroList Services of CA #225110528 Report a problem | ||
| 10/19/2025 | Price change | $2,198,000-12%$854/sqft |
Source: MetroList Services of CA #225110528 Report a problem | ||
| 8/22/2025 | Listed for sale | $2,498,000+40.7%$971/sqft |
Source: MetroList Services of CA #225110528 Report a problem | ||
Public tax history
| Year | Property taxes | Tax 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
Neighborhood: 95240
Nearby schools
GreatSchools rating
- 6/10Live Oak Elementary SchoolGrades: K-6Distance: 3.8 mi
- 3/10Morada Middle SchoolGrades: 7-8Distance: 5.6 mi
- 5/10Tokay High SchoolGrades: 9-12Distance: 4.9 mi
Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.
Sell for more on Zillow
Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
$1,817,800
2% more
+$36,356
With Zillow Showcase(estimated)
$1,854,156
- California
- San Joaquin County
- Lodi
- 95240
- 14700 N Locust Tree Rd