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<< Andalucia Vacations<< Mijas Vacations<<

Mijas Golf Villas

‹ ›

Residencial el Hipodromo Townhouse

2 Bedroom Mijas Golf Villas Sleeps 4
Rates: 40-30 EUR per night. Minimum Rental - monthly.

Amenities
Attractions
Rates
Reviews
Inquire

Townhouse 2 Bedrooms:
- 800 Euros per month unfurnished.
- 1050 Euros per month furnished.
Magnificent townhouse in the heart of the Costa del Sol, situated in Residencial el Hipodromo, next to the Costa del Sol Hippodrome, El Chaparral Golf Course and only five minutes from the beach. Five minutes from Fuengirola and 10 from Marbella. Area of great natural beauty. The house has a private parking space, 110 m2 built, alarm system, large living room with fireplace, private garden with jacuzzi, two bedrooms, built in wardrobes, fully fitted and equipped kitchen, security door. Closed in urbanization with security check point at the entrance, two swimming pools, two padel tennis courts, communal gardens, sauna and a water feature throughout the urbanization. For further information please contact Francisco on 0034-696246597.

● 0 TVs

● Smoking Permitted

● Jacuzzi - Outside

● Hot Tub

● Shared Swimming Pool

● Washing Machine Only

● Air - Conditioning

● Full Kitchen

● Linens Included

● Maid Service Available

● Parking Available

Mijas Spain Local Attractions

Mijas Local Attractions
Golf	Under 1 Mile	Horseback Riding	Under 1 Mile
Restaurants	1-5 Miles	Nightlife	1-5 Miles
Museums	5-10 Miles	Deep Sea Fishing	1-5 Miles
Fishing - Other	1-5 Miles	Sailing	1-5 Miles
Boating	1-5 Miles	Castle	1-5 Miles
Race Track-Horse	Under 1 Mile	Beach	1-5 Miles
Theaters	10-20 Miles	Casino	5-10 Miles
Marina	1-5 Miles

Townhouse 2 Bedrooms:
- 800 Euros per month unfurnished.
- 1050 Euros per month furnished.

Pricing for Golf Villas in Mijas Spain are quoted in euros

Check in time Check with Owner
Check out time Check with Owner
Payment methods accepted:
Cancellation Policy:
Deposit Required for Golf Villas :

Write a Review

Residencial el Hipodromo Townhouse is a Mijas Golf Villas in Andalucia Spain

Mijas Golf Villas

Residencial el Hipodromo Townhouse

2 Bedroom Mijas Golf Villas Sleeps 4 Rates: 40-30 EUR per night. Minimum Rental - monthly.

2 Bedroom Mijas Golf Villas Sleeps 4
Rates: 40-30 EUR per night. Minimum Rental - monthly.