SELECT COUNT(1) as total FROM `_rewidx_listings` `t1` WHERE (`t1`.`AddressCity` IN ('Palm Beach Gardens')) AND (`ListingType` = 'Residential') ORDER BY t1.ListingPrice DESC