Brickell Listings

Features
: Fenced
: Pool
2
2
Property Description

Pinecrest Elementary School district! In a quiet, upscale neighborhood in highly sought North Pinecrest area. Marble floors throughout and hardwood floors in all bedrooms with updated bathrooms and kitchen. Beautiful canopy of trees provide ample shade to large backyard with swimming pool in a private setting. Living area = 1,804 Adjusted area = 2,044 *** See Broker Remarks for Showing Instructions ***

Single Family Home For Sale HILLMONT

9840 SW 73rd Ave, Pinecrest, Florida 33156

  • Bedrooms : 3
  • Bathrooms : 2
$1,749,800
Listing ID#A11566697
QR Code
Basic Details
Building Name : HILLMONT
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11566697
Price : $1,749,800
Original Price : $1,749,900
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 0
Year Built : 1960
Property Sub Type : Single Family Residence
DOM : 13
Tax : $15,443
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