Welcome to 951 Front Ave! This beautifully remodeled home blends rustic charm with industrial style across three levels and features recent updates including a new roof, siding, leaf-blocking gutters, windows, and sewer line for added peace of mind. Starting with the main level, the kitchen features distressed concrete across countertops, backsplash, and the kitchen island, along with all new appliances and a custom-build butler's pantry that includes a double sink and ceiling fan. The formal dining area is made for entertaining - featuring a handcrafted dining table with matching chairs that seat eight, a custom liquor cabinet with glass cabinetry, built-in window benches with hidden storage, and plant shelves atop newer windows overlooking a spacious side yard. Custom copper artwork and lighting tie the room together perfectly. A half-bath off the dining area complements the home's aesthetic, while original hardwood floors flow into the inviting living room. Here you'll find custom mudded wall patterns and a matching built-in bookcase, an entertainment center pre-wired for a wall-mounted TV, digital thermostat, along with sconces and a ceiling fan for added comfort. Don't miss the eye-catching custom copper baluster staircase leading to the upper level! Off the living room, the expansive enclosed front porch provides optimal relaxation with beadboard ceilings and dual electric fans - perfect for morning coffee or unwinding after work. Upstairs, you'll find two of the home's three bedrooms and a brand-new flex room ideal for an office, gym, studio, or guest space. The primary suite features a mini-split for year-round comfort, dual sliding closet systems that make great use of the space, a built-in vanity, and TV hookup. The upper bath continues the home's style with a custom-built industrial sink. The second bedroom includes hardwood floors, another mini-split, ceiling fan, and front-facing newer window. The lower level adds even more versatility, offering a bedroom with custom ceiling woodwork, a stylish bath with walk-in shower, and additional living space once used as a home gym. You'll also find an updated LG front-loading washer and dryer, tankless water heater, a newer furnace and AC. Updated 200 AMP electrical in the house is complemented by 100 AMP in the garage for potential EV charging. Outside, enjoy the fully fenced yard with mature trees, raised south-facing planters, a concrete patio, spacious two-car garage, and a storage shed. This one-of-a-kind home has been thoughtfully cared for and meticulously designed with creativity, comfort, and craftmanship - you won't want to miss it!