SELECT *, CASE WHEN `locality` LIKE "sandy springs%" 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 ("sandy springs") 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.
$2,400,000904 Carriage Path SESmyrna GA 30082View Listing
$2,300,00011315 Stroup RdRoswell GA 30075View Listing
$2,200,000782 Holcomb Bridge RdNorcross GA 30071View Listing
$2,200,0001330 Cashiers WayRoswell GA 30075View Listing
$2,200,000335 Jones DrRoswell GA 30075View Listing
$2,100,0001260 Cashiers WayRoswell GA 30075View Listing
$2,000,0002899 Alexander St SESmyrna GA 30080View Listing
$1,999,9002454 Marneil Dr NEMarietta GA 30062View Listing
$1,850,000269 Hanson Way NWMarietta GA 30064View Listing
$1,750,0003090 Holly Springs Rd NEMarietta GA 30062View Listing
$1,650,0001410 Old Riverside RdRoswell GA 30076View Listing
$1,649,900784 N Saint Marys Ln NWMarietta GA 30064View 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