Fleisher Land & Homes Carbondale Colorado

SELECT DISTINCT(Aspen_listings.Agent_ID_2), Aspen_listings.Agent_Name_2
			FROM Aspen_listings
			LEFT JOIN fleisherBrokers ON fleisherBrokers.Agent_ID = Aspen_listings.Agent_ID_2
			WHERE (Aspen_listings.Office_ID = '20090111180142307375000000' || Aspen_listings.Office_ID = '20090111180113562117000000' || Aspen_listings.Office_ID = '20090111180101679946000000' || Aspen_listings.Office_ID = '20090111180100214105000000' || Aspen_listings.Office LIKE '%Fleisher%')
				&& Aspen_listings.Agent_ID_2 = fleisherBrokers.Agent_ID
			ORDER BY Aspen_listings.Agent_Name_2