Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3230 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3230 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3230 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

Foreclosure: 1185 Bayshore Drive
Englewood, FL 34223
Joseph Ciarla with ANYTIME REALTY LLC, original listing - (941) 730-1247

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,500,000
Beds: 8
Baths: Full: 6, ½: 1
Status: Active
SqFt: 11365 Square Feet
Agency: ANYTIME REALTY LLC
Agency Phone: (941) 730-1247

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: 170 feet of Lemon Bay frontage! If there was one word to describe this beauty it would be Unique! WOW, here is your rare opportunity to own your own slice of paradise. This custom estate offers 2.26 acres of land with 11,365 SqFt of indoor living space, making it one of the largest homes and largest lots on the waterfront side of this street! This stunning 2 story mansion offers 8 bedrooms, 6.5 bathrooms with an In-Law Suite. As you drive through the double gate entry and along the winding path up to the home, you drive past your own private Tennis/Basketball court and private pond/lagoon abundant with ducks and many more wildlife. As you pull up to the front, you are greeted with a circular driveway up to the glass-paneled foyer. Let me not forget to mention that if you've got cars, this place has all the space you'll need with an 8 car garage on the right side. Step inside and be amazed! Ahead of you is the dramatically ornate spiral staircase that leads to the upstairs and to the right of you is the Laundry room, one of the many bathrooms and the In-Law Suite that includes its own Kitchen, Living area, 2 bedrooms and it's own personal laundry room. Take a left and you are standing in the Formal Dining area, walk a little further and you step down into the expansive, regal Kitchen. Floor to ceiling glass windows line the left wall with the Kitchen to your right that offers granite stone countertops and executive-style cabinetry and stainless steel appliances. "Bungalow" wood paneling for the ceiling brings a tropical resort-style type of vibe. Wrapped around behind the Kitchen is a Game Room and a step-down, built-in Living Room with a fireplace. Back here is also another bedroom, bathroom and secondary spacious Living area. Keep walking along the backside of the property to the right side, behind the staircase and you will find the grandiose Primary Suite fit for a King! This suite provides ample amounts of space as it has enough room for a whole sectional sofa! Elegant is an understatement with a platform area for the bed and breathtaking bathroom that features a built-in tub smack dab in the center, his and hers sink nook, his and hers toilets and walk-in shower with 2 entrances. Let's not forget the humongous walk-in closet with tons of built-in drawers and shelves. Let's make our way on up the spiral staircase where the rest of the 4 bedrooms and 3 bathrooms are. Up here is more Living space, another fireplace with a cathedral, wood-paneled ceiling, another Game Room and Kids loft with peek-a-boo flooring to the Kitchen. Step outside on the catwalk-balcony for those spectacular Bay views that overlook the large swimming pool. Go fishing from your own wooded walking path that jets out into the Bay. This is luxury, don't let this scarcely-seen opportunity pass you by, show it today!
MlsNumber: --
ListingId: C7496411


Listing Provided By: ANYTIME REALTY LLC, original listing
Phone: (941) 730-1247
Office Phone: (941) 730-1247
Agent Name: Joseph Ciarla
Disclaimer: Copyright © 2024 Stellar MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3230 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for CARRI D. METZGER
CARRI D. METZGER
ASCIITHE METZGER GROUP POWERED BY COLDWELL BANKER VENICE
Call Today!: (941) 777-0774

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App