Column 'hotelid' does not belong to table select distinct [hotel id] as hotelid,establishmentname as displayname from COUK_hotels left JOIN dbo.COUK_users ON dbo.COUK_hotels.userid = dbo.COUK_users.internalid WHERE postcode LIKE @postcode AND (Status = 'L' OR Status = 'B' OR (Status = 'C' AND credits > 0) OR (Status = 'O')) ORDER BY establishmentname. Online Booking Hotels HS4

Online Booking Hotels HS4

Home
HS4
HS4 Bed and Breakfasts

Please select the county and then the area you wish to stay. We will provide an individual page for each hotel in our database. These can be printed or distributed in any way you decide

Nights

1

Sort

Filter

Map

Miles Km

Local Attraction

Features

Search

Location
Arrival
Nights

Average Nightly Price

Distance

Miles Km

Local Attraction

Features

Select from Bed and Breakfast Hotels in Postcode Area: HS4

[Home] [My Shortlist] [Advertise] [Hotelier Login] [Terms & Conditions] [Site Map]

A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | Y | Z