- Find Your Dream Home
- Free Home Valuation
- HomeLife Careers
- HomeLife Franchises
- Franchise Opportunity
- Buyers Guide
- Sellers Guide
- Sweepstakes
- HomeLife Gold Rewards Points™
- Community Marketing & Entertainment
- Relocation - Referrals
- Mortgage - Home Loans
- HomeLife Store
- Real Estate News
user warning: SELECT command denied to user 'homelife_hluser'@'192.168.33.3' for table 'Countries'
query: printOfficeGeoInfo
SELECT btn.bid, btn.nid, b.office_name, gtn.latitude, gtn.longitude, b.address, b.suite, b.city, c.name as county, cy.name as country, b.zip_postal FROM broker_to_node AS btn INNER JOIN broker AS b ON btn.bid = b.bid AND b.company_id=1 INNER JOIN properties.Countries cy ON cy.CountryID=b.country INNER JOIN properties.Counties c ON c.CountyID=b.county INNER JOIN geo_to_node AS gtn ON btn.nid = gtn.nid ORDER BY country, county, city in /home/homelife/public_html/includes/database.mysql.inc on line 122.
© 2008 HomeLife Realty Services Inc. All Rights Reserved. HomeLife® is a registered trademark of HomeLife Realty Services Inc.
* Each Brokerage Is Independently Owned and Operated.
Privacy | Terms of Use | Jobs | Contact Us | About Us | Trademarks
* Each Brokerage Is Independently Owned and Operated.
Privacy | Terms of Use | Jobs | Contact Us | About Us | Trademarks
Real Estate Internet Marketing by InCom Real Estate Web and e-Marketing Solutions