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!
Closed
$785,000
248 Heirloom Ave, Lodi, CA 95242
5beds
2,879sqft
Single Family Residence
Built in 2017
5,401 Square Feet Lot
$784,700 Zestimate®
$273/sqft
$3,454 Estimated rent
Home value
$784,700
$714,000 - $855,000
$3,454/mo
Zestimate® history
Owner options
List your home for rent
$3,454/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,454/mo
Rent Zestimate®
Refinance and save
$5,322/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$5,322/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Lovely landscapingOutdoor california roomBeautiful kitchen
Zillow last checked:
Listing updated:
Listed by:
Kim Arburua DRE #01103532 209-464-6700,
Full Circle Realty Associates
Bought with:
Joey Ferrari, DRE #01925797
Katzakian Real Estate
Source: MetroList Services of CA,MLS#: 226090905Originating MLS: MetroList Services, Inc.
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: $273/sqft
- Tax assessed value: $739,561
- Price range: $785K - $785K
- Date on market: 8/3/2026
Price history
| Date | Event | Price |
|---|---|---|
| 9/11/2026 | Sold | $785,000-1.8%$273/sqft |
Source: MetroList Services of CA #226090905 Report a problem | ||
| 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 |
Find assessor info on the county website
Neighborhood: 95242
Nearby homes
- $669,3003 bd2 ba2k sqft240 Heirloom Ave, Lodi, CA 95242Off Market
- $710,7004 bd3 ba2.6k sqft256 Heirloom Ave, Lodi, CA 95242Off Market
- $750,0003 bd3 ba3k sqft241 Landmark Ln, Lodi, CA 95242Sold
- $784,9004 bd3 ba2.6k sqft232 Heirloom Ave, Lodi, CA 95242Off Market
- $750,0003 bd3 ba2.4k sqft249 Landmark Ln, Lodi, CA 95242Sold
- $691,7003 bd2 ba2.1k sqft233 Landmark Ln, Lodi, CA 95242Off Market
- $711,7003 bd2 ba2.1k sqft3019 Radiance St, Lodi, CA 95242Off Market
- $755,5003 bd2 ba2.1k sqft3002 Radiance St, Lodi, CA 95242Off Market
Nearby schools
GreatSchools rating
- 8/10Vinewood Elementary SchoolGrades: K-6Distance: 1.1 mi
- 4/10Millswood Middle SchoolGrades: 7-8Distance: 0.9 mi
- 6/10Lodi High SchoolGrades: 9-12Distance: 1.2 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$784,700
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$784,700
- California
- San Joaquin County
- Lodi
- 95242
- 248 Heirloom Ave
