This spectacular 2-acre estate offers an unparalleled blend of luxury, functionality, and breathtaking views of the Saint John River and the historic world's longest covered bridge. At the heart of the property sits a sweeping ranch-style home. The expansive main level features a magnificent open-concept living area anchored by a cozy propane fireplace, a formal office, a family room, and a practical mudroom. Accommodations include three spacious bedrooms and two and a half bathrooms. The potential extends downward into a massive, full walk-out insulated concrete form (ICF) basement that opens toward the river, ready to be customized to your lifestyle. Two standout mechanical features include a fully integrated central heating and air conditioning system and a standby propane generator for ultimate peace of mind. Attached is an oversized 33'x47' attached four-car garage fully finished and insulated. Just steps from the main residence is an absolutely massive, 4,700-square-foot dream shop that commands attention. The core of this facility is a 40'x70' heated workspace boasting soaring 16-foot ceilings, an integrated mechanic's pit, a dedicated office or workspace with its own half bath, and two 14-foot overhead doors. Adding to its immense capability is a 25'x76' addition equipped with two more overhead doors, making it ideal for commercial endeavors, extensive vehicle collections, or heavy equipment storage. A provincial ATV and snowmobile trail is at the bottom of the hill. Furthermore, it is only a short drive to the Upper River Valley Hospital, local K-12 schooling, grocery shopping, and the fairways of the Covered Bridge Golf & Country Club, delivering a truly unique lifestyle opportunity. (id:60457) Location - The last house on McMullin Road