Property Search

prepare( " SELECT `". $wpdb->postmeta . "`.`meta_value`,`". $wpdb->posts . "`.`ID` FROM `". $wpdb->postmeta . "` INNER JOIN `". $wpdb->posts . "` ON `". $wpdb->posts . "`.`ID` = `". $wpdb->postmeta . "`.`post_id` WHERE `". $wpdb->postmeta . "`.`meta_key` = 'aios_listings_data' AND `". $wpdb->posts . "`.`post_status` = 'publish' AND `". $wpdb->posts . "`.`post_type` = 'listing'" , null); $raw_listings = $wpdb->get_results( $query, ARRAY_A ); $ctr = 0; $listings_city = array(); $listings_zip = array(); foreach( $raw_listings as $listing ) { if ( function_exists( 'maybe_unserialize' ) ) { $listing['meta_value'] = maybe_unserialize( $listing['meta_value'] ); } else { $listing['meta_value'] = @unserialize( $listing['meta_value'] ); } $listings_city[] = $listing['meta_value']['city']; $listings_zip[] = $listing['meta_value']['zip']; } $listings_city = array_unique($listings_city); sort($listings_city); $listings_zip = array_unique($listings_zip); $property_type = ["Building" , "Co-op" , "Commercial" , "Condo/coop" , "Condo/Sublet" , "Income Property" , "Investment" , "Land" , "Manor house" , "Rental" , "Residential", "Single Family", "Townhouse" , "Vacation" , "VILLAS"]; sort($property_type); ?>

Confidentiality , Commitment and Knowledge

These are the guiding principles upon which Wendy Jackson conducts all of her dealings. Her commitment to excellence and intrinsic knowledge of the real estate market are exceeded only by her irreproachable integrity and ethical standards. Her fierce passion and dedication to her work, coupled with her elegant and sophisticated, but friendly demeanor is what keeps her on top in the toughest real estate market in the world.