SELECT *, CASE WHEN `name` LIKE "panama city%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "panama city" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "panama city" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "panama city" 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 = "FL" AND (locality IN ("panama city") 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 4
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "FL" 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 4
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.
$2,200,0004301 Transmitter RdPanama City FL 32404View Listing
$2,000,0002527 W 9th StPanama City FL 32401View Listing
$1,970,0001415 Deer AvePanama City FL 32401View Listing
$1,950,0001615 Grant AvePanama City FL 32401View Listing
$1,799,999535 Mills LnPanama City FL 32404View Listing
$1,700,0003005 Kings Harbour RdPanama City FL 32405View Listing
$1,685,5002631 Mound AvePanama City FL 32405View Listing
$1,495,00011421 Poston RdPanama City FL 32404View Listing
$1,289,000201 Harrison AvePanama City FL 32401View Listing
$1,125,0002857 Tupelo DrPanama City FL 32405View Listing
$1,119,5002522 Pretty Bayou Island DrPanama City FL 32405View Listing
$1,095,000410 Bunkers Cove RdPanama City FL 32401View Listing
$999,9003711 Shoreline CirPanama City FL 32405View Listing
$980,8922109 Royal Tern St Lot 410Panama City FL 32405View Listing
$949,00011535 Poston RdPanama City FL 32404View Listing
$936,5007339 Rodgers DrPanama City FL 32404View Listing
$900,0005826 Highway 2297Panama City FL 32404View Listing
$899,0008125 High Point RdPanama City FL 32404View Listing
$890,000369 Confidence WayPanama City FL 32409View Listing
$829,000200 Hollis AvePanama City FL 32401View Listing
$815,0007546 Coleridge RdPanama City FL 32404View Listing
$799,0002363 Foxworth DrPanama City FL 32405View Listing
$799,00012722 Richard RdPanama City FL 32404View Listing
$789,900609 Kristanna DrPanama City FL 32405View 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-14-2024 1:25:28 pm.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "FL" 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 4
Blah