Brickell Listings

Features
: Other
: Restrictions Or Possible Restrictions
2
0
Property Description

Great 2 bedroom and 2 bathroom Mobile Home. Washer and Dryer included, as well as other Kitchen appliances. Central A/C is new. 2-car Carport plus Driveway and plenty of Guest Parking spaces just in front. House is in front of the community pool and mailbox areas. Covered terrace.
The current monthly lot fee includes community maintenance, garbage pickup, security 24-hr, clubhouse, pool, park playgrounds and other amenities at the family oriented and secure community of Royal Country. Close to the Turnpike and major highways, schools and shopping area. Excellent for investors.

Residential For Sale at 5352 Miami Gardens

5352 NW 199th Rd Lot 263, Miami Gardens, Florida 33055

  • Bedrooms : 2
  • Bathrooms : 2
$118,000
Listing ID#A11487923
QR Code
Basic Details
Building Name : ROYAL COUNTRY
Property Type : Residential
Listing Type : For Sale
Listing ID : A11487923
Price : $118,000
Original Price : $125,000
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Year Built : 1985
Property Sub Type : Mobile Home
Assoc Fee Frequency : Monthly
Association Fee : 750
DOM : 59
Tax : $0
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