Welcome to this spacious mid-century modern ranch home, built in 1949 and set on an expansive 0.67-acre lot. This home features a bright, open layout with oversized viewing windows that fill the interior with natural light and showcase its classic architectural charm. Multiple living areas provide flexibility for everyday living and entertaining, while original design elements blend beautifully with modern functionality. Step outside to your retreat like backyard and enjoy the remodeled pool with Acapulco entry, mature fruit trees, gated grounds, and a large covered patio ideal for gatherings or quiet evenings. Additional highlights include abundant storage throughout, well + city utilities, a detached garage, and generous outdoor space rarely found in this area. This is a unique opportunity to own a property that honors its historic roots while offering the space and comfort, all in a prime location.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Ranchette/Country, Detached
Year Built
1949
Year Built Source
Other
Remodeled/Updated
Yes
Remodeled/Updated Desc
Bath 0-5YR, Other-Rmks 0-5YR
Stories
1
Pets Allowed
Yes
Home Warranty
No
Directions to Property
Cross Street Hillview Drive.
Cross Street
Hillview Drive
County
Stanislaus
Special Listing Conditions
Offer As Is, None
Main Level
Bedroom(s), Dining Room, Family Room, Primary Bedroom, Full Bath(s), Partial Bath(s), Garage, Kitchen
Architectural Style
Mid-Century
Construction Materials
Brick
Foundation
Raised
Roof
Composition, Other
Heating
Central, Fireplace(s)
Cooling
Ceiling Fan(s), Central
Laundry Features
Cabinets, Sink, Space For Frzr/Refr, Inside Room
Other Structures
Shed(s)
Interior Features
Open Beam Ceiling
Full Bathrooms
2
Half Bathrooms
1
Bath Features
Shower Stall(s), Tub
# of Fireplaces
2
Fireplace Features
Brick, Living Room, Raised Hearth, Stone
Flooring
Carpet, Laminate, Tile, Wood
Appliances
Built-In Electric Range, Hood Over Range, Dishwasher, Double Oven
Room Type
Primary Bathroom, Primary Bedroom, Bonus Room, Dining Room, Family Room, Kitchen, Laundry, Living Room
Manual Sprinkler F&R, Auto Sprinkler F&R, Corner, Other
APN
029 030 024 000
Land Use
Residential
Driveway/Sidewalks
Gated, Paved Sidewalk, Gravel, Paved Driveway
Fencing
Back Yard, Entry Gate, Front Yard
Horse Property
No
Road Surface Type
Paved
Road Responsibility
Public Maintained Road
Zoning Description
R1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Modesto City
Middle or Junior School District
Modesto City
Senior High School District
Modesto City
Distance to Public Transportation
1-2 Miles
Census Tract
15.00
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 736250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 813750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2922 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3422 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` = 1710686 OR `props-main`.`id` = 1705316 OR `props-main`.`id` = 1711048 OR `props-main`.`id` = 1706733 OR `props-main`.`id` = 1711019 OR `props-main`.`id` = 1704345 OR `props-main`.`id` = 1705396 OR `props-main`.`id` = 1710598 OR `props-main`.`id` = 1674476 OR `props-main`.`id` = 1710238 OR `props-main`.`id` = 1703092 OR `props-main`.`id` = 1710496 OR `props-main`.`id` = 1710165 OR `props-main`.`id` = 1697509 OR `props-main`.`id` = 1709553 OR `props-main`.`id` = 1706715 OR `props-main`.`id` = 1697625 OR `props-main`.`id` = 1709770 OR `props-main`.`id` = 1706663 OR `props-main`.`id` = 1702599 OR `props-main`.`id` = 1710694 OR `props-main`.`id` = 1710769 OR `props-main`.`id` = 1710380 OR `props-main`.`id` = 1677808 OR `props-main`.`id` = 1710537 OR `props-main`.`id` = 1711205 OR `props-main`.`id` = 1710417 OR `props-main`.`id` = 1704429 OR `props-main`.`id` = 1710493 OR `props-main`.`id` = 1710494 OR `props-main`.`id` = 1711036 OR `props-main`.`id` = 1710495 OR `props-main`.`id` = 1710631 OR `props-main`.`id` = 1710617 OR `props-main`.`id` = 1711307 OR `props-main`.`id` = 1703306 OR `props-main`.`id` = 1711111 OR `props-main`.`id` = 1695792 OR `props-main`.`id` = 1701832 OR `props-main`.`id` = 1684215 OR `props-main`.`id` = 1689031 OR `props-main`.`id` = 1710901 OR `props-main`.`id` = 1710068 OR `props-main`.`id` = 1703059 OR `props-main`.`id` = 1698477 OR `props-main`.`id` = 1709200 OR `props-main`.`id` = 1701740 OR `props-main`.`id` = 1711323 OR `props-main`.`id` = 1697884 OR `props-main`.`id` = 1697394 OR `props-main`.`id` = 1701906 OR `props-main`.`id` = 1710097 OR `props-main`.`id` = 1705434 OR `props-main`.`id` = 1710656 OR `props-main`.`id` = 1702533 OR `props-main`.`id` = 1686383 OR `props-main`.`id` = 1685007 OR `props-main`.`id` = 1704339)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226009096' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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 Uzma Jackson, PMZ 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.
