Brickell Listings

Features
: Other
: Unfurnished
0
0
Property Description

GREAT 3 BEDROOMS 2 BATHS HOME IN A GREAT LOCATION. HOME IS TENANT OCCUPIED. PLEASE DO NOT WALK AROUND OR DISTURB TENTANT.

Single Family Home Sold 10TH ADDN TO RICHMOND HEI1,200 Sqft

14112 SW 110th Ave, Miami, Florida 33176

  • Bedrooms : 3
  • Bathrooms : 2
  • Square Footage: 1,200 Sqft
$395,000
Listing ID#A11405406
QR Code
Basic Details
Building Name : 10TH ADDN TO RICHMOND HEI
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11405406
Price : $399,900
Original Price : $399,900
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,200 Sqft
Year Built : 1976
Property Sub Type : Single Family Residence
DOM : 44
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