Brickell Listings

Features
: Garden
: Unfurnished
1
1
Property Description

NEW CONSTRUCTION OF 27 SINGLE FAMILY HOUSES IN A VERY CENTRAL AREA. 4 BEDROOMS, FULL BATHROOMS WITH ONE CAR GARAGE.
SOME CLOSING COST AVAILABLE WITH THE PREFERRED LENDER. CALL FOR INFOMATION

Single Family Home Sold LUXOR HOMES,LUXOR INVESTMENTS

24026 SW 116th Ct, Homestead, Florida 33032

  • Bedrooms : 4
  • Bathrooms : 2
$444,800
Listing ID#A11510116
QR Code
Basic Details
Building Name : LUXOR HOMES,LUXOR INVESTMENTS
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11510116
Price : $415,990
Original Price : $415,990
Bedrooms : 4
Bathrooms : 2
Half Bathrooms : 0
Year Built : 2024
Property Sub Type : Single Family Residence
Assoc Fee Frequency : Monthly
Association Fee : 50
DOM : 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