SELECT *, CASE WHEN `name` LIKE "marietta%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "marietta" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "marietta" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "marietta" 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 ("marietta") 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.
$1,500,0001524 Princeton West TrlMarietta GA 30062View Listing
$1,499,9003250 Old Mill Trce SEMarietta GA 30067View Listing
$1,495,0002906 Octavia CirMarietta GA 30062View Listing
$1,495,000929 Saint Lyonn CtsMarietta GA 30068View Listing
$1,475,0004251 Columns Dr SEMarietta GA 30067View Listing
$1,400,0001470 Pleasant View CirMarietta GA 30062View Listing
$1,399,9002750 Twisted Oak Ln NEMarietta GA 30066View Listing
$1,399,9002600 Middle Coray CirMarietta GA 30066View Listing
$1,399,9002575 Pope Manor WayMarietta GA 30062View Listing
$1,399,0003890 Lower Roswell RdMarietta GA 30068View Listing
$1,395,0004671 Wynmeade Park NEMarietta GA 30067View Listing
$1,395,0001211 Spence CtMarietta GA 30062View Listing
$1,375,0004040 Clubland DrMarietta GA 30068View Listing
$1,350,0002900 Treeside TerMarietta GA 30066View Listing
$1,325,0002854 Vireo BndMarietta GA 30062View Listing
$1,307,5003635 Fricks Rd NEMarietta GA 30062View Listing
$1,299,0005301 Sunset TrlMarietta GA 30068View Listing
$1,250,0003919 Cash LndgMarietta GA 30066View Listing
$1,200,0003328 Sulky Cir SEMarietta GA 30067View Listing
$1,200,000422 Ellis Meadow Ct SWMarietta GA 30064View Listing
$1,199,9005041 Canopy DrMarietta GA 30066View Listing
$1,178,9003305 Pinot CtMarietta GA 30062View Listing
$1,175,0002895 Lassiter Manor DrMarietta GA 30062View Listing
$1,150,0003915 Cash LndgMarietta GA 30066View 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-16-2024 8:54:33 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