Brickell Listings

Features
: Garden
: Unfurnished
0
0
Property Description

IMPRESSIVE MIAMI GARDENS HOME WITH 3 BEDS/2 BATHS~ BRAND NEW ROOF, IMPACT WINDOWS, OPEN AND BRIGHT LAYOUT, WITH A CONTEMPORARY KITCHEN W/QUARTZ C.TOPS. THIS HOME ADORNED WITH STUNNING TILE THROUGHOUT, MODERN BATHROOMS, UTILITY ROOM, AND A SPACIOUS YARD WITH ROOM FOR A POOL AND MORE. DON’T MISS OUT ON THIS MUST-SEE BEAUTY AND MAKE THIS YOUR NEW HOME! 3K APPLIANCE CREDIT AT CLOSING OR SELLER TO INSTALL BRAND NEW KITCHEN APPLIANCES AT CLOSING.

Single Family Home Sold STONEYBROOK ESTATES1,223 Sqft

17910 NW 25th Ct, Miami Gardens, Florida 33056

  • Bedrooms : 3
  • Bathrooms : 2
  • Square Footage: 1,223 Sqft
$524,999
Listing ID#A11498578
QR Code
Basic Details
Building Name : STONEYBROOK ESTATES
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11498578
Price : $524,999
Original Price : $524,999
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,223 Sqft
Year Built : 1957
Property Sub Type : Single Family Residence
DOM : 24
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