Condos, Homes & Lots for Sale in Puerto Vallarta, Jalisco

SELECT * FROM `apv_properties_realty` WHERE `type_id` IN ('E',11) GROUP BY `property_id`, `listing_id` ORDER BY FIELD(listing_status, 230, 229, 227, 228, 0) desc LIMIT 440, 10