Entire condo

Riverside 2BR w/ Kayak & Trails Nearby

Choose dates to view prices

Photo gallery for Riverside 2BR w/ Kayak & Trails Nearby

Terrace/patio
Smart TV
Smart TV
Iron/ironing board, free WiFi
Fridge, microwave, oven, stovetop

Reviews

9.4 out of 10
Exceptional

Popular amenities

  • Parking available
  • Dryer
  • Washer
  • Kitchen
  • Barbecue grill
  • Air conditioning

Explore the area

Map
480 South Front Street, Columbia, PA, 17512
  • Turkey Hill Experience
    ‪2 min drive‬
  • Dutch Apple Dinner Theatre
    ‪10 min drive‬
  • Franklin & Marshall College
    ‪18 min drive‬
  • Harrisburg, PA (MDT-Harrisburg Intl.)
    ‪37 min drive‬

Room options

Similar properties

About this property

Entire place

You'll have the entire condo to yourself and will only share it with other guests in your party.

Riverside 2BR w/ Kayak & Trails Nearby

Cozy 2-bedroom apartment with stunning Susquehanna River views in the heart of Columbia, PA. Sip coffee or cocktails on the custom driftwood deck as you watch eagles soar and sunsets glow. Steps from riverfront trails, kayaking, antique shops, breweries, and Columbia Crossings River Park. Perfect for couples or small families seeking a peaceful, nature-filled getaway with small-town charm.

• Scenic Views of the Susquehanna River
• Prime Location Near Trails, Shops & Breweries
• Cozy 2-Bedroom Apartment Layout
• Watch Eagles & Trains from the Deck
• Walking Distance to Columbia Crossings River Park
• BBQ Grill & Firepit

Escape to this 750 sq. ft. charming riverside apartment, a peaceful 2-bedroom retreat located on the second floor with breathtaking views of the Susquehanna River. Ideal for a romantic getaway or outdoor adventure base.

• Bedroom 1: king bed
• Bedroom 2: king bed
• Bathroom: shower
• Living Area: sofa, TV
• Kitchen: Stove, fridge, microwave, coffee maker
• Outdoor Deck: seating area, river, train views, fire pit
• Shared Spaces: first-floor vestibule with washer and dryer
LOCAL FAVORITES
Food & Drink

• Columbia Kettle Works: Brewery with craft beers and live events in a casual setting. (0.9 miles)
• Bully's Restaurant & Pub: Cozy spot with hearty pub fare and a local vibe. (1 mile)
• Union Station Grill: Casual American eatery serving burgers, steaks, and comfort food classics. (0.7 miles)

Outdoor Activities

• Columbia River Park: Launch point for kayaking and canoeing along the Susquehanna. (0.8 miles)
• Northwest Lancaster County River Trail: Perfect for biking, walking, and nature spotting. (0.8 miles)
• Chickies Rock Overlook Trail: Scenic hike with panoramic views of the river. (2.5 miles)

Recreational Activities

• Burning Bridge Antiques Market: Large antique shop with hidden treasures. (0.9 miles)
• Turkey Hill Experience: Interactive exhibits and ice cream tasting for all ages. (1.3 miles)
• National Watch and Clock Museum: Unique museum showcasing timepieces and horology. (1.4 miles)

OTHER THINGS TO NOTE:
• This property is not recommended for children under 5 years old.
• Complimentary parking at the property.
• Pets are not allowed.
• Smoking is strictly prohibited.
• Parties, gatherings, and events are strictly prohibited.
• Accessibility notice: This home requires stairs for entry.
• Please note that the apartment is located near train tracks, and occasional train noise may be heard — it's part of the charm that many guests enjoy. For added comfort, a white noise machine is provided.
• Kindly park in the designated lined areas in front of the porch steps to ensure the rear entrance of the business below remains clear.

We are pleased to provide host and guest liability and damage protection! Upon booking, you will receive a secure link to complete a virtual check-in through a guest portal.
During your stay at this condo building, you'll be within walking distance of Wright's Ferry Mansion. Features include laundry facilities. Free WiFi and a kitchen are available in the condo.
  • Air-conditioned condo with kitchen, washing machine, and balcony
  • Free WiFi
  • Amenities include laundry facilities
  • 11 minutes by foot from Wright's Ferry Mansion and a 2-minute drive from National Watch and Clock Museum
As a guest of this condo, you'll find barbecue grills, a garden, and laundry facilities. The front desk is open around the clock.

This Columbia condo is smoke free.

Property manager

Leavetown Vacations

Languages

English, French, Spanish

Property amenities

Internet

  • Available in the condo: Free WiFi

Parking and transport

  • Parking on site

Kitchen

  • Coffee/tea maker
  • Cookware, dishware, and utensils
  • Hob
  • Microwave
  • Oven
  • Refrigerator

Bathroom

  • Hair dryer
  • Towels provided

Living spaces

  • Living room

Entertainment

  • Smart TV with cable/satellite channels

Outdoor areas

  • Balcony
  • Barbecue grill
  • Firepit
  • Garden

Laundry

  • Laundry facilities
  • Washing machine

Comfort

  • Air conditioning
  • Heating

Pets

  • No pets allowed

Suitability/Accessibility

  • Smoke-free property

Services and conveniences

  • Iron/ironing board

Safety features

  • Carbon monoxide detector not reported (host has not indicated whether there is a carbon monoxide detector on the property; consider bringing a portable detector)
  • Smoke detector not reported (host has not indicated whether there is a smoke detector on the property)

General

  • Garden

Policies

Check-in

Check-in time starts at 4:00 PM
Minimum check-in age: 25

