SELECT props2.id, prop_name, site_name, county, sleeps, place, postcode, country, our_image, lat, lng, props2.info, props2.info_long, lo_price, priority, props2.type, types.singular_name AS type_name, source, sources.company_name AS brand, f_pets, f_pool, f_hottub, f_baby, f_internet, f_pub, f_coast, f_openfire, f_wheelchair, f_skytv, f_eco, f_evcharge, aff_url
FROM props2
LEFT JOIN sources ON sources.id = props2.source
LEFT JOIN types ON types.id = props2.type
WHERE props2.lo_price > 0
AND props2.live = 1
AND props2.hide = 0
AND props2.county_id > 0
AND props2.region_id > 0
AND props2.country_id > 0
AND sources.hidden = 0
/* AND props2.source NOT IN (1, 4, 5, 6, 7, 8, 403, 387, 241, 389,10) */ AND props2.type = 2 AND region_id = 7 AND county_id = 29 AND live = 1 AND hide = 0 AND lo_price > 0 ORDER BY priority DESC, lo_price DESC LIMIT 1160, 20
The quintessential Dorset village of Burton Bradstock is ideally situated for exploring the countryside and coast of this beautiful area, with both the South West Coast Path and the Jurassic Coast within easy reach. Hive Beach (0.5 miles) is nearby and there are many…
Enjoying a superb setting overlooking delightful Monmouth beach within a short walk of Lyme Regis town centre in the heart of Dorset, is this quaint holiday chalet, The Hut. Perfect for a small family on holiday, the accommodation might be small, but it delivers big on charm and…
Part of a pretty terrace in the small village of Uploders, this quintessentially English cottage is built from beautiful honey coloured stone and has a homely ambience, which is evident from the moment you step through the door. This property is in an ideal location for walkers…
Nestled in the popular Dorset town of Weymouth, is this fantastic one-bedroom holiday home, Brewers Retreat. Enjoying a superb location just moments away from the beach and the towns attractions, Brewers Retreat is a fabulous choice for couples seeking a coastal adventure.…
Enjoying stunning views over Charmouth, Golden Cap, and the Jurassic Coast is The Lodge @ Clifftop Park, a two-bedroom dwelling, located on a small secluded and private site. Just a stone's throw away from the beach and with two parking spaces, The Lodge offers a…
Canford Cliffs 2.1 miles. Flat 5 Fairwinds, a charming first-floor apartment is settled in the desirable location of Sandbanks near Canford Cliffs, Dorset. With plenty of local amenities and the beach just a short distance away, Flat 5 Fairwinds is the perfect spot for couples,…
Home From Home is a charming cottage set in the heart of Fortuneswell, Dorset, on the Isle of Portland. Perfect for families or groups of friends, this pet-friendly retreat offers guests a lovely location right near Chesil Beach! Upon entering, you'll be greeted by a…
Set in the town of Ferndown, close to all local amenities, New Forest, lots of nature reserves and Moors Valley country Park which is great for children, adults and dogs. The seaside town of Bournemouth with its sandy beaches and plenty of entertainment is only a short drive…
Radium is a charming ground-floor apartment just a few minutes from the seafront at Lyme Regis in Dorset. Forming part of an attractive conversion of a Grade II listed building, Radium is the ideal holiday destination for a small family or a couple. As soon as you step inside…
Resting just paces away from the hustle and bustle of the seaside town of Weymouth’s centre is this superb second-floor apartment, Harbour Hideaway. Situated just paces away from the stunning Old Harbour and slightly further to the golden sands of the beach, this apartment is…
This Grade II listed, former fisherman s cottage enjoys all the amenities Swanage has to offer right on its doorstep. It s within walking distance of the attractive Victorian pier, a lovely sandy beach, and small shops, bars and restaurants. It s not far to the Steam Railway,…
Crows Nest is a charming, reverse-level cottage settled into the seaside town of Fortuneswell, in Portland. With a close-by beach and shops, and pubs on the doorstep, this abode is an ideal base for a family or friends looking to explore the coast of Dorset. Be welcomed into a…
Three @ No36 is a beautifully-styled apartment in Weymouth, Dorset, boasting an excellent location with the beach on your doorstep. Boasting sea views, a Smart TV, and a dishwasher, this haven offers private, off-road parking for one car, making it an ideal escape for small…
Adjacent to the owners home yet offering a good degree of privacy, this cosy retreat for two is set within the heart of the village of Broadmayne. It is a great base for touring the array of attractions that are within easy reach, including Monkey World, The Tank Museum,…
Beauvoir Court Stables stands within the grounds of Beauvoir Court, a historic medieval barn conversion, once part of the ancient Cerne Abbey. With all of the accommodation on the ground floor, there is a well-appointed and light filled open-plan sitting room, dining area and a…
Nestling in the heart of the bustling town of Lyme Regis, Undercliff is a charming, semi-detached cottage which boasts traditional features but at the same time offers all the modern conveniences any discerning traveller would expect. The cottage is ideal for families thanks to…
Lovingly renovated, this delightful Victorian terraced house is tucked away in a quiet residential street in the centre of Weymouth and is only one mile from the beautiful award-winning beach, famous for its soft golden sands and shallow waters. The ground-floor offers a light…
This charming Grade II listed cottage celebrates its age and heritage with many character features including original beams and an inglenook fireplace for cosy evenings by the fire. Honeysuckle Cottage is the perfect base for exploring the many delights of this pretty part of…
This delightful holiday property is quietly tucked away in a peaceful location, not far from the picturesque town of Sherborne and conveniently located near many historic attractions. Nestled by a quiet country lane in the peaceful hamlet of Milborne Wick, this generous sized…
Situated in a quiet lane in the picturesque village of Corfe Castle, this property is just a three minute walk from the local bakery, post office, tearoom and pubs. Standing high on a hill, the castle is a historic focal point of the village and can be seen from the cottage. The…
Big fields, rolling countryside and the stunning Jurassic coast, rich with fossils, make Dorset a beautiful and fascinating place to visit. With abundant wildlife, ancient woodlands and the South West Coast Path National Trail running through, it's a great place for walkers and naturalists. Lots of historic houses and gardens to visit too.