Gorgeous home with modern charm.Featuring a fantastic upgraded kitchen complete with granite countertops, and new stainless steel appliances. Throughout you will notice plush carpeting, sleek tile flooring,& fresh interior/exterior paint. Offering a spacious family room with cozy fire place this home is perfect for entertaining.This home also offers a bonus unit with its own kitchenette, bed & bath Situated on a huge lot featuring fresh landscape make this home one of a kind. Come see today!
Single-familyProperty Type
1988Year Built
5,201 sq ftLot Size
$250Est. Price/Sq.Ft.
2 car garageParking
Listed by Polly Watts•DRE #00895696• Maxim Properties
Bought with Kylie Souza•DRE #02026095• Century 21 MM
*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
3
Baths
2
Stories
2
Lot width
—
Lot depth
—
Lot size
5,200 Sq. Ft.
Year renovated
—
Sq. Ft.
1,748
Year built
1988
Style
Single Family Residential
County
Stanislaus County
APN
056066017000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 13, 2026.
R-1
Low-Density Residential Zone
The R-1 (Low-Density Residential) zoning district is intended to accommodate lower-density residential development, including accessory structures and uses;
Permitted uses
Include but are not limited to:
Garden center
Housing-Single unit
Housing-Senior
Housing-Other
Lodging & hospitality
Bed & breakfast
Public service
Housing-Mobile home park
Park & open space
Jan 11, 2019 • Final
Res hvac
HVAC
Apr 11, 1988 • Final
Permit history entry
New construction
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: 2
Parking Features: Detached
Driveway Sidewalks: Paved Sidewalk
Interior
Bathroom Information
# of Bathrooms (Full): 2
Other Bathroom Features: Tub w/Shower Over
Bedroom Information
# of Bedrooms (Total): 4
Heating & Cooling
Cooling: Ceiling Fan(s), Central
Heating: Central
Interior Features
Appliances: Built-In Electric Range, Dishwasher, Microwave
Fireplaces Total: 1
Fireplace Features: Living Room
Flooring: Carpet, Tile, Linoleum/Vinyl
Laundry Features: Inside Room
# of Stories: 2
Room Information
Room Type: Baths Other
Dining Room Features: Formal Area
Exterior
Exterior Features
Allows Horses: No
Roof: Composition
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: 1,988
Lot Information
Lot Features: Curb(s)
Lot Size Square Feet: 5,201
Lot Size Acres: 0.1194
Utilities
Utility Information
Utilities: See Remarks
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: 5992
Postal Code: 95358
County Or Parish: Stanislaus
CrossStreet: Boise Ave & W Hatch Rd
Directions: From Carpenter, Head East on W Hatch Rd, Turn right onto Ustick
State Or Province: CA
Street Number Numeric: 1804
Unparsed Address: 1804 Ustick Rd, Modesto, CA 95358-5992
Street Address Filtered: 1804 Ustick Rd
Community Information
Senior Community YN: No
Public facts
Beds: 3
Baths: 2.0
Sq. Ft.: 1,748
Stories: 2.0
Lot Size: 5,200 square feet
Style: Single Family Residential
Year Built: 1988
Year Renovated: —
County: Stanislaus County
APN: 056066017000
Home facts updated by county records on Jul 13, 2026
Other
Selling Agent
Buyer Agent Full Name: Kylie A Souza
Around this home
Schools
Bret Harte Elementary School
Public K-6 • Assigned • 0.3mi
5/10
Evelyn Hanshaw Middle School
Public 7-8 • Assigned • 0.4mi
3/10
Thomas Downey High School
Public 9-12 • Assigned • 4.3mi
4/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
4/10 Flood Factor
Estimated 11-17% 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
33 unhealthy days expected this year, 38 days in 30 years
Provided by First Street
Historical weather
Modesto, CA • 95358
Average low and high temperatures (°F)
60
40
64
44
73
48
74
49
83
54
90
58
91
59
94
63
90
61
80
55
64
47
55
43
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 12.9 hours in
June and 4.6 hours in December, placing it above the
U.S. average for solar exposure.
12.9 hrs
4.6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$415,000 – $502,000
Sell confidently with a local market expert in Modesto. 3 minutes to get started.