Brickell Listings

Features
: Yes
: Unfurnished
0
0
Property Description

Updated 4 bedroom 3 bathroom home located on a large corner lot. This well maintained home is perfect for families or an investor. Great location close to Coral Gables, Miami international Airport, Expressways. This home will not last, call listing agent for showing appointment

Single Family Home Sold CHURCHILL ESTATES1,878 Sqft

261 NW 40th Ave, Miami, Florida 33126

  • Bedrooms : 4
  • Bathrooms : 3
  • Square Footage: 1,878 Sqft
$584,000
Listing ID#A11339526
QR Code
Basic Details
Building Name : CHURCHILL ESTATES
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11339526
Price : $599,000
Original Price : $599,000
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 1,878 Sqft
Year Built : 1946
Property Sub Type : Single Family Residence
DOM : 27
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