SELECT *, CASE WHEN `locality` LIKE "bergen%" 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 = "WI" AND (locality IN ("bergen") 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 33
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "WI" 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 33
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,050,0001433 Bayshore DrJunction City WI 54443View Listing
$900,000205210 Vallie LnMosinee WI 54455View Listing
$859,900209041 Beans Eddy RdMosinee WI 54455View Listing
$720,0001066 Maple Ridge RdMosinee WI 54455View Listing
$695,000147388 White Birch CtMosinee WI 54455View Listing
$500,000160 Acres Birch DrMosinee WI 54455View Listing
$429,900201841 Dorie LnMosinee WI 54455View Listing
$421,053832 Stone Ridge DrMosinee WI 54455View Listing
$419,900212607 Cubby LnMosinee WI 54455View Listing
$419,900142145 Saturn RdMosinee WI 54455View Listing
$409,632829 Stone Ridge DrMosinee WI 54455View Listing
$400,00081 Acres Birch DrMosinee WI 54455View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "WI" 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 33
Blah