For sale Home

Listed Oct 15, 2026

$2,250,000 Est. $14,882/mo

15800 North Tretheway Road

  • 3

    Beds

  • 4

    Baths

  • 3,737

    Sq ft

The story

  • Pool

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.

Facts & features

Home type

Home

Year built

2018

Floors

1

Lot size

10 acres

Price per sq ft

$602

Parking

3-car garage

Included features

  • Pool

    Yes

  • Fireplace

    1 fireplace

  • Cooling

    Ceiling Fan(s), Central, Whole House Fan

  • Heating

    Propane, Central, Fireplace(s)

  • Appliances

    Gas Cook Top, Dishwasher, Disposal, Microwave, Double Oven

  • Flooring

    Carpet, Tile

  • Roof

    Metal

  • Lot Information

    Auto Sprinkler F&R, Landscape Misc

  • Exterior

    Kitchen, Built-In Barbeque, Dog Run

  • Water Source

    Well

  • Sewer

    Septic System

Mortgage calculator

Estimated monthly payment

$14,882 /mo

7% rate · 30-yr fixed · 20% down

  • Principal & interest $11,975
  • Property tax $2,250
  • Insurance $656

Includes principal, interest, taxes & insurance.

Your Property Journey

Interested in this, or something like it?

Submit an inquiry

Drop your details and we will help you find what you are looking for.

Not quite. Help me find the right one

Talk it through or type it out, whichever feels easiest.

Your contact details

An agent will reach out personally, no automated calls.

Smart Assistant

Hi, how can I help you find your dream home?

Tap the voice button to talk, or just start typing.

Tap anywhere to fix a word or add more

Tap stop when you’re done. You can edit the text before searching.

By submitting, you agree to our Privacy Policy and Terms.

Listing Broker

Real Brokerage Technologies

Broker Name

Real Brokerage Technologies

Agent

Adriana V Tenbrink

Phone

4500442