Pending

Price cut: $16K (8/11)

$799,000

248 Heirloom Ave, Lodi, CA 95242

5beds

2,879sqft

$5,224/mo

Get pre-qualified

Single Family Residence

Built in 2017

5,401 Square Feet Lot

$793,100 Zestimate^®

$278/sqft

$-- HOA

What's special

Lovely landscapingOutdoor california roomBeautiful kitchen

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!

24 days

680

39

Facts & features

Interior

Bedrooms & bathrooms

Bedrooms: 5
Bathrooms: 3
Full bathrooms: 3

Primary bedroom

Features: Walk-In Closet(s)

Primary bathroom

Features: Shower Stall(s), Double Vanity, Tub

Dining room

Features: Bar, Space in Kitchen

Kitchen

Features: Pantry Closet, Granite Counters, Island w/Sink

Heating

Central

Cooling

Ceiling Fan(s), Central Air

Appliances

Included: Built-In Electric Oven, Gas Cooktop, Range Hood, Dishwasher, Disposal, Microwave, Tankless Water Heater, Dryer, Washer
Laundry: Cabinets, Gas Dryer Hookup, Inside Room

Features

Flooring: Carpet, Tile
Number of fireplaces: 1
Fireplace features: Outside, Gas

Interior area

Total structure area: 0
Total interior livable area: 2,879 sqft

Property

Parking

Total spaces: 2
Parking features: Garage Door Opener, Garage Faces Front
Garage spaces: 2

Features

Levels: Two
Stories: 2
Exterior features: Balcony
Fencing: Back Yard,Fenced

Lot

Size: 5,401 Square Feet
Features: Auto Sprinkler F&R, Shape Regular, Landscape Back, Landscape Front

Details

Additional structures: Shed(s)
Parcel number: 029560100000
Zoning: residential
Special conditions: Standard

Construction

Type & style

Home type: SingleFamily
Property subtype: Single Family Residence

Materials

Stucco
Foundation: Slab
Roof: Tile

Condition

Year built: 2017

Utilities & green energy

Electric: 220 Volts
Sewer: Public Sewer
Water: Public
Utilities for property: Public, Sewer Connected, Electric, Natural Gas Connected

Community & HOA

Community

Subdivision: Rose Gate 2

Location

Region: Lodi

Financial & listing details

Price per square foot: $278/sqft
Tax assessed value: $739,561
Price range: $799K - $799K
Date on market: 8/3/2026

Estimated market value

$793,100

$753,000 - $833,000

$3,586/mo

Price history

Date	Event	Price
8/14/2026	Pending sale	$799,000$278/sqft
Source: MetroList Services of CA #226090905 Report a problem
8/11/2026	Price change	$799,000-2%$278/sqft
Source: MetroList Services of CA #226090905 Report a problem
8/3/2026	Listed for sale	$815,000+57.3%$283/sqft
Source: MetroList Services of CA #226090905 Report a problem
6/16/2017	Sold	$518,000$180/sqft
Source: Public Record Report a problem

Public tax history

Year	Property taxes	Tax assessment
2026	--	$739,561 +2%
2025	$8,382 +2.8%	$725,061 +2%
2024	$8,157 +20.5%	$710,845 +23%
2023	$6,770 +2.3%	$577,812 +2%
2022	$6,619 -1.4%	$566,484 +2%
2021	$6,716 +2.6%	$555,377 +1%
2020	$6,544 +2.1%	$549,683 +2%
2019	$6,411 +1.7%	$538,906 +2%
2018	$6,306 +188.1%	$528,340 +168.3%
2017	$2,189 +157.4%	$196,901 +145.2%
2016	$850	$80,295 +29.8%
2015	--	$61,841