Welcome to 811 N President Ave - this absolutely stunning, 3 bed/1 bath single-family home is on a highly coveted, attractive street with excellent location just outside Lancaster City within Manheim Township School District! It has been cosmetically remodeled and updated - all while preserving its classic charm. This home features abundant character, a detached garage, and all new paint, flooring, and fixtures throughout! The home welcomes you in via a lovely brick paver walkway leading to the stunning traditional brick facade with painted shutters. A covered front entranceway with a beautiful, original wood door and painted wood slatted ceiling will welcome you in. Once inside, you're greeted with a bright living space with glowing refinished hardwoods that continue throughout, and beautiful, original trim detailing. A painted brick fireplace anchors the room and the original wood staircase creates a lovely focal point. Continue seamlessly into the dining and kitchen area, which features beautiful windows and moldings. The charming kitchen has been outfitted with several upgrades such as stainless steel appliances, upgraded quartz countertops (including a large peninsula for eat-in gathering and workspace), stylish white cabinetry, and colored subway tile backsplash. Enjoy direct access to the backyard, including a lovely covered patio that overlooks the flat and usable, fully fenced rear yard and one car detached garage. Upstairs, the elegant second level boasts three sizable bedrooms, all bright spaces with more glowing wood floors and beautiful archways. A gorgeous family bathroom on this floor features a stunning tiled tub/shower combination and new vanity. Enjoy this home with peace of mind with the newly serviced HVAC system, and mechanicals that have been updated to code. Beautiful, minutes away from major highways and shopping areas, and a treat to tour - contact us today! (Seller/investor willing to discuss options to add AC/forced air, newer windows or half bath. Willing to customize and adjust price.)