It's in the top 10% of views. Tour it before it's gone!
Today:
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.
Single-familyProperty Type
2018Year Built
10 acresLot Size
$602Price/Sq.Ft.
3 garage spacesParking
Listed by Adriana Tenbrink•DRE #01907061• Real Brokerage Technologies
This is a new listing, so no sales records exist yet. As the MLS and public records start to fill up, we'll list the details here.
As the MLS and public records start to fill up, we'll list the details here.
Public record
Public record
Zoning
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Finished Sq. Ft.
—
Unfinished Sq. Ft.
—
Total Sq. Ft.
—
Year built
—
Style
Vacant Land
County
San Joaquin County
APN
051-200-13
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Apr 8, 2023.
AG-40
General Agriculture Zone
The General Agriculture Zone is established to preserve agricultural lands for the continuation of commercial agricultural enterprises. This zone implements the General Agriculture land use designation of the General Plan
Permitted uses
Include but are not limited to:
Garden center
Housing-Single unit
Housing-Senior
Housing-Other
Infrastructure
Agriculture-Cropland
Climate risks
4/10 Flood Factor
Estimated 19-29% chance of a flood reaching the building in the next 30 years
3/10 Fire Factor
0.46% chance of being in a wildfire in next 30 years
8/10 Heat Factor
7 days above 102° expected this year, 16 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
10/10 Air Factor
28 unhealthy days expected this year, 30 days in 30 years
Provided by First Street
Historical weather
Lodi, CA • 95240
Average low and high temperatures (°F)
59
39
65
44
74
48
76
49
84
54
90
57
92
59
94
60
88
60
80
53
63
45
55
44
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
100/ 100
Exceptional sunlight
Sunscore
This home ranks in the top 1% for direct sun exposure in Lodi. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.1 hrs
6.5 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 15800 N Tretheway Rd
$2,203,293
$47K under list price of $2.25M
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $530K to $977K.