Meticulous meets family-friendly in this executive custom-built bungalow located at the end of a quiet cul-de-sac! With a view like none other, this home has it all and much more. Offering over 1,650 sq. ft. of quality finished living space on the main level and boasting 3 spacious bedrooms, 2 full bathrooms, airy living room with panoramic views of the Saint John River, modern upgraded kitchen & large separate dining room. The modern kitchen offers ample kitchen cabinets, quartz countertops with under-mount sink, XL centre Island with breakfast bar & plenty of large pull outs and built-ins! Just off the kitchen is the spacious dining room which is accented with XL windows which floods this space with light! The master suite is located on one end of the home & has wall to wall view of the river, backyard & has newly upgraded ensuite with corner glass shower, separate air jet soaker tub & large vanity with quartz countertops, as well as a large walk-in closet. On the other side of the main level, you will find two good sized bedrooms with ample closet/storage space & main level bath. The main level is finished off with a laundry area & access to the single car attached garage. The lower level offers an additional 1,400 sq. ft.+ of finished living space, and houses two additional bedrooms, a family room, rec room with walkout to the fenced in backyard, den/office area & full bathroom. The fenced in backyard offers plenty of room to roam and a hot tub!