Your 'Port' has been chosen Clear this filter or visit another page to change

Castro, Chile

Castro is a city in the Chilean island of Chiloé Island. Castro is the capital of the Chiloé Province in the Los Lagos Region. It is Chile's third oldest city in continued existence. Tourism in Chiloé is very strongly based on the island's cultural heritage, predominantly consisting of crafts markets, appreciation of cultural landscapes, museum exhibitions, seafood cuisine and architectural heritage (Chiloé's old churches).

Castro itself has distinctive architecture which is seen in the stilt houses built over the sea, called palafitos. Also worth noting is the San Francisco Church, declared a national monument in 1910, which is completely built from local wood.

The annual festival which takes place during the third week of February is of great interest and during which cultural customs can be viewed.

Things to see and do

* Artisan market
* San Francisco Church - Wooden cathedral
* Stilt houses

Cruise Season – Jan - Dec
Currency – Peso (CLP)
Language – Spanish
Population – 42,000 approx
Land Area – 473 km²
Electricity – 2 perpendicular flat pins USA style
Time – GMT minus four hours
International Country Telephone Code – + 56

Port Location – The port at Castro is centrally located within walking distance of the town centre.

Transport Links – There are buses from the mainland (Puerto Montt). The ferry crossing is included in the price. Another convenient way to enter would be with a rented car. Which would also give you means to explore the rest of Chiloe.

#	Query	Time
(1)	connect	0.0010290145874023
(2)	DESCRIBE `ports`	0.003180980682373
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'castro-chile') AND (orchid_available = 1) LIMIT 1	0.011749982833862
(4)	DESCRIBE `destinations`	0.0026440620422363
(5)	SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 37)))	0.00046014785766602
(6)	DESCRIBE `avid_specials`	0.0017340183258057
(7)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '37' AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = ''))	0.0011749267578125
(8)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '882')	0.00059080123901367
(9)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '882')	0.0022399425506592
(10)	SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '882')	0.0018730163574219
(11)	DESCRIBE `cruises`	0.0065920352935791
(12)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (76700, 76701)) ORDER BY FIND_IN_SET(id, '76700,76701')	0.0019509792327881
(13)	DESCRIBE `cruiselines`	0.0031919479370117
(14)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('18')) ORDER BY FIND_IN_SET(id, '18')	0.00058078765869141
(15)	DESCRIBE `cruisetypes`	0.0018489360809326
(16)	DESCRIBE `destinations`	0.0027091503143311
(17)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('37')) ORDER BY FIND_IN_SET(id, '37')	0.00052595138549805
(18)	DESCRIBE `ships`	0.0042150020599365
(19)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 84)))	0.00067806243896484
(20)	DESCRIBE `ships`	0.0041038990020752
(21)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 84)))	0.00057792663574219
(22)	DESCRIBE `ports`	0.0022718906402588
(23)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 882)))	0.00047707557678223

Query

Time

(1)

connect

0.0010290145874023

(2)

DESCRIBE `ports`

0.003180980682373

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'castro-chile') AND (orchid_available = 1) LIMIT 1

0.011749982833862

(4)

DESCRIBE `destinations`

0.0026440620422363

(5)

SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 37)))

0.00046014785766602

(6)

DESCRIBE `avid_specials`

0.0017340183258057

(7)

SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = '37' AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = ''))

0.0011749267578125

(8)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '882')

0.00059080123901367

(9)

SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '882')

0.0022399425506592

(10)

SELECT `latlong`.`lat`, `latlong`.`long` FROM `latlong` WHERE (port_id = '882')

0.0018730163574219

(11)

DESCRIBE `cruises`

0.0065920352935791

(12)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (76700, 76701)) ORDER BY FIND_IN_SET(id, '76700,76701')

0.0019509792327881

(13)

DESCRIBE `cruiselines`

0.0031919479370117

(14)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('18')) ORDER BY FIND_IN_SET(id, '18')

0.00058078765869141

(15)

DESCRIBE `cruisetypes`

0.0018489360809326

(16)

DESCRIBE `destinations`

0.0027091503143311

(17)

SELECT `destinations`.* FROM `destinations` WHERE (id IN ('37')) ORDER BY FIND_IN_SET(id, '37')

0.00052595138549805

(18)

DESCRIBE `ships`

0.0042150020599365

(19)

SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 84)))

0.00067806243896484

(20)

DESCRIBE `ships`

0.0041038990020752

(21)

SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 84)))

0.00057792663574219

(22)

DESCRIBE `ports`

0.0022718906402588

(23)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 882)))

0.00047707557678223

My Favourite Cruises

Castro, Chile

Database Profiling Report

Find Your Cruise

My Favourite Cruises

Castro, Chile

Database Profiling Report