Home | San Joaquin County | Lodi | 95242 | 3039 Concerto St
MLS: ME226072668 | Status: Active | Price: $849,950
Beds/Baths: 3 / 2 /1
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 3 | 2 /1 | 2,413 | 6,961 | – |
Welcome home to the highly coveted community of Rose Gate. 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. 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.
| Field | Value |
|---|---|
| MLS # | ME226072668 |
| MLS Source | MetroList Services, Inc. |
| Days on Site | 1 |
| Feature | Details |
|---|---|
| Bedrooms | Primary Bath, Primary Suite/Retreat |
| Bathrooms | Primary - Tub |
| Kitchen | Breakfast Bar, Breakfast Nook, Hookups - Ice Maker, Island with Sink, Kitchen/Family Room Combo, Other |
| Appliances | Cooktop - Gas, Dishwasher, Garbage Disposal, Other, Oven - Built-In, Oven - Electric, Oven Range - Built-In, Gas |
| Dining Room | Dining Area in Family Room, Other |
| Family Room | Kitchen/Family Room Combo, Other, Vaulted Ceilings, View |
| Flooring | Carpet, Tile, Wood |
| Laundry | 220 Volt Outlet, Cabinets, Hookup - Gas Dryer, In Laundry Room, Laundry - Yes, Tub / Sink |
| Cooling | Ceiling Fan, Central Forced Air |
| Heating | Central Forced Air, Gas, Solar |
| Feature | Details |
|---|---|
| Roof | Tile |
| Foundation | Slab, Concrete Perimeter and Slab |
| Pool | Pool - No |
| Style | Other |
| Feature | Details |
|---|---|
| Garage/Parking | 24'+ Deep Garage, Electric Car Hookup, Facing Front, Garage: 2 Car(s) |
| Elementary District | Lodi Unified |
| High School District | Lodi Unified |
| Sewer | Public Sewer |
| Water | Public |
| Zoning | SFR |
John DuBois
Advance 1 Professional Real Estate
License #: 01970857
Phone: (209) 371-9664
| # Buildings | # Leased Units | # Total Units |
|---|---|---|
| 0 | – | – |
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| Millswood Middle School | public | 7-8 | 0.97 mi | 4 |
| Erma B. Reese Elementary School | public | K-6 | 1.08 mi | 6 |
| Vinewood Elementary School | public | K-6 | 1.12 mi | 8 |
| Lodi High School | public | 9-12 | 1.22 mi | 6 |
| Lodi Middle School | public | 7-8 | 1.47 mi | 4 |
| Woodbridge School | public | K-6 | 1.50 mi | 4 |
| George Washington Elementary School | public | K-6 | 1.72 mi | 7 |
| Liberty High School | public | 9-12 | 1.80 mi | 2 |
| Lakewood Elementary School | public | K-6 | 1.86 mi | 6 |
| Leroy Nichols Elementary School | public | K-6 | 1.90 mi | 4 |
| Ellerth E. Larson Elementary School | public | K-6 | 1.92 mi | 6 |
| Valley Robotics Academy | public | K-12 | 2.03 mi | 4 |
| Walter J. Katnich Community Day School | public | 7-12 | 2.03 mi | N/A |
| Independence School | public | K-12 | 2.03 mi | 5 |
| Henderson School | public | 7-8 | 2.03 mi | N/A |
| Tokay High School | public | 9-12 | 2.09 mi | 5 |
| Clyde W. Needham Elementary School | public | K-6 | 2.10 mi | 7 |
| Beckman Elementary School | public | K-6 | 2.46 mi | 5 |
| Lawrence Elementary School | public | K-6 | 2.71 mi | 5 |
| Heritage Elementary School | public | K-6 | 2.84 mi | 4 |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 1854 Botticelli Way | $689,999 | 5 | 3/1 | 2,560 | Active |
| 3031 Ashton St | $859,000 | 3 | 3/1 | 2,398 | Active |
| 3009 Tulip Way | $724,888 | 3 | 3 | 2,279 | Active |
| 750 Greenwood Dr | $685,000 | 4 | 2 | 1,870 | Active |
©2026 MetroList Services, Inc. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MetroList Services, Inc.
Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.
This listing information is up-to-date as of June 08, 2026. For the most current information, please contact John DuBois, (209) 371-9664.