This is a Short Sale: BRING ALL OFFERS - AS-IS, NO CONTINGENCIES. The Lender, Servicer or Seller may cancel the Contract and Sale at any time for any reason without any penalties or Concessions to anyone whatsoever.
Property Sub Type
Single Family Residence
Year Built
2023
Special Listing Conditions
Short Sale, Notice Of Default
Levels
One
Price Per Square Foot
$170
Days On London
3
County Or Parish
Stanislaus
New Construction Y/N
No
Property Attached Y/N
No
Heating Y/N
Yes
Directions
East on Interstae Highway 5
Disclosures
CC And R's
Architectural Style
Contemporary
Room Type
Office
Heating
Forced Air
Laundry Y/N
Yes
Laundry Features
Inside, Washer Included, Dryer Included
Direction Faces
South
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Appliances Y/N
Yes
Appliances
Disposal, Microwave, Dishwasher
Flooring
Wood
Common Walls
No Common Walls
Fireplace Y/N
No
Fireplace Features
None
Pool Features
None
Pool Private Y/N
No
Spa Y/N
No
Spa Features
None
Sewer
Other
Parking Y/N
Yes
Parking Features
Garage - Two Door
Lot Size Area
6021.0000
Lot Size Units
Square Feet
View Y/N
Yes
Parcel Number
047073089000
Additional Parcels Y/N
No
Senior Community Y/N
No
Association Y/N
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 308750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 341250 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) >= 1663 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2163 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` = 1717988 OR `props-main`.`id` = 1689927 OR `props-main`.`id` = 1714209 OR `props-main`.`id` = 1714784 OR `props-main`.`id` = 1709777 OR `props-main`.`id` = 1716615 OR `props-main`.`id` = 1716701 OR `props-main`.`id` = 1649515 OR `props-main`.`id` = 1721374 OR `props-main`.`id` = 1716547 OR `props-main`.`id` = 1721540 OR `props-main`.`id` = 1715615 OR `props-main`.`id` = 1723903 OR `props-main`.`id` = 1723862 OR `props-main`.`id` = 1718842 OR `props-main`.`id` = 1722234 OR `props-main`.`id` = 1701580 OR `props-main`.`id` = 1714544 OR `props-main`.`id` = 1707875 OR `props-main`.`id` = 1723015 OR `props-main`.`id` = 1705572 OR `props-main`.`id` = 1723016 OR `props-main`.`id` = 1716593)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls26670201' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-27' 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.
