SELECT pm.*, p.ID from pbk9wlov_postmeta as pm INNER JOIN pbk9wlov_posts as p on p.ID = pm.post_id where p.ID = ( SELECT pm.post_id FROM pbk9wlov_postmeta pm WHERE pm.meta_key = 'leadpages_slug' AND pm.meta_value = 'category/arcadia-az-real-estate' ORDER BY pm.meta_id ASC LIMIT 1 )

---

• 2 Biltmore Estates Dr Unit 314 Phoenix, AZ 85016
• 5302 N 42nd Pl Phoenix, AZ 85018
• 6035 N Central Ave Phoenix, AZ 85012
• 2564 E Ocotillo Rd Phoenix, AZ 85016
• 6019 N Central Ave Phoenix, AZ 85012
• 1539 E Eugie Ave Phoenix, AZ 85022
• 21905 N 37th Terrace Phoenix, AZ 85050
• 3147 E Rose Ln Phoenix, AZ 85016
• 6711 E Camelback Rd Unit 61 Scottsdale, AZ 85251