GoHotelly
Extended stay hotel

The Mansion at Rebecca's Fountain

Enjoy a 5-star extended stay at The Mansion at Rebecca's Fountain near Niskayuna, NY. LGBTQ+ friendly with nearby attractions like Rivers Casino and miSci Museum.

Near, Niskayuna, NY 12309, United States View on map
10/10
Exceptional Based on 31 recent guest reviews
What recent guests emphasize

Exceptional hospitality and spacious comfort

Guests consistently highlight the welcoming hosts, well-equipped kitchen, and comfortable gathering spaces that make for memorable extended stays in a peaceful setting with convenient access to local attractions.

Guests often praise

  • Warm and attentive hosts who go above and beyond, including personalized communication and thoughtful accommodations for guests with special needs.
  • Spacious, clean, and beautifully furnished property with large common areas perfect for family gatherings and group events.
  • Well-stocked kitchen and dining areas, often enhanced by Chef Larissa’s exceptional cooking services, allowing for a stress-free dining experience.
  • Comfortable beds and cozy ambiance featuring fireplaces and relaxing outdoor spaces like hot tubs and yard games.
  • Convenient location near local attractions, with helpful recommendations for activities and dining options in the area.

Worth knowing

  • Good for visitors aiming to explore local sightseeing and recreation, though the overall accessibility to public transportation and local travel scored moderate marks.
  • Booking activities such as massages or chef services in advance is advisable due to popularity and added value.
  • The property accommodates large groups well, but available only by prior arrangement, suited for planned events or family reunions rather than spontaneous stays.
  • Some guests expressed a desire for longer stays to fully enjoy all the services and amenities offered.
  • LGBTQ+ friendly environment ensuring an inclusive and welcoming atmosphere for all guests.

Best for

  • Large families or groups seeking a spacious, private retreat with home-like comforts and communal gathering spaces.
  • Special occasions such as weddings, holidays, reunions, and celebrations requiring a well-equipped venue with attentive support.
  • Travelers who appreciate high levels of hospitality, personalized service, and culinary experiences on-site.
  • Guests looking for a quiet and scenic extended stay that balances relaxation with easy access to nearby cultural, recreational, and entertainment venues.
Compare booking partners

Open this hotel on the platform you trust.

GoHotelly doesn't process bookings — we open this property on each partner so you can compare live rates, cancellation rules and loyalty perks side by side.

Some links are affiliate — if you book, GoHotelly may earn a small commission at no extra cost to you. Read the full disclosure.

About this property

Welcome to The Mansion at Rebecca's Fountain

Set near Niskayuna, NY, The Mansion at Rebecca's Fountain offers an extended stay option that blends the charm of a vacation home with the conveniences of a vineyard estate. Rated highly by guests, the property provides spacious, comfortable accommodations suitable for large groups, family gatherings, and special events.

The mansion features well-appointed common areas and a fully stocked kitchen, making it practical for guests who enjoy cooking and spending quality time together. Attention to accessibility needs has been noted by guests, highlighting thoughtful arrangements for those with mobility challenges. The atmosphere is welcoming and inclusive, with an LGBTQ+ friendly environment.

Located a short drive from Albany International Airport, the property allows easy access to local attractions including the Rivers Casino & Resort Schenectady, the miSci Museum of Innovation & Science, and Maple Ski Ridge. Guests can also enjoy on-site experiences such as massage services and chef-prepared meals, which have been praised in reviews.

The mansion’s quiet, private setting offers a peaceful retreat while still being convenient for exploring the surrounding area. Suitable for visitors seeking a blend of relaxation and recreation, the property scores moderately for sightseeing and local convenience, offering a base for varied activities in upstate New York.

Summary compiled by GoHotelly editors from verified guest reviews, partner descriptions and editorial notes.
Verified guest reviews

What recent guests are actually saying

Reviews from travelers who stayed here in the last 12 months, grouped to help you spot the pattern quickly.

TLG
Tabar Lindsay Gifford Apr 15, 2026
10

