Quick search
$n
"; echo ""; } echo ""; echo "Featured properties
"; while($row = mysql_fetch_array($result)) { extract($row); $random1[]="$pid"; } //shuffle array shuffle($random1); //SET MAX FEATURED PROPERTY HERE $max=1; if(count($random1)==1){$max=1;} for($i=0; $i<$max; $i++) { $sql = "SELECT property_id AS pid, name AS n, location AS l FROM property WHERE property_id='$random1[$i]'"; $result = mysql_query($sql) or die("Couldnt execute query - ".mysql_error()); $row = mysql_fetch_array($result); extract($row); $sql = "SELECT filename FROM image WHERE image_no='1' AND property_id='$pid'"; $result = mysql_query($sql) or die("Couldnt execute query - ".mysql_error()); $nrows = mysql_num_rows($result); if($nrows>0) { $row = mysql_fetch_array($result); extract($row); echo "![\"Featured](\"properties/$pid/$filename-small.jpg\")
";
}
echo "$n, $l.
"; echo ""; echo ""; } echo "
Self Catering Holiday Cottage Accommodation in Coltishall, Norfolk, East Anglia
The picturesque village of Coltishall in Norfolk is set on the banks of the river Bure a few miles from the Broadland capital of Wroxham.
The village dates back to Roman times, and in the middle ages it was a centre for the extraction of lime and marl, an industry that continued for many centuries. It was later replaced, when the river became navigable, by a thriving boat and wherry building industry. In Victorian times the village was more a town than a village and, as is apparent by the many large houses, a wealthy area.
Today the village has a large pleasant green where boats can moor and a surprising number of shops and businesses. It is linked to the village of Horstead, separated only by the river bridge. Due to the river narrowing and a weir, the river above the village is not accessible to boats.
The local church dates back to the 13th century with a 15th century tower and an unusual thatched roof.
Rivernere, Coltishall
This newly renovated cottage, dating back to 1826, is perfectly located just 100 yards from Coltishall village green on the banks of the river Bure. This beautiful reed-lined waterway is a gateway to over 200 miles of navigable broads. The cottage, which was originally part of the village pub, is situated down a quiet lane, making it ideal for walkers and cyclists. Surrounded by many walks, including the cycle track running alongside the nearby Bure Valley Railway. A short stroll takes you to three pubs serving good food, with restaurants and local shops a little further along. Nearby are the nature reserves at How Hill and Hickling Broad and the fine sandy beaches of Sea Palling, Walcott and Winterton-on-Sea are just a 20 minute car ride away. Day boats can be hired at nearby Wroxham, or visit Horning for a trip on the Mississippi Paddle Steamer. The medieval city of Norwich is only 7 miles away, with its cobbled streets, a castle, museums, cathedrals, shopping malls and theatre.
Sleeps: 4
Rooms: 2
Pets: Yes
Smoking: No
Cot: No
Facilities:
Colour TV + video & DVD, CD.
Duvets + linen. No towels.
Electric & gas central heating included June to September (outside these dates @ £30 per week, pay on balance).
Washing machine.
Microwave.
Logs available locally.
Nonsmokers.
No children under 5 years.
Garden + furniture.
Safe on road parking.
One well behaved dog by prior arrangement + refundable bond.
Property Description:
Attractive comfortable lounge with open fire and wooden floor. Well-equipped fully fitted kitchen/diner with ornamental wood burner. Open stairs with a twist, two charming bedrooms, one double, one twin with countryside views. Bathroom with over bath shower.
We have an extensive offering of pretty cottages, comfortable family houses, impressive bungalows and even a relaxing houseboat. All of these properties are regularly inspected by one of our knowledgeable staff, which ensures that we can advise you quickly and accurately as to which property will be the perfect holiday base to suit your needs.
