Brickell Listings

Features
: Garden
: Unfurnished
2
2
Property Description

PACK YOUR SUITE CASE AND MOVE IN. INCREDIBLE PROPERTY LOCATED IN THE HIGHLY DESIRED COMMUNITY OF KEYS GATE NEAR THE PRESTIGIOUS KEYS GATE GOLF CLUB. PROPERTY OFFERS NEW FLOORS, NEW KITCHEN, NEW STAIR CASE, NEW BATHROOMS, FRESH INTERIOR/EXTERIOR PAINT JOB, NEW PLUMBING+ELECTRICITY, MAKING IT A FULLY MOVE IN READY DREAM. THIS HOME IS PERFECT FOR A FAMILY LOOKING FOR THEIR FOREVER HOME. IT’S ALSO AN INCREDIBLE OPPORTUNITY FOR INVESTORS LOOKING FOR A HIGH RETURN. EASY TO SHOW – TEXT LISTING AGENT.

Single Family Home Sold KEYS-GATE NO 11,988 Sqft

480 SE 25th Dr, Homestead, Florida 33033

  • Bedrooms : 3
  • Bathrooms : 3
  • Square Footage: 1,988 Sqft
$475,000
Listing ID#A11353605
QR Code
Basic Details
Building Name : KEYS-GATE NO 1
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11353605
Price : $475,000
Original Price : $475,000
Bedrooms : 3
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 1,988 Sqft
Year Built : 2002
Property Sub Type : Single Family Residence
Assoc Fee Frequency : Monthly
Association Fee : 399
DOM : 31
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