Welcome home to this warm and inviting 4-bedroom, 2-bath gem nestled in a wonderful neighborhood within the highly rated Sylvan School District! From the moment you arrive, you'll feel the comfort and charm this home has to offer. With plenty of space for a growing family, the thoughtful layout provides room to gather, relax, and create lasting memories. The solar system with backup offers energy efficiency, savings, and peace of mind when it matters most.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Property Condition
Updated/Remodeled, Original
Year Built
1964
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Kitchen 0-5YR
Stories
1
Levels
One
Pets Allowed
Yes
Home Warranty
No
Directions to Property
from Mchenry ave East on Rumble ave. turn right on Sheffield Your new home is on the next corner!
Cross Street
Rumble
County
Stanislaus
Special Zones
Unknown
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Dining Room, Family Room, Full Bath(s), Garage, Kitchen, Street Entrance
Architectural Style
Ranch
Construction Materials
Cement Siding, Stucco
Foundation
ConcreteGrid, PillarPostPier
Roof
Composition
Heating
Central
Cooling
Ceiling Fan(s), Central
Laundry Features
Inside Area, Inside Room
Window Features
Dual Pane Full, Low E Glass Full
Property Faces
East
Other Structures
Shed(s)
Full Bathrooms
2
Bath Features
Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Brick, Family Room
Flooring
Carpet, Tile, Vinyl, Wood
Appliances
Built-In Electric Oven, Compactor, Dishwasher, Disposal, Microwave, Electric Cook Top
Room Type
Family Room, Living Room
Kitchen Features
Tile Counter
Dining Room Features
Dining/Family Combo
Living Room Features
View
Family Room Features
View
Primary Bedroom Features
Walk-In Closet
Primary Bathroom Features
Shower Stall(s)
Patio And Porch Features
Covered Patio
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Cable Available, Sewer In & Connected, Internet Available, Solar
Electric
220 Volts in Laundry
Irrigation
Public District
Water Source
Meter on Site, Water District
Sewer
Public Sewer
Energy Efficient
Thermostat, Windows
Parking Features
Attached, RV Possible
Garage Spaces
2.00
Open Parking Spaces
4.00
Lot Features
Auto Sprinkler F&R, Corner
APN
013 061 001 000
Land Use
Residential
Topography
Level
View Description
City, Other
Driveway/Sidewalks
Sidewalk/Curb/Gutter
Fencing
Back Yard, Vinyl, Fenced, Full
Horse Property
No
Road Surface Type
Asphalt
Road Responsibility
Public Maintained Road
Zoning Description
sfr
List AOR
MetroList Services, Inc.
Association
No
Restrictions
Other
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Sylvan Union
Middle or Junior School District
Sylvan Union
Senior High School District
Modesto City
Distance To Shopping
3 Blocks
Distance to Public Transportation
1 Block
Census Tract
9.07
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 546250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 603750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1662 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2162 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1722611 OR `props-main`.`id` = 1721157 OR `props-main`.`id` = 1720304 OR `props-main`.`id` = 1717982 OR `props-main`.`id` = 1720873 OR `props-main`.`id` = 1723565 OR `props-main`.`id` = 1723651 OR `props-main`.`id` = 1713035 OR `props-main`.`id` = 1720561 OR `props-main`.`id` = 1714720 OR `props-main`.`id` = 1723305 OR `props-main`.`id` = 1714510 OR `props-main`.`id` = 1703336 OR `props-main`.`id` = 1721848 OR `props-main`.`id` = 1724219 OR `props-main`.`id` = 1720627 OR `props-main`.`id` = 1716030 OR `props-main`.`id` = 1723554 OR `props-main`.`id` = 1723779 OR `props-main`.`id` = 1712373 OR `props-main`.`id` = 1722670 OR `props-main`.`id` = 1722317 OR `props-main`.`id` = 1720637 OR `props-main`.`id` = 1712711 OR `props-main`.`id` = 1718941 OR `props-main`.`id` = 1720377 OR `props-main`.`id` = 1707045 OR `props-main`.`id` = 1724184 OR `props-main`.`id` = 1722465 OR `props-main`.`id` = 1716075 OR `props-main`.`id` = 1702807 OR `props-main`.`id` = 1723504 OR `props-main`.`id` = 1719850 OR `props-main`.`id` = 1716276 OR `props-main`.`id` = 1723691 OR `props-main`.`id` = 1722566 OR `props-main`.`id` = 1715732 OR `props-main`.`id` = 1713162 OR `props-main`.`id` = 1718143 OR `props-main`.`id` = 1718926 OR `props-main`.`id` = 1722505 OR `props-main`.`id` = 1722260 OR `props-main`.`id` = 1720968 OR `props-main`.`id` = 1715680 OR `props-main`.`id` = 1702971 OR `props-main`.`id` = 1721201 OR `props-main`.`id` = 1721379 OR `props-main`.`id` = 1722054 OR `props-main`.`id` = 1723462 OR `props-main`.`id` = 1722746 OR `props-main`.`id` = 1723170 OR `props-main`.`id` = 1720807 OR `props-main`.`id` = 1714968 OR `props-main`.`id` = 1723421 OR `props-main`.`id` = 1715603 OR `props-main`.`id` = 1722985 OR `props-main`.`id` = 1724237 OR `props-main`.`id` = 1724069 OR `props-main`.`id` = 1717161 OR `props-main`.`id` = 1708028 OR `props-main`.`id` = 1721984 OR `props-main`.`id` = 1721978 OR `props-main`.`id` = 1713189 OR `props-main`.`id` = 1723638 OR `props-main`.`id` = 1723998 OR `props-main`.`id` = 1717568 OR `props-main`.`id` = 1707869 OR `props-main`.`id` = 1704964 OR `props-main`.`id` = 1723461 OR `props-main`.`id` = 1666517 OR `props-main`.`id` = 1716436 OR `props-main`.`id` = 1722600 OR `props-main`.`id` = 1717001 OR `props-main`.`id` = 1717181 OR `props-main`.`id` = 1717240 OR `props-main`.`id` = 1722602 OR `props-main`.`id` = 1718598 OR `props-main`.`id` = 1711297 OR `props-main`.`id` = 1724019 OR `props-main`.`id` = 1721328 OR `props-main`.`id` = 1721459 OR `props-main`.`id` = 1712982 OR `props-main`.`id` = 1721951 OR `props-main`.`id` = 1719310 OR `props-main`.`id` = 1718539 OR `props-main`.`id` = 1716072 OR `props-main`.`id` = 1718356 OR `props-main`.`id` = 1721129 OR `props-main`.`id` = 1723434)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226042151' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-29' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
0
Courtesy of Brian Serna, Century 21 Select Real Estate IDX provided by Reliance Marketing
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
