Brickell Listings

Features
: Other
: Unfurnished
0
0
Property Description

SEE BROKER REMARKS……….Opportunity knock this is a great investment at the price reflected ,this property has a large lot with entry for side for borth sides to parking your boat or RV,room for pool, three bedroom, two bath wiht easuy access to FLorida Turnpike.

Single Family Home Sold AVOCADO MANOR1,502 Sqft

15400 SW 295th St, Homestead, Florida 33033

  • Bedrooms : 3
  • Bathrooms : 2
  • Square Footage: 1,502 Sqft
$399,900
Listing ID#A11454545
QR Code
Basic Details
Building Name : AVOCADO MANOR
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11454545
Price : $399,900
Original Price : $399,900
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,502 Sqft
Year Built : 1969
Property Sub Type : Single Family Residence
Assoc Fee Frequency : Monthly
Association Fee : 0
DOM : 12
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