Properties for sale Crete


Properties for sale Crete

Find properties for sale Crete with Dreamcatchers Crete. Search over 200+ properties in Crete and surrounding areas. 

There's a great selection of properties for sale in North West Crete. Dreamcatchers Estate Agents, based in Almyrida in the Chania region offer 250+ properties including Apartments, bungalows, Villas (both modern and traditional) and renovations. We will help you find and choose the perfect property, be it a permanent home, a holiday home or a business investment. Dreamcatchers have over 10 years of experience in the Real Estate business in the Chania region and will expertly guide you through the buying or selling process from choosing a property to completion and beyond.

Properties for sale crete

Map View List View Grid View

Properties for sale crete

(default) 9 queries took 9 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Setting`.`id`, `Setting`.`from_name`, `Setting`.`from_email`, `Setting`.`admin_email`, `Setting`.`admin_email2`, `Setting`.`admin_contact`, `Setting`.`admin_address`, `Setting`.`admin_timings`, `Setting`.`admin_mobile`, `Setting`.`footer_text`, `Setting`.`banner_description`, `Setting`.`facebook_url`, `Setting`.`twitter_url`, `Setting`.`linkdin_url`, `Setting`.`google_url`, `Setting`.`youtube_url`, `Setting`.`instagram_url`, `Setting`.`created_by`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`meta_title`, `Setting`.`meta_keywords`, `Setting`.`meta_description`, `Setting`.`analytics`, `Setting`.`logo_image`, `Setting`.`new_property_count`, `Setting`.`property_order`, `Setting`.`updated_property_count`, `Setting`.`updated_property_order`, `Setting`.`featured_property_count`, `Setting`.`featured_property_order`, `Setting`.`testimonial_count`, `Setting`.`map_content`, `Setting`.`timezone`, `Setting`.`default_language`, `Setting`.`default_currency`, `Setting`.`favicon` FROM `dxcake_17`.`settings` AS `Setting` WHERE `created_by` = 1 LIMIT 1110
2SELECT `Staticblock`.`title`, `Staticblock`.`slug`, `Staticblock`.`content` FROM `dxcake_17`.`static_blocks` AS `Staticblock` WHERE `Staticblock`.`status` = 1 AND `Staticblock`.`slug` = 'properties-for-sale-crete-static-block' LIMIT 1110
3SELECT `Setting`.`new_property_count`, `Setting`.`property_order`, `Setting`.`updated_property_count`, `Setting`.`updated_property_order`, `Setting`.`featured_property_count`, `Setting`.`featured_property_order` FROM `dxcake_17`.`settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1110
4SELECT `Category`.`cat_name` FROM `dxcake_17`.`categories` AS `Category` WHERE `slug` = 'properties-for-sale-crete' LIMIT 1110
5SELECT `Category`.`id` FROM `dxcake_17`.`categories` AS `Category` WHERE `slug` = 'properties-for-sale-crete' LIMIT 1110
6SELECT `Property`.`id`, `Property`.`title`, `Property`.`slug`, `Property`.`address`, `Property`.`price`, `Property`.`special_price`, `Property`.`reference_number`, `Property`.`area`, `Property`.`plot_size`, `Property`.`energy_rating`, `Property`.`land_water_supply`, `Property`.`land_electricity_supply`, `Property`.`nearest_village`, `Property`.`short_description`, `Property`.`bedrooms`, `Property`.`bathrooms`, `Property`.`pool`, `Property`.`lat`, `Property`.`lng`, `Property`.`total_building_allowance`, `Property`.`video_name`, `Category`.`cat_name`, `Category`.`slug`, `Category`.`meta_title`, `Category`.`meta_keywords`, `Category`.`meta_description`, `Village`.`title` FROM `dxcake_17`.`properties` AS `Property` LEFT JOIN `dxcake_17`.`categories` AS `Category` ON (`Property`.`category_id` = `Category`.`id`) LEFT JOIN `dxcake_17`.`villages` AS `Village` ON (`Village`.`id`=`Property`.`nearest_village`) LEFT JOIN `dxcake_17`.`property_agent_details` AS `PropertyAgentDetail` ON (`PropertyAgentDetail`.`property_id` = `Property`.`id`) WHERE `Property`.`status` = 1 AND `Property`.`trash` = 0 AND `Category`.`slug` = 'properties-for-sale-crete' ORDER BY `Property`.`reference_number` DESC LIMIT 1212125
7SELECT `PropertyImage`.`id`, `PropertyImage`.`property_id`, `PropertyImage`.`name`, `PropertyImage`.`is_cover`, `PropertyImage`.`position`, `PropertyImage`.`status`, `PropertyImage`.`created`, `PropertyImage`.`modified` FROM `dxcake_17`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`status` = 1 AND `PropertyImage`.`property_id` IN (1351, 1350, 1349, 1348, 1345, 1346, 1340, 1329, 1328, 1326, 1233, 1344) ORDER BY `PropertyImage`.`is_cover` DESC, `PropertyImage`.`id` DESC3823822
8SELECT COUNT(*) AS `count` FROM `dxcake_17`.`properties` AS `Property` LEFT JOIN `dxcake_17`.`categories` AS `Category` ON (`Property`.`category_id` = `Category`.`id`) LEFT JOIN `dxcake_17`.`villages` AS `Village` ON (`Village`.`id`=`Property`.`nearest_village`) LEFT JOIN `dxcake_17`.`property_agent_details` AS `PropertyAgentDetail` ON (`PropertyAgentDetail`.`property_id` = `Property`.`id`) WHERE `Property`.`status` = 1 AND `Property`.`trash` = 0 AND `Category`.`slug` = 'properties-for-sale-crete'112
9SELECT `Village`.`id`, `Village`.`title` FROM `dxcake_17`.`villages` AS `Village` WHERE `Village`.`status` = 1 ORDER BY `Village`.`title` ASC45450