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.
$378,9004682 Sunset DrMosinee WI 54455View Listing
$324,900133039 Cottage RdMosinee WI 54455View Listing
$299,900River Rd Lot 3Junction City WI 54443View Listing
$299,0002723 River RdJunction City WI 54443View Listing
$279,999507 State Highway 153 EMosinee WI 54455View Listing
$225,0004526 N Sunset DrMosinee WI 54455View Listing
$209,900Scout Rd Lot 1Mosinee WI 54455View Listing
$199,0002079 Peninsula PlJunction City WI 54443View Listing
$159,900Harvest Moon RdMosinee WI 54455View Listing
$155,0001.51 Acres State Hghway # 153Mosinee WI 54455View Listing
$119,000Dubay Dr Parcel 014-25Mosinee WI 54455View Listing
$67,0002120 Peninsula PlJunction City WI 54443View 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