Nestled in the heart of the coveted Point Ridge Farms neighborhood, this extraordinary custom creekside home offers the rare combination of timeless charm and modern luxury. Thoughtfully reimagined through an extensive, multi-year renovation, nearly every inch of this residence has been upgraded while preserving its original character. Boasting 6 bedrooms and 4.5 bathrooms, the home includes both a main-level and an upper-level primary suite, ideal for multigenerational living or flexible lifestyle needs. Timeless curb appeal with a charming covered porch, framed by rich wooden beams, welcomes you through a solid custom front door into a welcoming foyer. The gourmet kitchen is a chef's dream: heated travertine floors, custom cabinetry with under-cabinet lighting, granite countertops, tile backsplash, 48” gas range with hood, built-in refrigerator and impressive center island. Enjoy panoramic creek views through wall-to-wall windows. Choose to eat in the cozy eat-in kitchen area or in the more formal dining room adorned with wainscoting, crown molding and a ceiling medallion. Family room with wood burning fireplace and decorative mantel. The first-floor primary suite features a spa-like bath with heated ceramic tile floors, a marble-topped double vanity with under-cabinet lighting, walk-in tiled shower with glass doors and bench, and a spacious walk-in closet. Upstairs, a second luxurious suite includes heated ceramic tile floors, quartz counters with under-cabinet lighting, a private water closet, walk-in tiled shower and a large walk-in closet. Three additional upstairs bedrooms and a full hall bath with jetted tub complete with tile surround, heated floors and a double bowl vanity. Cedar closet and pull down attic storage. The finished walkout lower level is a retreat of its own, offering a media area with 120” drop-down screen and projector, exercise space, craft room, additional family room with fireplace, sixth bedroom, full bath, and a wet bar with granite counters, mini fridge, built-in drawer dishwasher and under-cabinet lighting. Step outside to a massive, multi-tiered Trex deck overlooking your newly poured patio with hot tub pad, and lush, level yard with direct access to over 100 feet of Conodoguinet Creek frontage - an entertainer's paradise and nature lover's dream. Additional upgrades include: new roof, gutters, fascia, and dormers, whole-house replacement windows, updated HVAC (2 AC units + mini split), new plumbing, electric, and insulation. Finished garage interior, whole-house audio + automatic lighting sensors. Extensive hardscaping, professionally designed landscaping and ambient exterior lighting. New storage shed and rear electric dog fence. New kitchen, wet bar and baths. Main floor laundry, half bath and mudroom off garage. This is a truly one-of-a-kind property offering turnkey luxury, privacy, and rare waterfront living in one of the area's most sought-after communities. Serviced by Hampden Township and Cumberland Valley Schools. Neighborhood park, sports courts and additional creek access is just down the street. Inquire for the full list of improvements and features or to schedule your own private showing.