Beautifully updated modern farmhouse offering the feel of a brand-new home, nestled along the scenic Rippowam River. This charming 3-bedroom, 2-bath home combines modern updates, an open floor plan, and exceptional outdoor living-offering the perfect balance of city convenience and a peaceful nature setting. The gourmet kitchen features stylish finishes, ample cabinetry, and opens seamlessly to the dining and living areas, ideal for everyday living and entertaining. The inviting family room includes a wood-burning fireplace, creating a warm and welcoming gathering space. Enjoy stunning river and backyard views from the brand-new deck, perfect for morning coffee or evening relaxation. The paved patio offers space for outdoor dining and grilling, while the fire pit overlooking the river provides the perfect place to unwind. The fully fenced, beautifully landscaped backyard offers privacy and room to relax or entertain. The flexible floor plan includes two bedrooms and a full bath upstairs, plus an additional bedroom and full bath on the main level, ideal for guests or home office. Conveniently located minutes from downtown shopping and dining, public transportation, and parks featuring pickleball and tennis courts, a playground, splash pad, and walking track. Enjoy city living in a serene riverside setting with comfort, style, and convenience at your doorstep.