SELECT *, CASE WHEN `name` LIKE "chesterfield%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "chesterfield" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "chesterfield" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "chesterfield" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "MO" AND (locality IN ("chesterfield") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "MO" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$1,099,0000-2BBLT Riviera-WildhorseChesterfield MO 63017View Listing
$1,099,000298 Herworth DrChesterfield MO 63005View Listing
$1,069,0000-2BBLT Monterey-WildhorseChesterfield MO 63017View Listing
$950,00068 Lakes RdChesterfield MO 63005View Listing
$925,00017712 Chaistain CtChesterfield MO 63005View Listing
$849,000415 Herworth DrChesterfield MO 63005View Listing
$845,00018668 Olive Street RdChesterfield MO 63005View Listing
$828,347961 Grand Reserve DrChesterfield MO 63017View Listing
$787,000730 Savannah Crossing WayChesterfield MO 63017View Listing
$775,0002043 Kehrs Mill RdChesterfield MO 63005View Listing
$755,00014012 Conway RdChesterfield MO 63017View Listing
$749,9002259 Twin Estates CirChesterfield MO 63017View Listing
$749,07216533 Yellowwood Dr Unit 69-302Chesterfield MO 63017View Listing
$749,0002226 Kehrsgrove CtChesterfield MO 63005View Listing
$742,41716524 Yellowwood Dr Unit 45-302Chesterfield MO 63017View Listing
$739,90016839 Kehrsbrooke CtChesterfield MO 63005View Listing
$729,9002-BBLT Pin Oak Ii at Tara RdgChesterfield MO 63005View Listing
$689,9002-BBLT Buckley at Tara RdgChesterfield MO 63005View Listing
$689,42216503 Honey Locust Dr Unit 36-301Chesterfield MO 63017View Listing
$680,00017160 Surrey View DrChesterfield MO 63005View Listing
$675,0002206 Twin Estates CirChesterfield MO 63017View Listing
$650,00015019 Manor Creek DrChesterfield MO 63017View Listing
$650,0001144 Deep Forest DrChesterfield MO 63005View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-16-2024 2:30:19 pm.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "MO" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID
Blah