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.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<< Colombia Vacations<< Antioquia Vacations<< Medellin Vacations<<

Medellin Apartment

‹ ›

2 Bedroom Medellin Apartment Sleeps 3
Rates: - per night. Minimum Rental - 3 nights.

Amenities
Attractions
Rates
Calendar
Reviews
Inquire

Welcome to Medellin Vacation Apartments with excellent service, amenities, location, rates, guest reviews and frequent visitor rewards program.

For complete and current information, please visit our web site.
website:

http://www.medellinvacationapartments.com/

● 1 TVs

● Smoking Permitted

● Views

● Washer Dryer

● BBQ Grill

● Microwave

● Hair Dryer

● Full Kitchen

● Iron

● Gym Access

● Internet Access

● Linens Included

● Elevator

● Resident Staff

● Maid Service Available

● Parking Available

http://www.medellinvacationapartments.com/z_pages_english/rejuvenation_vacation.html

Pricing for Apartment in Medellin Colombia are quoted in USD

Check in time Check with Owner
Check out time Check with Owner
Payment methods accepted: American Express, Visa, Master Card, Paypal, Checks, Cash.
Cancellation Policy: http://www.medellinvacationapartments.com/z_pages_english/terms_conditions.html
Deposit Required for Apartment : US 98

Property Availability Calendar

August 2017

Sun

Mon

Tue

Wed

Thu

Fri

Sat

September 2017

Sun

Mon

Tue

Wed

Thu

Fri

Sat

October 2017

Sun

Mon

Tue

Wed

Thu

Fri

Sat

November 2017

Sun

Mon

Tue

Wed

Thu

Fri

Sat

December 2017

Sun

Mon

Tue

Wed

Thu

Fri

Sat

January 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

February 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

March 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

April 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

May 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

June 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

July 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

Member Since:Jun 2009

Website Verified

Write a Review

Medellin Colombia Local Attractions

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

is a Medellin Apartment in Antioquia Colombia

Antioquia Cities:
Medellin

Medellin Apartment

2 Bedroom Medellin Apartment Sleeps 3 Rates: - per night. Minimum Rental - 3 nights.

Property Availability Calendar

2 Bedroom Medellin Apartment Sleeps 3
Rates: - per night. Minimum Rental - 3 nights.