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)

North America Vacations<< USA Vacations<< Florida Vacations<< Miami Vacations<<

Miami Bal Harbour Condo

‹ ›

Bal Harbour Condo

1 Bedroom Miami Bal Harbour Condo Sleeps 3
Rates: 130-80 USD per night. Minimum Rental - 1 week.

Amenities
Attractions
Rates
Reviews
Inquire

Perfect location on Bay Harbour Island, steps away from prestigious Bal Harbour right near the well-known Bal Harbour shops, restaurants, a few blocks north of Miami Beach and easy access to Miami and Ft. Lauderdale. This property is on Bay Harbour Island a few blocks from the beach. It has the perfect location close to all the action in South Beach and the glamour of Bal Harbour, but apart from the traffic and noise. Unit has garden patio, all new kitchen and baths, walk in closet, washer and dryer, new appliances, flat screen TV with cable, stereo, fully furnished and equipped. Apartment is great for singles or couples. The location and area are fantastic with fashionable restaurants and shops along the palm tree lined Kane Concourse near Collins Avenue. The building has a heated pool and tropical garden area.

● 1 TVs

● Washer Dryer

● Air - Conditioning

● Central Air

● Internet Access

● Linens Included

2012 RATES
Nightly $79 to $129

Pricing for Bal Harbour Condo in Miami USA are quoted in USD

Check in time Check with Owner
Check out time Check with Owner
Payment methods accepted:
Cancellation Policy: Please contact us for Cancellation Policies
Deposit Required for Bal Harbour Condo : Please contact us regarding payment details

Write a Review

Miami USA Local Attractions

Miami Local Attractions
Horseback Riding	Nearby	Restaurants	Nearby
Nightlife	Nearby	Museums	Nearby
Sailing	Nearby	Beach	Nearby
Theaters	Nearby	Art Galleries	Nearby
Swimming	Nearby	Marina	Nearby

Bal Harbour Condo is a Miami Bal Harbour Condo in Florida USA

Miami Bal Harbour Condo

Bal Harbour Condo

1 Bedroom Miami Bal Harbour Condo Sleeps 3 Rates: 130-80 USD per night. Minimum Rental - 1 week.

1 Bedroom Miami Bal Harbour Condo Sleeps 3
Rates: 130-80 USD per night. Minimum Rental - 1 week.