Brickell Listings

Features
: Garden
: More Than 20 Lbs
0
0
Property Description

The house is tenant occupied until Feb 14th, 2025. This is a Legal 4bedrooms house, not like other in the area. 1673sqft total. Oversized master bedroom area with walk in closet. Located in a quiet area 5 min to Aventura, 10min to Sunny isles beaches. Walking distance to a beautiful canal with jogging path and playgrounds on the west and Historic Greynolds Park on the east side of the house. Stamped concrete driveway for 6 cars. Hurry, this house will be sold fast. Contact listing agent to make an appointment.

Single Family Home For Sale FULFORD BY THE SEA SEC U1,633 Sqft

1645 NE 175th St, North Miami Beach, Florida 33162

  • Bedrooms : 4
  • Bathrooms : 3
  • Square Footage: 1,633 Sqft
$559,000
Listing ID#A11419477
QR Code
Basic Details
Building Name : FULFORD BY THE SEA SEC U
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11419477
Price : $559,000
Original Price : $595,000
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 1,633 Sqft
Year Built : 1953
Property Sub Type : Single Family Residence
DOM : 226
Tax : $6,716
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