SELECT vd.id, vd.tName, vd.tFolderName,vd.display_price, vd.tRef, loc.tName AS tLocationName,loc.id AS locId, vd.tCurrency,vd.tLinkKeywords, vd.tShortDescription2, vd.iCommission,CASE WHEN vd.iSleeps IN (0,1,2,3,4,5) THEN '5' WHEN vd.iSleeps IN (6,7) THEN '6' WHEN vd.iSleeps IN (8,9) THEN '8' WHEN vd.iSleeps IN (10,11) THEN '10' WHEN vd.iSleeps IN (12,13) THEN '12' WHEN vd.iSleeps IN (14) THEN '14' WHEN vd.iSleeps IN (15,16,17,18,19) THEN '19' WHEN vd.iSleeps IN (20,21,22,23,24) THEN '20' ELSE '25' END AS iSleeps, vd.bSwimmingPool, vd.bInternet, vd.bWifi, vd.bAirConditioning, vd.destination, MIN(rat.iRateGross) AS minRate, MAX(rat.iRateGross) AS maxRate ,ups.userId AS selection, ck.tshowme FROM villas_details AS vd LEFT JOIN locations AS loc ON (loc.id = vd.iLocation) LEFT JOIN locations_shortdesc AS ck ON (loc.id = ck.iLocation) LEFT JOIN villas_rates AS rat ON ( rat.iPropertyID = vd.id AND rat.iYear >= 2015) LEFT JOIN user_property_selection AS ups ON (ups.propId = vd.id AND ups.userId = '') LEFT JOIN villas_availability AS va ON (vd.id = va.iPropertyID) WHERE bPublished=1 AND rat.iRateGross <> 0 AND vd.destination = 'southern-scotland' GROUP BY vd.id ORDER BY vd.iSleeps ,maxRate, minRate asc LIMIT 0, 200
Find prestige accomodation for your holidays in the Southern Scotland and London
 
 
 
 
 

Exclusive vacation rentals in southern Scotland, UK

Tel: +44 (0)207 205 2000 Email: rentals@provence.emotional-escapes.com

   
Contact Us

London: +44 (0)207 205 2000

New York: +1 646 513 4224

Sydney: +61 (0)2 8520 3256

or

Email Us

  • Europe
  • United Kingdom
  • Southern Scotland
Sort By:

close

This month's featured properties

Bannockburn Castle
Edinburgh

• 12 bedrooms
• Historic buildings
• Landscaped grounds
• Wedding venue
• Private lake
• On-site staff

120 to 120 £/week
+ Click here for more details

Sleeps up to 5

George V Park Flat
Edinburgh

• 1 Double room
• In the centre of Edinburgh


POA

+ Click here for more details

Royal Mile Escape
Edinburgh

• 2 bedrooms
• In the centre of Edinburgh

POA

+ Click here for more details

Edinburgh Counting House Apartment 1
Edinburgh

• 2 bedrooms
• In the centre of Edinburgh

POA

+ Click here for more details

Arthur's Seat Apartment
Edinburgh

• 2 bedrooms
• Centre of Edinburgh

880 to 1720 £/week
+ Click here for more details

Sleeps 6

Covenanters Cottage
West Linton

• 3 bedrooms
• Panoramic views
• Near Edinburgh

680 to 960 £/week
+ Click here for more details

Garlieston Cottage
Wigtown

• 4 bedrooms
• Tailored grounds
• Heated pool

830 to 1640 £/week
+ Click here for more details

Sleeps 8

Queen Street Flat
Edinburgh

• 3 bedrooms
• In New Town, Edinburgh

POA

+ Click here for more details

The Shore Apartment
Edinburgh

• 3 bedrooms
• Near centre of Edinburgh

POA

+ Click here for more details

Sleeps 10

Reiver's Tower
Selkirk

• 5 bedrooms
• On-site property manager
• Historic building

Special offers available - see rates page!

2880 to 6930 £/week
+ Click here for more details

Sleeps 12

King James Tower
North Berwick

• 7 bedrooms / 6 bathrooms
• Landscaped grounds
• Panoramic views
• Historic building

POA

+ Click here for more details

Sleeps 14

Constance House
Edinburgh

• 6 bedrooms / 4 bathrooms
• Near Edinburgh
• Historic building

2270 to 3110 £/week
+ Click here for more details

Constance Lodge
Edinburgh

• 5 bedrooms / 5 bathrooms
• Historic building

2270 to 3110 £/week
+ Click here for more details

Sleeps 19

Bute Barn
Dunoon

• 5 bedrooms
• Indoor heated pool
• Sauna

2030 to 5030 £/week
+ Click here for more details

Benmore House
Dunoon

• 7 bedrooms
• Landscaped grounds
• Historic buildings
• Sauna
• Near the seaside

2030 to 3350 £/week
+ Click here for more details

Bute Mill
Dunoon

• 10 bedrooms
• Rural views
• Landscaped grounds
• Near the seaside

2630 to 6470 £/week
+ Click here for more details

Sleeps 20

Biggar House
Biggar

• 10 rooms / 9 bathrooms
• Tailored grounds
• Panoramic views
• Historic buildings


4795 to 7195 £/week
+ Click here for more details

Sleeps 25+

Bannockburn Castle
Edinburgh

• 12 bedrooms
• Historic buildings
• Landscaped grounds
• Wedding venue
• Private lake
• On-site staff

120 to 120 £/week
+ Click here for more details

Kyles of Bute House
Dunoon

• 14 bedrooms
• Air conditioning
• Landscaped grounds
• Heated indoor pool

4670 to 9710 £/week
+ Click here for more details