Regio's - Haspengouw

user warning: Got error 122 from storage engine query: SELECT DISTINCT(node.nid) AS nid, node_data_field_promotie_einddatum.field_promotie_type_value AS node_data_field_promotie_einddatum_field_promotie_type_value, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, node_data_field_promotie_einddatum.field_promotie_prijs_normaal_value AS node_data_field_promotie_einddatum_field_promotie_prijs_normaal_value, node_data_field_promotie_einddatum.field_promotie_prijs_promotie_value AS node_data_field_promotie_einddatum_field_promotie_prijs_promotie_value, node_data_field_promotie_einddatum.field_promotie_begindatum_value AS node_data_field_promotie_einddatum_field_promotie_begindatum_value, node_data_field_promotie_einddatum.field_promotie_einddatum_value AS node_data_field_promotie_einddatum_field_promotie_einddatum_value, node_data_field_promotie_einddatum.field_promotie_omschr_promotie_value AS node_data_field_promotie_einddatum_field_promotie_omschr_promotie_value, node_data_field_promotie_einddatum.field_promotie_geldigheid_value AS node_data_field_promotie_einddatum_field_promotie_geldigheid_value, node_data_field_promotie_einddatum.field_promotie_logiestype_value AS node_data_field_promotie_einddatum_field_promotie_logiestype_value, node_data_field_promotie_einddatum.field_promotie_gemeente_value AS node_data_field_promotie_einddatum_field_promotie_gemeente_value, node_data_field_promotie_einddatum.field_promotie_regio_value AS node_data_field_promotie_einddatum_field_promotie_regio_value, node_data_field_promotie_einddatum.field_promotie_telefoon_value AS node_data_field_promotie_einddatum_field_promotie_telefoon_value, node_data_field_promotie_einddatum.field_promotie_website_url AS node_data_field_promotie_einddatum_field_promotie_website_url, node_data_field_promotie_einddatum.field_promotie_website_title AS node_data_field_promotie_einddatum_field_promotie_website_title, node_data_field_promotie_einddatum.field_promotie_website_attributes AS node_data_field_promotie_einddatum_field_promotie_website_attributes, node_data_field_promotie_einddatum.field_promotie_email_email AS node_data_field_promotie_einddatum_field_promotie_email_email, RAND(1328616513) AS _random_seed FROM node node LEFT JOIN content_type_promotie node_data_field_promotie_einddatum ON node.vid = node_data_field_promotie_einddatum.vid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid INNER JOIN node_access na ON na.nid = node.nid LEFT JOIN domain_access domain_access ON node.nid = domain_access.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'domain_site') OR (na.gid = 0 AND na.realm = 'domain_id'))) AND ( (((domain_access.realm = 'domain_id' AND domain_access.gid = 0) OR (domain_access.realm = 'domain_site' AND domain_access.gid = 0))) ) AND ( ((node.type in ('promotie')) AND (node.status <> 0)) AND ((DATE_FORMAT(STR_TO_DATE(node_data_field_promotie_einddatum.field_promotie_einddatum_value, '%Y-%m-%dT%T'), '%Y-%m-%d') >= '2012-02-07') AND (DATE_FORMAT(STR_TO_DATE(node_data_field_promotie_einddatum.field_promotie_einddatum_value, '%Y-%m-%dT%T'), '%Y-%m-%d') >= '2012-01-01')) )ORDER BY _random_seed ASC LIMIT 0, 10 in /var/www/vhosts/najaar.toerismelimburg.be/httpdocs/sites/all/modules/contrib/views/includes/view.inc on line 755.
user warning: Got error 122 from storage engine query: SELECT DISTINCT(node.nid) AS nid, node_data_field_bezienswaardigheid_foto.field_bezienswaardigheid_foto_fid AS node_data_field_bezienswaardigheid_foto_field_bezienswaardigheid_foto_fid, node_data_field_bezienswaardigheid_foto.field_bezienswaardigheid_foto_list AS node_data_field_bezienswaardigheid_foto_field_bezienswaardigheid_foto_list, node_data_field_bezienswaardigheid_foto.field_bezienswaardigheid_foto_data AS node_data_field_bezienswaardigheid_foto_field_bezienswaardigheid_foto_data, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, RAND() AS _random FROM node node LEFT JOIN votingapi_vote votingapi_vote_node_percent ON node.nid = votingapi_vote_node_percent.content_id AND (votingapi_vote_node_percent.content_type = 'node' AND votingapi_vote_node_percent.value_type = 'percent') LEFT JOIN content_type_bezienswaardigheid node_data_field_bezienswaardigheid_foto ON node.vid = node_data_field_bezienswaardigheid_foto.vid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid INNER JOIN node_access na ON na.nid = node.nid LEFT JOIN domain_access domain_access ON node.nid = domain_access.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'domain_site') OR (na.gid = 0 AND na.realm = 'domain_id'))) AND ( (((domain_access.realm = 'domain_id' AND domain_access.gid = 0) OR (domain_access.realm = 'domain_site' AND domain_access.gid = 0))) ) AND ( (node.type in ('bezienswaardigheid')) AND (node.status <> 0) )ORDER BY _random ASC LIMIT 0, 1 in /var/www/vhosts/najaar.toerismelimburg.be/httpdocs/sites/all/modules/contrib/views/includes/view.inc on line 755.
user warning: Got error 122 from storage engine query: SELECT DISTINCT(node.nid) AS nid, node_data_field_flash_header_afbeelding.field_flash_header_afbeelding_fid AS node_data_field_flash_header_afbeelding_field_flash_header_afbeelding_fid, node_data_field_flash_header_afbeelding.field_flash_header_afbeelding_list AS node_data_field_flash_header_afbeelding_field_flash_header_afbeelding_list, node_data_field_flash_header_afbeelding.field_flash_header_afbeelding_data AS node_data_field_flash_header_afbeelding_field_flash_header_afbeelding_data, node.type AS node_type, node.vid AS node_vid, node_data_field_minimumprijs_pppn.field_minimumprijs_pppn_value AS node_data_field_minimumprijs_pppn_field_minimumprijs_pppn_value, node.title AS node_title, location.city AS location_city, RAND() AS _random FROM node node LEFT JOIN content_field_logiestype2 node_data_field_logiestype2_value_0 ON node.vid = node_data_field_logiestype2_value_0.vid AND node_data_field_logiestype2_value_0.field_logiestype2_value = '172' LEFT JOIN content_field_flash_header_afbeelding node_data_field_flash_header_afbeelding ON node.vid = node_data_field_flash_header_afbeelding.vid LEFT JOIN content_type_logie node_data_field_minimumprijs_pppn ON node.vid = node_data_field_minimumprijs_pppn.vid LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid LEFT JOIN location location ON location_instance.lid = location.lid INNER JOIN node_access na ON na.nid = node.nid LEFT JOIN domain_access domain_access ON node.nid = domain_access.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'domain_site') OR (na.gid = 0 AND na.realm = 'domain_id'))) AND ( (((domain_access.realm = 'domain_id' AND domain_access.gid = 0) OR (domain_access.realm = 'domain_site' AND domain_access.gid = 0))) ) AND ( (node.type in ('logie')) AND (node.status <> 0) AND (node_data_field_logiestype2_value_0.field_logiestype2_value = '172') )ORDER BY _random ASC LIMIT 0, 2 in /var/www/vhosts/najaar.toerismelimburg.be/httpdocs/sites/all/modules/contrib/views/includes/view.inc on line 755.
user warning: Got error 122 from storage engine query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, RAND(1328616705) AS _random_seed FROM node node LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid INNER JOIN node_access na ON na.nid = node.nid LEFT JOIN domain_access domain_access ON node.nid = domain_access.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'domain_site') OR (na.gid = 0 AND na.realm = 'domain_id'))) AND ( (((domain_access.realm = 'domain_id' AND domain_access.gid = 0) OR (domain_access.realm = 'domain_site' AND domain_access.gid = 0))) ) AND ( (node.type in ('fietscafe')) AND (node.status <> 0) )ORDER BY _random_seed ASC ) count_alias in /var/www/vhosts/najaar.toerismelimburg.be/httpdocs/sites/all/modules/contrib/views/includes/view.inc on line 729.
user warning: Got error 122 from storage engine query: SELECT DISTINCT(node.nid) AS nid, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, RAND(1328616705) AS _random_seed FROM node node LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid INNER JOIN node_access na ON na.nid = node.nid LEFT JOIN domain_access domain_access ON node.nid = domain_access.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'domain_site') OR (na.gid = 0 AND na.realm = 'domain_id'))) AND ( (((domain_access.realm = 'domain_id' AND domain_access.gid = 0) OR (domain_access.realm = 'domain_site' AND domain_access.gid = 0))) ) AND ( (node.type in ('fietscafe')) AND (node.status <> 0) )ORDER BY _random_seed ASC LIMIT 0, 1 in /var/www/vhosts/najaar.toerismelimburg.be/httpdocs/sites/all/modules/contrib/views/includes/view.inc on line 755.

