SELECT COUNT(1) as total FROM `_rewidx_listings` `t1` WHERE (`t1`.`AddressCounty` IN ('Palm Beach')) AND (`t1`.`IsWaterfront` = 'Y') AND ((( `t1`.`ListingFeedComponent` IN('bearfl','bearfl_sold') AND ((FIND_IN_SET('Condo', REPLACE(`ListingSubType`, ', ', ',')) OR FIND_IN_SET('High Rise (8+)', REPLACE(`ListingSubType`, ', ', ',')) OR FIND_IN_SET('Low Rise (1-3)', REPLACE(`ListingSubType`, ', ', ',')) OR FIND_IN_SET('Mid Rise (4-7)', REPLACE(`ListingSubType`, ', ', ','))))) OR ( `t1`.`ListingFeedComponent` IN('bmls','bmls_sold') AND ((FIND_IN_SET('Condo/Coop', REPLACE(`ListingSubType`, ', ', ',')) OR FIND_IN_SET('Condo Hotel', REPLACE(`ListingSubType`, ', ', ',')) OR FIND_IN_SET('Condo or Coop', REPLACE(`ListingSubType`, ', ', ','))))) OR ( `t1`.`ListingFeedComponent` IN('gflr','gflr_sold') AND ((FIND_IN_SET('Condo', REPLACE(`ListingSubType`, ', ', ',')) OR FIND_IN_SET('Condominium', REPLACE(`ListingSubType`, ', ', ','))))) OR ( `t1`.`ListingFeedComponent` IN('mar','mar_sold') AND ((`ListingSubType` = 'Condo' OR `ListingSubType` = 'Condominium'))) OR ( `t1`.`ListingFeedComponent` IN('mfr','mfr_sold') AND ((`ListingSubType` = 'Condo' OR `ListingSubType` = 'Condo-Hotel'))) OR ( `t1`.`ListingFeedComponent` IN('nabor','nabor_sold') AND ((FIND_IN_SET('High Rise (8+)', REPLACE(`ListingSubType`, ', ', ',')) OR FIND_IN_SET('Low Rise (1-3)', REPLACE(`ListingSubType`, ', ', ',')) OR FIND_IN_SET('Mid Rise (4-7)', REPLACE(`ListingSubType`, ', ', ','))))) OR ( `t1`.`ListingFeedComponent` IN('pbbor','pbbor_sold') AND ((`ListingSubType` = 'Condo' OR `ListingSubType` = 'Condominium' OR `ListingSubType` = 'Condo/Coop' OR `ListingSubType` = 'Condominium/TH'))) OR ( `t1`.`ListingFeedComponent` IN('ragfmb','ragfmb_sold') AND ((FIND_IN_SET('Condo', REPLACE(`ListingSubType`, ', ', ',')) OR FIND_IN_SET('High Rise (8+)', REPLACE(`ListingSubType`, ', ', ',')) OR FIND_IN_SET('Low Rise (1-3)', REPLACE(`ListingSubType`, ', ', ',')) OR FIND_IN_SET('Mid Rise (4-7)', REPLACE(`ListingSubType`, ', ', ','))))) OR ( `t1`.`ListingFeedComponent` IN('ramc','ramc_sold') AND ((`ListingSubType` = 'Condo/Coop' OR `ListingSubType` = 'Condominium'))))) AND `t1`.`ListingType` NOT IN ("Commercial", "Commercial Lease", "Commercial Sale", "Rental", "Residential Lease", "Business") ORDER BY t1.ListingPrice DESC<br /><br />