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
Related Links: Rifle Chamber of Commerce BLM CDOT Traveler Information City of Rifle Colorado Mountain College Colorado Sportsmen Wildlife Fund Colorado State Parks Colorado Tourism Office Division of Wildlife Garfield County Garfield County Re2 Schools Grand River Hospital District Silt Chamber of Commerce Town of Meeker Town of New Castle Town of Silt Wildernet
See All Rifle Area Listings
Please Keep Me Updated
