CONNECT
Connect
With Us
Our Offices
Bridgehampton Office 631.537.3200
East Hampton Office 631.324.8080
East Hampton Annex 631.324.8080
Greenport Office 631.477.5990
Mattituck Office 631.298.0600
Montauk Office 631.668.0500
Southampton Office 631.283.5800
Westhampton Office 631.288.3030
Get In Touch

Main Content

SPECTACULAR SOUNDFRONT

$1,995,000
Web # 45538 Sold
  • Greenport
  • 8 Bedrooms
  • 6.5 Bathrooms
  • 2.71 Acres
Garden House Is Designed For Families & Friends To Gather And Play! 8 Bedrooms, 6.5 Baths All Accessing Courtyards, Gardens And Patios. Large Central Room With Open Floor Plan, Great Room, Kitchen, Dining Room, Hot Tub Room, Fire Pit & Tennis Court .Waterfront Private Setting With Tennis Court & Ultra Private Beach! 3 Car Garage With Unfinished 2nd Floor!

Location

Get In Touch

You May Also Like

SELECT ID, post_status, post_type, post_title, post_content, raw_info, listing_info, api_type, api_class, rets_prop_type, rets_prop_status, out_prop_type, out_prop_status, api_prop_features, open_house, list_price, rental_price, sold_price, state, city, zip_code, mls_number, bedrooms, house_size, property_size, bathrooms, full_address, street_name, broker, listing_key, listing_agent_key, colisting_agent_key1, colisting_agent_key2, full_street_address, SaleOrRent, RentAmtAugLaborDay, RentAmtJulyAug, RentAmtJuly, RentAmtJune, RentAmtMemLaborDay, RentAmtOffSeason, RentAmtYearRoundMonthly, RentAmtjun_jul, RentAmtsht_term, last_modified, date_added FROM tbl_api WHERE ( out_prop_status != 'sold' ) AND ( out_prop_status != 'off-the-market' ) AND ( out_prop_status != 'sold' ) AND ( ) AND mls_number NOT IN (333909,34159,341317,341255,38562,32933,38493,2987309,3095178,3121374,3055599,3114706,3076311,3066474,3121376,3044711,3028526,3084683,3104026,3123188,3105164,335231,73733,340016,333742,334391,334393) AND raw_info NOT LIKE '%\"ListingType\":\"P\"%' AND mls_number NOT LIKE 'P%' AND raw_info NOT LIKE '%"visibility":"My Brokerage Only"%' AND zip_code IN (11932, 11963, 11963, 11962, 11937, 11937, 11975, 11935, 11939, 11944, 11957, 11958, 11964, 11965, 11971, 11931, 11933, 11933, 11941, 11947, 11948, 11952, 11956, 11901, 11970, 11792, 11980, 11954, 11963, 11966, 11968, 11976, 11941, 11942, 11946, 11978, 11959, 11960, 11972, 11977, 11978, 11930) AND 1=1 AND post_status = '1' GROUP BY full_street_address, api_class ORDER BY list_price DESC LIMIT 0, 10 SELECT ID, post_status, post_type, post_title, post_content, raw_info, listing_info, api_type, api_class, rets_prop_type, rets_prop_status, out_prop_type, out_prop_status, api_prop_features, open_house, list_price, rental_price, sold_price, state, city, zip_code, mls_number, bedrooms, house_size, property_size, bathrooms, full_address, street_name, broker, listing_key, listing_agent_key, colisting_agent_key1, colisting_agent_key2, full_street_address, SaleOrRent, RentAmtAugLaborDay, RentAmtJulyAug, RentAmtJuly, RentAmtJune, RentAmtMemLaborDay, RentAmtOffSeason, RentAmtYearRoundMonthly, RentAmtjun_jul, RentAmtsht_term, last_modified, date_added FROM tbl_api WHERE ( out_prop_status != 'sold' ) AND ( out_prop_status != 'off-the-market' ) AND ( out_prop_status != 'sold' ) AND mls_number NOT IN (333909,34159,341317,341255,38562,32933,38493,2987309,3095178,3121374,3055599,3114706,3076311,3066474,3121376,3044711,3028526,3084683,3104026,3123188,3105164,335231,73733,340016,333742,334391,334393) AND raw_info NOT LIKE '%\"ListingType\":\"P\"%' AND mls_number NOT LIKE 'P%' AND raw_info NOT LIKE '%"visibility":"My Brokerage Only"%' AND zip_code IN (11932, 11963, 11963, 11962, 11937, 11937, 11975, 11935, 11939, 11944, 11957, 11958, 11964, 11965, 11971, 11931, 11933, 11933, 11941, 11947, 11948, 11952, 11956, 11901, 11970, 11792, 11980, 11954, 11963, 11966, 11968, 11976, 11941, 11942, 11946, 11978, 11959, 11960, 11972, 11977, 11978, 11930) AND 1=1 AND post_status = '1' GROUP BY full_street_address, api_class ORDER BY list_price DESC LIMIT 0, 12