15800 N Tretheway RD, Lodi, CA 95240
15800 N Tretheway RD, Lodi, CA 95240
15800 N Tretheway RD, Lodi, CA 95240
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
Lance McHan

Lance McHan

+1(209) 279-2235
$2,250,000
Est. payment /mo
3 Beds
4 Baths
3,737 SqFt
Save

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

Read Less Info
MetroList® Services, Inc
Listed by Real Brokerage Technologies

Nearby School & Business

Get More Information

Lance McHan

Lance McHan

+1(209) 279-2235

Broker Associate License ID: 01987449

Broker Associate License ID: 01987449

Name

Name

Phone*

Phone

Message

By checking this box, I agree to receive recurring marketing communication from or on behalf of Cornerstone Real Estate Group, including auto-dialed calls, texts, and artificial/prerecorded voice messages (message frequency varies; data rates may apply; reply "STOP" to opt-out of texts or "HELP" for assistance); Consent not required to make a purchase. I understand that I can call to obtain direct assistance.

By checking this box, I agree to the Terms of Service and Privacy Policy of this website.

By checking this box, I agree to receive transactional and informational text messages from or on behalf of Cornerstone Real Estate Group (e.g., appointment/showing reminders, property status updates, account or service notifications). Consent is not a condition of purchase. Message frequency varies. Message & data rates may apply.
Quick Search