Discover an exceptional executive home at 790 Front Mountain Road. A stunning Cape Cod style retreat that offers the perfect blend of country living within the city limits. Situated on nearly 3 acres, this property provides breathtaking views overlooking the City of Moncton North, along with luxurious amenities and timeless charm. Each room is designed with elegance and allure, featuring large windows that flood the space with natural light and stunning views. There is a formal dinning area, great for special occasions and gatherings, an updated spotless kitchen, a great room/family room, perfect for gatherings, complete with propane fireplace. The main floor also has an office and a den/family room which could be made into a main floor bedroom with an addition of a closet, as well as a beautiful 3 piece bath with stand alone tub. The upper level boasts three large bedrooms, with the master having a walk in closet and ensuite, a full bath completes the upper level. The basement has a rec room and another office or play space. The double attached garage has epoxy floors and large storage space. AN outdoor paradise awaits with beautifully landscaped gardens, featuring an inground pool, gazebo and outdoor shower for a true sanctuary. The detached garage with a greenhouse at the back includes space for hobbies and toys. This really is a home that does not come along often and has so much to offer and see. For your private showing please contact your favorite REALTOR® today. (id:47421)