UK Days Out and Activity Finder
A comprehensive directory for finding days out, activities, events and attractions around the UK.
Golf Courses & Clubs in Stonehaven, Kincardineshire
J W McBainTel: 01569 762702CraignellFax: 01569 762702StonehavenKincardineshireAB39 3UR
Stonehaven Golf ClubTel: 01569 762124Stonehaven Golf ClubFax: 01569 765973StonehavenKincardineshireAB39 3RH
Golf Courses & Clubs near Stonehaven
SELECT sqrt((abs(p.x - t2.x) * abs(p.x - t2.x)) + (abs(p.y-t2.y) * abs(p.y-t2.y))) as distance, b.*, t.nameTown, c.nameCounty, p.* from businesses_daygo b join towns t on b.idTown = t.idTown join counties c on t.idCounty = c.idCounty join postcodes p on b.shortPostCode = p.postcode join towns t2 where b.idBusinessType = 169334 and t.idTown <> 4212 and t2.idTown = 4212 order by (abs(p.x - t2.x) * abs(p.x - t2.x)) + (abs(p.y-t2.y) * abs(p.y-t2.y)) limit 8BIGINT UNSIGNED value is out of range in '(`vpsdaygo_ukbuisness`.`p`.`x` - `vpsdaygo_ukbuisness`.`t2`.`x`)'