SELECT *, CASE WHEN `name` LIKE "johns creek%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "johns creek" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "johns creek" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "johns creek" 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 ("johns creek") 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.
$3,100,0002000 Westbourne WayJohns Creek GA 30022View Listing
$2,647,0003910 Merriweather WoodsJohns Creek GA 30022View Listing
$2,285,0002007 Tavistock CtJohns Creek GA 30022View Listing
$2,150,0003905 Merriweather WoodsJohns Creek GA 30022View Listing
$1,500,0004850 GaidrewJohns Creek GA 30022View Listing
$1,350,0009890 Autry Falls DrJohns Creek GA 30022View Listing
$1,299,0004245 Fairway Villas DrJohns Creek GA 30022View Listing
$1,165,000640 Falls Lake DrJohns Creek GA 30022View Listing
$975,000455 Morton Mill LnJohns Creek GA 30022View Listing
$969,00059 Creekside Park DrJohns Creek GA 30022View Listing
$900,000175 Stoney Ridge DrJohns Creek GA 30022View Listing
$775,0005715 Preserve CirJohns Creek GA 30005View Listing
$730,0003085 Birchton StJohns Creek GA 30022View Listing
$669,9005595 Vicarage WalkJohns Creek GA 30005View 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 5:29:47 am.
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
