Save
Ask
Tour
Hide
Share
$815,000
New Listing

248 Heirloom Avenue
Lodi, CA 95242

For Sale|Single Family Residence|Active
5
Beds
3
Total Baths
3
Full Baths
2,879
SqFt
$283
/SqFt
2017
Built
Subdivision:
Rose Gate 2
County:
San Joaquin
248 Heirloom Avenue248 Heirloom Avenue248 Heirloom Avenue248 Heirloom Avenue
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$3,718
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.

Welcome to this lovely home in Lodi's desireable Rose Gate (Artistry) locale. Featuring 5 bedrooms and 3 full bathrooms, (one bedroom and bathroom downstairs) and includes so many nice and unique features. Absolutley beautiful kitchen, a chef's dream with tons of workspace, storage and a pantry closet! Open space concept into living room with custom built-in entertainment center with surround sound. Living room and kitchen look out to an outdoor California Room with surround sound and a gas fireplace. A great space to spend time while entertaining! The primary bathroom has double sinks, a tub and wonderful walk in shower. Great inside laundry with cabinets, sink and folding area. The backyard also has an extra kitchen area, lovely landscaping and timed sprinklers that have a rain gauge feature. The house is also equipped with a Christmas light package. This home has been cared for and well maintained, it's like walking into a model home. You will love it!

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$815,000
Days On Site 
0 Days
Bedrooms 
5
Inside Area (SqFt) 
2,879 sqft
Total Baths 
3
Full Baths 
3
Partial Baths 
N/A
Lot Size 
0.124 Acres
Year Built 
2017
MLS® Number 
226090905
Status 
Active
Property Tax 
N/A
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
3 hours agoListing updated with changes from the MLS®
3 hours agoListing first seen on site
General Features
Acres 
0.124
Cross Street 
Radiance
Direction Faces 
West
Foundation 
Slab
Garage 
Yes
Garage Spaces 
2
Levels 
Two
Parking 
Garage Door OpenerGarage Faces Front
Property Sub Type 
Single Family Residence
Sewer 
Public Sewer
Utilities 
Natural Gas AvailableSewer ConnectedNatural Gas ConnectedElectricity Available
Water Source 
Public
Zoning 
residential
Interior Features
Appliances 
WasherDryerBuilt-In Electric OvenGas CooktopDishwasherDisposalMicrowaveTankless Water HeaterRange Hood
Basement 
None
Cooling 
Ceiling Fan(s)Central Air
Electric 
220 Volts
Fireplace 
Yes
Fireplace Features 
OutsideGas
Fireplaces 
1
Flooring 
CarpetTile
Heating 
Central
Interior 
Walk-In Closet(s)Double VanityGranite CountersKitchen Island
Laundry Features 
Gas Dryer Hookup
Window Features 
Double Pane Windows
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Stucco
Exterior 
Balcony
Fencing 
Back YardFenced
Lot Features 
Sprinklers In FrontSprinklers In RearLandscaped
Other Structures 
Shed(s)
Patio And Porch 
CoveredPatio
Roof 
Tile
Windows/Doors 
Double Pane Windows
Community Features
Financing Terms Available 
CashConventionalSubmit
MLS Area 
20901
School District 
San Joaquin
Schools
School District
San Joaquin
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of Full Circle Realty Associates



All measurements and all calculations of the area are approximate. Information provided by Seller/Other sources, not verified by Broker. All interested persons should independently verify the accuracy of information. Provided properties may or may not be listed by the office/agent presenting the information. Data maintained by MetroList® may not reflect all real estate activity in the market. All real estate content on this site is subject to the Federal Fair Housing Act of 1968, as amended, which makes it illegal to advertise any preference, limitation or discrimination because of race, color, religion, sex, handicap, family status or national origin or an intention to make any such preference, limitation or discrimination. Terms of Use
Last checked 2026-08-03 11:10 AM PDT

Neighborhood & Commute
Source: Walkscore
Save
Ask
Tour
Hide
Share