Brickell Listings

Features
: Restrictions Or Possible Restrictions
0
0
Property Description

Luxurious 2 Bedroom and 1.5 Bathroom apartment in the heart of the sought area of Kendall! This beauty features an completely updated kitchen with granite countertops, stainless steel appliances, and cabinets. The bathroom is fully updated as well as tile through out the unit! Also, this unit features two spacious bedroom along with a balcony with great view! The community also offers a great laundry facility, elevator, along with a community pool as well. Close to schools, highways, restaurants, and supermarkets.

Condo For Sale at EL CONQUISTADOR SOUTH CON

14155 SW 87th St #E408, Miami, Florida 33183

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 890 Sqft
$250,000
Listing ID#A11542396
QR Code
Basic Details
Subdivision : 14155 SW 87th
Building Name : EL CONQUISTADOR SOUTH CON
Property Type : Condo
Listing Type : For Sale
Listing ID : A11542396
Price : $250,000
Original Price : $250,000
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 890 Sqft
Year Built : 1973
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 398
DOM : 46
Tax : $2,366
Search Results

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 1' at line 1]
SELECT `id` FROM `wp_wpl_properties` AS p WHERE 1 AND `listing` = '9' AND `property_type` = '36' AND ( MATCH( `textsearch` ) AGAINST ( '(+"LOC-33131") "Listing ID 33131"' IN BOOLEAN MODE ) ) AND `show_address`='1' AND `f_140`='1' AND (`f_140_options` LIKE '%,1,%' OR `f_140_options` LIKE '%,3,%' OR `f_140_options` LIKE '%,4,%' OR `f_140_options` LIKE '%,5,%' OR `f_140_options` LIKE '%,6,%' OR `f_140_options` LIKE '%,7,%' OR `f_140_options` LIKE '%,8,%' OR `f_140_options` LIKE '%,9,%' OR `f_140_options` LIKE '%,10,%') AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY p.price_si DESC , p.id ASC LIMIT , 1

Agent info
Brickellmania LLC
3011 SW 24 ST. Miami Fl 33145
Contact Agent