Magical weekend at the Mansion - My friends and I booked this incredible home for a reunion. We were looking for something big enough to accommodate our large group, and were so pleased to find this property. This was the most perfect place for us to gather. The rooms were all great, the gathering spaces are welcoming and large enough to comfortably accommodate our crew. The kitchen was so well stocked (we all love to cook) and the outdoor space is really lovely too. The home and property is spectacular but even better are the staff and hosts! Larissa and Raphael went above and beyond to make our group feel welcomed. The communication about how to get there, how to check in, and what other services were available was so helpful, and they were always very quick to respond. They answered all of our questions and kept in good contact with us leading up to the trip. They even took extra steps to make arrangements in one of the bedrooms to accommodate the mobility challenges of one of our friends who recently had knee surgery. This house is amazing, and we'll definitely be back. Our only regret was not booking longer, or booking Chef Larissa for meals. I can't recommend this property, the staff and the hosts more highly - 10 stars!!

LP
lisa proulx Apr 08, 2026
10

We had a wonderful stay at Rebecca’s Fountain over Thanksgiving week! Our hosts, Larissa and Rafael, were gracious, attentive and very helpful! This was an amazing space to gather for a family holiday; room for all 19 of us! Super comfy beds, huge fully stocked kitchen! Beautiful furnishings, cozy fireplace and gorgeous views! The hosts even decorated for Christmas for us! We would definitely choose Rebecca’s Fountain again!

JR—
JANÁIRA REITER — Advogada Mar 20, 2026
10

The Bela Vista Guesthouse is beautiful and is on the same grounds as The Mansion at Rebecca’s Fountain, which is the Main property where large groups book for stay, family gatherings, Christmas parties, bachelorettes, weddings and such. I traveled to visit family in upstate NY and this property was just perfect to stay over, warm and cozy inside, super comfortable accommodations and in a great quiet private retreat. The area is filled with golf courses, great pubs, a cool brewery/bar for scotch tasting, and even wine tasting tours. I hired the massagist of the property and was such a good experience too, super relaxing and the masseur was very respectful, he is licensed. The host Larissa is wonderful and her recommendations for food and activities were great. I went ice skating with my family and had a blast. Definitely recommend the Bela Vista Guesthouse at Rebecca’s Fountain!

KE
Krystal Einarsson Mar 19, 2026
10

I photographed a wedding at the mansion and highly recommend the venue. The staff was very responsive to my messages, willing to meet with me to show me the property so I can plan where it's best to take photos for the event, and everyone I was in contact with was incredibly nice. The mansion was spotless and beautiful, the decor was perfect and it made for an amazing setting within the Capital Region of Upstate NY. If you're looking for a gorgeous hidden gem for your wedding or elopement, make sure you check out this venue.

JO
JUUH Oliveira Mar 04, 2026
10

The Mansion at Rebeccas Fountain is truly a peaceful retreat. I recently stayed with my family and everything was perfect. House is extremely comfortable, clean, and has everything you may need. We hired the Chef Larissa for our experience and it was the best decision ever. She took care of cooking for us and making sure we just enjoy our family time without all the worry, cleaning after, setting up and planning that cooking involves. Her service was top notch and so was the food she ‘prepared with love’ as she said, and that is exactly what we tasted. The beds were so comfortable and the great room was perfect to gather. The location is very convenient as well, was a short 15min drive from Albany Airport and very easy to go for our local outings, there are always so much going on around. And Larissa was also great recommending attractions and activities to do with the kids, she is very informed and helpful. We are already booked and very excited for the Thanksgiving Supper at The Mansion next month, I thought was a brilliant idea to just bring my whole family again, sit back, relax and enjoy great food , drinks and music, instead of being behind the stove the entire day. I highly recommend the place, totally worth it. Thank you Larissa for making us feel like home.

HW
Heather Wilson Jan 05, 2026
10

We stayed at The Mansion at Rebecca’s Fountain for a family wedding - our experience was TOP notch!! The house was amazing, the accommodations very comfortable and the hosts were extremely helpful on all fronts! They organized the catering plan for the entire weekend to take all of the worries and stress out of the trip - the food was incredible! We also enjoyed the massage therapist who did an incredible job. It was a perfect weekend and the hosts here go above and beyond to make sure your experience is second to none. We highly recommend and will definitely stay here again!!

BF
Billy Faia Jan 02, 2026
10

We had an incredible stay at Larissa's place.From the moment we arrived, Larissa and the staff were exceptionally helpful and accommodating. She not only suggested fantastic places to visit but also prepared a delicious breakfast buffet and organized a fun hibachi night. The house itself was amazing—complete with a jacuzzi, yard games, and a grill. It’s a beautifully secluded private property, yet conveniently close to Saratoga Race Track and the local nightlife. I highly recommend Larissa's place for anyone looking for a wonderful and memorable getaway

SE
Suzana Eischstaedt Dec 31, 2025
10

