Your name:	*
And email:	*
Telephone:
Arrival:
# nights:
# Adults:		#Children:
Additional comments:

Message:

SELECT CityID, MinimumNightlyRentalTypes.Name AS MinimumNightlyRental, PropertyTypes.Name as Type, Users.FirstName, Users.LastName, Users.PrimaryTelephone, Users.Country AS OwnerCountry, Users.Email, Users.Username, Users.Address AS OwnerAddress, Users.EveningTelephone, Users.DaytimeTelephone, Users.MobileTelephone, Users.Website, Users.City AS OwnerCity, Users.State AS OwnerState, Users.Zip AS OwnerZip, Users.Registered, Users.IfPayTravelAgents, Users.DateCreated, Cities.City, StateProvinces.StateProvince, Countries.Country, Regions.Region, CASE WHEN EXISTS (SELECT * FROM PropertiesAmenities INNER JOIN Amenities ON PropertiesAmenities.AmenityID = Amenities.ID WHERE (PropertiesAmenities.PropertyID = Properties.ID) AND (Amenities.Amenity = 'Smoking Permitted')) THEN 'Yes' ELSE 'No' END AS Smoking, CASE WHEN EXISTS (SELECT * FROM PropertiesAmenities INNER JOIN Amenities ON PropertiesAmenities.AmenityID = Amenities.ID WHERE (PropertiesAmenities.PropertyID = Properties.ID) AND (Amenities.Amenity = 'Pet Friendly')) THEN 'Yes' ELSE 'No' END AS PetFriendly, Properties.ID, Properties.UserID, Properties.Name, Properties.TypeID, Properties.Address, Properties.CityID, Properties.IfShowAddress, Properties.PaymentMethod ,Properties.NumBedrooms, Properties.NumBaths, Properties.NumSleeps,Properties.MinNightRate,Properties.HiNightRate,Properties.MinRateCurrency,Properties.Name2, Properties.MinimumNightlyRentalID, Properties.NumTVs, Properties.NumVCRs, Properties.NumCDPlayers, Properties.Description, Properties.Amenities, Properties.LocalAttractions, Properties.Rates, Properties.CancellationPolicy, Properties.DepositRequired, Properties.IfMoreThan7PhotosAllowed, Properties.IfFinished, Properties.IfApproved, CASE WHEN EXISTS (SELECT * FROM Invoices WHERE (Invoices.PropertyID = Properties.ID) AND (PaymentAmount >= InvoiceAmount) AND (GETDATE() <= RenewalDate)) THEN 1 ELSE 0 END AS IfPaid, Properties.DateAdded, Properties.DateStartViewed, Properties.VirtualTour, Properties.RatesTable, Properties.PricesCurrency, Properties.CheckIn, Properties.CheckOut, Properties.LodgingTax, Properties.TaxIncluded, Properties.DateAvailable, Properties.IfDiscounted, Properties.IfLastMinuteCancellations, Properties.LastMinuteComments, Properties.HomeExchangeCityID1, Properties.HomeExchangeCityID2, Properties.HomeExchangeCityID3, Properties.HomeExchangeComments FROM Properties INNER JOIN Cities ON Properties.CityID = Cities.ID INNER JOIN StateProvinces ON StateProvinces.ID = Cities.StateProvinceID INNER JOIN Countries ON StateProvinces.CountryID = Countries.ID INNER JOIN Regions ON Countries.RegionID = Regions.ID INNER JOIN Users ON Properties.UserID = Users.ID LEFT OUTER JOIN MinimumNightlyRentalTypes ON Properties.MinimumNightlyRentalID = MinimumNightlyRentalTypes.ID LEFT OUTER JOIN PropertyTypes ON Properties.TypeID = PropertyTypes.ID LEFT JOIN PropertyCategories ON PropertyCategories.ID=PropertyTypes.Category WHERE (Properties.ID = @PropertyID)

Europe Vacations<< Spain Vacations<< Murcia Vacations<< Mazarron Vacations<<

Mazarron Holiday House with private pool

‹ ›

Camposol Golf complex Holiday House

2 Bedroom Mazarron Holiday House with private pool Sleeps 6
Rates: 40-25 GBP per night. Minimum Rental - 1 week.

Amenities
Attractions
Rates
Reviews
Inquire

Villa sleeping up to 6 persons Fully furnished to a high standard (including linen) Oven, hob, fridge freezer, microwave, washing machine Living room containing a double sofa bed, TV & CD player Dining room with seating for 6 Bedroom containing one double bed Bedroom containing 2 single beds Bath & shower with instant hot water Front Terrace with garden furniture and rear enclosed courtyard Cots & Highchairs available at no extra cost No pets allowed Non smokers only Heating Small splash pool Ceiling fans in both bedrooms and lounge/diner Access to communal pool (seasonal - with small entrance fee) with adults and children's pool and snack bar

● 1 TVs

● Shared Swimming Pool

● Washing Machine Only

● Microwave

● Hair Dryer

● Full Kitchen

● Iron

● Linens Included

● Parking Available

1st Bedroom	2nd Bedroom	Living Area
Double Bed.	2-Twin Beds.	Sleeper Sofa - Queen.

18 hole golf course (9 holes open) and driving range, International golf hotel and golf club Fantastic views, flamenco evenings, dancing and dinners at golf club Communal swimming pool with bar and children's pool (small local charge) Shops, bars, restaurants (including Marianna's with superb menu del dia for 10 euros) Indian, Spanish and Chinese restaurant on site Thermal and tropical pool at the golf hotel (fed by natural springs 500 metres due to open in the future) Various food and craft markets locally on different days Natural mud baths (local), Espuna National Park Puerto de Mazarron & many beaches (within a 15 minute drive) Murica and Alicante airport (50 mins and 1 hour 10 mins) serviced by low cost airlines (transfers can be arranged, although we consider a car is essential for this holiday) Ten pin bowling alley and pool hall

£175 to £275 per villa per week
Peak season is June to September

Pricing for Holiday House with private pool in Mazarron Spain are quoted in GBP

Check in time 4 PM
Check out time 12 PM
Payment methods accepted:
Cancellation Policy:
Deposit Required for Holiday House with private pool : £150

Write a Review

Mazarron Spain Local Attractions

Site seeing, Sierra Espuna National Parl, Habour of Cartagena, beaches all within 15 minutes

Mazarron Local Attractions
Golf	1-5 Miles	Restaurants	1-5 Miles
Beach	5-10 Miles

Camposol Golf complex Holiday House is a Mazarron Holiday House with private pool in Murcia Spain

Mazarron Holiday House with private pool

Camposol Golf complex Holiday House

2 Bedroom Mazarron Holiday House with private pool Sleeps 6 Rates: 40-25 GBP per night. Minimum Rental - 1 week.

2 Bedroom Mazarron Holiday House with private pool Sleeps 6
Rates: 40-25 GBP per night. Minimum Rental - 1 week.