Royal LePage Hodgins Realty

Establishment and real estate agency at 102 Burrows Avenue East, Melfort, SK S0E 1A0, Canada. Here you will find detailed information about Royal LePage Hodgins Realty: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Real estate agency  

Address:
102 Burrows Avenue East
Melfort
Saskatchewan S0E 1A0
Canada
Get directions

Phone:
+1 306-752-5751

Website:
royallepage.ca

Reviews of Royal LePage Hodgins Realty

Sorry, but now we haven't any revews about Royal LePage Hodgins Realty.

Add review

About royallepage.ca

Canada Real Estate Listings and Homes for Sale | Royal LePage Real Estate
Get expert advice on buying and selling a house, and search Canadian real estate listings. View homes and cottages for sale from Royal LePage Canada.

1SELECT * FROM `item` WHERE url = 'royal-lepage-hodgins-realty' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('179') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('18731') LIMIT 1
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('237935')
0SELECT * FROM `category` WHERE id IN ('96','129') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'melfort-sk' LIMIT 1
0SELECT * FROM `region` WHERE id = 179 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 237935 AND `date` < '2024-04-20 10:24:42' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('237935')
2SELECT * FROM `item` WHERE id IN ('426917','238356','238088','427257','238048','426882') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('179') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('18731') LIMIT 1
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('238048','238088','238356','426882','426917','427257')
0SELECT * FROM `category` WHERE id IN ('96','118','117','140','128') LIMIT 5
0SELECT * FROM counts where updated="2024-04-20" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-20" and table_name like 'news'
1SELECT * FROM `category` ORDER BY name
1SELECT * 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 ('168','179') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('14649','14199','14334','18872') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('251821','251822','251823','251824')
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