Brickell Listings

Features
: In Ground
: Garden
: Unfurnished , Furniture For Sale
2
2
Property Description

POOL HOME ON 1.25 ACRES WITH 3600 SQ FT UNDER ROOF N 26OO+ UNDER AIR. FANTASTIC CUSTOM FEATURES. OPEN FLOOR PLAN WITH MULTIPLE LIVING AREAS.. SHE’S A 3 /3 TRI SPLIT EVERY BEDROOM IS A SUITE! THE KITCHEN…A CHEFS DREAM.HUGE CENTER ISLAND/FARM SINK, INSTA-HOT H2O AT STOVE, COFFEE BAR, COMMERCIAL APPLIANCES, POURED CONCRETE COUNTERS GREAT VIEW OF POOL N LG LIVING AREA. OPENS TO LAUNDRY ROOM /LARGE PANTRY. EASY CONVERSION TO CABANA BATH #4. THE MAIN SUITE W/ SITTING OPENS TO OUTSIDE CABANA W 3 WALK IN CLOSETS, HAS AMAZING BATH W/ MAKEUP AREA.. THE GUEST RMS R UPDATED A WALL OF WINDOWS OVERLOOKS THE POOL, NEW ROOF 3 YRS , FULLY FENCED W PRIVACY GATES.. THIS IS A MUST SEE.. HAS DET.GARAGE. SELLER WILL CREDIT TOWARDS CLOSING COST FOR HEDGES OR ?.

Single Family Home Sold REDLAND 1.25 AC POOL HOME,REDLAND 1.25 AC2,615

29245 SW 197th Ave, Miami, Florida 33030

  • Bedrooms : 3
  • Bathrooms : 3
  • Square Footage: 2,615 Sqft
$830,000
Listing ID#A11329085
QR Code
Basic Details
Building Name : REDLAND 1.25 AC POOL HOME,REDLAND 1.25 AC
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11329085
Price : $845,000
Original Price : $849,000
Bedrooms : 3
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 2,615 Sqft
Year Built : 1970
Property Sub Type : Single Family Residence
DOM : 76
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