Check-out

Check-out before 11:00 AM

Special check-in instructions

You will receive an email from the host with check-in and check-out instructions

Pets

  • No pets allowed

Children and extra beds

  • Children are welcome.

Important information

You need to know

This property is managed by a professional host. The provision of housing is linked to their trade, business, or profession.
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
Onsite parties or group events are strictly prohibited
Host has not indicated whether there is a carbon monoxide detector on the property; consider bringing a portable detector with you on the trip
Host has not indicated whether there is a smoke detector on the property
This property is managed through our partner, Vrbo. You will receive an email from Vrbo with a link to a Vrbo account, where you can change or cancel your reservation
You will receive an email from the host with check-in and check-out instructions. You will also receive an email from Vrbo with a link to a Vrbo account which will enable you to manage your booking.

Property is also known as

6603-16790

Riverside 2BR w/ Kayak & Trails Nearby Reviews

Reviews

9.4

Exceptional

Rating 10 - Excellent. 10 out of 13 reviews
Rating 8 - Good. 2 out of 13 reviews
Rating 6 - Okay. 0 out of 13 reviews
Rating 4 - Poor. 1 out of 13 reviews
Rating 2 - Terrible. 0 out of 13 reviews

9.4/10

Cleanliness

Reviews

4/10 Poor

maria m.

Disliked: Cleanliness

Very Dissapointing

Unfortunately we had a terrible experience in this property. We arrived to a half cleaned place, a trash bag on the door, cleaning products on tables, pillows on the floor, dirty mirrors from the person before brushing their teeth, we didn't even know if they had cleaned the sheets. We were seriously in shock!Apart from that they promised to come clean the next day, which obviously does not make it right and we agreed they would come at noon when we were not there so they don't disturb and they never came. Very disappointed for the price we paid to check in to a half cleaned apt. and all they offered in compensation was an apology and refund half the cleaning fee!
Stayed 2 nights in May 2025

10/10 Excellent

Cheryl M.

Liked: Cleanliness

Comfortable with a great river view

This rental was more spacious than expected. Very comfortable and clean. Loved the huge windows in the master bedroom which give a great view of the river. As noted in the property description, trains run immediately behind the building, so it was not a surprise to us. Just be aware you WILL hear and feel the trains passing by overnight.
Stayed 2 nights in Oct 2024

8/10 Good

Y E.

Liked: Cleanliness

Trains and River

Cozy property right on river and train tracks. View was amazing and trains were fun. Property is very well maintained, clean, and stocked with needed supplies. Easy to find and convenient parking. The business located on the first floor was loud at times, and trains were loud all the times (they almost always come by during the night). Did not try the provided white noise machine but perhaps that could have helped. A nice visit overall.
Stayed 2 nights in Aug 2024

10/10 Excellent

Phil S.

Liked: Cleanliness

Great Location

If you are in Lancaster or the Columbia are this is a property worth consideration. Great location, the deck is amazing all the amenities. I come to the area frequently this is a gem that I will stay at again
Stayed 2 nights in May 2024

8/10 Good

Tommy G.

Liked: Cleanliness

Review

It was a good property and good amenities but the AC didn’t work very well than that. I enjoy the stay.
Stayed 2 nights in Jul 2023

10/10 Excellent

Daniel E., Imler Pa

Liked: Cleanliness

Beautiful Views

Very clean, comfortable and cozy. Nice to have linens and towels available. Area very nice to visit.
Stayed 2 nights in Jun 2023

10/10 Excellent

Martha B.

Liked: Cleanliness

Spring PA trip

Loved the place! Very relaxing! Even with the trains. Would rent again!
Stayed 4 nights in May 2023

10/10 Excellent

brenda b.

Liked: Cleanliness

Great property

Very clean. On the water, beautiful view. Trains do go by at night but we enjoyed them.
Stayed 2 nights in May 2023

10/10 Excellent

amber g.

Liked: Cleanliness

Great Location!

This was our first time to the area! This house is in a great location! Columbia is a very cute town, lots of antique shops and restaurants! The house was very cute and clean! Great view of the river! The fire pit was a great way to spend our evenings. We didn’t mind the trains at all!
Stayed 3 nights in Oct 2022

10/10 Excellent

Ann F.

Liked: Cleanliness

Scenic Susquehanna

Great location: 20 minutes to Lancaster, 2 minutes to Columbia and less than 10 to Wrightsville and Marietta, both charming and interesting. My only quibble, and it's small, is that this apartment is located next to working railroad tracks. Fantastic for train lovers, but if you have trouble sleeping, could be an issue. Master bedroom has great view of river and trains as does the deck.
Stayed 3 nights in Sep 2022

10/10 Excellent

Leslie G.

Liked: Cleanliness

Loved it!

We loved our stay. It was perfect for our needs to have a short term work retreat.
Stayed 2 nights in Jul 2022

10/10 Excellent

Nicole Danielle S.

Liked: Cleanliness

Great

Good experience
Stayed 2 nights in Jul 2022

10/10 Excellent

Piper T.

Liked: Cleanliness

Clean, comfortable stay with great views!

Our stay was lovely! The house itself is very clean and well kept. The bedrooms are quite large and the bathroom is updated and clean. There is also a spare bathroom for renters use downstairs and a washer/dryer available. The outdoor area is incredible! A great view of the river, a fire pit, and lots of places to sit and watch the river. The house is on the train tracks, so if you are a light sleeper you might want to bring earplugs! Both rooms have sound machines though. The town isn’t huge, but a quick drive across the river and you’re in a cute area! All in all a great place to stay!
Stayed 3 nights in Jun 2022