SELECT *, CASE WHEN `name` LIKE "springfield%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "springfield" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "springfield" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "springfield" 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 ("springfield") 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.
$4,100,0001906 N Golden AveSpringfield MO 65802View Listing
$4,000,000622 E Sunset StSpringfield MO 65807View Listing
$2,650,000700 N Farm Road 193Springfield MO 65802View Listing
$2,000,0002749 W Farm Road 56Springfield MO 65803View Listing
$1,792,0004697 N Farm Road 175Springfield MO 65803View Listing
$1,775,0005256 S Stirling WaySpringfield MO 65809View Listing
$1,675,000529 S Oaks DrSpringfield MO 65809View Listing
$1,499,0007155 E CresSpringfield MO 65809View Listing
$1,450,0004110 E Shafter CirSpringfield MO 65809View Listing
$1,400,000764 S Mulberry LnSpringfield MO 65809View Listing
$1,300,0001611 S Farm Road 199Springfield MO 65809View Listing
$1,299,0008756 W Farm Road 124Springfield MO 65802View Listing
$1,150,0003825 E Pond Apple DrSpringfield MO 65809View Listing
$1,150,0005928 S Dollison AveSpringfield MO 65810View Listing
$1,100,0001308 S Pickwick AveSpringfield MO 65804View Listing
$1,100,0004727 Cobble Creek DrSpringfield MO 65809View Listing
$975,000863 N State Highway 125Springfield MO 65802View Listing
$950,000703 S Hickory DrSpringfield MO 65809View Listing
$949,9004863 S Landon CtSpringfield MO 65810View Listing
$925,0004349 E Valley RdSpringfield MO 65809View Listing
$875,0004350 E Misty Woods StSpringfield MO 65809View Listing
$850,0006232 S Riverbend RdSpringfield MO 65810View Listing
$850,0001645 E Meadowmere StSpringfield MO 65804View Listing
$839,9005279 W Farm Road 156Springfield MO 65802View 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-13-2024 4:18: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