SELECT wp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_postmeta price_meta2 WHERE price_meta2.post_id=wp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-07-27:2026-07-27' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'accommodation_location_post_id' AND wp_postmeta.meta_value IN ('1328') )
) AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title ASC
![E1068F0x700](https://snite-booking.com/wp-content/uploads/2023/08/E1068F0x700-400x300.jpg)
From
€
A charming villa, on the Costa Adeje, in the Torviscas hills.
It has several large terraces and gardens, a BBQ area, 5 bedrooms plus a sofa bed for
a capacity up to 11 people, 3 bathrooms with shower and / or Jacuzzi, Wi-Fi, Swimming
pool with Fantastic Ocean and Sunset View!
Large living room, TV with satellite channels, free wifi and kitchen with electric hob,
oven, microwave, dishwasher, refrigerator and everything you need:
- toaster
- electric juicer
- kettle
- microwave oven
- coffee machine
- Towels, beach towels and sheets
- Hairdryer
- TV with satellite channels
- iron and ironing board
There are 1 bedrooms with a double bed and 4 bedrooms with 2 single beds.
It has a washing machine and a dishwasher.
Linen and towels included.
There is a golf course less than 3 km away and it is 5 km from 'Playa de Las Americas'
Flexible arrival and departure times, if possible (agreed in advance)
For check-in after 10.30 pm there is a supplement of 20 euros to be paid upon arrival.
For lost keys there is an extra 100 euros to change the lock.
It is best to rent a car to get around easily and reach beaches and supermarkets in just a few minutes, just 1.5 km away.
Taxis are cheap and there are good bus connections.
The villa is just 20 km from Tenerife South Airport and 2.5 km from the famous Siam Park.
![E1128F0x700](https://snite-booking.com/wp-content/uploads/2023/08/E1128F0x700-400x300.jpg)
From
€
Wonderful property in El Madroñal, a few minutes from the famous beaches of Costa
Adeje is close to all services.
Furnished with taste and elegance it is an oasis of peace in the heart of the south
Tenerife coast and 20 km from Tenerife South airport.
The property is very bright surrounded by a well-kept garden and terrace with
barbecue.
Private heated swimming pool with whirlpool and salad water measures 9 m x 4 m
,table tennis, barbecue.
There is a 1-car garage.
In Madroñal, just a few minutes from the famous beaches of Costa Adeje and
close to all services.
Located on two levels it has 3 bedrooms and 3 bathrooms for up to
7 people.
On the ground floor there is a large living room with bathroom and fully equipped
kitchen
including dishwasher, microwave, coffee maker, juicer,
kettle, oven and everything you need to cook.
TV with Sky premium in all languages and WiFi with optical fiber.
An internal staircase leads to the first floor where you will find the main bedroom with a
private bathroom complete with a bathtub
hydromassage. On the same floor there is another bathroom with shower and there are
2 double bedrooms, one with an extra single bed
Complete the alarm system property.
Including bed linen, towels and beach towels.
For check in after 22.30 there is a supplement of 25 euros to be paid
arrival.
For the loss of the keys there is a supplement of 100.00 euros for the change
lock.
In case of loss of the remote control, the amount charged will be € 60.00.
Available for every need and advice.
You can walk to several bars, small supermarket, restaurant,
greengrocer, hairdresser, veterinarian, butcher.
To go to the beach we recommend renting a car and in 2 km you can reach it
the Duque or Fañabe beach. At 800 m you will find
the Gransur shopping center with shops, restaurants and cinemas.
![E1001F29x700](https://snite-booking.com/wp-content/uploads/2023/08/E1001F29x700-400x300.jpg)
Luxury White Villa Sea View, Heated Pool
Costa adeje
From
€
Luxury White Villa Sea View, Heated Pool
ADEJE
Wonderful chalet in El Madroñal, just minutes from the famous beaches and close to all amenities.Located on two levels, 4 bedrooms,ping pong,A/C
-
![E1380F20x700](https://snite-booking.com/wp-content/uploads/2023/08/E1380F20x700-400x300.jpg)
MAJESTIC GOLF VILLA
MAJESTIC GOLF
From
€
Majestic Golf Villa
COSTA ADEJE
Majestic villa just a few metres from the golf course. Distributed over 2 levels, with 4 bedrooms and 4 bathrooms en suite, plus 1 toilet on the groun
![E1133F36x700](https://snite-booking.com/wp-content/uploads/2023/08/E1133F36x700-400x300.jpg)
From
€
Wonderful property in El Madroñal, a few minutes from the famous beaches of Costa Adeje and close to all the services
of El Madroñal.
Furnished with taste and elegance, it is an oasis of peace in the heart of southern Tenerife, just 20 km from Tenerife
South airport.
The property is very bright and with a sea view from almost all the windows,
Located on two levels it has 4 bedrooms and 4 bathrooms with capacity for up to 10 people, wifi, heated swimming pool
and beautiful gardens.
On the main floor there are:
- well equipped kitchen with dishwasher, microwave, oven, refrigerator, freezer, ceramic and everything you need for to
cook
- main bathroom with shower
- Double bedroom
- main living room with sea view
- dining room overlooking the patio with beautiful gardens, fruit trees and ocean views
- outdoor dining area
- barbecue
- heated swimming pool with sun beds
The upper level has:
- double bedroom with private bathroom with tub and shower and large balcony overlooking the sea
- bedroom with 2 single beds, private bathroom and large terrace.
An internal staircase leads to the underground floor where there are:
- Secondary living room with 2 double sofa beds and bathroom.
- garage for one car.
- PLAYSTATION
Includes sheets, towels and beach towels.
Unfortunately no tours were found.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.