See all 91 photos

$2,250,000

Est. payment - /mo

Save

3 Beds

4 Baths

3,737 SqFt

New

15800 N Tretheway RD Lodi, CA 95240

Save

REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.

In-PersonVirtual Tour

Cindy Mello

cindymello@gmail.com +1(209) 346-4580

UPDATED:

Key Details

Property Type Single Family Home

Sub Type Single Family Residence

Listing Status Active

Purchase Type For Sale

Square Footage 3,737 sqft

Price per Sqft $602

MLS Listing ID 226127565

Bedrooms 3

Full Baths 3

HOA Y/N No

Year Built 2018

Property Sub-Type Single Family Residence

Source MLS Metrolist

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 office 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.

Location

State CA

County San Joaquin

Area 20903

Direction From Hwy 99, take the Kettleman Lane/Hwy 12 exit and head east. Turn left (north) onto N Tretheway Road. Continue to 15800 N Tretheway Road to your right side.

Rooms

Guest Accommodations No

Master Bathroom Shower Stall(s), Soaking Tub, Tile, Walk-In Closet, Quartz, Window

Master Bedroom Surround Sound, Walk-In Closet, Outside Access, Sitting Area

Living Room View, Open Beam Ceiling

Dining Room Breakfast Nook, Space in Kitchen, Formal Area

Kitchen Breakfast Area, Quartz Counter, Island

Interior

Interior Features Storage Area(s)

Heating Propane, Central, Fireplace(s)

Cooling Ceiling Fan(s), Central, Whole House Fan

Flooring Carpet, Tile

Fireplaces Number 1

Fireplaces Type Stone, Gas Log

Equipment Central Vacuum, Water Filter System

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

Laundry Cabinets, Space For Frzr/Refr, Inside Room

Exterior

Exterior Feature Kitchen, Built-In Barbeque, Dog Run

Parking Features 24'+ Deep Garage, Attached, Boat Storage, RV Access, RV Garage Detached, Garage Facing Side, Guest Parking Available, Workshop in Garage

Garage Spaces 3.0

Carport Spaces 2

Fence Metal, Partial

Pool Built-In, Salt Water

Utilities Available Public, Internet Available, Solar, Propane Tank Leased

View Orchard

Roof Type Metal

Topography Level,Trees Many

Porch Enclosed Patio

Private Pool Yes

Building

Lot Description Auto Sprinkler F&R, Landscape Misc

Story 1

Foundation Slab

Sewer Septic System

Water Well

Architectural Style Contemporary

Schools

Elementary Schools Lodi Unified

Middle Schools Lodi Unified

High Schools Lodi Unified

School District San Joaquin

Others

Senior Community No

Tax ID 151-200-13

Special Listing Condition None

Listed by Real Brokerage Technologies

NEARBY SCHOOL & BUSINESS

GET MORE INFORMATION

Cindy Mello

Broker Associate CA DRE#01309212

+1(209) 346-4580 | cindymello@gmail.com

QUICK SEARCH