In het zuiden van Limburg zijn bodem en landschap de mens gunstig gezind. Al eeuwenlang vestigen volkeren zich in deze vruchtbare en bloesemrijke regio. Met een gulle oogst aan fruit, kastelen, monumenten en erfgoed tot gevolg.
- Haspengouw in feeststemming

Het Toscane-gevoel

In het zuiden krijgt Limburg een glooiend karakter. Haspengouw kenmerkt zich door zijn heuvels met kastelen, vierkantshoeves, kerkdorpjes, holle wegen en fruiboomgaarden.
- Ontdek zelf het landschap en bestel hier je fietskaart

Vruchtbare lekkernijen

Appels, peren, kersen, aardbeien, druiven en bessen zorgen het jaar rond voor een feestelijk bourgondische sfeer.

Het Mergelland

De omgeving van Riemst en Maastricht wordt ook wel het Mergelland genoemd. In deze regio komt de eeuwenoude witte en zachtgele kalksteen tot aan de oppervlakte. Nóg fascinerender is de ondergrondse wereld: een immens labyrinth van gangen en grotten.
- Lees hier meer over het Mergelland

Logeren in Haspengouw

Waar je ook logeert, de ontvangst is hartelijk. Haspengouw heeft een ruime keuze aan logies, zowel in de steden als op het platteland. B&B's, kleine hotels, vierkantshoeven, een kasteel of een fietskluis, noem maar op. Haspengouw heeft het allemaal.
- Logies in Haspengouw

Tips: