Seller's Agent in 2025
Susan Williams
PMZ Real Estate
(209) 327-8834
17 in this area
58 Total Sales
3039 Concerto St Lodi, CA 95242
Sunwest Neighborhood
3
Beds
2.5
Baths
2,413
Sq Ft
6,960
Sq Ft Lot
Highlights
- Solar Power System
- Great Room
- Quartz Countertops
- Wood Flooring
- Open Floorplan
- No HOA
About This Home
As of October 2025Welcome to Rose Gate, where timeless design & modern living come together in this beautifully upgraded home. From the moment you arrive, the iron gated entry opens to a charming courtyard, setting the tone of warmth & style before you even step inside. A grand welcome awaits you where 18' ceilings in the entry & living room create a light-filled, airy atmosphere. An open concept floor plan designed for both comfort & entertaining. The den with glass French doors offers a quiet retreat~perfect as a home office, library or creative space. At the heart of the home, the kitchen impresses with an abundance of cabinetry and expansive counter space, making it as functional as it is beautiful. The kitchen flows seamlessly into the living room, where a built-in enhances both style and storage. Throughout the home, engineered hardwood floors and high-end finishes bring sophistication to every room, while living spaces extend outdoors to the inviting California room. Step outside to the pergola-covered patio, a perfect setting for evening gatherings, Sunday brunches, or relaxing afternoons in the shade. From the gated courtyard to the elegant interiors & outdoor retreat, this residence offers more than just a home~ it offers a lifestyle of comfort, connection,& refined style.
Last Agent to Sell the Property
PMZ Real Estate License #02009787 Listed on: 08/29/2025
Home Details
Home Type
- Single Family
Year Built
- Built in 2022
Lot Details
- 6,960 Sq Ft Lot
- Landscaped
- Sprinklers on Timer
Parking
- 2 Car Attached Garage
- Electric Vehicle Home Charger
- Extra Deep Garage
- Front Facing Garage
- Garage Door Opener
Home Design
- Concrete Foundation
- Slab Foundation
- Frame Construction
- Blown Fiberglass Insulation
- Ceiling Insulation
- Floor Insulation
- Tile Roof
- Concrete Perimeter Foundation
- Masonry
- Plaster
- Stone
Interior Spaces
- 2,413 Sq Ft Home
- 1-Story Property
- Ceiling Fan
- Great Room
- Open Floorplan
- Dining Room
Kitchen
- Breakfast Area or Nook
- Breakfast Bar
- Built-In Gas Oven
- Self-Cleaning Oven
- Built-In Gas Range
- Range Hood
- Microwave
- Ice Maker
- Dishwasher
- Kitchen Island
- Quartz Countertops
- Ceramic Countertops
- Disposal
Flooring
- Wood
- Carpet
- Tile
Bedrooms and Bathrooms
- 3 Bedrooms
- Tile Bathroom Countertop
- Secondary Bathroom Double Sinks
- Low Flow Toliet
- Bathtub with Shower
- Separate Shower
- Low Flow Shower
Laundry
- Laundry in unit
- Sink Near Laundry
- Laundry Cabinets
- 220 Volts In Laundry
- Gas Dryer Hookup
Home Security
- Carbon Monoxide Detectors
- Fire and Smoke Detector
Eco-Friendly Details
- Solar Power System
- Solar owned by seller
Outdoor Features
- Fire Pit
- Pergola
Utilities
- Central Heating and Cooling System
- Heating System Uses Natural Gas
- Underground Utilities
- 220 Volts in Kitchen
- Tankless Water Heater
- Gas Water Heater
- High Speed Internet
- Cable TV Available
Community Details
- No Home Owners Association
Listing and Financial Details
- Assessor Parcel Number 027-470-26
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Aug 29, 2025
Closed on
Sep 29, 2025
Sold by
Nicholas L Walker L and Nicholas Shirley A
Bought by
Mitchell Cherie
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
-1.01%
Purchase Details
Closed on
Feb 14, 2022
Sold by
Rose Gate 2-Lodi Llc
Bought by
Nicholas L Walker And Shirley A Walker Revoca
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 Values in the Area
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Grant Deed | $839,000 | Old Republic Title | |
| Grant Deed | $829,500 | Old Republic Title |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 10/03/2025 10/03/25 | Sold | $839,000 | -3.6% | $348 / Sq Ft |
| 09/19/2025 09/19/25 | Pending | -- | -- | -- |
| 08/29/2025 08/29/25 | For Sale | $869,950 | -- | $361 / Sq Ft |
Source: MetroList
Tax History Compared to Growth
Tax History
| 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
-
Susan Williams
-
John DuBois
Buyer's Agent in 2025
John DuBois
Advance 1 Professional Real Estate
(209) 371-9664
12 in this area
85 Total Sales
Map
Source: MetroList
MLS Number: 225112652
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
- 3033 Concerto St
- 2731 Dazzler St
- 2665 Buttercup Dr
- The Poppy Plan at Rose Gate - Chelsea Collection
- The Poplar II Plan at Rose Gate - Carrousel Collection
- The Bayberry Plan at Rose Gate - Carrousel Collection
- The Terrace Plan at Rose Gate - Chelsea Collection
- The Hawthorn Plan at Rose Gate - Carrousel Collection
- Lavender Plan at Rose Gate - Carrousel Collection
- The Barcelona Plan at Rose Gate - Chelsea Collection
- The Coronado Plan at Rose Gate - Chelsea Collection
- The Landmark Plan at Rose Gate - Chelsea Collection
- The Aspen Plan at Rose Gate - Chelsea Collection
- 2585 Buttercup Dr
- 2929 Cammie Ln
- 2816 Applewood Dr
- 2926 La Jolla Way
- 2933 Coronado Dr
- 2921 Coronado Dr
- 208 Gramercy Park Dr