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;

90 Marthas Road
Edgartown, MA 02539

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,495,000
Beds: 5
Baths: 6
Status: Active
SqFt: --
Agency: Alisan Lohan-Conway Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Other
Year Built: 2024
Notes: KATAMA - NEW CONSTRUCTION - Minutes to South Beach, Edgartown Great Pond & Downtown Edgartown. This Superbly Appointed Custom Built Five (5) Bedroom, Six (6) Bath, (Five Full, 1 Half), Three (3) Story home, with a Two (2) car garage, presently Under Construction in a desirable location of Edgartown off Meeting House Way. Take a bike ride to South Beach, scoot over to Wilson’s Landing to launch your kayak, eat, take flight at Katama Airfield, drive to Vineyard Golf Club, grab lunch at Morning Glory Farm, drive to Downtown Edgartown to eat, shop, or play Tennis nearby. If you'd rather stay at home, this 5,050sq.ft. home with three finished floors, a tree lined back yard, 38' x 16' Gunite Pool, Bluestone patio, mahogany deck and outdoor shower will be an Entertainer’s delight! Elegant and Striking curb appeal with an abundance of living space. GROUND FLOOR: Luxurious living room with fireplace, architectural details and custom built-ins. Dining room with custom built-in drinks|butler's cabinet. Custom designed gourmet Kitchen with soapstone counters, a huge Carrara Marble clad island, Ceiling Height cabinets, and Thermador® Stainless Steel Appliances including a wine tower! Breakfast dining with French Doors leading directly to 30’ Mahogany Deck, onto Bluestone patio and straight into the Gunite pool. Sun room leading to Ground floor Bedroom Suite which has direct access to deck and pool. SECOND FLOOR: A second living room with fireplace, 1st laundry, two more Bedroom Suites with access to Balcony|Deck overlooking the pool. The Primary suite has its own private sitting room, full bathroom, laundry, wet bar and walk-in closet. A third bedroom shares guest bathroom with second living room. THIRD FLOOR: Fourth Bedroom suite with private bath and additional loft, lined with multiple closets. With three finished floors, there’s plenty of room for guests and plenty of space to get away from the guests! Situated on more than half an acre of manicured land, lots of space to have fun and create many memories. Central Air, Hardwood Floors, Custom tile, extensive trim package throughout. Large two Car Garage. Community Tennis Courts nearby. Seven (7) Bedroom Sewer Connection allows for additional bedrooms. Expansion possibilities. COMPLETION END OF MARCH 2024. PHOTOS - Exteriors are actual house - Interiors are of Similar Home and represent the finished product. Similar Home can be viewed. Furnishings not included but may be purchased for an additional price.
MlsNumber: 41453


Listing Provided By: Alisan Lohan-Conway Properties, original listing
Name: Alisan Lohan-Conway Properties
Phone: (508) 627-1858
Office Name: Alisan Lohan-Conway Properties
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