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.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<< Poland Vacations<< Mazowsze Vacations<< Warsaw Vacations<<

Warsaw Apartment

‹ ›

Old Town Square Apt

2 Bedroom Warsaw Apartment Sleeps 6
Rates: 145-90 EUR per night. Minimum Rental - 2 nights.

Amenities
Attractions
Rates
Calendar
Reviews
Inquire

composition: living room, 2 bedrooms (single/ double beds), kitchen, bathroom

● 1 TVs

● Washing Machine Only

● Hair Dryer

● Full Kitchen

● Iron

● Linens Included

● Public Transportation Near

cable TV, radio/CD, cooker, fridge, dishwasher, washing machine, kettle, coffee maker, iron, ironing board, hair dryer

from 90 till 145 euro per day

Pricing for Apartment in Warsaw Poland are quoted in euro

Check in time 1 PM
Check out time 11 AM
Payment methods accepted: Visa, Master Card, Cash.
Cancellation Policy:
Deposit Required for Apartment : yes

Property Availability Calendar

August 2017

Sun

Mon

Tue

Wed

Thu

Fri

Sat

September 2017

Sun

Mon

Tue

Wed

Thu

Fri

Sat

October 2017

Sun

Mon

Tue

Wed

Thu

Fri

Sat

November 2017

Sun

Mon

Tue

Wed

Thu

Fri

Sat

December 2017

Sun

Mon

Tue

Wed

Thu

Fri

Sat

January 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

February 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

March 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

April 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

May 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

June 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

July 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

Member Since:Jun 2008

Website Verified

Write a Review

Warsaw Poland Local Attractions

Old Town area

Warsaw Local Attractions
Restaurants	Nearby	Museums	Nearby
Castle	Nearby	Theaters	Nearby
Art Galleries	Nearby

Old Town Square Apt is a Warsaw Apartment in Mazowsze Poland

Mazowsze Cities:
Warsaw

Warsaw Apartment

Old Town Square Apt

2 Bedroom Warsaw Apartment Sleeps 6 Rates: 145-90 EUR per night. Minimum Rental - 2 nights.

Property Availability Calendar

2 Bedroom Warsaw Apartment Sleeps 6
Rates: 145-90 EUR per night. Minimum Rental - 2 nights.