Featured Listings

select * from wp_property_db where `property-status` not like '%|Off Market|%' and `property-category` like '%|Featured Listing|%'  ORDER BY `wpcf-highlighted-property` DESC, `wpcf-total-price-sort` desc

No properties fit the given criteria, listed below are some other properties that you may be interested in.