SELECT COUNT(1) as total FROM `_rewidx_listings` `t1` WHERE (`t1`.`ListingPrice` >= '2000000') AND (`t1`.`ListingPrice` <= '3000000') AND (`ListingType` = 'Residential') AND ( (`DescriptionWaterfront` LIKE '%Ocean Access%' OR `IsGulfAccess` = 'Y' )  OR  `DescriptionWaterfront` LIKE '%Ocean Front%') ORDER BY t1.ListingPrice DESC<br /><br />