15800 N Tretheway Road, Lodi, CA 95240

$2,250,000
3
BD
4
BA
3,737
SqFt

Show Photos

Verify your account to unlock exclusive photos, mortgage tools, and more.

List Price
$2,250,000
MLS#
226127565
Status
ACTIVE
Bedrooms
3
Bathrooms
4
Living Sq. Ft
3,737
Square Footage
3737
Type
Single Family Residential
Zip
95240
City
Lodi

Property Description

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.

Additional Information

Land Area (Acres)
10
Year Built
2018
Subtype
Single Family Residence
Subtype Description
Detached
Style
Contemporary
Construction
Metal, Stone, Stucco, Frame, Wood
Foundation
Slab
Stories
1
Carport Spaces
2
Garage Spaces
3
Garage
24'+ Deep Garage, Attached, Boat Storage, RV Access, RV Garage Detached, Garage Facing Side, Guest Parking Available, Workshop in Garage
House FAces
West
Baths Other
Shower Stall(s), Tile, Window, Quartz
Master Bath
Shower Stall(s), Soaking Tub, Tile, Walk-In Closet, Quartz, Window
Floor Coverings
Carpet, Tile
Laundry Description
Cabinets, Space For Frzr/Refr, Inside Room
Dining Description
Breakfast Nook, Space in Kitchen, Formal Area
Kitchen Description
Breakfast Area, Quartz Counter, Island
Kitchen Appliances
Gas Cook Top, Dishwasher, Disposal, Microwave, Double Oven
Number of Fireplaces
1
Fireplace Description
Stone, Wood Burning
Rec Parking
RV Access, RV Garage Detached, Boat Storage
Pool
Yes
Horses
Yes
Horse Amenities
Paddocks, Pens, Tack Room
Misc
Kitchen, Built-In Barbeque, Dog Run
Equipment
Central Vacuum, Water Filter System
Cooling
Ceiling Fan(s), Central, Whole House Fan
Heat
Propane, Central, Fireplace(s)
Water
Well
Utilities
Public, Internet Available, Solar, Propane Tank Leased
Sewer
Septic System

Mortgage Calculator

Amount of Loan
Annual Interest Rate
%
Term of Loan
Years

Does not include any taxes or fees.
Please consult a financial professional.
Calculator source: Real Geeks

Listing courtesy of Real Brokerage Technologies.

metrolist logo

All measurements and all calculations of area (i.e., Sq Ft and Acreage) are approximate. Broker has represented to MetroList that Broker has a valid listing signed by seller authorizing placement in the MLS. Above information is provided by Seller and/or other sources and has not been verified by Broker. Copyright 2026 MetroList Services, Inc. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of MetroList® MLS. All information has been provided by seller/other sources and has not been verified by broker. All interested persons should independently verify the accuracy of all information. Last updated .

Terms of Use