SELECT *, CASE WHEN `name` LIKE "sandy springs%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "sandy springs" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "sandy springs" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "sandy springs" 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 = "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.
$6,750,0005271 Lake Forrest DrSandy Springs GA 30342View Listing
$4,995,0006285 Riverside DrSandy Springs GA 30328View Listing
$3,999,500178 Mount Paran RdSandy Springs GA 30327View Listing
$3,475,0001370 Indian TrlSandy Springs GA 30327View Listing
$3,350,0004550 Jolyn PlSandy Springs GA 30342View Listing
$3,000,00019 Spruell Springs RdSandy Springs GA 30342View Listing
$2,999,900330 Heards Ferry RdSandy Springs GA 30328View Listing
$2,995,0004845 Northway DrSandy Springs GA 30342View Listing
$2,750,000465 Belada BlvdSandy Springs GA 30342View Listing
$1,600,0001140B Churchill Downs Rd NESandy Springs GA 30319View Listing
$1,450,000490 Franklin RdSandy Springs GA 30342View Listing
$1,400,000190 Northglenn Ct NESandy Springs GA 30342View Listing
$1,375,0006270 Riverwood DrSandy Springs GA 30328View Listing
$1,240,00084 Mount Paran Rd NWSandy Springs GA 30327View Listing
$850,0006837 Crescendo CtSandy Springs GA 30328View Listing
$825,000270 Amherst CtSandy Springs GA 30328View Listing
$799,9007785 Highland BlfSandy Springs GA 30328View Listing
$774,900120 Huntcliff PtSandy Springs GA 30350View Listing
$735,000243 Franklin RdSandy Springs GA 30342View Listing
$695,0006071 Boylston Dr NESandy Springs GA 30328View Listing
$695,0006071 Boylston Dr NE Unit 13Sandy Springs GA 30328View Listing
$675,187220 Wessex CtSandy Springs GA 30328View 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-13-2024 6:25:29 pm.
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
Ranch
Single Family
