This charming 3-bedroom, 2-bath home is a fantastic opportunity for buyers ready to add their personal touch. Featuring 1,065 sq ft of living space on a generous 7,079 sq ft lot, the property offers plenty of room to create your ideal home or next investment. With just a bit of TLC, this home has the potential to truly shine.
Property Sub Type
Single Family Residence
Year Built
1980
Year Built Source
Assessor
Special Listing Conditions
Short Sale
Stories Total
1
Price Per Square Foot
$281
Days On Market
3
County Or Parish
Stanislaus
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
USE NAV Cross Street: Hatch
Heating
Central
Cooling
Central Air
Roof
Composition
Foundation Details
Concrete Perimeter
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Appliances Y/N
No
Flooring
Carpet, Laminate, Tile
Common Walls
No Common Walls
Fireplace Y/N
No
Water Source
Public
Sewer
Public Sewer
Parking Total
2.00
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Size Area
7078.0000
Lot Size Units
Square Feet
View Y/N
No
Parcel Number
040086020000
Zoning
R
Association Y/N
No
High School District
Ceres Unified
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 284050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 313950 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) >= 815 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1315 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` = 1699465 OR `props-main`.`id` = 1700207 OR `props-main`.`id` = 1688578 OR `props-main`.`id` = 1698485 OR `props-main`.`id` = 1690280 OR `props-main`.`id` = 1696133 OR `props-main`.`id` = 1697603 OR `props-main`.`id` = 1701115 OR `props-main`.`id` = 1698817 OR `props-main`.`id` = 1701074 OR `props-main`.`id` = 1668573 OR `props-main`.`id` = 1700238 OR `props-main`.`id` = 1695396 OR `props-main`.`id` = 1662513 OR `props-main`.`id` = 1701741 OR `props-main`.`id` = 1698740 OR `props-main`.`id` = 1700269 OR `props-main`.`id` = 1702054 OR `props-main`.`id` = 1689588 OR `props-main`.`id` = 1674469 OR `props-main`.`id` = 1687989 OR `props-main`.`id` = 1701985 OR `props-main`.`id` = 1697462 OR `props-main`.`id` = 1684877 OR `props-main`.`id` = 1702052 OR `props-main`.`id` = 1697803 OR `props-main`.`id` = 1702055 OR `props-main`.`id` = 1701752 OR `props-main`.`id` = 1701039 OR `props-main`.`id` = 1695208 OR `props-main`.`id` = 1702166 OR `props-main`.`id` = 1700950 OR `props-main`.`id` = 1697511 OR `props-main`.`id` = 1697587 OR `props-main`.`id` = 1691126 OR `props-main`.`id` = 1697866 OR `props-main`.`id` = 1695662 OR `props-main`.`id` = 1701021 OR `props-main`.`id` = 1646283 OR `props-main`.`id` = 1693548 OR `props-main`.`id` = 1700364 OR `props-main`.`id` = 1698941 OR `props-main`.`id` = 1700177 OR `props-main`.`id` = 1700736 OR `props-main`.`id` = 1700952 OR `props-main`.`id` = 1695522 OR `props-main`.`id` = 1691502 OR `props-main`.`id` = 1701352 OR `props-main`.`id` = 1694588 OR `props-main`.`id` = 1701012 OR `props-main`.`id` = 1699060 OR `props-main`.`id` = 1700083 OR `props-main`.`id` = 1699215 OR `props-main`.`id` = 1702164 OR `props-main`.`id` = 1702165)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82030541' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-10' 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
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.
