Brickell Listings

Features
: Other
0
0
Property Description

EXCELLENT SINGLE FAMILY WITH 4 BEDROOMS, 3 BATHROOMS PLUS GARAGE CONVERTED INTO EFFICIENCY, PRIVATE AND SECURE COMMUNITY, NO ASSOCIATION, NEW ROOF, NEW AIR CONDITIONING, LARGE PATIO WITH FRUITS TREES, NEXT TO THE TRUNPIKE AND MAIN STREETS, DON’T MISS THIS OPPORTUNITY, MOTIVATED OWNER! SELLERS WOULD PREFER TO WORK ON THIS TRANSACTION WITH THE TITLE COMPANY **DREAMS TITLE SERVICES, INC**
MAKE YOUR APPOINTMENT TODAY!

Single Family Home For Sale MEADOW WOOD MANOR SEC 91,602 Sqft

25935 SW 123rd Ave, Homestead, Florida 33032

  • Bedrooms : 4
  • Bathrooms : 3
  • Square Footage: 1,602 Sqft
$595,000
Listing ID#A11546870
QR Code
Basic Details
Building Name : MEADOW WOOD MANOR SEC 9
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11546870
Price : $595,000
Original Price : $605,000
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 1,602 Sqft
Year Built : 1989
Property Sub Type : Single Family Residence
DOM : 14
Tax : $1,047
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