Airport, New Haven, CT (HVN-Tweed - New Haven Regional)
Rooms & beds
2 bedrooms (sleeps 6)
Bedroom 1
1 Queen Bed
Bedroom 2
1 Queen Bed
Living Room 1
1 Double Sofa Bed
1 bathroom
Bathroom 1
Toilet · Shower only
Spaces
Porch or lanai
Kitchen
Balcony
About this property
Aqua Vista
Newly renovated 2-Family Home! Located right in Greenport Village providing walking distance to all the restaurants, bars, shopping, coffee shops, and Shelter Island Ferry, Long Island Railroad (LIRR), and Hampton Jitney. Aqua Vista is the second floor apartment with a separate entrance. My place is close to restaurants and dining, the beach, family-friendly activities, nightlife, and public transport. You’ll love my place because of Location!. My place is good for couples, solo adventurers, business travelers, families (with kids). This property has two apartments. The Aqua Vista Apt.2 and The Sandpiper Apt. 1 (see listing on VRBO website that can accommodate 12 people when available at the same time for larger families and wedding parties
Add dates for prices
Have a question?
AI iconBetaBeta
Get instant answers with AI powered search of property information and reviews.
Similar properties
The Oyster House: An artful home nestled in the village of Greenport
Greenport
The Oyster House: An artful home nestled in the village of Greenport
Pets allowed: dogs less than 23 kg per pet (limit one pet total)
default
Smoking
Smoking is not permitted
Bicycles should be locked in back of house and not brought in the apartment.
ABSOLUTELY, POSITIVELY...NO HANGING OF DECORATIONS
Super-quiet time starts at 9pm and ends at 9am. Outside of that window, the noise should continue to stay at a respectable levels.
Important information
You need to know
Extra-person charges may apply and vary depending on property policy
Government-issued photo identification and a credit card, debit card or cash deposit may be required at check-in for incidental charges
Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed
On-site parties or group events are strictly prohibited
Host has indicated that there is a carbon monoxide detector on the property
Host has indicated that there is a smoke detector on the property
Safety features at this property include a fire extinguisher and a deadlock
Frequently asked questions
Is Aqua Vista pet-friendly?
Yes, this property allows dogs (limit 1 total) with a maximum weight of up to 23 kg per pet.
How much does it cost to stay at Aqua Vista ?
As of 6 Apr, 2026, prices found for a 1-night stay for 2 adults at Aqua Vista on 31 May, 2026 start from S$210, including taxes and fees. This price is based on the lowest nightly price found in the last 24 hours for stays in the next 30 days. Prices are subject to change. Choose your dates for more accurate prices.
How much is parking at Aqua Vista ?
On-site parking is available at the property.
What time is check-in at Aqua Vista ?
Check-in begins at 3:00 PM.
What time is check-out at Aqua Vista ?
Checkout is at 11:00 AM.
Where is Aqua Vista located?
Located in Pipes Cove, this holiday home is within a 5-minute walk of Railroad Museum of Long Island and East End Seaport Maritime Museum. Greenport Carousel and Camera Obscura are also within 10 minutes. Greenport Station is only a 3-minute walk.
Reviews
9.8
Exceptional
Reviews are presented in chronological order, subject to a moderation process, and verified unless otherwise labelled.
Great 2 bedroom unit. Near train station and shelter island ferry. Everything in greenport is easily walkable. Nice little kitchen for nights that you want to stay in.
The apartment is in the perfect location to walk to all the shops and restaurants in Greenport. Right down the street from the Shelter Island ferry which we took to go hiking. Enjoyed our stay!
This place was a dream. Super comfortable. The host has thought of everything, including a sweet holiday welcome gift. Everything is in walking distance- I didn't use my car for 2 days. It was wonderful to walk along the water into town. What a great retreat!
Great location, comfortable and clean…that with great communication response from owner made for a great stay…owner helped when app wasn’t allowing me to extend my stay…grateful for a great experience…highly recommend!
Place was very clean and easy to access. Great location for anyone staying in the area. Host was easy to talk to and very helpful in finding places nearby to visit.
This apartment is perfect for a getaway to Greenport!Walkable to all in townThe apartment was immaculate, with everything, especially the light and fan switch’s are labeled for ease of useWe recommend ANDYs for happy hour. Great drinks, food and atmosphere Also do not miss dining at First and South! That’s our favorite Also get a pie at 1943 Host was great for communicating all the details of the stayHighly recommend
Mark S.
Stayed 2 nights in Sep 2025
Verified
10/10 Excellent
Cathleen
16 Oct, 2024
Liked: Cleanliness, amenities, property conditions & facilities, communication
Spacious, clean,comfortable place! Owners very nice & accommodating. Definitely would stay again. Best way to stay in Greenport.
Liked: Cleanliness, amenities, property conditions & facilities, communication
This was our second stay at Aqua Vista. We love the property. The house is recently renovated and everything is brand new. It is nicely decorated and very comfortable. It is located close to the beach and center of the town with all of the restaurants. The property manager is a great host. We enjoyed our visit to the fullest.
Very cozy and clean. So close to town. The host put together a book of all the local spots making it easy to know where to go. Excellent communication as well. Would def stay again.
This was a perfect holiday stay!! The home was walking distance to and from family and town. The home had everything that was needed. It was a home away from home. Most of all the host was so nice and communicative prior to and during our stay!
We enjoyed our stay very much! The apartment was immaculate and had everything that we needed for our stay. The walk to town was so easy, and we never had to use our car. The host was very responsive and gave wonderful recommendations! We will definitely be back!
I was looking for a quiet, enjoyable place near the water and got just what I was looking for. My visit was during the off season early in the week so there wasn’t much to do in town but that was exactly what I was looking for. Really enjoyed it and look forward to returning in the future.
Karen B.
Stayed 3 nights in Feb 2024
Verified
10/10 Excellent
Mary
10 May, 2025
Liked: Cleanliness, amenities, property conditions & facilities, communication
This was my second time staying at The Sandpiper and once again, it did not disappoint. Perfect location, within walking distance of town. The apartment has everything you could need. Communication was great. We'll be back!
What a great little spot in a great little town.
The location couldn’t be easier and convenient. The train is literally across the street and Main Street a 5 min walk to the water and shops! The Apt is clean, well appointed, and so comfortable.
This was a real find!!
My sister and I stayed at Aqua Vista
the last weekend in October. The weather was amazing. The house is located just a block form the ferry to Shelter Island and a couple of blocks to all the shops in Greenport.The apartment was clean well equipped and well maintained. Located in a lovely area close to all the shops. We would definitely stay there again .
The
The property was perfect. Host Christopher never made an appearance, but he had thought of everything. The house was clean and well-equipped with cleaning supplies, ample linens and amenities. We absolutely love Greenport; we have a dear friend who lives in nearby Orient so we come often. We felt privileged to be able to stay in the center of Greenport, with easy access to everything up and down the North Fork during that weekend wedding.
We’ve been to Greenport many times and have been looking for a comfortable place to stay. We have found it. The location is a short walk from downtown restaurants and shops. The place is newly renovated and comfortably furnished. Kitchen is well equipped. There is a nice deck. The only downside to the location is that the street is where the line forms for Shelter Island ferry so there is more traffic than you’d expect for a residential street. It’s not particularly noisy, but a bus does run to the ferry, so it is noticeable. The LIRR station is about a block away so there are train horns a few times per day (including about 6 am on weekdays) but it wasn’t a big problem. Highly recommend the property.