Great location, wide open living space with high ceilings and POOL/SPA/SLIDE! Corner lot with extended parking space/possible RV parking on side of property. MUST SEE!
Single-familyProperty Type
2001Year Built
10,019 sq ftLot Size
$247Est. Price/Sq.Ft.
3 car garageParking
Listed by Sara Elliott•DRE #01942409• The Mohan Group
Bought with Tana Goff•DRE #01932644• HomeSmart PV & Associates
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Permits
Beds
5
Baths
4
Stories
2
Lot width
—
Lot depth
—
Lot size
10,215 Sq. Ft.
Year renovated
—
Sq. Ft.
3,103
Year built
2001
Style
Single Family Residential
County
Stanislaus County
APN
046017039000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 13, 2026.
SP
Specific Plan Zone
Specific plans are established to enable land to be planned and developed as coordinated, comprehensive projects providing for systematic implementation of the General Plan, and provide a means to plan for specific areas, providing land use pattern, development standards, design guidelines, and development processes for these areas. The Purpose and Intent of the SP Zone is to permit various land uses including residential, industrial, and commercial development through Specific Plans, pursuant to Government Code Section 65450, et seq. The intent of this is to implement policies regarding certain uses, standards, and development review processes adopted through the Specific Plan process.
Mar 9, 2020 • Final
Res electrical
Electrical
Solar
Jan 24, 2002 • Final
Res pool
Pool and hot tub
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking & Garage Information
Garage Spaces: 3
Parking Features: Attached
Driveway Sidewalks: Sidewalk/Curb/Gutter
Interior
Bathroom Information
# of Bathrooms (Full): 4
Other Bathroom Features: Double Sinks, Shower Stall(s), Tub
Bedroom Information
# of Bedrooms (Total): 5
Heating & Cooling
Cooling: Central
Heating: Central
Interior Features
Fireplaces Total: 1
Fireplace Features: Family Room
Flooring: Tile, Wood
Window Features: Dual Pane Full
# of Stories: 2
Room Information
Room Type: Baths Other
Dining Room Features: Formal Area
Main Level: Bedroom(s), Full Bath(s)
Exterior
Exterior Features
Allows Horses: No
Roof: Tile
Pool Information
Pool Features: On Lot, Pool/Spa Combo
Has Private Pool: Yes
Has Spa: No
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Subtype Description: Attached
Property Condition: Updated/Remodeled
Year Built: 2,001
Lot Information
Lot Features: Corner
Lot Size Square Feet: 10,019
Lot Size Acres: 0.23
Utilities
Utility Information
Electric: 220 Volts in Laundry
Sewer: In & Connected
Irrigation Source: Public District
Water Source: Public
Location
HOA Information
Association YN: No
School Information
School District County: Stanislaus
Elementary School District: Modesto City
Middle Or Junior School District: Modesto City
High School District: Modesto City
Location Information
Postal Code Plus 4: 8777
Postal Code: 95356
County Or Parish: Stanislaus
CrossStreet: Carousel
Directions: 99 South towards Fresno, exit Palendale, keep left on Palendale, right on Carver, right onto Carousel, left on Front, house is on corner of left hand side.
State Or Province: CA
Street Number Numeric: 4024
Unparsed Address: 4024 Front St, Modesto, CA 95356-8777
Street Address Filtered: 4024 Front St
Community Information
Senior Community YN: No
Public facts
Beds: 5
Baths: 4.0
Sq. Ft.: 3,103
Stories: 2.0
Lot Size: 10,215 square feet
Style: Single Family Residential
Year Built: 2001
Year Renovated: —
County: Stanislaus County
APN: 046017039000
Home facts updated by county records on Jul 13, 2026
Other
Selling Agent
Buyer Agent Full Name: Tana Goff
Around this home
Schools
Mary Lou Dieterich Elementary School
Public K-6 • Assigned • 0.8mi
6/10
Prescott Junior High School
Public 7-8 • Assigned • 1.1mi
4/10
Joseph A. Gregori High School
Public 9-12 • Assigned • 2.6mi
7/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
3/10 Flood Factor
Estimated 10-14% chance of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
7/10 Heat Factor
7 days above 102° expected this year, 15 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
10/10 Air Factor
28 unhealthy days expected this year, 32 days in 30 years
Provided by First Street
Historical weather
Modesto, CA • 95356
Average low and high temperatures (°F)
59
39
64
44
72
48
74
49
83
54
89
58
91
59
94
62
89
61
79
55
64
47
55
44
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 13 hours in
June and 4.6 hours in December, placing it above the
U.S. average for solar exposure.
13 hrs
4.6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$729,000 – $883,000
Reach more buyers when you sell with Redfin. Save up to $7,671 in fees.3 minutes to get started.