SELECT *, CASE WHEN `name` LIKE "hattiesburg%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "hattiesburg" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "hattiesburg" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "hattiesburg" 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 = "MS" AND (locality IN ("hattiesburg") 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 13
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "MS" 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 13
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,675,000Circle C Ranch RdHattiesburg MS 39401View Listing
$3,675,000Circle C RnchHattiesburg MS 39401View Listing
$1,599,00018 Waterford PlHattiesburg MS 39402View Listing
$1,549,50070 Canebrake BlvdHattiesburg MS 39402View Listing
$1,499,000312 6th AveHattiesburg MS 39401View Listing
$1,295,0006758 # Us98 # US98Hattiesburg MS 39402View Listing
$950,000380 Anderson RdHattiesburg MS 39401View Listing
$939,00066 Herb Anderson RdHattiesburg MS 39401View Listing
$840,00018 Woodville TraceHattiesburg MS 39402View Listing
$779,90012 Turnbury DrHattiesburg MS 39401View Listing
$764,000297 Ralph Rawls RdHattiesburg MS 39402View Listing
$749,9002066 Evelyn Gandy PkwyHattiesburg MS 39401View Listing
$749,0008 St Landry CvHattiesburg MS 39402View Listing
$685,000190 Tallulah RdgHattiesburg MS 39402View Listing
$675,0001 Canebrake BlvdHattiesburg MS 39402View Listing
$660,0007 Canebrake BlvdHattiesburg MS 39402View 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-12-2024 9:42:18 pm.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "MS" 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 13
Blah
Ranch
Single Family
