Save
Ask
Tour
Hide
Share
$2,250,000
3 Days On Site

15800 N Tretheway Road
Lodi, CA 95240

For Sale|Single Family Residence|Active
3
Beds
4
Total Baths
3
Full Baths
1
Partial Bath
3,737
SqFt
$602
/SqFt
2018
Built
County:
San Joaquin
Call Now: 877-805-7348
Is this the listing for you? We can help make it yours.
877-805-7348
15800 N Tretheway Road15800 N Tretheway Road15800 N Tretheway Road15800 N Tretheway Road
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

Enter an interest rate to see your estimated monthly payment.
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.

Beauty and brains? It's possible! Discover this stunning custom estate in Lodi's enchanting countryside, where a cherry orchard becomes your everyday backdrop. Beyond the private gated entrance, an expansive driveway leads to grand entry doors welcoming you into a home where modern sophistication meets warmth and comfort. Soaring ceilings, exquisite finishes, and thoughtful design set the stage for something extraordinary. The gourmet kitchen impresses with Wolf and Sub-Zero appliances, breathtaking Mont Blanc quartzite countertops, a striking center island and elegant lighting. The dining room frames spectacular sunsets through expansive picture windows, while a magnificent crystal chandelier casts vibrant rainbow reflections throughout the surrounding spaces. The primary suite is a private retreat offering generous space, peaceful orchard views, and a luxurious bathroom featuring floor-to-ceiling tile, a glass-enclosed double shower, and a freestanding MTI soaking tub beneath a breathtaking crystal light fixture. Two additional junior suites are thoughtfully designed with private bathrooms featuring beautiful quartz accents and refined tilework, offering exceptional comfort and privacy.A beautifully appointed officeand media room features premium cabinetry, quartz countertops, and inspiring views. A spacious mudroom with a charming barn door provides convenient access near the breezeway connecting the home to the impressive finished shop. And the shop you've been dreaming about? It's already here! Featuring 3 oversized roll-up doors, RV and sewer hookups, plumbed air lines, a full bathroom, and a 10x5 tack room. Equestrian amenities include a 24x12 paddock area with heavy-duty metal fencing, a drive-through gate, and a horse shelter with feeder and mats. Outdoor living is just as captivating! The California room flows beautifully into the outdoor kitchen, creating the perfect setting for entertaining. A stunning saltwater pool with clean architectural lines and an elegant sheer-descent waterfall invites you to unwind and enjoy peaceful evenings beneath the stars. Set on approximately 10 acres, with 8 acres currently leased for cherry farming, this estate also features owned solar and the tranquility of country living. Here, luxury is not just about beautiful finishes; it's about having the space, privacy, and freedom to enjoy life at your own pace. More than a property... Beauty, brains, and a lifestyle to match. This estate truly has it all.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$2,250,000
Days On Site 
3 Days
Bedrooms 
3
Inside Area (SqFt) 
3,737 sqft
Total Baths 
4
Full Baths 
3
Partial Baths 
1
Lot Size 
10 Acres
Year Built 
2018
MLS Number 
226127565
Status 
Active
Property Tax 
N/A
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
Owner
Friends & Family
Recent Activity
3 days agoListing updated with changes from the MLS
4 days agoListing first seen on site
General Features
Acres 
10
Additional Property Use 
AgriculturalResidentialOrchard
Attached Garage 
Yes
Carport 
2
Cross Street 
E Kettlemsn Lane
Direction Faces 
West
Foundation 
Slab
Garage 
Yes
Garage Spaces 
3
Parking 
PavedAttachedWorkshop in GarageBoatGarage Faces SideGuest
Property Sub Type 
Single Family Residence
Sewer 
Septic Tank
Style 
Contemporary
Water Source 
Well
Zoning 
AG-40AG-40AG-40AG-40
Interior Features
Appliances 
Gas CooktopDishwasherDisposalMicrowaveDouble OvenWater Purifier
Cooling 
Ceiling Fan(s)Whole House FanCentral Air
Electric 
220 Volts in Laundry
Fireplace 
Yes
Fireplace Features 
StoneWood Burning
Fireplaces 
1
Flooring 
CarpetTile
Heating 
PropaneCentralFireplace(s)
Interior 
Central VacuumWalk-In Closet(s)StorageKitchen Island
Laundry Features 
Laundry Room
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
StoneStuccoFrame
Exterior 
Dog Run
Fencing 
Partial
Lot Features 
LevelWoodedSprinklers In FrontSprinklers In RearLandscaped
Other Structures 
Workshop
Patio And Porch 
PatioEnclosed
Pool Features 
Salt WaterPrivate
Private Pool 
Yes
Roof 
Metal
View 
Orchard
Waterview 
Orchard
Community Features
MLS Area 
20903
School District 
San Joaquin
Horse Property 
PaddocksTack Room
Financing Terms Available 
CashConventionalSubmit
Horse Allowed 
Yes
Schools
School District
San Joaquin
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of Real Brokerage Technologies



All measurements and all calculations of the area are approximate. Information provided by Seller/Other sources, not verified by Broker. All interested persons should independently verify the accuracy of information. Provided properties may or may not be listed by the office/agent presenting the information. Data maintained by MetroList® may not reflect all real estate activity in the market. All real estate content on this site is subject to the Federal Fair Housing Act of 1968, as amended, which makes it illegal to advertise any preference, limitation or discrimination because of race, color, religion, sex, handicap, family status or national origin or an intention to make any such preference, limitation or discrimination. Terms of Use
Last checked 2026-10-19 05:35 AM PDT

Neighborhood & Commute
Source: Walkscore
Save
Ask
Tour
Hide
Share