Condo

Riverside 2BR w/ Kayak & Trails Nearby

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

Unwind on the driftwood deck with panoramic Susquehanna River views—perfect for morning coffee or sunset cocktails.
Cozy open-concept living area with plush seating and a TV, ideal for relaxing after exploring Columbia.
Wake up to river views from this king bedroom—your serene retreat after a day of outdoor adventure.
Charming dining nook with natural light and easy access to the deck—perfect for leisurely meals.
Exterior of the riverside apartment, just steps from riverfront trails and downtown shops.

Reviews

9.8 out of 10
Exceptional
2 bedrooms1 bathroomSleeps 4

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
    ‪3 min drive‬
  • Dutch Apple Dinner Theatre
    ‪10 min drive‬
  • Spooky Nook Sports
    ‪16 min drive‬
  • Lancaster, PA (LNS)
    ‪27 min drive‬

Rooms & beds

2 bedrooms (sleeps 4)

1 bathroom

Bathroom 1

Spaces

Kitchen
Balcony
Garden

About this property

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:
• 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.

Property manager

Leavetown Vacations
Premier Host

Add dates for prices

Amenities

Kitchen
Washer
Dryer
Free WiFi
Air conditioning
Outdoor space

Have a question?

AI iconBeta

Get instant answers with AI powered search of property information and reviews.

Similar properties

About the area

Columbia

Map
480 South Front Street, Columbia, PA, 17512

What's nearby

  • National Watch and Clock Museum - 2 min drive - 2.1 km
  • Turkey Hill Experience - 3 min drive - 2.2 km
  • Dutch Apple Dinner Theatre - 10 min drive - 10.7 km
  • Bube's Brewery - 13 min drive - 12.7 km
  • Spooky Nook Sports - 16 min drive - 15.2 km

Restaurants

  • ‪McDonald's - ‬4 min drive
  • ‪Black Olive Family Diner - ‬3 min drive
  • ‪Union Station Grill - ‬11 min walk
  • ‪Wendy's - ‬6 min drive
  • ‪Mr. Joe's Steakhouse - ‬11 min walk

Reviews

9.8

Exceptional

Reviews are presented in chronological order, subject to a moderation process, and verified unless otherwise labelled.
Learn moreOpens in a new window
Rating 10 - Excellent. 10 out of 12 reviews
Rating 8 - Good. 2 out of 12 reviews
Rating 6 - Okay. 0 out of 12 reviews
Rating 4 - Poor. 0 out of 12 reviews
Rating 2 - Terrible. 0 out of 12 reviews

10/10

Cleanliness

10/10

Check-in

10/10

Communication

10/10

Location

9.8/10

Listing accuracy

Reviews

10/10 Excellent

Leslie G.

Liked: Cleanliness, check-in, communication, location, listing accuracy

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

Phil S.

Liked: Cleanliness, check-in, communication, location, listing accuracy

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

10/10 Excellent

Daniel E.

Liked: Cleanliness, check-in, communication, location, listing accuracy

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, check-in, communication, location, listing accuracy

Spring PA trip

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

10/10 Excellent

Cheryl M.

Liked: Cleanliness, check-in, communication, location, listing accuracy

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

Tommy G.

Liked: Cleanliness, check-in, communication, location, listing accuracy

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

Nicole Danielle S.

Liked: Cleanliness, check-in, communication, location, listing accuracy

Great

Good experience
Stayed 2 nights in Jul 2022

10/10 Excellent

amber g.

Liked: Cleanliness, check-in, communication, location, listing accuracy

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

brenda b.

Liked: Cleanliness, check-in, communication, location, listing accuracy

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

8/10 Good

Y E.

Liked: Cleanliness, check-in, communication, location, listing accuracy

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

Ann F.

Liked: Cleanliness, check-in, communication, location

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

Piper T.

Liked: Cleanliness, check-in, communication, location, listing accuracy

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

About the host

Hosted by Leavetown Vacations

Host profile image

Languages:

English, French, Spanish

Premier Host

They consistently provide great experiences for their guests
Tell us how we can improve our siteShare feedback