Listing Agent: Claudia Wales, Bay Area Realty Investments
Move-in ready and full of charm! This stunning home offers a functional layout, spacious living areas, and a backyard designed for entertaining. Situated in desirable neighborhood close to schools, shopping, dining, and commuter access. Property is being sold in its present condition. This is an excellent opportunity for buyers to add their own personal touches and create value.
Property Sub Type
Single Family Residence
Year Built
1985
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
1
Price Per Square Foot
$293
Days On London
13
County Or Parish
Stanislaus
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Prescott North of Sylvan Cheyenne to Terneuzen Ave. Cross Street: Cheyenne Way
Heating
Central
Cooling
Central Air
Roof
Composition
Foundation Details
Slab
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Bathrooms Half
1
Appliances Y/N
No
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Pellet Stove, Family Room
Water Source
Public
Sewer
Public Sewer
Parking Total
1.00
Attached Garage Y/N
Yes
Garage Spaces
1.00
Lot Size Area
3876.0000
Lot Size Units
Square Feet
View Y/N
No
Parcel Number
054041037000
Zoning
SFR
Association Y/N
Yes
Association Name
HOA
Association Fee
33.00
Association Fee Frequency
Monthly
High School District
Other
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 456000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 504000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1388 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1888 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` = 1738753 OR `props-main`.`id` = 1723223 OR `props-main`.`id` = 1744792 OR `props-main`.`id` = 1741722 OR `props-main`.`id` = 1742693 OR `props-main`.`id` = 1738695 OR `props-main`.`id` = 1727864 OR `props-main`.`id` = 1735297 OR `props-main`.`id` = 1738667 OR `props-main`.`id` = 1734187 OR `props-main`.`id` = 1744702 OR `props-main`.`id` = 1725851 OR `props-main`.`id` = 1709443 OR `props-main`.`id` = 1729851 OR `props-main`.`id` = 1722841 OR `props-main`.`id` = 1724411 OR `props-main`.`id` = 1721846 OR `props-main`.`id` = 1737124 OR `props-main`.`id` = 1725720 OR `props-main`.`id` = 1740572 OR `props-main`.`id` = 1736579 OR `props-main`.`id` = 1728472 OR `props-main`.`id` = 1726184 OR `props-main`.`id` = 1714968 OR `props-main`.`id` = 1735346 OR `props-main`.`id` = 1738997 OR `props-main`.`id` = 1715603 OR `props-main`.`id` = 1725721 OR `props-main`.`id` = 1714244 OR `props-main`.`id` = 1737840 OR `props-main`.`id` = 1728688 OR `props-main`.`id` = 1724418 OR `props-main`.`id` = 1725187 OR `props-main`.`id` = 1726521 OR `props-main`.`id` = 1744577 OR `props-main`.`id` = 1733116 OR `props-main`.`id` = 1739067 OR `props-main`.`id` = 1742666 OR `props-main`.`id` = 1743874 OR `props-main`.`id` = 1741293 OR `props-main`.`id` = 1742597 OR `props-main`.`id` = 1744186 OR `props-main`.`id` = 1718072 OR `props-main`.`id` = 1737009 OR `props-main`.`id` = 1742632 OR `props-main`.`id` = 1725170 OR `props-main`.`id` = 1733602 OR `props-main`.`id` = 1727423 OR `props-main`.`id` = 1731042 OR `props-main`.`id` = 1736647 OR `props-main`.`id` = 1738996 OR `props-main`.`id` = 1736184 OR `props-main`.`id` = 1726359 OR `props-main`.`id` = 1721491 OR `props-main`.`id` = 1717558 OR `props-main`.`id` = 1736609 OR `props-main`.`id` = 1726026 OR `props-main`.`id` = 1744298 OR `props-main`.`id` = 1715828 OR `props-main`.`id` = 1736667 OR `props-main`.`id` = 1736994 OR `props-main`.`id` = 1740175 OR `props-main`.`id` = 1720798 OR `props-main`.`id` = 1727765 OR `props-main`.`id` = 1727174 OR `props-main`.`id` = 1728862 OR `props-main`.`id` = 1737853 OR `props-main`.`id` = 1732930 OR `props-main`.`id` = 1741775 OR `props-main`.`id` = 1724508 OR `props-main`.`id` = 1741674 OR `props-main`.`id` = 1737014 OR `props-main`.`id` = 1725344 OR `props-main`.`id` = 1737753 OR `props-main`.`id` = 1721749 OR `props-main`.`id` = 1736591 OR `props-main`.`id` = 1713231 OR `props-main`.`id` = 1724605 OR `props-main`.`id` = 1721580 OR `props-main`.`id` = 1723229 OR `props-main`.`id` = 1738316)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82050736' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-02' 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();
1
Similar Properties
$485,000
4
3
1,853
0.11
2008 Sheldon Dr
Modesto, CA 95350
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.
