Pending

Concerto Street

Lodi, CA 95242
Mark as Favorite
Bed 4

Bed

Bath 3

Bath

SqFt2,607

Sqft

Welcome to Rose Gate 2 - This stunning 2022 built, single-story 2607 sq ft. farmhouse beauty boasts 4/2.5 baths with custom upgrades and OWNED SOLAR. Entertain with family and friends in this wide open concept living area including 4'' plantation shutters, a wine bar with 2 wine refrigerators, grand 15' island with sink, custom to the ceiling cabinets, Beautiful SS GE Cafe appliances, Bravada engineered HW floors and crown molding. Tesla EV charging in the garage. Entertain in your backyard or sit with coffee in the morning under your lighted covered patio w/ceiling fans. A must see to appreciate all the love that went into this home. Come take a look - you won't be disappointed!

Detail Ic Property Details

Property Type : Residential

Price : $829,000

AD Id : 60430352

MLS Id : 224124247

Beds : 4

Living Area Size : 2,607

Year Built : 2022

County : San Joaquin

  • Map Map

Map

Feature Features

  • Bedroom Information

    Total beds: 4

    Bathroom Information

    Total Baths: 3 Full Baths: 2

    Water/Sewer

    Sewer: Public Sewer

    Room Information

    Total Bedroom: 4
  • Flooring Information

    Carpet, Tile, Wood, See Remarks
  • Roofing Information

    Tile
  • Interior Features

    Roof: Tile Appliances: Gas Cook Top, Built-In Gas Oven, Dishwasher, Disposal, Plumbed For Ice Maker, Tankless Water Heater, Wine Refrigerator Laundry Features: Cabinets, Gas Hook-Up, Ground Floor, Inside Room
  • Heating & Cooling

    Heating: Central Cooling: Ceiling Fan(s), Central, See Remarks WaterSource: Public
  • Fireplace

    Number of Fireplaces: 0 Fireplace Features: 0

  • Building Information

    Year Built: 2022 Construction Materials: Stucco, Wood Roof: Tile Foundation Details: Slab
  • Exterior Features

    Foundation Details: Slab
    Porch: Covered Patio
  • Road Types

    Asphalt
  • Laundry Features

    Cabinets, Gas Hook-Up, Ground Floor, Inside Room

    Patio And Porch

    Covered Patio

  • Lot Information

    Lot Description: Auto Sprinkler Front, Curb(s)/Gutter(s), Shape Regular, Grass Artificial, Landscape Front, See Remarks, Low Maintenance Lot Square Feet: 6,299 Stories: 1 Main Square Feet: 2,607

    Property Information

    Property Type: Residential Sub Type: Single Family Residence Style: Contemporary,Farmhouse SQ ft (Living Area): 2,607 Subdivision: Rose Gate 2 Source Neighborhood: Rose Gate 2 Construction Materials: Stucco,Wood Property Age: 4 Cross Street: W Lodi Ave Source Neighborhood: 20901 Postal Code Plus 4: 8803 Area: Lodi S: 95242 Zoning: SFR Living Area Source: Builder Structure Type: Detached

    Farm Info

    Irrigation Source: None

  • Listing Price Information

    Listing Id: 224124247 List Price: $829,000 List Price Tot SqFt: $318

  • Tax Information

    Parcel Number: 027-470-04

  • Parking Information

    # of Garage Spaces: 2 Attached, EV Charging, Garage Door Opener, Garage Facing Front

  • Elementary School District: Lodi Unified
    Junior High School District: Lodi Unified
    Senior High School District: Lodi Unified
  • Utility Information

    Cable Available, Public, Solar, Internet Available, Natural Gas Connected Electric: 220 Volts in Kitchen, 220 Volts in Laundry, Photovoltaics Seller Owned, See Remarks
  • Location Information

    Direction: W lodi Ave, west to Rose Gate 2 - left to Concerto and right to property
Sell a home like this and save $49,241 Find out How

How much is this property worth?

Curious about this home's true market value? Use our free Home Evaluation Tool to instantly get a personalized Comparative Market Analysis (CMA) report. Make smarter, data-driven decisions before you buy.

Images
Loading, please wait...

Nearby Home Value

Address Estimate Bed Bath Sq. Ft Lot Size
Tienda Drive, Lodi, CA, 95242 $532,750 3 3 1,872 1,872 SqFt
Oleander Drive, Lodi, CA, 95242 $624,990 3 2 1,855 1,855 SqFt
Carrousel Street, Lodi, CA, 95242 $799,900 3 3 2,544 2,544 SqFt
Tejon Street, Lodi, CA, 95242 $669,500 4 3 2,256 2,256 SqFt
Incline Drive, Lodi, CA, 95242 $615,000 3 3 2,247 2,247 SqFt
Fuchsia Drive, Lodi, CA, 95242 $899,000 5 3 3,187 3,187 SqFt
Lombard Street, Lodi, CA, 95242 $1,650,000 4 5 4,600 4,600 SqFt
Vienna Drive, Lodi, CA, 95242 $1,099,000 4 3 3,620 3,620 SqFt
Moore Road, Lodi, CA, 95242 $1,999,000 5 4 4,343 4,343 SqFt
Junewood Court, Lodi, CA, 95242 $705,000 3 3 2,039 2,039 SqFt

ByOwner last updated this listing 06/12/2026 @ 02:05

MLS: 224124247 LISTED BY: Cynthia Karzen, Berkshire Hathaway HomeServices-Drysdale Properties SOURCE: MLS Metrolist

Selling? Save $49,241 when you sell a home like this

Tour with a ByOwner Agent