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

SPACIOUS BAY ESTATES COLONIAL~ROOM FOR POOL!

$509,000
Web # 37150 Sold
  • East Quogue
  • 4 Bedrooms
  • 3.5 Bathrooms
  • 2350 Square Feet
  • 0.48 Acres
Mature Flowering and Specimen Trees, Secluded, Fenced Property Ready For a Pool. Home Feels Spacious and Cozy, With Open Great Room and Lots of Light. Freshly Painted, Stainless Appliances, Corian Countertops. Covered Deck for Summer Dining, Bonus Private 2.5 Room Wing with it's own Separate Front Entrance would be a Perfect Compact In-Law Suite, Handicap Accessible Apartment, or Professional Home Office. Minutes to Hamlet Villages and All Amenities, Gorgeous Ocean Beaches Nearby as Well.

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