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','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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','txhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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','txhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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;

239 Bahia Vista Drive
Englewood, FL 34223

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,450,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2444
Agency: Tall Pines Realty, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1966
Notes: Welcome to 239 Bahia Vista Drive, located at the end of a privately maintained road, where you will find a gated Bayfront oasis situated directly on picturesque Lemon Bay. There is a deep channel that runs down the side of the property with protected dockage on the 3rd side for a total of 436 ft of water frontage which makes it a truly unique offering. When you pull into the circular paver driveway, you will enjoy parking in the detached 2 car garage with half bath. The breezeway has entrance points from the garage and the front side walk. Upon entering the home, you will be greeted by views of Lemon Bay. The open feel of the living space is highlighted by a fireplace, wall niches, recessed lighting and tropical colors. The kitchen has the same amazing view of the water. Other kitchen features you will appreciate include solid wood cabinets, solid surface counter tops, a glass window pass through to the Florida room, appliance garage,built in lighting and a generous sized pantry, just to name a few. You will be spending a lot of time in the Florida Room which gives you a front row seat to the water views. A wet bar is built in for convenience when hosting family and friends. A set of large sliding glass doors give you multiple points of entry to the caged in ground pool and deck area. An added bonus is the tiki hut located right on the point. There isn't a better place in Englewood to watch our world famous sunsets, the dolphins at play or the fireworks on the fourth of July. The large master bedroom suite has a door leading in from both the living room and the Florida Room. Another amazing view of the water greets you when entering. There is an additional area attached that can be a den, office, lounging area, or workout space. The walk-in closet has room for all your clothing, beachwear, shoes and accessories. The master bathroom has a relaxing sunken, jetted tub, walk in shower, private toilet area as well as double vanities. Off the living room, you will find a full second bathroom for guests. A hallway brings you to two more bedrooms and the laundry area. Offered furnished, this special home is waiting for you to move right in!
MlsNumber: D6136259


Listing Provided By: Tall Pines Realty, Inc., original listing
Name: Tall Pines Realty, Inc.
Phone: (941) 475-5015
Office Name: TALL PINES REALTY
Office Phone: (941) 475-5015
Agent Name: Joe McCarthy
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','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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 Roxana Dumitrascuta
Roxana Dumitrascuta
ASCIIeXp Reality, LLC
Call Today!: (941) 928-7332

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App