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/SR26002741/17166-Smokey-River/Sonora/https://www.londonproperties.com/images/props/crmls/full/SR26002741.jpgLondon Properties Sonora Real Estate | 17166 Smokey River
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 185834.25 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 205395.75 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) >= 974 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1474 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` = 1727434 OR `props-main`.`id` = 1736767 OR `props-main`.`id` = 1728568 OR `props-main`.`id` = 1740792 OR `props-main`.`id` = 1740306 OR `props-main`.`id` = 1727432 OR `props-main`.`id` = 1740188 OR `props-main`.`id` = 1727451 OR `props-main`.`id` = 1729086 OR `props-main`.`id` = 1742179 OR `props-main`.`id` = 1740649 OR `props-main`.`id` = 1740189 OR `props-main`.`id` = 1731122 OR `props-main`.`id` = 1738634 OR `props-main`.`id` = 1736534 OR `props-main`.`id` = 1737389 OR `props-main`.`id` = 1741321 OR `props-main`.`id` = 1728651 OR `props-main`.`id` = 1730090 OR `props-main`.`id` = 1732278 OR `props-main`.`id` = 1727341 OR `props-main`.`id` = 1728566 OR `props-main`.`id` = 1735548 OR `props-main`.`id` = 1727621 OR `props-main`.`id` = 1736878 OR `props-main`.`id` = 1737834 OR `props-main`.`id` = 1733416 OR `props-main`.`id` = 1727564 OR `props-main`.`id` = 1729975 OR `props-main`.`id` = 1738558 OR `props-main`.`id` = 1739086 OR `props-main`.`id` = 1729082 OR `props-main`.`id` = 1727725 OR `props-main`.`id` = 1727658 OR `props-main`.`id` = 1701517 OR `props-main`.`id` = 1740466 OR `props-main`.`id` = 1738755 OR `props-main`.`id` = 1737620 OR `props-main`.`id` = 1728624 OR `props-main`.`id` = 1728094 OR `props-main`.`id` = 1735549 OR `props-main`.`id` = 1737827 OR `props-main`.`id` = 1737858 OR `props-main`.`id` = 1728328 OR `props-main`.`id` = 1735350 OR `props-main`.`id` = 1738987 OR `props-main`.`id` = 1732563 OR `props-main`.`id` = 1718589 OR `props-main`.`id` = 1742273 OR `props-main`.`id` = 1738011 OR `props-main`.`id` = 1738945 OR `props-main`.`id` = 1735351 OR `props-main`.`id` = 1729047 OR `props-main`.`id` = 1729974 OR `props-main`.`id` = 1727788 OR `props-main`.`id` = 1736457 OR `props-main`.`id` = 1736561 OR `props-main`.`id` = 1731137 OR `props-main`.`id` = 1736768 OR `props-main`.`id` = 1728114 OR `props-main`.`id` = 1737410 OR `props-main`.`id` = 1728570 OR `props-main`.`id` = 1731893)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSR26002741' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-26' 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.
