15800 N Tretheway Road, Lodi, CA 95240
Local realty services provided by:Legacy Real Estate & Associates ERA Powered
Listed by: adriana tenbrink
Office: real brokerage technologies
MLS#:226127565
Source:MetroList
Price summary
- Price:$2,250,000
- Price per sq. ft.:$602.09
About this home
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....
Contact an agent
Home facts
- Year built:2018
- Listing ID #:226127565
- Added:11 day(s) ago
- Updated:October 27, 2026 at 05:01 PM
Rooms and interior
- Bedrooms:3
- Total bathrooms:4
- Full bathrooms:3
- Rooms Total:4
- Flooring:Carpet, Tile Floor
- Kitchen Description:Dishwasher, Disposal, Double Oven, Gas Cook Top, Microwave
- Living area:3,737 sq. ft.
Heating and cooling
- Cooling:Ceiling Fan(s), Central, Whole House Fan
- Heating:Central, Fireplace(s), Propane
Structure and exterior
- Roof:Metal
- Year built:2018
- Building area:3,737 sq. ft.
- Lot area:10 Acres
- Lot Features:Auto Sprinkler F&R, Landscape Misc
- Construction Materials:Frame, Metal, Stone, Stucco, Wood
- Exterior Features:Enclosed Patio
- Foundation Description:Slab
- Levels:1 Story
Utilities
- Sewer:Septic System
Finances and disclosures
- Price:$2,250,000
- Price per sq. ft.:$602.09
Features and amenities
- Appliances:Dishwasher, Disposal, Double Oven, Microwave
- Laundry features:Cabinets, Inside Laundry Room
- Amenities:Storage Area(s)
Parking
- Garage spaces:3
- Carport spaces:2
New listings near 15800 N Tretheway Road
- New
$399,950Active2 beds 1 baths1,016 sq. ft.327 Eureka Avenue, Lodi, CA 95240
MLS# 226132036Listed by: HERO REAL ESTATE - New
$560,000Active2 beds 2 baths1,631 sq. ft.2451 Macarthur Parkway, Lodi, CA 95242
MLS# 226131981Listed by: BERKSHIRE HATHAWAY HOMESERVICES-DRYSDALE PROPERTIES - Open Thu, 4 to 6pmNew
$599,000Active2 beds 2 baths1,814 sq. ft.116 N Rose Street, Lodi, CA 95240
MLS# 226131429Listed by: RE/MAX GOLD LODI - New
$699,000Active4 beds 2 baths2,328 sq. ft.3062 Wisteria Drive, Lodi, CA 95242
MLS# 226131565Listed by: KATZAKIAN REAL ESTATE - New
$664,900Active3 beds 2 baths1,877 sq. ft.1741 Windjammer Court, Lodi, CA 95242
MLS# 226131580Listed by: RE/MAX GOLD LODI - New
$319,000Active3 beds 1 baths942 sq. ft.850 Woodrow Street, Lodi, CA 95240
MLS# 226131341Listed by: HOMWRX - New
$609,950Active3 beds 2 baths1,442 sq. ft.2621 Candlewood Drive, Lodi, CA 95242
MLS# 226131106Listed by: HOMELINK REAL ESTATE - New
$1,097,000Active3 beds 5 baths3,815 sq. ft.2350 St. Anton, Lodi, CA 95242
MLS# 226130806Listed by: CORNERSTONE REAL ESTATE GROUP - New
$716,900Active3 beds 2 baths2,279 sq. ft.1937 Daffodil Drive, Lodi, CA 95242
MLS# 226130441Listed by: BERKSHIRE HATHAWAY HOMESERVICES-DRYSDALE PROPERTIES - New
$639,950Active4 beds 3 baths2,430 sq. ft.1908 Bridgewood Drive, Lodi, CA 95242
MLS# 226131013Listed by: SHERMAN & ASSOCIATES RE