Beautifully renovated and expansive 5 bedroom, 3.5 bath single family home in desirable and quiet residential Modesto neighborhood. Complete with vaulted ceilings, ample lighting, and a wonderful layout, the home consists of two enormous master suites, one on the top floor and one on the bottom floor. The suites are equipped with large bathtubs and showers, and walk-in closets. The living room is expansive with a highly vaulted ceiling. The home underwent renovation in 2018 with brand new carpet, paint, appliances and modern furnishings. New AC unit in 2019. This home is perfect for a large family or for investors seeking a profitable business. The home has excellent curb appeal with a three car garage and an extra wide driveway which was completed in March 2020 to enable ample extra off-street driveway parking. Highly regarded neighborhood and excellent location!! Come see this gorgeous home today!!!
Single-familyProperty Type
2003Year Built
6,909 sq ftLot Size
$222Est. Price/Sq.Ft.
3 car garageParking
Listed by Yan Liu•DRE #01951111• Real Estate EBroker Inc.
Bought with Alvin Prasad•DRE #01779078• RE/MAX Executive
*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
3.5
Stories
—
Lot width
—
Lot depth
—
Lot size
6,909 Sq. Ft.
Year renovated
—
Sq. Ft.
2,911
Year built
2003
Style
Single Family Residential
County
Stanislaus County
APN
085044076000
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.
Apr 3, 2003 • Final
New sfd
New construction
Dec 2, 2002 • Active
Water and sewer
Plumbing
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
Interior
Bathroom Information
# of Bathrooms (Full): 3
# of Bathrooms (Partial): 1
Other Bathroom Features: Double Sinks, Tub, Tub w/Shower Over
Bedroom Information
# of Bedrooms (Total): 5
Heating & Cooling
Cooling: Central
Heating: Central
Interior Features
Fireplaces Total: 1
Fireplace Features: Circulating
Flooring: Carpet, Tile, Other, Linoleum/Vinyl
Laundry Features: Inside Room
# of Stories: 2
Room Information
Room Type: Baths Other
Dining Room Features: Dining/Living Combo
Main Level: Bedroom(s), Full Bath(s)
Exterior
Exterior Features
Allows Horses: No
Roof: Tile
Pool Information
Has Private Pool: No
Has Spa: No
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Subtype Description: Detached
Property Condition: Updated/Remodeled
Year Built: 2,003
Lot Information
Lot Features: Other
Lot Size Square Feet: 6,909
Lot Size Acres: 0.1586
Utilities
Utility Information
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: 7870
Postal Code: 95355
County Or Parish: Stanislaus
CrossStreet: Kodiak Dr
Directions: E Briggsmore Ave to Roselle to Kodiak Dr to Mars Hill St
State Or Province: CA
Street Number Numeric: 2804
Unparsed Address: 2804 Mars Hills St, Modesto, CA 95355-7870
Street Address Filtered: 2804 Mars Hills St
Community Information
Senior Community YN: No
Public facts
Beds: 5
Baths: 3.5
Sq. Ft.: 2,911
Stories: —
Lot Size: 6,909 square feet
Style: Single Family Residential
Year Built: 2003
Year Renovated: —
County: Stanislaus County
APN: 085044076000
Home facts updated by county records on Jul 13, 2026
Other
Selling Agent
Buyer Agent Full Name: Alvin Prasad
Around this home
Schools
Mary Ann Sanders Elementary School
Public K-5 • Assigned • 0.5mi
7/10
Daniel J. Savage Middle School
Public 6-8 • Assigned • 0.7mi
5/10
James C. Enochs High School
Public 9-12 • Assigned • 0.8mi
7/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
2/10 Flood Factor
Minimal risk 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
6/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
36 unhealthy days expected this year, 39 days in 30 years
Provided by First Street
Historical weather
Modesto, CA • 95355
Average low and high temperatures (°F)
60
40
65
45
74
49
75
50
84
56
92
60
94
62
94
64
88
64
79
56
64
47
56
45
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 13.2 hours in
June and 4.6 hours in December, placing it above the
U.S. average for solar exposure.
13.2 hrs
4.6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$614,000 – $743,000
Reach more buyers when you sell with Redfin. Save up to $6,453 in fees.3 minutes to get started.