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<< Italy Vacations<< Sardinia Vacations<< Santa Maria Navarrese Vacations<<

Santa Maria Navarrese Apartment

‹ ›

Santa Maria Navarrese Villa

2 Bedroom Santa Maria Navarrese Apartment Sleeps 6
Rates: 60-50 EUR per night. Minimum Rental - 1 week.

Amenities
Attractions
Rates
Reviews
Inquire

Santa Maria Navarrese, in apartment house at 200 mt. from the sea, consisting of kitchen with living room with sofa, 2 double bedrooms, bathroom, veranda dining outdoors, a barbecue, car park, really in an excellent position!

● 1 TVs

● Pet Friendly

● BBQ Grill

● Hair Dryer

● Full Kitchen

The house is close to the services of first necessity, such as banks, restaurants, supermarket, newsagents, and so on! The nearest beach, which lies about 200m from the house is the sandy beach of Tancau

Prices from Euro 350 per week.

Pricing for Apartment in Santa Maria Navarrese Italy are quoted in EUR

Check in time Check with Owner
Check out time Check with Owner
Payment methods accepted:
Cancellation Policy: Check with owner.
Deposit Required for Apartment : 30%

Write a Review

Santa Maria Navarrese Italy Local Attractions

Santa Maria Navarrese Villa is a Santa Maria Navarrese Apartment in Sardinia Italy

Santa Maria Navarrese Apartment

Santa Maria Navarrese Villa

2 Bedroom Santa Maria Navarrese Apartment Sleeps 6 Rates: 60-50 EUR per night. Minimum Rental - 1 week.

2 Bedroom Santa Maria Navarrese Apartment Sleeps 6
Rates: 60-50 EUR per night. Minimum Rental - 1 week.