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<< Madrid Vacations<< Madrid Vacations<<

Madrid Apartment

‹ ›

Madrid Gran Via Apartment

2 Bedroom Madrid Apartment Sleeps 6
Rates: 120-100 EUR per night. Minimum Rental - 3 nights.

Amenities
Attractions
Rates
Reviews
Inquire

This totally renovated apartment has been tastefully decorated in a fun and modern Mediterranean style. Bright colours prevail in the small details of this space: lamps, pillows, curtains make this place special. Bright sun bathes the apartment in natural light streaming in from the balconied windows.
There are 2 bedrooms, 1 with a large double bed and 1 more with 2 single beds. The living/dining room has a sofa bed which sleeps 2, a table and chairs, TV, DVD and sound system. From the computer desk, take advantage of the free high speed ADSL WiFi internet connection. The small kitchen includes a washing machine, fridge, electric stove top, microwave and a full set of dishware. The bathroom comes with shower. Heat and air conditioning.

● 1 TVs

● Smoking Permitted

● Views

● Air - Conditioning

● Central Air

● Microwave

● Full Kitchen

● Iron

● Internet Access

● Linens Included

● Public Transportation Near

Gran Via 1	Gran Via 2
Queen Bed, 2-Twin Beds, Sleeper Sofa - Queen, Private Bath, TV, DVD.	2-Twin Beds, Sleeper Sofa - Queen, Sleeper Sofa - Twin, Private Bath, TV, DVD.

From 100 euros/night for 2 persons

Pricing for Apartment in Madrid Spain are quoted in EURO

Check in time Check with Owner
Check out time Check with Owner
Payment methods accepted:
Cancellation Policy: http://www.homesfortravellers.com/terms_conditions-en-124.htm
Deposit Required for Apartment : 30% OF THE TOTAL RENT

Write a Review

Madrid Spain Local Attractions

Very central, next to both metros Plaza de España and Santo Domingo (100m).The apartment is near all Madrid monuments and tourist places. Only 3 minutes walk to Gran Vía and Plaza España and 5 minutes to the Royal Palace and the Puerta del Sol, the epicentre of Madrid. Further along is the lovely Los Austrias neighbourhood with fantastic tapas bars in unexpected corners. Closer to home there are loads of restaurants, bars and pastry shops all with their specialties worth sampling. Also close to the apartment is the Opera, and just beyond the enormous Royal Palace and its surrounding park.

Madrid Local Attractions
Golf	Nearby	Restaurants	Nearby
Nightlife	Nearby	Museums	Nearby
Public Gardens	Nearby	Theaters	Nearby
Art Galleries	Nearby	Swimming	Nearby
Casino	Nearby

Madrid Gran Via Apartment is a Madrid Apartment in Madrid Spain

Madrid Cities:
Madrid

Madrid Apartment

Madrid Gran Via Apartment

2 Bedroom Madrid Apartment Sleeps 6 Rates: 120-100 EUR per night. Minimum Rental - 3 nights.

2 Bedroom Madrid Apartment Sleeps 6
Rates: 120-100 EUR per night. Minimum Rental - 3 nights.