Located in a highly desirable neighborhood, this beautifully situated corner-lot single-family home offers 3 bedrooms, 3 bathrooms, 1,739 sq. ft. of living space on a 3,920 sq. ft. lot, all at an outstanding price.
Property Sub Type
Single Family Residence
Year Built
1987
Levels
Two
Price Per Square Foot
$251
Days On London
0
Cumulative Days On London
0
County Or Parish
Stanislaus
New Construction Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Cross Street: Sylvan Meadows.
Architectural Style
Contemporary
Cooling
Wall/Window Unit(s)
Laundry Y/N
Yes
Construction Materials
Wood Siding
Foundation Details
Slab
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Appliances Y/N
Yes
Room Bathroom Features
Tile Counters
Accessibility Features
None
Flooring
Tile, Carpet
Fireplace Y/N
Yes
Fireplace Features
Wood Burning
Pool Features
None
Pool Private Y/N
No
Patio Y/N
Yes
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Garage, Garage Door Opener
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Sprinklers In Front, Sprinklers On Side, Sprinklers Timer, Front Yard
Lot Size Area
3920.0000
Lot Size Units
Square Feet
Sprinklers Y/N
Yes
Parcel Number
052065024000
Subdivision Name
None
Subdivision Name Other
None
Association Y/N
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 427452.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 472447.5 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) >= 1543 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2043 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` = 1739541 OR `props-main`.`id` = 1727024 OR `props-main`.`id` = 1737967 OR `props-main`.`id` = 1737966 OR `props-main`.`id` = 1745843 OR `props-main`.`id` = 1728933 OR `props-main`.`id` = 1747740 OR `props-main`.`id` = 1726019 OR `props-main`.`id` = 1747523 OR `props-main`.`id` = 1733618 OR `props-main`.`id` = 1738314 OR `props-main`.`id` = 1740679 OR `props-main`.`id` = 1744338 OR `props-main`.`id` = 1727834 OR `props-main`.`id` = 1747732 OR `props-main`.`id` = 1728177 OR `props-main`.`id` = 1735297 OR `props-main`.`id` = 1732001 OR `props-main`.`id` = 1744702 OR `props-main`.`id` = 1733579 OR `props-main`.`id` = 1747147 OR `props-main`.`id` = 1742695 OR `props-main`.`id` = 1736355 OR `props-main`.`id` = 1724411 OR `props-main`.`id` = 1738174 OR `props-main`.`id` = 1741904 OR `props-main`.`id` = 1740841 OR `props-main`.`id` = 1744580 OR `props-main`.`id` = 1746287 OR `props-main`.`id` = 1715680 OR `props-main`.`id` = 1741685 OR `props-main`.`id` = 1728232 OR `props-main`.`id` = 1722054 OR `props-main`.`id` = 1728179 OR `props-main`.`id` = 1747706 OR `props-main`.`id` = 1723462 OR `props-main`.`id` = 1746930 OR `props-main`.`id` = 1720807 OR `props-main`.`id` = 1714968 OR `props-main`.`id` = 1738997 OR `props-main`.`id` = 1715603 OR `props-main`.`id` = 1743738 OR `props-main`.`id` = 1745332 OR `props-main`.`id` = 1747524 OR `props-main`.`id` = 1743991 OR `props-main`.`id` = 1735300 OR `props-main`.`id` = 1747356 OR `props-main`.`id` = 1727422 OR `props-main`.`id` = 1737854 OR `props-main`.`id` = 1721984 OR `props-main`.`id` = 1721978 OR `props-main`.`id` = 1727944 OR `props-main`.`id` = 1730671 OR `props-main`.`id` = 1707870 OR `props-main`.`id` = 1747796 OR `props-main`.`id` = 1724573 OR `props-main`.`id` = 1724659 OR `props-main`.`id` = 1746340 OR `props-main`.`id` = 1738185 OR `props-main`.`id` = 1747010 OR `props-main`.`id` = 1739235 OR `props-main`.`id` = 1738197 OR `props-main`.`id` = 1725170 OR `props-main`.`id` = 1727423 OR `props-main`.`id` = 1735306 OR `props-main`.`id` = 1746339 OR `props-main`.`id` = 1741825 OR `props-main`.`id` = 1721459 OR `props-main`.`id` = 1741068 OR `props-main`.`id` = 1742194 OR `props-main`.`id` = 1728139 OR `props-main`.`id` = 1735305 OR `props-main`.`id` = 1723887 OR `props-main`.`id` = 1712982 OR `props-main`.`id` = 1736667 OR `props-main`.`id` = 1740601 OR `props-main`.`id` = 1728412 OR `props-main`.`id` = 1729130 OR `props-main`.`id` = 1741701 OR `props-main`.`id` = 1736181 OR `props-main`.`id` = 1741309 OR `props-main`.`id` = 1741096 OR `props-main`.`id` = 1741116)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41141295' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-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.
