SELECT COUNT(1) as total FROM `_rewidx_listings` `t1` WHERE (`t1`.`ListingPrice` >= '500000') AND (`t1`.`ListingPrice` <= '600000') AND (`t1`.`AddressCity` IN ('Miami')) AND (`ListingType` = 'Residential') ORDER BY t1.ListingPrice DESC<br /><br />