Welcome to this inviting 2-bedroom, 1-bath ranch, complete with the rare addition of an included waterfront parcel (273-K-312) offering close and convenient access to the river. Thoughtfully updated and well maintained, this home blends modern finishes with flexible living spaces and an excellent location. The spacious, newly renovated bathroom features beautiful white chair rail accents along the walls, a sleek gray shaker-style vanity, and durable waterproof laminate flooring, creating a clean and contemporary feel. The updated kitchen is designed for both function and style, offering abundant counter space, an impressive amount of cabinetry for storage, and a built-in wine rack. It comes fully equipped with newer appliances, including a high-end Whirlpool four-door stainless steel refrigerator, dishwasher, and microwave, all complemented by newer laminate flooring. The partially finished basement provides the perfect flex space for a home office, game room, or potential third bedroom, with sewer plumbing already in place for the addition of a half or full bath. A fully equipped laundry area is also located in the basement for added convenience. Outside, the fenced-in backyard offers a private setting for pets, play, or entertaining, while covered front and back porches provide comfortable spaces to relax and enjoy the outdoors in any season. A dedicated off-street parking pad in the front yard adds everyday convenience. With quick access to downtown Pittsburgh and Pittsburgh International Airport, this home offers comfort, versatility, and a desirable waterfront lifestyle in one exceptional opportunity.