SELECT *, CASE WHEN `locality` LIKE "st martins%" 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 ("st martins") 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,850,00052968 W Railroad RdCentertown MO 65023View Listing
$2,800,0001700 Valley Hi RdJefferson City MO 65109View Listing
$2,599,99920200 S Jemerson Creek RdHartsburg MO 65039View Listing
$2,240,00019050 S Mackie LnHartsburg MO 65039View Listing
$1,599,900425 Cedar Creek CtJefferson City MO 65101View Listing
$1,450,0004710 Route ZCentertown MO 65023View Listing
$1,100,0004807 Horner RdJefferson City MO 65109View Listing
$950,000710 Sycamore Valley DrJefferson City MO 65109View Listing
$950,000Route BJefferson City MO 65101View Listing
$849,900State Highway TJefferson City MO 65109View Listing
$815,000145 W Cedar Tree LnHartsburg MO 65039View Listing
$799,9002975 E McCarty StJefferson City MO 65101View 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
