For Sale
New

248 Heirloom Avenue, Lodi, CA 95242

$815,000(Negotiable)
$815,000(Negotiable)
561202282_c35b859d-f594-4281-b6e3-2a79825a574e.jpg
561202282_5129ddea-7150-48c4-90d1-7aab47c890fe.jpg
561202282_ca22bc35-48a9-41f9-a54e-4df4e328a4a3.jpg
561202282_71febb96-3ea7-4dfe-b49f-6dd62ce5a73d.jpg
561202282_eb8e5e79-2cda-4e85-a272-4a4e81b6ca24.jpg
561202282_a6af82e2-991e-40d7-9471-94ce3da0d10a.jpg
561202282_ab96ad09-f77d-408a-9439-40722ac2ea94.jpg
561202282_670346af-cbc8-44e9-9421-09019d6ad786.jpg
561202282_47c97038-3a70-48ee-9ea3-cf219fcbc412.jpg
561202282_419c8238-3765-41bd-8f03-194f8809fb42.jpg
561202282_feab83d4-31ea-48a9-8726-2574951aa720.jpg
561202282_7a04f5ee-bc43-4d72-8670-081f6cc48db0.jpg
561202282_5be28bcc-33fc-4f0c-8a55-74adc01609e5.jpg
561202282_fe502c23-88e7-4d56-bee6-fa1fdf6b5314.jpg
561202282_0dd3fc8c-629c-4509-a5c5-c2c12cd0313e.jpg
561202282_0ca41a28-bebd-44b7-9d8f-c667640db23c.jpg
561202282_628806ff-6367-4520-8afa-a4835a46c175.jpg
561202282_b836d94f-9038-4ccc-9bb9-bcd577205cd8.jpg
561202282_0c36b38f-a95d-4522-9047-abf7baea0c3a.jpg
561202282_ff610ba8-7519-449a-92cc-00478de7805e.jpg
561202282_73907da6-46c6-4a41-99c9-65dbeb8e0ad3.jpg
561202282_2944168c-724c-4443-8c46-f9c4487ca09e.jpg
561202282_3c6bb160-2176-47c8-ba16-7fb613d2dd54.jpg
561202282_814ef86b-f726-469f-a754-6154696fbfe8.jpg
561202282_f983016a-193f-47e0-9f3f-9ec9e10c8d81.jpg
561202282_39f3973c-78cd-47b9-ac0a-195feb6f5517.jpg
561202282_fe54e2d1-0f6b-483a-a7a5-73d46990c0a7.jpg
561202282_3d022f57-f46c-4145-a7e1-b69285fe1a77.jpg
561202282_d05633be-a6cd-49e2-b6a7-3250d7416597.jpg
561202282_f25d17ac-c0a4-48e0-816a-03d7268bbd6c.jpg
561202282_f2be88c7-031d-41dc-8591-b54258b64fa9.jpg
561202282_d1372cb6-1474-4cf7-9baf-586307fef062.jpg
561202282_393c1a2c-f889-4bb7-9722-a7f8887dda84.jpg
561202282_f1c9a880-b36c-40fa-9fcb-0c065419d1bb.jpg
561202282_7ee94905-00be-467a-8f08-1d7238cbb320.jpg
561202282_5dbb8fb3-e8ff-4c04-b478-3b0e4be765cb.jpg
561202282_d6b8a015-3889-4733-a390-2debf2a1c451.jpg
561202282_194160ce-ff51-48f0-b6c2-26e65e6da8fc.jpg
561202282_c9d701b1-04ca-410c-a041-f74ae5885495.jpg
561202282_cbc63c24-9d27-4320-86dc-d3e95baea741.jpg
561202282_c35b859d-f594-4281-b6e3-2a79825a574e.jpg
561202282_5129ddea-7150-48c4-90d1-7aab47c890fe.jpg
561202282_ca22bc35-48a9-41f9-a54e-4df4e328a4a3.jpg
561202282_71febb96-3ea7-4dfe-b49f-6dd62ce5a73d.jpg
561202282_eb8e5e79-2cda-4e85-a272-4a4e81b6ca24.jpg
561202282_a6af82e2-991e-40d7-9471-94ce3da0d10a.jpg
561202282_ab96ad09-f77d-408a-9439-40722ac2ea94.jpg
561202282_670346af-cbc8-44e9-9421-09019d6ad786.jpg
561202282_47c97038-3a70-48ee-9ea3-cf219fcbc412.jpg
561202282_419c8238-3765-41bd-8f03-194f8809fb42.jpg
561202282_feab83d4-31ea-48a9-8726-2574951aa720.jpg
561202282_7a04f5ee-bc43-4d72-8670-081f6cc48db0.jpg
561202282_5be28bcc-33fc-4f0c-8a55-74adc01609e5.jpg
561202282_fe502c23-88e7-4d56-bee6-fa1fdf6b5314.jpg
561202282_0dd3fc8c-629c-4509-a5c5-c2c12cd0313e.jpg
561202282_0ca41a28-bebd-44b7-9d8f-c667640db23c.jpg
561202282_628806ff-6367-4520-8afa-a4835a46c175.jpg
561202282_b836d94f-9038-4ccc-9bb9-bcd577205cd8.jpg
561202282_0c36b38f-a95d-4522-9047-abf7baea0c3a.jpg
561202282_ff610ba8-7519-449a-92cc-00478de7805e.jpg
561202282_73907da6-46c6-4a41-99c9-65dbeb8e0ad3.jpg
561202282_2944168c-724c-4443-8c46-f9c4487ca09e.jpg
561202282_3c6bb160-2176-47c8-ba16-7fb613d2dd54.jpg
561202282_814ef86b-f726-469f-a754-6154696fbfe8.jpg
561202282_f983016a-193f-47e0-9f3f-9ec9e10c8d81.jpg
561202282_39f3973c-78cd-47b9-ac0a-195feb6f5517.jpg
561202282_fe54e2d1-0f6b-483a-a7a5-73d46990c0a7.jpg
561202282_3d022f57-f46c-4145-a7e1-b69285fe1a77.jpg
561202282_d05633be-a6cd-49e2-b6a7-3250d7416597.jpg
561202282_f25d17ac-c0a4-48e0-816a-03d7268bbd6c.jpg
561202282_f2be88c7-031d-41dc-8591-b54258b64fa9.jpg
561202282_d1372cb6-1474-4cf7-9baf-586307fef062.jpg
561202282_393c1a2c-f889-4bb7-9722-a7f8887dda84.jpg
561202282_f1c9a880-b36c-40fa-9fcb-0c065419d1bb.jpg
561202282_7ee94905-00be-467a-8f08-1d7238cbb320.jpg
561202282_5dbb8fb3-e8ff-4c04-b478-3b0e4be765cb.jpg
561202282_d6b8a015-3889-4733-a390-2debf2a1c451.jpg
561202282_194160ce-ff51-48f0-b6c2-26e65e6da8fc.jpg
561202282_c9d701b1-04ca-410c-a041-f74ae5885495.jpg
561202282_cbc63c24-9d27-4320-86dc-d3e95baea741.jpg

Overview

ID
3512458
Type
Single Family Residence
Parking
No
Beds
5
Baths
3
Sqft
2879
Build Year
2017
Purpose
For Sale

About This Listing

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!

Last checked: 2 hours ago
Listing updated: August 3, 2026, 3:43 pm
Listed By: Kim Arburua, Full Circle Realty Associates
Source: MLS Metrolist, MLS#:226090905

Map Location

248 Heirloom Avenue,95242,Lodi,San Joaquin,CA

Walk Score

All data, photos, visualizations, and information regarding a property, including the property’s compliance with state and local legal requirements and all measurements and calculations of area, have been obtained from various sources, and may include such material that has been generated by use of artificial intelligence. Such information and material have not been and will not be verified for accuracy by the listing broker or the multiple listing service, and are not guaranteed as complete, accurate or reliable. Such information and material should be independently reviewed and verified for accuracy. This information and material are intended for the personal use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
MetroList CA data Last Updated: August 3, 2026, 3:43 pm
Data Source: SACM
Metrolist True Source LogoMetroList Services, Inc. Copyright © 2025