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<< Latvia Vacations<< Rigas Vacations<< Riga Vacations<<

Riga Self Catering Apartment

‹ ›

Riga Apt

1 Bedroom Riga Self Catering Apartment Sleeps 4
Rates: 85-50 EUR per night. Minimum Rental - 2 nights.

Amenities
Attractions
Rates
Reviews
Inquire

Furnished and renovated 2-rooms apartment on the 2nd floor. There is a bedroom with double bed, living room with big corner sofa, cable TV. Built-in kitchen, washing-machine. There are shower cabin and toilet in the bathroom. Clean staircase and closed street door. Entrance is through the yard. Convenient location in the town: close to Old Town, Arena Riga (www.arenariga.lv), night clubs, sightseeing and shopping area.

● 1 TVs

● Smoking Permitted

● Iron

● Linens Included

● Maid Service Available

Bedroom	Living room
Double Bed.	Sleeper Sofa - Twin, TV, DVD.

Meduim season (11.01-19.12): 50-65 Euro/night
High season (20.12-10.01): 70-85 Euro/night

Prices depends on number of people and term of stay.
Refundable deposit against damages - 50 Euro / 35 Ls
Daily cleaning fee - 15 Euro / 11Ls / day

Pricing for Self Catering Apartment in Riga Latvia are quoted in Euro

Check in time Check with Owner
Check out time 1 PM
Payment methods accepted:
Cancellation Policy:
Deposit Required for Self Catering Apartment : Euro 50-100

Write a Review

Riga Latvia Local Attractions

Riga is a very bright town full of cafes, bars opened until late, restaurants, pubs and discos. During summer Dome Square becomes the place for meetings and for amusement, with tables and chairs. Nights are animated like London, Paris and Amsterdam.
There are a lot of public locals where amusement is the key word.

Riga Local Attractions
Restaurants	Nearby	Nightlife	Nearby
Museums	Nearby	Public Gardens	Nearby
Theaters	Nearby	Art Galleries	Nearby
Casino	Nearby

Riga Apt is a Riga Self Catering Apartment in Rigas Latvia

Rigas Cities:
Riga

Riga Self Catering Apartment

Riga Apt

1 Bedroom Riga Self Catering Apartment Sleeps 4 Rates: 85-50 EUR per night. Minimum Rental - 2 nights.

1 Bedroom Riga Self Catering Apartment Sleeps 4
Rates: 85-50 EUR per night. Minimum Rental - 2 nights.