SELECT *, CASE WHEN `locality` LIKE "cleveland%" 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 ("cleveland") 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.
$4,452,000221/429 King St/Main StClermont GA 30527View Listing
$2,950,00010 Parkway PlzCleveland GA 30528View Listing
$2,200,0003274 Highway 255NSautee Nacoochee GA 30571View Listing
$1,950,0001304 Highway 17Sautee Nacoochee GA 30571View Listing
$1,849,00097 E Lake Laceola Rd SCleveland GA 30528View Listing
$1,840,000Webster Lake RdCleveland GA 30528View Listing
$1,800,000Skitts Mountain RdCleveland GA 30528View Listing
$1,575,000876 Ascension TrlCleveland GA 30528View Listing
$1,450,0005524 Westmoreland RdCleveland GA 30528View Listing
$1,399,000220 Sal Mountain River Rd Lot 86Sautee Nacoochee GA 30571View Listing
$1,399,000220 Sal Mountain River RdSautee Nacoochee GA 30571View Listing
$1,371,200Appalachian Pkwy Lot 2Cleveland GA 30528View 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