$2,250,000

15800 N Tretheway Rd, Lodi, CA 95240

Get pre-approved

3 bd · 4.0 ba · 3,737 sqft · $602/sqft · 10.00 acres

Residential · Single Family Residence · Built 2018 · 4 days on Properkey

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.

Agent & source

Listed by
Adriana V. Tenbrink
Brokerage
Real Brokerage Technologies
DRE
#01907061
MLS # 226127565 Source MetroList Services

Property details

Rooms & Layout

Levels
1 story
Bedrooms
3
Bathrooms
4.0 (3 full, 1 partial)
Kitchen
Breakfast Area, Quartz Counter, Island
Dining
Breakfast Nook, Space in Kitchen, Formal Area
Living Room
Great Room, View, Open Beam Ceiling
Primary Bedroom
  • Surround Sound
  • Walk-In Closet
  • Outside Access
  • Sitting Area
Primary Bathroom
  • Shower Stall(s)
  • Soaking Tub
  • Tile
  • Walk-In Closet
  • Quartz
  • Window
Other Bathrooms
  • Shower Stall(s)
  • Tile
  • Window
  • Quartz
Laundry
Cabinets, Space For Frzr/Refr, Inside Room

Property Features

View
Orchard
Lot features
Auto Sprinkler F&R, Landscape Misc
Pool
Built-In, Salt Water
Horse amenities
Paddocks, Pens, Tack Room
Topography
Level, Trees Many

Building & Construction

Architectural Style
Contemporary
Construction Materials
  • Metal
  • Stone
  • Stucco
  • Frame
  • Wood
Roof
Metal
Foundation
Slab

Exterior & Parking

Parking
3-car garage, 24'+ Deep Garage, Attached, Boat Storage, RV Access, RV Garage Detached, Garage Facing Side, Guest Parking Available, Workshop in Garage
Patio & Porch
Enclosed Patio
Fencing
Metal, Partial
Exterior Features
Kitchen, Built-In Barbeque, Dog Run
Other Structures
Workshop

Interior & Comfort

Heating
Propane, Central, Fireplace(s)
Cooling
Ceiling Fan(s), Central, Whole House Fan
Flooring
Carpet, Tile
Fireplace
1 (Stone, Wood Burning)
Interior Features
Storage Area(s)

Appliances & Equipment

Appliances
  • Gas Cook Top
  • Dishwasher
  • Disposal
  • Microwave
  • Double Oven
Other equipment
Central Vacuum, Water Filter System

Utilities

Water Source
Well
Sewer
Septic System
Electric
Battery Backup, 220 Volts in Laundry
  • Public
  • Internet Available
  • Solar
  • Propane Tank Leased
Irrigation
Agricultural Well, Shares Domestic Well

Nearby

Active Pending Closed Rental
Elementary
Lodi Unified District
Middle
Lodi Unified District
High
Lodi Unified District

Schedule a tour

Book an in-person visit

Takes about a minute

Pick a day

Preferred time

Your name and email come from the account you sign in with or create.

Prefer to talk? Call us
(888) 854-8588

Make an Offer

Step 1 of 4

Here's what to expect:

  1. 1.Share your offer details. Tell us about your desired offer — it's just a starting point, nothing is final!
  2. 2.Get expert guidance. A Properkey agent will reach out to discuss a game plan.
  3. 3.Finalize your offer. Your agent will prepare your offer and negotiate on your behalf.

All data, photos, visualizations, and information regarding a property, including the property's compliance with state and local legal requirements and all measurements and calculations of area, have been obtained from various sources, and may include such material that has been generated by use of artificial intelligence. Such information and material have not been and will not be verified for accuracy by the listing broker or the multiple listing service, and are not guaranteed as complete, accurate or reliable.

Such information and material should be independently reviewed and verified for accuracy. This information and material are intended for the personal use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Data last updated: October 19, 2026 6:18 PM PT
Copyright © 2026 MetroList Services, Inc. All Rights Reserved.

Schedule a tour