Calling all visionaries! This home is bursting with potential and ready for its next chapter. With the right updates and creativity, this property could be transformed into something truly special. Whether you're an investor seeking your next project or a buyer ready to renovate and build equity, this home offers a rare opportunity to reimagine the space and maximize value. Bring your tools, your ideas, and your imaginationthe possibilities here are exciting.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
1951
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
1
Home Warranty
No
Directions to Property
Kazmir to Bedford
Cross Street
Kazmir
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Primary Bedroom, Full Bath(s), Kitchen, Street Entrance
Architectural Style
Contemporary
Construction Materials
Wood
Foundation
Slab
Roof
Composition
Heating
Wall Furnace
Cooling
Window Unit(s)
Laundry Features
Inside Area
Full Bathrooms
2
Bath Features
Tub w/Shower Over
Flooring
Other
Kitchen Features
Synthetic Counter
Dining Room Features
Dining/Family Combo
Living Room Features
Great Room
Basement
None
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public
Electric
220 Volts in Laundry
Irrigation
None
Water Source
Public
Sewer
Other
Parking Features
No Garage, Converted Garage
Lot Features
Other
APN
037 046 079 000
Driveway/Sidewalks
Unpaved
Horse Property
No
Zoning Description
r-1
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
Census Tract
16.04
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 323000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 357000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1155 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1655 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` = 1702759 OR `props-main`.`id` = 1716058 OR `props-main`.`id` = 1698158 OR `props-main`.`id` = 1687989 OR `props-main`.`id` = 1715836 OR `props-main`.`id` = 1713354 OR `props-main`.`id` = 1713218 OR `props-main`.`id` = 1711197 OR `props-main`.`id` = 1715827 OR `props-main`.`id` = 1714427 OR `props-main`.`id` = 1714913 OR `props-main`.`id` = 1695208 OR `props-main`.`id` = 1714434 OR `props-main`.`id` = 1715950 OR `props-main`.`id` = 1715944 OR `props-main`.`id` = 1715720 OR `props-main`.`id` = 1715949 OR `props-main`.`id` = 1715785 OR `props-main`.`id` = 1714379 OR `props-main`.`id` = 1712896 OR `props-main`.`id` = 1714742 OR `props-main`.`id` = 1716273 OR `props-main`.`id` = 1715996 OR `props-main`.`id` = 1705396 OR `props-main`.`id` = 1714357 OR `props-main`.`id` = 1715591 OR `props-main`.`id` = 1715604 OR `props-main`.`id` = 1713114 OR `props-main`.`id` = 1712686 OR `props-main`.`id` = 1710238 OR `props-main`.`id` = 1716051 OR `props-main`.`id` = 1714350 OR `props-main`.`id` = 1714690 OR `props-main`.`id` = 1699060 OR `props-main`.`id` = 1703092 OR `props-main`.`id` = 1714265 OR `props-main`.`id` = 1710165 OR `props-main`.`id` = 1697509 OR `props-main`.`id` = 1709553 OR `props-main`.`id` = 1715937 OR `props-main`.`id` = 1697625 OR `props-main`.`id` = 1709770 OR `props-main`.`id` = 1714442 OR `props-main`.`id` = 1714507 OR `props-main`.`id` = 1714421 OR `props-main`.`id` = 1714901 OR `props-main`.`id` = 1716005 OR `props-main`.`id` = 1714157 OR `props-main`.`id` = 1677808 OR `props-main`.`id` = 1714305 OR `props-main`.`id` = 1714861 OR `props-main`.`id` = 1714197 OR `props-main`.`id` = 1712392 OR `props-main`.`id` = 1715588 OR `props-main`.`id` = 1713155 OR `props-main`.`id` = 1715605 OR `props-main`.`id` = 1714262 OR `props-main`.`id` = 1714263 OR `props-main`.`id` = 1714756 OR `props-main`.`id` = 1714264 OR `props-main`.`id` = 1714383 OR `props-main`.`id` = 1714372 OR `props-main`.`id` = 1714932)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226026354' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-13' 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 Cynthia Fraze, Berkshire Hathaway HomeServices-Drysdale Properties 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.
