Nestled in the charming North Mayfair neighborhood, this stunning 5-bedroom, 2-bathroom detached single-family home offers a perfect blend of modern amenities and classic comfort. Enjoy the convenience of nearby LaBagh Woods, Gompers Park, and easy access to I-90/94, along with an array of shops and restaurants along the Foster and Elston corridors. Step inside to find a spacious layout adorned with red oak hardwood and tile flooring throughout. The main floor boasts a sunroom with heated floors and skylights, creating a cozy retreat filled with natural light. The kitchen is a chef's dream, equipped with quartz countertops, stainless steel Samsung appliances, custom cabinetry, and has two massive skylights. The upstairs bathroom features with heated floors, heated towel rack, a luxurious whirlpool jet tub and separate shower, perfect for unwinding after a long day. The property also features a 2.5-car detached garage with dual entrances and newly resealed epoxy flooring and board walls (2024). The basement is designed for both functionality and entertainment, featuring dual-zone electric heated floors, a full wet bar, a wine fridge, and a playroom, or doubling as a second living area. Additional highlights include both tank and tankless water heaters, a furnace with humidity control, and a second bathroom with heated floors, a jet tub and shower. The basement also houses a laundry area with a washer/dryer stack and a laundry sink, making household chores a breeze. The fenced-in backyard with a composite deck is perfect for outdoor entertaining. Recent upgrades include a new gas furnace (2023), single-zone air conditioning, and a whole house UV water filtration system installed in 2020. The home has new copper plumbing (2020), gas and electric tankless water heaters (2020), new overhead sewer system (2020), new gas lines (2020), and electrical work & new wiring (2020), new roof (2014, previous owners), new roof section over mudroom (2018), whole house wired sound system (2020), and whole-property commercial grade wired camera system (2020). Don't miss out on this incredible opportunity - schedule a viewing today to tour your new home today!