Come and see this very nice property close to the freeway 99.With over 1/4 lot plus. tree bonus rooms.Nice Interior.This type of property wont last in the market.Close to shooping center.Big Storage room in the back yard.Fruit trees in the back yard. nice property with a super price and affordable.Why pay rent.You will love this property once you see it.
Property Sub Type
Single Family Residence
Year Built
1964
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
1
Price Per Square Foot
$392
Days On Market
231
County Or Parish
Stanislaus
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Cross Street: 7th st
Cooling
Central Air
Roof
Shingle
Bathrooms Full
1
Bathrooms Full And Three Quarter
1
Appliances Y/N
No
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Living Room
Water Source
Public
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Other
Attached Garage Y/N
No
Garage Spaces
2.00
Lot Size Area
10454.0000
Lot Size Units
Square Feet
View Y/N
No
Parcel Number
045015038000
Zoning
r1
Association Y/N
No
High School District
Other
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 426550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 471450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 896 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1396 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` = 1697469 OR `props-main`.`id` = 1692758 OR `props-main`.`id` = 1683567 OR `props-main`.`id` = 1683583 OR `props-main`.`id` = 1683445 OR `props-main`.`id` = 1691105 OR `props-main`.`id` = 1689930 OR `props-main`.`id` = 1689743 OR `props-main`.`id` = 1693432 OR `props-main`.`id` = 1655583 OR `props-main`.`id` = 1691731 OR `props-main`.`id` = 1664315 OR `props-main`.`id` = 1697402 OR `props-main`.`id` = 1692684 OR `props-main`.`id` = 1692685 OR `props-main`.`id` = 1600757)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82004485' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-15' 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.
