Brickell Listings

Features
: Yes
0
0
Property Description

BUYER INCENTIVE, RECEIVE $7,500.00 TOWARD PURCHASE OF THIS HOME. And enjoy the summer breeze in this lovely three bedroom, two bath home with ceramic tile and vine wooden flooring, high impact window and doors, roof one year old, central air and heat, dishwasher, exterior nicely painted and interior well maintained. Convenient location, two miles from Miami Marina, Coral Gables shopping. Easy to show. Call listing agent.

Single Family Home For Sale MACFARLANE HOMESTEAD1,287 Sqft

3794 Florida Ave, Miami, Florida 33133

  • Bedrooms : 3
  • Bathrooms : 2
  • Square Footage: 1,287 Sqft
$810,000
Listing ID#A11408894
QR Code
Basic Details
Building Name : MACFARLANE HOMESTEAD
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11408894
Price : $810,000
Original Price : $810,000
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,287 Sqft
Year Built : 1993
Property Sub Type : Single Family Residence
DOM : 278
Tax : $2,407
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