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

Warsaw Apartment

‹ ›

Nowy Swiat

1 Bedroom Warsaw Apartment Sleeps 3
Rates: 83-65 EUR per night. Minimum Rental - 2 nights.

Amenities
Attractions
Rates
Reviews
Inquire

spacious studio apartment in the city centre
living room/ sleeping area, kitchen, bathroom

● 1 TVs

● Views

● Washing Machine Only

● Hair Dryer

● Full Kitchen

● Iron

● Internet Access

● Linens Included

● Public Transportation Near

sat TV, radio/CD, telephone, internet, cooker, fridge, dishwasher, washing machine, kettle, coffee maker, iron, hair dryer

from 65 till 83 euro per night

Pricing for Apartment in Warsaw Poland are quoted in euro

Check in time 1 PM
Check out time 11 AM
Payment methods accepted:
Cancellation Policy:
Deposit Required for Apartment : yes

Write a Review

Warsaw Poland Local Attractions

city centre

Warsaw Local Attractions
Restaurants	Nearby	Nightlife	Nearby
Museums	Nearby	Castle	Nearby
Public Gardens	Nearby	Wineries	Nearby
Theaters	Nearby	Art Galleries	Nearby
Casino	Nearby

Nowy Swiat is a Warsaw Apartment in Mazowsze Poland

Mazowsze Cities:
Warsaw

Warsaw Apartment

Nowy Swiat

1 Bedroom Warsaw Apartment Sleeps 3 Rates: 83-65 EUR per night. Minimum Rental - 2 nights.

1 Bedroom Warsaw Apartment Sleeps 3
Rates: 83-65 EUR per night. Minimum Rental - 2 nights.