SELECT *, CASE WHEN `locality` LIKE "pocono ranch lands%" 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 = "PA" AND (locality IN ("pocono ranch lands") 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 14
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "PA" 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 14
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,699,000241 Hunters LnDingmans Ferry PA 18328View Listing
$1,499,999901 Meyer RdBushkill PA 18064View Listing
$1,200,0006147 Sullivan TrlBushkill PA 18064View Listing
$1,005,000323 E Moorestown RdBushkill PA 18091View Listing
$995,000297 Myck RdDingmans Ferry PA 18328View Listing
$849,8001240 Miller RdBushkill PA 18091View Listing
$735,0001505 Seifert RdBushkill PA 18064View Listing
$699,000815 Milford RdDingmans Ferry PA 18328View Listing
$499,000569 Whippoorwill DrBushkill PA 18324View Listing
$499,000301 Traverse RdDingmans Ferry PA 18328View Listing
$399,9002205 Longview DrBushkill PA 18324View Listing
$315,185312 Mountain Top DrDingmans Ferry PA 18328View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "PA" 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 14
Blah
Commercial
Land
Ranch
Single Family
