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

QUIOGUE RENTAL – WESTHAMPTON BEACHES & CLOSE TO MAIN ST.

MD to LD - $45,000
July - $23,000
Aug(-LD) - $25,000
Web # 88663
  • Quiogue
  • 4 Bedrooms
  • 3.0 Bathrooms
  • 2500 Square Feet
  • 1.00 Acres
Quietly situated behind an evergreen border is this four bedroom, three bathquaint farmhouse. Conveniently located within close distance to Main Street Westhampton Beach, theatres, restaurants, shops as well being near to theocean beaches. Swim in the new pool or relax on your patio.

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