Property photo 1
Property photo 2
Property photo 3
Property photo 4
Property photo 5
3 Beds
4 Baths
3,737 sqft

$2,250,000

15800 N Tretheway Road, Lodi CA, 95240

Price per sqft$602.09
Built in2018
Property size3,737 sqft
Property typeResidential

Overview

Active

Listed Oct 15, 2026

Updated 38h ago

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.

$14,969/mo

Est. mortgage payment based on a $2,250,000 home price.

All estimates are provided by Luxury Presence for informational purposes only. Actual amounts may vary.

Additional information

MLS® ID
226127565

Interior Features

Bedrooms
3
Bathrooms
4
Fireplace
Yes
Cooling
Yes
Heating
Yes
Basement
No

Exterior Features

Lot Size
10 Acres

Other Property Details

Garage
Yes
View
Yes
Pool
Yes
55+/Senior Community
No
MLS provider logo

Courtesy of Real Brokerage Technologies, Adriana Tenbrink,
Listing Contact:  

Data maintained by METROLIST® may not reflect all real estate activity in the market. All information has been provided by seller/other sources and has not been verified by broker. All measurements and all calculations of area (i.e., Sq Ft and Acreage) are approximate. All interested persons should independently verify the accuracy of all information. All real estate advertising placed by anyone through this service for real properties in the United States is subject to the US 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.' This service will not knowingly accept any advertisement for real estate which is in violation of the law. Our readers are hereby informed that all dwellings, under the jurisdiction of U.S. Federal regulations, advertised in this service are available on an equal opportunity basis. 

©2026 METROLIST®. All rights reserved.

Data last updated 3:42 AM UTC

 

Powered by Luxury Presence