SELECT *, CASE WHEN `locality` LIKE "thomasville%" 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 ("thomasville") 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.
$799,000102 W Pastime DrThomasville GA 31792View Listing
$795,0001522 Millpond RdThomasville GA 31792View Listing
$749,900201 Chatham DrThomasville GA 31792View Listing
$675,000124 Sweetbriar Lakes DrThomasville GA 31757View Listing
$625,0002462 Cone RdThomasville GA 31757View Listing
$600,000105 Ivanhoe DrThomasville GA 31792View Listing
$599,000105 Junius StThomasville GA 31792View Listing
$595,000101 Springdale CirThomasville GA 31792View Listing
$569,000147 Willow Ridge CirThomasville GA 31757View Listing
$525,000Se Us Highway 84 By-Pass and Hall RdThomasville GA 31757View Listing
$499,900212 Yorkshire CresThomasville GA 31792View Listing
$499,000452 Carrington CirThomasville GA 31757View 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
Commercial
Land
Ranch
Single Family
