See other homes in:
Primary listing photo
Listing photo 2
Listing photo 3
Listing photo 4
Listing photo 5

248 Heirloom Ave, Lodi, CA, 95242

5beds
3baths
2,879sqft
$815,000
$283price/sqft
$5,716/moest. monthly cost
$228,640/yrincome needed

About 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!

Getting Around

35
WalkingCar-Dependent
0
TransitVery Limited Transit
38
BikeSomewhat Bikeable

Schools

8/10
4/10
Millswood Middle SchoolGrades 7-80.9 mi
6/10
Lodi High SchoolGrades 9-121.2 mi

Construction

Condition

  • Year built: 2017

Materials

  • Foundation: Slab
  • Roof: Tile
  • Construction materials: Stucco

Type & Style

  • Home type: SingleFamily
  • Property subType: Single Family Residence

Interior

Appliances

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

Bedrooms & Bathrooms

  • Bedrooms: 5
  • Bathrooms: 3
  • Full bathrooms: 3

Dining Room

  • Features: Bar,Space in Kitchen

Features

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

Heating & Cooling

  • Heating features: Central
  • Cooling features: Ceiling Fan(s),Central Air

Interior Area

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

Kitchen

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

Master Bathroom

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

Master Bedroom

  • Features: Walk-In Closet(s)

Property

Details

  • Parcel number: 029560100000
  • Zoning: residential
  • Special condition: Standard

Features

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

Lot

  • Lot size: 5,401 sqft
  • Features: Auto Sprinkler F&R,Shape Regular,Landscape Back,Landscape Front

Parking

  • Total spaces: 2
  • Parking features: Garage Door Opener,Garage Faces Front
  • Has garage: Yes
  • Attached garage spaces: 2
  • Covered spaces: 2

Climate Risk is Financial Risk

Every home has a financial story beyond the listing price. Below, you’ll see the climate risks that could affect this property — and in Bills & Affordability, how those risks may influence repairs, insurance, utilities, and long-term value.

Biggest Threats for This Home

  • Inland Flooding
    Inland FloodingVery High
  • Drought
    DroughtModerate
  • Earthquake
    EarthquakeModerate
  • Heat Wave
    Heat WaveModerate

How This Home’s Risks Compare

Inland Flooding
Drought
Earthquake
Heat Wave

FEMA Declared Disasters in San Joaquin County and California

Earthquake
Flood
Mud Landslide
Severe Ice Storm
Severe Storm
Snowstorm
Straight Line Winds
Tropical Storm
Winter Storm

Understanding the Costs

Financial advisors generally recommend spending no more than 30% of your gross household income on housing costs. In practice, many households stretch to 35% or beyond — especially in high-cost markets.

Estimated Costs Today

MonthlyAnnual
Mortgage $4,121$49,452
Home Insurance *$186$2,232
Property Taxes $792$9,504
Electricity $617$7,408
Total$5,716$68,592
*Does not include cost of any FAIR Plan premiums

Income You'd Need if You Spent...

35% on housing$195,977/yr
40% on housing$171,480/yr
45% on housing$152,426/yr

California FAIR Plan Programs

California FAIR Plan Association

Covered
WildfireWildfire
Visit Website →
Current Policies
Residential: 417,310Commercial: 13,990
Total Premiums$1.42B
Total Exposure$429.84B

How Costs Could Change Over Time

Climate risk is quickly impacting all of the major home ownership costs. Adjust the growth rates and percentage of income spent on housing below to see how your housing costs could change over the next 10 years — and what income you'd need to keep up.

Insurance Growth Rate5-year average: 6.0%
6.0%
0%30.0%
Electricity Growth Rate10-year average: 4.3%
4.3%
0%15.0%
Property Taxes Growth Rate2-year average: 1.6%
1.6%
0%15.0%
Income Spent on Housing
30%
30%45%

Comparing Against the Market

Price Per Sq Ft

$283This listing

vs Other Active Listings

Avg $/sqft

ZIP 95242$312
San Joaquin County$288

vs Homes Sold Last Month

Median $/sqft

ZIP 95242$314
San Joaquin County$300

Current Market Trends

Median Price Per Square Foot

The median price per square foot of homes sold in this area each month. Compare this to this listing's price per square foot to gauge whether the home is priced in line with recent sales.

Historicals for This Listing

Zestimate History ($/sqft)

No zestimate history available

Price History

DateEventPrice
2026-08-14Pending sale$799,000
2026-08-11Price change$799,000
2026-08-03Listed for sale$815,000
2017-06-16Sold$518,000

For Sale by Agent

AgentKim Arburua
BrokerageFull Circle Realty Associates

Similar Homes