SELECT *, CASE WHEN `locality` LIKE "barton%" 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 = "MI" AND (locality IN ("barton") 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 28
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "MI" 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 28
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,875,00013120 Northland DrBig Rapids MI 49307View Listing
$850,00020820 14 Mile RdBig Rapids MI 49307View Listing
$850,00022711 Fifteen Mile # 2Big Rapids MI 49307View Listing
$569,90017050 21 Mile RdBig Rapids MI 49307View Listing
$529,00016473 Mitchell Creek Trl Unit 7Big Rapids MI 49307View Listing
$499,00017312 15 Mile RdBig Rapids MI 49307View Listing
$485,000The Hills of Mitchell CrkBig Rapids MI 49307View Listing
$450,00022975 18 Mile RdBig Rapids MI 49307View Listing
$450,00014735 190th AveBig Rapids MI 49307View Listing
$425,0007708 E 7 Mile RdBig Rapids MI 49307View Listing
$395,00020153 Spruce Rd # 2Big Rapids MI 49307View Listing
$385,90021937 6 Mile RdReed City MI 49677View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "MI" 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 28
Blah
Commercial
Land
Ranch
Single Family
