Castle Realty 2000 Ltd

Establishment at 20 Malabar Drive, Sault Ste. Marie, ON P6B 4A5, Canada. Here you will find detailed information about Castle Realty 2000 Ltd: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment

Address:
20 Malabar Drive
Sault Ste. Marie
Ontario P6B 4A5
Canada
Get directions

Phone:
+1 705-949-5540

Website:
castlerealty.ca

Photos

Reviews of Castle Realty 2000 Ltd

Sorry, but now we haven't any revews about Castle Realty 2000 Ltd.

Add review

About castlerealty.ca

Sault Ste Marie ON Real Estate Listings -Realty Executives Castle AllianceRealty Executives Castle Alliance Ltd. Brokerage | Sault Ste. Marie and Algoma District Real Estate and Property Listings
On our website you will find information about all our current real estate listings in Sault Ste. Marie Ontario and the Algoma District. Let our experienced sales agents help you to buy or sell your residential, recreational, vacant land, or commercial property.

1	SELECT * FROM `item` WHERE url = 'castle-realty-2000-ltd' LIMIT 1
0	SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('17147') LIMIT 1
0	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('44019')
0	SELECT * FROM `category` WHERE id IN ('96') LIMIT 1
0	SELECT * FROM `locality` WHERE url = 'sault-ste-marie-on' LIMIT 1
0	SELECT * FROM `region` WHERE id = 176 LIMIT 1
1	SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 44019 AND `date` < '2024-04-19 09:15:29' ORDER BY `date` DESC
0	SELECT * FROM `photos` WHERE `item_id` IN ('44019')
2	SELECT * FROM `item` WHERE id IN ('43926','43984','44361','44481','43765','43985') LIMIT 6
1	SELECT * FROM `region` WHERE id IN ('176') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('17147') LIMIT 1
1	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('43765','43926','43984','43985','44361','44481')
0	SELECT * FROM `category` WHERE id IN ('96','118','107','99','157','116') LIMIT 6
0	SELECT * FROM counts where updated="2024-04-19" and table_name like 'news'
0	SELECT * FROM counts where updated="2024-04-19" and table_name like 'news'
1	SELECT * FROM `category` ORDER BY name
1	SELECT * 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
0	SELECT * FROM `region` WHERE id IN ('170','176') LIMIT 2
0	SELECT * FROM `locality` WHERE id IN ('15335','16470','15236') LIMIT 3
0	SELECT * FROM `photos` WHERE `item_id` IN ('157547','157548','157549','157552')
0	SELECT * 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
0	SELECT * FROM `region` WHERE id IN ('168') LIMIT 1

Castle Realty 2000 Ltd

Contacts

Photos

Reviews of Castle Realty 2000 Ltd

About castlerealty.ca

Share this page

Additional actions

Today's weather in Sault Ste. Marie

Nearest places