SELECT *, CASE WHEN `locality` LIKE "lake mykee town%" AND `slide_location` = "" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `slide_location` = "" AND `logo_file_name` IS NOT NULL THEN 5 END as `rank` FROM `wp_slides` WHERE st = "MO" AND (locality IN ("lake mykee town") 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.
$2,800,0001700 Valley Hi RdJefferson City MO 65109View Listing
$1,599,900425 Cedar Creek CtJefferson City MO 65101View Listing
$1,399,0002805 State Road AAHolts Summit MO 65043View Listing
$1,100,0004807 Horner RdJefferson City MO 65109View Listing
$950,000Route BJefferson City MO 65101View Listing
$950,000710 Sycamore Valley DrJefferson City MO 65109View Listing
$936,0002876 State Road TTNew Bloomfield MO 65063View Listing
$849,900State Highway TJefferson City MO 65109View Listing
$799,9002975 E McCarty StJefferson City MO 65101View Listing
$765,0001912 Andrea DrJefferson City MO 65101View Listing
$750,000Schotthill Woods DrJefferson City MO 65101View Listing
$750,000S Country Club DrJefferson City MO 65109View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
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
Commercial
Land
Ranch
Single Family
