Doug Haayer Advantage Team

Establishment and real estate agency at 136 Vermilion Avenue, Princeton, BC V0X 1W0, Canada. Here you will find detailed information about Doug Haayer Advantage Team: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Real estate agency  

Address:
136 Vermilion Avenue
Princeton
British Columbia V0X 1W0
Canada
Get directions

Phone:
+1 250-295-1585

Website:
princetonbcrealestateforsale.com

Opening hours

Sunday 08:00am — 05:00pm
Monday 08:00am — 08:00pm
Tuesday 08:00am — 08:00pm
Wednesday 08:00am — 08:00pm
Thursday 08:00am — 08:00pm
Friday 08:00am — 08:00pm
Saturday 08:00am — 05:00pm

Reviews of Doug Haayer Advantage Team

Sorry, but now we haven't any revews about Doug Haayer Advantage Team.

Add review

About princetonbcrealestateforsale.com

Princeton BC Real Estate for Sale with Princeton's Leading Real Estate Agents. Houses and property for sale including MLS listings, residential, acreages, ranches, commercial and recreational.
Princeton BC Real Estate for Sale with Princeton Realtors that are the most productive and professional in the area. This website has the most houses and homes for sale and property listings available in Princeton and Area. Houses, Ranches, farms, lakefront, riverfront, investment and commercial property. We service Tulameen, Allison Lake, Missezula Lake, Osprey Lake and more!
princeton bc real estate for sale, Princeton bc realtors, princeton bc houses for sale, princeton homes for sale, royal lepage princeton, princeton mls listings, princeton property for sale, princeton realtors , princeton bc real estate agents

9SELECT * FROM `item` WHERE url = 'doug-haayer-advantage-team' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('169') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14938') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('156173')
0SELECT * FROM `category` WHERE id IN ('96','129') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'princeton-bc' LIMIT 1
0SELECT * FROM `region` WHERE id = 169 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 156173 AND `date` < '2024-04-26 01:30:12' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('156173')
1SELECT * FROM `item` WHERE id IN ('156020','155856','156252','155988','156215','155977') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('169') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14938') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('155856','155977','155988','156020','156215','156252')
0SELECT * FROM `category` WHERE id IN ('96','107','99','118','100') LIMIT 5
0SELECT * FROM counts where updated="2024-04-26" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-26" and table_name like 'news'
0SELECT * FROM `category` ORDER BY name
3SELECT * FROM `item` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `item`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 4
0SELECT * FROM `region` WHERE id IN ('176','178') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('16752','17251','17772','18120') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('99242','99243','99244','99247')
0SELECT * FROM `locality` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `locality`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 7
0SELECT * FROM `region` WHERE id IN ('168') LIMIT 1