Hayley Friedman
eXp Realty of California Inc.
(916) 915-0389
49 Total Sales
1 in Sunwest
$742,800 Price
3039 Concerto St Lodi, CA 95242
Sunwest Neighborhood
3
Beds
2.5
Baths
2,413
Sq Ft
6,961
Sq Ft Lot
Highlights
- Solar Power System
- Cathedral Ceiling
- Window or Skylight in Bathroom
- Custom Home
- Wood Flooring
- Great Room
About This Home
As of July 2026Welcome home to the highly coveted community of Rose Gate, located in America's Favorite Small Town (Parade Magazine 2026) and affectionally recognized as the "Zinfandel Capital Of The World." This beautifully designed and exquisitely upgraded home is sure to please with it's iron gated entry into your courtyard and beautiful stone accents covering the walls for a stunning look. With well over $100,000 in upgrades and owned solar, it's better than buying new. Oh my, the 18 foot ceilings in the great room surrounded by high-end wood flooring and the most incredible view to your backyard is all surrounded by the open concept floor plan and one of the most elaborate kitchens around. With high-end Cafe' appliances and a 6 burner stove top, the chef in the family is sure to be satisfied. With 3 large bedrooms and an office/den, you will easily have plenty of room for your family and guests. The outside California room has a ceiling fan, the backyard has a beautiful pergola and amazing landscaping with artificial turf and new french drains put in in last couple of months. With so many more amazing features you must see this home in person to truly appreciate it's beauty.
Last Agent to Sell the Property
Advance 1 Professional Real Estate License #01970857 Listed on: 06/07/2026
Last Buyer's Agent
Advance 1 Professional Real Estate License #01970857 Listed on: 06/07/2026
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Details
Home Type
- Single Family
Year Built
- Built in 2022
Lot Details
- 6,961 Sq Ft Lot
- South Facing Home
- Back Yard Fenced
- Sprinklers on Timer
Parking
- 2 Car Garage
- 2 Open Parking Spaces
- Electric Vehicle Home Charger
- Extra Deep Garage
- Front Facing Garage
Home Design
- Custom Home
- Slab Foundation
- Tile Roof
- Stucco
Interior Spaces
- 2,413 Sq Ft Home
- 1-Story Property
- Cathedral Ceiling
- Ceiling Fan
- Double Pane Windows
- Great Room
- Open Floorplan
- Dining Room
- Property Views
Kitchen
- Breakfast Area or Nook
- Built-In Electric Oven
- Built-In Gas Range
- Plumbed For Ice Maker
- Dishwasher
- Kitchen Island
- Quartz Countertops
- Disposal
Flooring
- Wood
- Carpet
- Tile
Bedrooms and Bathrooms
- 3 Bedrooms
- Walk-In Closet
- Quartz Bathroom Countertops
- Tile Bathroom Countertop
- Secondary Bathroom Double Sinks
- Bathtub with Shower
- Window or Skylight in Bathroom
Laundry
- Laundry Room
- Sink Near Laundry
- Laundry Cabinets
- 220 Volts In Laundry
- Gas Dryer Hookup
Home Security
- Security System Leased
- Carbon Monoxide Detectors
- Fire and Smoke Detector
Eco-Friendly Details
- Energy-Efficient Appliances
- Energy-Efficient Windows
- Solar Power System
Outdoor Features
- Covered Patio or Porch
Utilities
- Central Heating and Cooling System
- Natural Gas Connected
- Tankless Water Heater
- Gas Water Heater
Community Details
- No Home Owners Association
- Built by FCB
- Rose Gate 2 Valencia Subdivision
Listing and Financial Details
- Home warranty included in the sale of the property
- Assessor Parcel Number 027-470-26
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Aug 29, 2025
Closed on
Sep 29, 2025
Sold by
Bought by
Seller's Agent
Susan Williams
PMZ Real Estate
Buyer's Agent
John DuBois
Advance 1 Professional Real Estate
List Price
$869,950
Sold Price
$839,000
Premium/Discount to List
-$30,950
-3.56%
Views
130
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-0.52%
Purchase Details
Closed on
Oct 4, 2023
Sold by
Bought by
Purchase Details
Closed on
Feb 14, 2022
Sold by
Bought by
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Sunwest, CA
-
Hayley Friedman
-
Ryan Hansen
Ryan Hansen
HomeSmart PV & Associates
(209) 719-3856
76 Total Sales
6 in Sunwest
$285K - $525K Price Range
-
Jenna Diaz
Jenna Diaz
eXp Realty of Northern California, Inc.
(209) 680-2563
34 Total Sales
2 in Sunwest
$420K - $548K Price Range
-
Marin Whitaker
Marin Whitaker
Mid Valley Funding and Investment
(916) 848-5913
25 Total Sales
1 in Sunwest
$625,000 Price
-
Megan Blackwell
Megan Blackwell
Amen Real Estate
(279) 529-0258
130 Total Sales
1 in Sunwest
$515,000 Price
-
Jennifer Vignali
Jennifer Vignali
Berkshire Hathaway HomeService
(209) 299-3018
23 Total Sales
2 in Sunwest
$580K - $587K Price Range
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Grant Deed | $839,000 | Old Republic Title | |
| Quit Claim Deed | -- | None Listed On Document | |
| Grant Deed | $829,500 | Old Republic Title |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 07/24/2026 07/24/26 | Sold | $810,000 | -2.4% | $336 / Sq Ft | |
| 06/28/2026 06/28/26 | Pending | -- | -- | -- | |
| 06/22/2026 06/22/26 | Price Changed | $829,950 | 0.0% | $344 / Sq Ft | |
| 06/22/2026 06/22/26 | For Sale | $829,950 | -2.4% | $344 / Sq Ft | |
| 06/16/2026 06/16/26 | Pending | -- | -- | -- | |
| 06/07/2026 06/07/26 | For Sale | $849,950 | +1.3% | $352 / Sq Ft | |
| 10/03/2025 10/03/25 | Sold | $839,000 | -3.6% | $348 / Sq Ft | View Prior Sale |
| 09/19/2025 09/19/25 | Pending | -- | -- | -- | |
| 08/29/2025 08/29/25 | For Sale | $869,950 | -- | $361 / Sq Ft |
Source: MetroList
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $5,975 | $502,077 | $45,186 | $456,891 |
| 2024 | $5,815 | $492,233 | $44,300 | $447,933 |
| 2023 | $5,741 | $482,582 | $43,432 | $439,150 |
| 2022 | $914 | $84,523 | $84,523 | $0 |
| 2021 | $482 | $42,866 | $42,866 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
John DuBois
Seller's Agent in 2026
John DuBois
Advance 1 Professional Real Estate
(209) 371-9664
11 in this area
76 Total Sales
-
Susan Williams
Seller's Agent in 2025
Susan Williams
PMZ Real Estate
(209) 327-8834
19 in this area
55 Total Sales
Map
Source: MetroList
MLS Number: 226072668
APN: 027-470-26
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.
Nearby Homes
- 248 Heirloom Ave
- 3045 Celebration Dr
- 217 Jubilee St
- 2924 Ashton St
- 2906 Ashton St
- 185 Jubilee St
- 3057 Carrousel St
- 2640 Tiffany St
- 2919 La Jolla Way
- 2664 Ponderosa Dr
- 2639 Creekside Dr
- 705 Elina St
- 727 Chelsea St
- 2586 Knobcone Ln
- 2924 Alexandra St
- 2918 Alexandra St
- 2925 La Jolla Way
- 2548 Knobcone Ln
- 2920 La Jolla Way
- 2486 Central Park Dr
Your Personal Tour Guide
Ask me questions while you tour the home.