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.
 | HomeLife Properties, LLC Address: 5545 N. Wickham Road Location: Melbourne, Florida Office:321-775-0272 Toll free:1-888-532-3074 |
 | HomeLife Team Equity Realty Address: 150 South Arroyo Parkway Location: Pasadena, California Office:626-204-8333 Toll free:800-300-9022 |
| HomeLife-Coastal Properties Address: 699 17th St Location: Vero Beach, Florida Office:772-257-0597 |
| HomeLife Genesis Realty Group Address: 5111 N Scottsdale Rd Location: Scottsdale, Arizona Office:480-775-9111 |
| HomeLife Access Realty Address: 313 England St Location: Ashland, Virginia Office:804-798-7878 |