Welcome to 547 N. Church Street--an exceptional, complete-home renovation down to the studs with a second-floor addition, where everything has been rebuilt with intention. With 4 bedrooms, 2.5 bathrooms, and 1,720 sq ft of finished living space, this home offers the rare combination of updated design and major system upgrades that help support long-term value. This house delivers modern functionality with standout craftsmanship and is truly move-in ready. The renovation isn't cosmetic--it's structural and mechanical, starting with a strengthened building envelope. The home is fully sheathed with Zip System to help resist moisture intrusion, paired with spray foam insulation in key areas (roof sections, basement perimeter, and crawl spaces) and added sound-deadening insulation/drywall for comfort and efficiency. You'll also appreciate the big-ticket improvements buyers prioritize: 200-amp electrical service, wiring, plumbing, HVAC, high-efficiency windows and exterior doors, roof with Owens Corning architectural shingles, and seamless gutters/downspouts for reliable water management. From the street, the upgraded open-air front porch sets the tone with Rosetta Stone (Plum Creek palette) stacked ledger accents, board-and-batten detailing, and a striking two-tier wrought iron chandelier. The decorative-glass front door features Barcelona-style ironwork with privacy glass, a rich cherry stain, and coordinated black hardware--tied together by a warm, wood-look porch ceiling. Durable exterior upgrades continue with substantial .046' vinyl Dutchlap siding, Azek composite trim, corbels that add Craftsman-style charm to the rooflines, and refreshed landscaping that complements the home's original brick. Inside, you'll immediately notice the luxury vinyl plank flooring, oversized trim, updated lighting fixtures, and thoughtful layout that allows for flexible placement of furniture. The kitchen is a true centerpiece with solid-wood cabinetry, crown molding, soft-close doors and drawers, brushed gold hardware, under-cabinet lighting, a large stainless double-bowl sink, and stone countertops with warm gold flecks--finished with a light subway tile backsplash and ample space for dining. A convenient half bath on the main level features a vanity top selected to coordinate with the kitchen finishes. The first-floor primary suite offers comfort and privacy, featuring well-placed windows, a walk-in closet, and an ensuite bath accessed through attractive glass barn doors with hammered black pulls. The custom-tiled bathroom includes a cultured-marble walk-in shower designed to maximize a high-end look while minimizing grout lines for easier maintenance, plus glass shower doors with Diamond Coat to reduce spotting. Dual undermount sinks and black fixtures complete the space with a cohesive, modern feel. Upstairs, you'll find three sizable bedrooms with abundant natural light, generous closets (including mirrored rolling doors for an airy feel), and special touches like built-in desk areas and library shelving in the front rooms--plus 'secret cubbies' that add fun, functional storage. The second-floor bath is uniquely designed for real-life efficiency: washer/dryer hookups, laundry cabinetry, a private water-closet area, and a 'one-of-a-kind' cultured-marble vanity with three separate sinks so everyone has their own space. The full tub/shower, privacy-glass window, plenty of outlets, and easy-care flooring round out the home's practicality. The basement has been freshly sealed and painted. Outdoor functionality is also strong. The property offers a large backyard and alley access, providing flexibility for future plans--such as adding a garage with a breezeway. This is the kind of property that rarely comes to market in this condition; where finishes are beautiful and the infrastructure has been rebuilt to match. If you've been searching for a home where the work has already been done--done thoughtfully--this one is a must