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)

South America Vacations<< Brazil Vacations<< Rio Grande do Norte Vacations<< Natal Vacations<<

Natal Studios, Apartements

‹ ›

1 Bedroom Natal Studios, Apartements Sleeps 3
Rates: - per night. Minimum Rental - 1 week.

Amenities
Attractions
Rates
Reviews
Inquire

I rent apartment in Natal, Beach of Ponta Negra, a suite with conditioned air, 2 beds, hall with sofa-bed, Kitchen equipped, microwaves, security box, security in Building 24 h, to 60 meters of the beach, TV by cable, swimming pool, totally furnished. We pick you in the airport.
Very near from party zone, discoteques, restaurants, etc.

Prices according to stay and season.

● 1 TVs

● Pet Friendly

● Smoking Permitted

● Views

● Shared Swimming Pool

● Gas Fireplace

● Air - Conditioning

● Central Air

● Microwave

● Full Kitchen

● Linens Included

● Resident Staff

● Maid Service Available

● Parking Available

● Public Transportation Near

● Seaside

Bedroom	Living Room
2-Twin Beds, Private Bath.	Sleeper Sofa - Queen, TV, DVD, VCR.

Price: 100 R$/día.

Pricing for Studios, Apartements in Natal Brazil are quoted in R$

Check in time Check with Owner
Check out time Check with Owner
Payment methods accepted:
Cancellation Policy:
Deposit Required for Studios, Apartements : Booking of 30 % of total.

Write a Review

Natal Brazil Local Attractions

Natal Local Attractions
Golf	Nearby	Restaurants	Nearby
Nightlife	Nearby	Sailing	Nearby
Beach	Nearby	Swimming	Nearby
Casino	Nearby

is a Natal Studios, Apartements in Rio Grande do Norte Brazil

Rio Grande do Norte Cities:
Natal

Natal Studios, Apartements

1 Bedroom Natal Studios, Apartements Sleeps 3 Rates: - per night. Minimum Rental - 1 week.

1 Bedroom Natal Studios, Apartements Sleeps 3
Rates: - per night. Minimum Rental - 1 week.