SELECT *, CASE WHEN `name` LIKE "lawrenceville%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lawrenceville" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lawrenceville" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "lawrenceville" 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 ("lawrenceville") 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.
$790,000990 Henry TerLawrenceville GA 30046View Listing
$790,000461 Saddle Ridge DrLawrenceville GA 30046View Listing
$790,0001605 Ivy Lea CtLawrenceville GA 30045View Listing
$779,9001865 Chloe CtLawrenceville GA 30043View Listing
$775,000583 Martins Chapel RdLawrenceville GA 30045View Listing
$764,0001818 Prince DrLawrenceville GA 30043View Listing
$715,951288 Ryston Way Unit 65Lawrenceville GA 30045View Listing
$715,0001747 Miramonte WayLawrenceville GA 30045View Listing
$690,000818 Springlake RdLawrenceville GA 30045View Listing
$684,9001760 Stepstone CtLawrenceville GA 30043View Listing
$684,9001498 Rocky River Dr Unit 42Lawrenceville GA 30045View Listing
$670,000265 Camden Creek CtLawrenceville GA 30043View Listing
$670,0001399 Mill Path LoopLawrenceville GA 30045View Listing
$659,900151 Pine Forest DrLawrenceville GA 30046View Listing
$659,000597 Town Square WayLawrenceville GA 30046View Listing
$650,000905 Ingleside DrLawrenceville GA 30044View Listing
$650,0003302 Wasatch Range WayLawrenceville GA 30044View 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-02-2024 8:57:11 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