This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
$595,900
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/1
Property Description
This two-story, four-bedroom, two-and-a-half bath home is simply stunning. The chef-ready kitchen includes stainless steel appliances, granite countertops, oversized wood cabinetry and a large, corner pantry. Upstairs, you will find the four large bedrooms, including the master suite. The master suite showcases a stunning en-suite bathroom with a dual-sink vanity, extended shower and a huge walk-in closet. In addition, this home comes with designer-selected upgrades included at no extra cost such as luxury vinyl-plank flooring, a Wi-Fi-enabled garage door opener, programmable thermostat, included solar panels and more.
Full Property Details
Full Property Details for 3149 Aerosmith Way
Sign in to view more details. Local MLS Rules require you to be signed in. Not a member yet? Sign up now.
General
- Sold For: $595,900
- Status: Closed
- Type: Single Family
- Source: BAREIS
- MLS ID: 225073993
- Added to Site: 225 day(s) ago
Interior
- Appliances: Tankless Water Heater, Microwave, Dishwasher, Gas Cook Top, Free Standing Refrigerator, Free Standing Gas Range, Free Standing Gas Oven
- Flooring: Wood, Vinyl, Carpet
Rooms
Bathrooms
- Total Bathrooms: 3
- Full Bathrooms: 2
- Half Bathrooms: 1
- Bathroom Features: Tub w/Shower Over, Low-Flow Toilet(s), Stone
Bedrooms
- Total Bedrooms: 4
- Primary Bedroom: Walk-In Closet
Other Rooms
- Living Room: Great Room
- Kitchen: Stone Counter, Island, Granite Counter, Pantry Closet, Breakfast Area
- Dining Room: Dining/Living Combo
- Laundry: Inside Room, Hookups Only, Upper Floor, Gas Hook-Up
Additional Information
- Security/Safety: Smoke Detector, Carbon Mon Detector
Parking
- Garage: Yes
- Garage Spaces: 2
- Garage Description: Interior Access, Uncovered Parking Spaces 2+, Garage Facing Front, Garage Door Opener, Attached, Private
Location
- Cross Streets: Holman Road
- Driving Directions: From CA-99 N, Exit onto East Morada Lane. Turn Right onto 99 Frontage Road, Right onto Morada Lane, and Right onto Holman Road. Turn Left onto Lt Col Mark Taylor St, Right onto Nash Drive, and Right onto Righteous Drive.
School Information
- School District: San Joaquin
- Elementary School: Lodi Unified
- Middle School: Lodi Unified
- High School: Lodi Unified
Heating & Cooling
- Cooling Type: Central, Ceiling Fan(s)
- Heating Type: Natural Gas, Gas, Central
Utilities
- Sewer: Public Sewer
- Water: Public
- Utility Description: Underground Utilities, Solar, Sewer Connected, Public, Natural Gas Connected, Internet Available, Electricity, Cable TV Available
Structural Information
- Architectural Style: Craftsman
- Builder: LLC, LGI Homes - California
- Construction: Wood, Lap Siding, Wall Insulation, Stucco, Fiber Cement, Concrete, Ceiling Insulation
- Foundation: Slab, Concrete
- Roof: Composition, Shingle
- Windows: Window Screens, Low E Glass Partial, Window Coverings, Weather Stripped, Dual Pane Partial
- Stories/Levels: 2
- Square Feet: 1,907
- Sq. Ft. Source: Builder
- Year Built: 2025
Lot Features
- Lot Size (Acres): 0.1259
- Lot Size (Sq. Ft.): 5,484
- Zoning: Residential
- Lot Description: Landscape Front
- Fencing (Description): Wood, Fenced, Back Yard
Disclosures and Reports
- Special Conditions: None
Listing provided by LGI Realty - California, Inc., Jeanine M Roach
Listing agent
— 3149 Aerosmith Way —
Jeanine M Roach
LGI Realty - California, Inc.
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 3149 Aerosmith Way
School District:Lodi Unified School District
| Name | Grades | Distance |
|---|---|---|
George Lincoln Mosher 3220 Buddy Holly Drive, Stockton, CA 95212 | K-6 | 0.3 mi |
Morada Middle School 5001 E.view Dr., Stockton, CA 95212 | 7-8 | 1.4 mi |
Ronald E. Mcnair High School 9550 Ronald E. McNair Way, Stockton, CA 95210 | 9-12 | 1.6 mi |
Disclaimer:
School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 2 days ago
- 4Beds
- 3Total Baths
Listed by Real Estate Ebroker Inc, Weiqing Yan
- Single Family
- Active
- Updated 9 days ago
- 4Beds
- 3Total Baths
Listed by Intero Real Estate Services, Vidal Prevost
- Single Family
- Active
- Updated 3 days ago
- 4Beds
- 3Total Baths
- 1,907Sq. Ft.
Listing provided by LGI Realty - California, Inc., Jeanine M Roach
- Single Family
- Active
- Updated 3 days ago
- 4Beds
- 3Total Baths
- 1,907Sq. Ft.
Listing provided by LGI Realty - California, Inc., Jeanine M Roach
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- Updated 23 hours ago
- 5Beds
- 5Total Baths
Listed by AHERN REAL ESTATE GROUP (925) 837-4100
- Single Family
- Active
- Updated 2 days ago
- 4Beds
- 4Total Baths
Listed by Kiper Development, Inc., John Kiper
- Single Family
- Active
- Updated 4 days ago
- 4Beds
- 2Total Baths
- 1,603Sq. Ft.
Listed by KB HOME Sales-Northern California Inc
- Single Family
- Active
- Updated 3 days ago
- 4Beds
- 4Total Baths
- 3,175Sq. Ft.
Listed by PMZ Real Estate
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Condo
- Active
- Updated 43 minutes ago
- 3Beds
- 2Total Baths
Listed by Real Estate Source, Inc., Shanee Hawkins
- Condo
- Active
- Updated 2 hours ago
- 3Beds
- 2Total Baths
- 1,500Sq. Ft.
Listed by Zuffalo Real Estate
- Single Family
- Active
- Updated 5 days ago
- 4Beds
- 3Total Baths
Listed by Redfin, Laralee Miller
- Single Family
- Active
- Updated 23 hours ago
- 4Beds
- 3Total Baths
- 1,714Sq. Ft.
Listed by PMZ Real Estate
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Closed
- 5Beds
- 3Total Baths
- 2,208Sq. Ft.
Listing and Sold provided by LGI Realty - California, Inc., Jeanine M Roach
- Single Family
- Closed
- 3Beds
- 2Total Baths
- 1,505Sq. Ft.
Listing provided by LGI Realty - California, Inc., Jeanine M Roach
- Single Family
- Closed
- 3Beds
- 2Total Baths
- 1,505Sq. Ft.
Listing provided by LGI Realty - California, Inc., Jeanine M Roach
- Single Family
- Closed
- 4Beds
- 2Total Baths
- 1,837Sq. Ft.
Listing provided by LGI Realty - California, Inc., Jeanine M Roach
3149 Aerosmith Way, Stockton, CA 95212 (MLS# 225073993) is a Single Family property that was sold at $595,900 on December 08, 2025. Want to learn more about 3149 Aerosmith Way? Do you have questions about finding other Single Family real estate for sale in Stockton? You can browse all Stockton real estate or contact a Coldwell Banker agent to request more information.