SELECT *, CASE WHEN `locality` LIKE "west hattiesburg%" 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 = "MS" AND (locality IN ("west 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,600,000200 Ac /-Luther Carter RdPetal MS 39465View Listing
$1,500,0009085 Old River RdPetal MS 39465View 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
$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
LIGHTBOX-IMAGES
LENDORS & TITLE COMPANIES
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
Commercial
Land
Ranch
Single Family
