Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/crmls/41151133/Modesto/https://www.londonproperties.com/images/props/crmls/full/41151133.jpgLondon Properties Modesto Real Estate
It's a must see! New property, new build. There is so much potential, from building an additional property for income or a large family, to growing crops. Property is located in agriculture area. Property has a big lot and was divided to place an ADU in back, floor plans available.
Property Sub Type
Single Family Residence
Year Built
1936
Levels
One
Price Per Square Foot
$496
Days On London
1
Cumulative Days On London
1
County Or Parish
Stanislaus
New Construction Y/N
Yes
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Cross Street: Beverly.
Architectural Style
Traditional
Laundry Y/N
Yes
Construction Materials
Stucco
Bathrooms Full
1
Bathrooms Full And Three Quarter
1
Room Kitchen Features
Remodeled Kitchen
Appliances Y/N
Yes
Flooring
Laminate
Fireplace Y/N
No
Fireplace Features
None
Pool Features
None
Pool Private Y/N
No
Patio Y/N
Yes
Parking Y/N
Yes
Parking Features
RV Access/Parking
Attached Garage Y/N
No
Lot Features
Horse Property, Back Yard
Lot Size Area
9583.0000
Lot Size Units
Square Feet
Parcel Number
037005027000
Subdivision Name
Other
Subdivision Name Other
Other
Association Y/N
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 369443.6 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 408332.4 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 534 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1034 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` = 1786019 OR `props-main`.`id` = 1785448 OR `props-main`.`id` = 1777836 OR `props-main`.`id` = 1790259 OR `props-main`.`id` = 1751542 OR `props-main`.`id` = 1782537 OR `props-main`.`id` = 1773094 OR `props-main`.`id` = 1780856 OR `props-main`.`id` = 1789358 OR `props-main`.`id` = 1734142 OR `props-main`.`id` = 1734141 OR `props-main`.`id` = 1787073 OR `props-main`.`id` = 1778142 OR `props-main`.`id` = 1783807 OR `props-main`.`id` = 1783809 OR `props-main`.`id` = 1781934 OR `props-main`.`id` = 1737121 OR `props-main`.`id` = 1777024 OR `props-main`.`id` = 1783453 OR `props-main`.`id` = 1790861 OR `props-main`.`id` = 1786460 OR `props-main`.`id` = 1747166 OR `props-main`.`id` = 1768659 OR `props-main`.`id` = 1778552 OR `props-main`.`id` = 1789225 OR `props-main`.`id` = 1781766 OR `props-main`.`id` = 1761392 OR `props-main`.`id` = 1760650 OR `props-main`.`id` = 1786648 OR `props-main`.`id` = 1761876 OR `props-main`.`id` = 1786899 OR `props-main`.`id` = 1790401 OR `props-main`.`id` = 1790238 OR `props-main`.`id` = 1790233 OR `props-main`.`id` = 1790223 OR `props-main`.`id` = 1788661 OR `props-main`.`id` = 1781924 OR `props-main`.`id` = 1771840 OR `props-main`.`id` = 1781909 OR `props-main`.`id` = 1723705 OR `props-main`.`id` = 1738013 OR `props-main`.`id` = 1784091 OR `props-main`.`id` = 1786736 OR `props-main`.`id` = 1774427 OR `props-main`.`id` = 1741452 OR `props-main`.`id` = 1746466 OR `props-main`.`id` = 1764542 OR `props-main`.`id` = 1703306)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41151133' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-14' 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.
