Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$815,000 Just Listed

  • For Sale
  • Active
  • Single Family
  • 5 Beds
  • 3 Full Baths
  • 2,879 Sq. Ft.
  • 2 Car Garage
  • Updated 3 days ago
See This Home
Save This Home
See This Home
Save This Home
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!

Full Property Details for 248 Heirloom Ave

General

  • Price: $815,000
  • Status: Active
  • Type: Single Family
  • Source: METROLIST_Cali
  • MLS ID: 226090905
  • Updated: 8/3/2026
  • Added to Site: 3 day(s) ago

Interior

  • Rooms/Areas: Primary Bedroom
  • Fireplace: Yes
  • Number of Fireplaces: 1
  • Fireplace(s): Outside, Gas Piped
  • Appliances: Built-In Electric Oven, Gas Cook Top, Hood Over Range, Dishwasher, Disposal, Microwave, Tankless Water Heater
  • Flooring: Carpet, Tile

Rooms

Bathrooms

  • Total Bathrooms: 3
  • Full Bathrooms: 3
  • Bathroom Features: Shower Stall(s), Double Sinks, Tub
  • Primary Bathroom: Shower Stall(s), Double Sinks, Tub

Bedrooms

  • Total Bedrooms: 5
  • Primary Bedroom: Walk-In Closet 2+

Other Rooms

  • Kitchen: Pantry Closet, Granite Counter, Island w/Sink
  • Dining Room: Dining Bar, Space in Kitchen
  • Laundry: Cabinets, Dryer Included, Gas Hook-Up, Washer Included, Inside Room

Exterior

  • Exterior Features: Balcony

Parking

  • Garage: Yes
  • Garage Spaces: 2
  • Parking: Garage Door Opener, Garage Facing Front

Location

  • County: San Joaquin
  • Subdivision: Rose Gate 2
  • Cross Streets: Radiance
  • Driving Directions: From Lower Sacramento Rd, turn west on Lodi Ave. Go through the first round about and then take a right at the next street. Then take another immediate right and loop around to Heirloom Ave.
  • Direction Faces: West

School Information

  • School District: San Joaquin
  • Elem School District: Lodi Unified
  • Midd School District: Lodi Unified
  • High School District: Lodi Unified

Heating & Cooling

  • Cooling Type: Ceiling Fan(s), Central
  • Heating Type: Central
  • Heating Fuel: Central

Utilities

  • Sewer: Public Sewer
  • Water: Public
  • Utility Description: Public, Sewer Connected, Electric, Natural Gas Connected

Structural Information

  • Architectural Style: Two Story
  • Construction: Stucco
  • Foundation: Slab
  • Roof: Tile
  • Windows: Dual Pane Full
  • Stories/Levels: 2
  • Square Feet: 2,879
  • Sq. Ft. Source: Assessor Agent-Fill
  • Year Built: 2017

Additional Structures

  • Other Structures: Shed(s)

Lot Features

  • Lot Size (Acres): 0.124
  • Lot Size (Sq. Ft.): 5,401
  • Irrigation System: Public District
  • Zoning: residential
  • Lot Description: Auto Sprinkler F&R, Shape Regular, Landscape Back, Landscape Front
  • Fencing (Description): Back Yard, Fenced

Disclosures and Reports

  • Special Conditions: None
  • APN: 029-560-10

Listed by Full Circle Realty Associates

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 248 Heirloom Ave —

  • Full Circle Realty Associates

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 248 Heirloom Ave

School District:Lodi Unified School District
NameGradesDistance
Vinewood Elementary School
1600 West Tokay Street, Lodi, CA 95242
K-61.1 mi
Millswood Middle School
233 North Mills Avenue, Lodi, CA 95242
7-80.9 mi
Lodi High School
3 South Pacific Avenue, Lodi, CA 95242
9-121.2 mi
Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 248 Heirloom Ave Get Price Alerts and Save Property

Date
Details
Price
Change
Source
8/03/2026
Listed
$815,000
57.34%
MLS
6/01/2017
Sold
$518,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 248 Heirloom Ave

Year
Property Taxes
Change
Tax Assessment
Change
2025
$8,382
3%
$725,061
2%
2024
$8,157
1%
$710,845
23%
2023
$8,056
22%
$577,812
2%
2022
$6,619
-1%
$566,484
2%
2021
$6,716
3%
$555,377
1%
2020
$6,544
2%
$549,683
2%
2019
$6,411
2%
$538,906
2%
2018
$6,306
188%
$528,340
168%
2017
$2,189
158%
$196,901
145%
2016
$850
29%
$80,295
30%
2015
$659
—
$61,841
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 248 Heirloom Ave

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Full Circle Realty Associates

Similar Properties near 248 Heirloom Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

2012 Van Ruiten Dr, Lodi, CA 95242 - Photo 1
$799,999

2012 Van Ruiten Dr  Lodi, CA 95242

  • Single Family
  • Active
  • 5
    Beds
  • 3
    Total Baths
  • 3,187
    Sq. Ft.
