SELECT *, CASE WHEN `locality` LIKE "pembroke%" 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 = "GA" AND (locality IN ("pembroke") 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 6
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "GA" 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 6
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.
$9,500,0006272 W Highway 280Pembroke GA 31321View Listing
$9,000,000641 US Highway 80 EEllabell GA 31308View Listing
$7,000,0005185 Old Groveland RdPembroke GA 31321View Listing
$5,150,000GA Highway 280Pembroke GA 31321View Listing
$3,400,0008527 Highway 119 SEllabell GA 31308View Listing
$2,750,0001063 Old Olive Branch RdEllabell GA 31308View Listing
$2,500,000700 US Highway 80 Hwy EEllabell GA 31308View Listing
$2,255,000981 Roberts RdEllabell GA 31308View Listing
$2,030,5001369 Eldora Rd Lot 1Ellabell GA 31308View Listing
$2,000,0007458 Ga-119 Highway SEllabell GA 31308View Listing
$2,000,0001099 Old Olive Branch RdEllabell GA 31308View Listing
$1,500,000232D Strickland Rd Lot 2Pembroke GA 31321View Listing
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "GA" 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 6
Blah