SELECT COUNT(1) as total FROM `_rewidx_listings` `t1` WHERE (`t1`.`IsWaterfront` = 'Y') AND (`ListingType` = 'Residential') AND ( `DescriptionWaterfront` LIKE '%Interior Can%' OR  `DescriptionWaterfront` LIKE '%Intracoastal%' OR  `DescriptionWaterfront` LIKE '%Lake%' OR  `DescriptionWaterfront` LIKE '%River%') ORDER BY t1.ListingPrice DESC<br /><br />