Listed by Schaffer & Company, Realtors
1544 Jasmine Way, Lodi, CA 95242 - Photo 1 Just Listed
$775,000
Open House

1544 Jasmine Way  Lodi, CA 95242

  • Single Family
  • Active
  • Updated 1 day ago
  • 5
    Beds
  • 3
    Total Baths
  • 3,400
    Sq. Ft.
Listed by KW Central Valley
552 Denier Ct, Galt, CA 95632 - Photo 1
$799,000

552 Denier Ct  Galt, CA 95632

  • Single Family
  • Active
  • Updated 17 hours ago
  • 5
    Beds
  • 3
    Total Baths
  • 3,440
    Sq. Ft.
Listed by eXp Realty of California Inc.
6368 Hidden Acres Rd, Stockton, CA 95212 - Photo 1
$850,000

6368 Hidden Acres Rd  Stockton, CA 95212

  • Single Family
  • Active
  • 5
    Beds
  • 3
    Total Baths
  • 2,893
    Sq. Ft.
Listed by Mpire Luxe Real Estate

Just Listed near 248 Heirloom Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

N Hwy 99, Acampo, CA 95220 - Photo 1 Just Listed
$104,995

N Hwy 99  #164  Acampo, CA 95220

  • Single Family
  • Active
  • Updated 19 hours ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,392
    Sq. Ft.
Listed by Foundation Real Estate
9835 Harvey Rd, Galt, CA 95632 - Photo 1 Just Listed
$758,500
Open House

9835 Harvey Rd  Galt, CA 95632

  • Single Family
  • Active
  • Updated 14 hours ago
  • 2
    Beds
  • 1
    Total Bath
  • 1,010
    Sq. Ft.
Listed by Real Brokerage Technologies, Inc
928 Norman Rd, Galt, CA 95632 - Photo 1 Just Listed
$572,926
Open House

928 Norman Rd  Galt, CA 95632

  • Single Family
  • Active
  • Updated 2 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,960
    Sq. Ft.
Listed by Cobalt Real Estate
1263 Billorights Ave, Galt, CA 95632 - Photo 1 Just Listed
$658,400

1263 Billorights Ave  Galt, CA 95632

  • Single Family
  • Active
  • Updated 1 day ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,698
    Sq. Ft.
Listed by Mertitage Homes

Price Reduced near 248 Heirloom Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

12301 E Jahant Rd, Acampo, CA 95220 - Photo 1 Price Reduced
-$20,000 (-2.11%)
$925,700
Open House

12301 E Jahant Rd  Acampo, CA 95220

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,710
    Sq. Ft.
Listed by HomeSmart ICARE Realty
18975 Lambert Way, Lockeford, CA 95237 - Photo 1 Price Reduced
-$5,000 (-0.91%)
$544,900

18975 Lambert Way  Lockeford, CA 95237

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,672
    Sq. Ft.
Listed by Game Realty
1540 Billorights Ave, Galt, CA 95632 - Photo 1 Price Reduced
-$1,000 (-0.17%)
$594,000

1540 Billorights Ave  Galt, CA 95632

  • Single Family
  • Active
  • Updated 16 hours ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,365
    Sq. Ft.
Listed by Mertitage Homes
749 Creekview Cir, Galt, CA 95632 - Photo 1 Price Reduced
-$10,000 (-1.87%)
$525,000

749 Creekview Cir  Galt, CA 95632

  • Single Family
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,401
    Sq. Ft.
Listed by Nick Sadek Sotheby's International Realty

Recent Sales near 248 Heirloom Ave

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

2931 Concerto Ct, Lodi, CA 95242 - Photo 1 Sold
$850,000

2931 Concerto Ct  Lodi, CA 95242

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 2,413
    Sq. Ft.
Listed by PMZ Real Estate
Sold by Redfin Corporation
3039 Concerto St, Lodi, CA 95242 - Photo 1 Sold
$810,000

3039 Concerto St  Lodi, CA 95242

  • Single Family
  • Closed
  • Updated 12 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,413
    Sq. Ft.
Listed and Sold by Advance 1 Professional Real Estate
2946 Valencia, Lodi, CA 95242 - Photo 1 Sold
$894,505

2946 Valencia  Lodi, CA 95242

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 2,937
    Sq. Ft.
Listed by Schaffer & Company, Realtors
Sold by Century 21 Tri-Dam Realty
198 Cottage Ln, Lodi, CA 95242 - Photo 1 Sold
$810,000

198 Cottage Ln  Lodi, CA 95242

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 2,876
    Sq. Ft.
Listed by Sherman & Associates RE
Sold by Rotner and Associates

248 Heirloom Avenue, Lodi, CA 95242 (MLS# 226090905) is a Single Family property with 5 bedrooms and 3 full bathrooms. 248 Heirloom Avenue is currently listed for $815,000 and was received on August 03, 2026. Want to learn more about 248 Heirloom Avenue? Do you have questions about finding other Single Family real estate for sale in Lodi? You can browse all Lodi real estate or contact a Coldwell Banker agent to request more information.

Tour this property