An entertainer's dream! Possible bed and breakfast? Short term rental? The options are endless! Located directly across from Lodi Lake, this rare Craftsman estate consists of a 3,173 sqft custom home with all of the bells and whistles, a 1,800 sqft accessory dwelling unit above a 7-car garage, a sparkling pool, and impressive built in stone fireplace and gazebo all on a .58 acre lot! The main home was remodeled from the studs in ~2013 and exudes luxury with its thoughtful design. Notable extravagances include an extraordinary chef's kitchen, a completely built out mudroom, a primary suite with a walk in closet which is home to a built in island and make-up vanity, a spa-like primary bathroom with a cave shower, soaking tub, and separate vanities, and finished basement outfitted with a move theater and wine cellar. Additional distinguished features include top-of-the-line Thermador range, warming shelf, and hood, paneled refrigerator, dishwasher, and wine fridge, ultra-custom cabinetry, whole house vacuum, whole house fan, whole house sound system, two unit HVAC system, and so much more! The accessory dwelling residence currently has one bedroom, one bathroom, full HVAC and the potential for more bedrooms, bathrooms, and a full kitchen. Ask for a list of amenities and upgrades
Single-familyProperty Type
1930Year Built
0.58 acresLot Size
$391Est. Price/Sq.Ft.
7 car garageParking
Listed by Leanne Carillo•DRE #01214114• Parker Realty
Listed by Madison Delbrugge•DRE #02004973• Parker Realty
Bought with Norma Halstead•DRE #01992952• Keller Williams Realty
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
4
Baths
2.5
Stories
2
Lot width
—
Lot depth
—
Lot size
0.58 Acres
Year renovated
—
Sq. Ft.
3,173
Year built
1930
Style
Single Family Residential
County
San Joaquin County
APN
03903003
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 6, 2026.
RLD
Low-Density Residential District
The RLD zoning district is intended for areas appropriate for the development of single-family detached, two-family, and three-family homes. All interior lots are restricted to single-family homes. Corner lots can have one-, two-, or three-family homes. The maximum allowable residential density is 8.0 dwelling units per acre. The RLD zoning district is consistent with the low-density residential land use designation of the general plan.
Permitted uses
Include but are not limited to:
Housing
Housing-Single unit
Housing-Senior
Housing-Other
Agriculture-Cropland
Property details
Parking
Parking & Garage Information
Garage Spaces: 7
Parking Features: 24'+ Deep Garage, Deck, Detached, Garage Door Opener