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

0 Eastville Avenue
Oak Bluffs, MA 02557
Alisan Lohan-Conway with Alisan Lohan-Conway Properties, original listing - (508) 696-8457

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,400,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Alisan Lohan-Conway Properties
Agency Phone: (508) 696-8457

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Land-Unimproved Land
Year Built: --
Notes: EXISTING FIVE (5) LOT SUBDIVISION IN OAK BLUFFS. Almost 5 Acres of wooded, level land within half a mile of Eastville Beach, Doug's Cove Preserve (4.6 acres of Land Bank Property) and less than a mile to Oak Bluffs Harbor. NEW Shared Use Path runs along Eastville Avenue, when finished will link Vineyard Haven and Oak Bluffs for walking and cycling. Septic permits in place for two lots. Lot #1 - 147.2 (45,782sq.ft.) Permit in place for an APPROVED 6 Bedroom Septic System; Lot #2 - 147.3 - (31,320sq.ft.) 6 Bedroom Septic System Designed and submitted, NOT YET approved; Lot #3 - 147.4 - (34,824sq.ft.) 6 Bedroom Septic System Designed and submitted, NOT YET approved; Lot #4 - (52,451sq.ft.) 6 Bedroom Septic System Designed, NOT YET submitted; Lot #5 - (45,074sq.ft.) - Permit in place, APPROVED for a 4 Bedroom Septic System. Lot # 5 - May have access directly from Wapello Street. Ten (10) Bedrooms have been approved. Applications for an additional Twelve (12) Bedrooms are in process. Lot#2 - Application for 6 bedrooms. Lot#3 - Application for 6 Bedrooms. Lot #4 is undetermined at this point. Access may be allowed via Sunset Road or Eastville Avenue. Water is available via Sunset Road, at the property. Electricity is on site. Buyer is responsible for verifying any and all information on this property.
MlsNumber: --
ListingId: 40762


Listing Provided By: Alisan Lohan-Conway Properties, original listing
Phone: (508) 627-1858
Office Phone: (508) 696-8457
Agent Name: Alisan Lohan-Conway
Disclaimer: Copyright © 2024 LINK Martha’s Vineyard. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App