Thomas Osterman, a leader within the Phoenix area real estate community since 1984, has been assisting clients with their home purchasing and selling needs. Having been named among the top 3% of Maricopa County Realtors in 2012, Thomas has used his intimate knowledge of Paradise Valley, North Scottsdale, Central Scottsdale, North Phoenix, North Central Phoenix, Arcadia and the Biltmore neighborhoods to offer an exceptional level of personal service. Due to his master negotiation skills, Thomas will ensure that you receive the outcome you desire and the home you deserve. If you are looking for an experienced, professional and genuine real estate agent to get the job done, contact Thomas today at (602) 405-4052.
from pbk9wlov_postmeta as pm
INNER JOIN pbk9wlov_posts as p
on p.ID = pm.post_id
where p.ID = (
FROM pbk9wlov_postmeta pm
WHERE pm.meta_key = 'leadpages_slug'
AND pm.meta_value = '1150000-2'
ORDER BY pm.meta_id ASC