Brickell Listings

Features
: Yes
: Unfurnished
1
1
Property Description

Excellent opportunity in Miami Gardens for investors or first time home buyer. Corner lot 2- story townhome with plenty of parking space. Home features 3 beds 1.5 baths and large fenced in patio with no back neighbors and is FHA/VA approved lot and block. Back patio open to large field perfect for play area for kids and pets. Lot size over 6,000 sq ft. Newly painted with new laminate vinyl flooring throughout. Conveniently located near shopping centers, restaurants and all major highways.

Condo For Sale at LESLIE ESTATES SEC SEVEN

2790 NW 196th St #., Miami Gardens, Florida 33056

  • Bedrooms : 3
  • Bathrooms : 2
  • Square Footage: 1,406 Sqft
$340,000
Listing ID#A11491054
QR Code
Basic Details
Building Name : LESLIE ESTATES SEC SEVEN
Property Type : Condo
Listing Type : Sold
Listing ID : A11491054
Price : $340,000
Original Price : $340,000
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 1,406 Sqft
Year Built : 1979
Property Sub Type : Townhouse
Assoc Fee Frequency : Monthly
Association Fee : 47
DOM : 23
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