SELECT *, CASE WHEN `name` LIKE "ambler%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "ambler" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "ambler" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "ambler" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "PA" AND (locality IN ("ambler") 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
$1,250,000Lower State Rd Lot 1Ambler PA 19002View Listing
$1,250,000Lower State Rd Lot 2Ambler PA 19002View Listing
$1,224,885516 Dawes Ln Unit 65Ambler PA 19002View Listing
$1,215,250500 Dawes Ln Unit 57Ambler PA 19002View Listing
$1,178,950506 Dawes Ln Unit 60Ambler PA 19002View Listing
$1,150,0008 Lindenwold TerAmbler PA 19002View Listing
$1,137,690610 Roberts Rd Unit 56Ambler PA 19002View Listing
$1,115,7641103 Paine Rd Unit 152Ambler PA 19002View Listing
$1,100,000908 Forest DrAmbler PA 19002View Listing
$1,092,193200 Hooper Dr Unit 122Ambler PA 19002View Listing
$1,084,9511111 Paine Rd Unit 139Ambler PA 19002View Listing
$1,079,900504 Dawes Ln Unit 59Ambler PA 19002View Listing
$1,064,0001207 E Butler PikeAmbler PA 19002View Listing
$1,019,900711 Hampton Rd # 101Ambler PA 19002View Listing
$1,009,900518 Dawes Ln # 66Ambler PA 19002View Listing
$999,995263 Nelson Dr Unit 1Ambler PA 19002View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-16-2024 11:08:59 am.
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