Our time at The Mansion at Rebecca’s Fountain was so precious. Gathering with our family was beautiful and we certainly enjoyed every minute of it. The house is gorgeous, spacious, comfortable and everything clean. Was great having Larissa cooking for us her delicious meals and just really bonding, instead of doing all the cooking and cleaning and etc, that was a relieve and a blessing. The kids enjoyed themselves at the hot tub, playing some board games and play station while at the house, and when we went out for apple picking at the Indian Ladder farms kids and everybody had a blast and such a fun time. The local apple cider was worth trying and also the apple cider doughnut were a hit. Thanks Larissa for your care, your recommendations and your welcoming personality. Can’t wait to go back.

Location & neighborhood

Where you'll find The Mansion at Rebecca's Fountain

Niskayuna, New York, USA

Based on sightseeing, recreation, and getting around

  • Albany International Airport 19 min Car · 1 hr 29 Transit
Things to do nearby

Worth the walk or a quick ride

Curated spots travelers usually pair with a stay in New York. Distances are rough real-world times, not straight-line.

miSci | Museum of Innovation & Science 234 reviews

miSci | Museum of Innovation & Science

15 Museum Drive, Schenectady, NY 12308, United States

4.3 · Science Museum
Rivers Casino Schenectady 7,215 reviews

Rivers Casino Schenectady

1 Rush St, Schenectady, NY 12305, United States

4 · Casino
Maple Ski Ridge 347 reviews

Maple Ski Ridge

2725 Mariaville Rd, Schenectady, NY 12306, United States

4.6 · Ski Resort
People also viewed

Similar Extended Stay Hotels in New York

Hand-picked alternatives with a comparable feel, size and price band.

210 Crossings Pl, Antioch, TN 37013, United States

Hampton Inn Nashville-I-24 Hickory Hollow

Stay at Hampton Inn NashvilleI24 Hickory Hollow in Antioch, TN. Enjoy free WiFi, breakfast, parking, outdoor pool, fitness cent...

4.1 (954) View
23 Rippling Water Dr, Camdenton, MO 65020, United States

Rippling Waters Resort

Rustic cabins & condos on Lake of the Ozarks with free WiFi, parking, heated fishing dock, and familyfriendly amenities. Close t...

4.8 (99) View
1712 Commerce St, Dallas, TX 75201, United States

AC Hotel Dallas Downtown

Relax at AC Hotel Dallas Downtown with gym, restaurant, and WiFi. Near Reunion Tower and top attractions like Dallas Museum of Ar...

4.2 (969) View
820 Shelden Ave, Houghton, MI 49931, United States

Hampton Inn & Suites Houghton

Stay at Hampton Inn & Suites Houghton, MI, featuring free breakfast, parking, indoor pool, and easy access to Mont Ripley Ski Area...

4.5 (185) View
1600 Surf Ave, North Wildwood, NJ 08260, United States

Surf 16 Motel

Surf 16 Motel offers modest rooms with kitchenettes, outdoor pool, and kidfriendly services. Just a 5minute walk to North Wildwo...

3.5 (38) View
3537 US-60, Ponca City, OK 74604, United States

Double N Motel

Stay at Double N Motel in Ponca City, OK. Enjoy free WiFi, parking, petfriendly rooms, and easy access to E.W. Marland Mansion a...

3.5 (146) View
1550 Old Bayshore Hwy, Burlingame, CA 94010, United States

Bay Landing Hotel

Casual Bay Landing Hotel in Burlingame offers free WiFi, breakfast, airport shuttle, and business facilities. Just minutes from S...

4.3 (1,625) View
200 Country Club Blvd, Elephant Butte, NM 87935, United States

Marina Suites Motel

Stay at Marina Suites Motel in Elephant Butte, NM. Enjoy 1bedroom units with kitchens, free WiFi, and parking minutes from Eleph...

4.8 (55) View
120 Playground Lp, Counce, TN 38326, United States

The Lodge at Pickwick Landing

Relax at The Lodge at Pickwick Landing in Counce, TN. Enjoy lake views, free WiFi, pools, a restaurant, and familyfriendly ameni...

4.4 (558) View
Share your stay

Stayed at The Mansion at Rebecca's Fountain? Help the next traveler decide.

Short, honest notes are more useful than long ones. A few sentences about what worked, what surprised you, and who the hotel is best for will go a long way.

Your email is only used to verify the review — it won't be shown publicly.