Waterview property offers many options. This well maintained 3 unit residence is currently configured as a spacious main home with 3 bedrooms + 2.5 baths, plus two separate apartments, one with 3 bedrooms + 2 baths, and a recently renovated unit featuring 2 bedrooms + 1 bath. The lower unit in the walk out basement was previously used for a business and could easily serve that purpose again, with ample paved parking available and located on a major tourist route. Each unit includes its own laundry + private paved driveway. The main home showcases an open concept kitchen, dining, and living area, highlighted by a vaulted ceiling, propane fireplace, and large windows that capture beautiful water views. This area is ideal for entertaining. The kitchen offers generous counter space, a pull-out pantry, + abundant natural light. Triple patio door off the living room leads to a large deck. The main floor also includes a primary bedroom with a full ensuite bath, laundry + 2 pc bath, and a front office. Upstairs, you will find two additional bedrooms and a full bathroom. The property is equipped with an automatic propane generator and a new ducted heat pump for the main unit + basement was installed in 2026. The main-floor apartment also benefits from its own ducted heat pump. Charming wrap around verandah + 2 storage sheds. Buyers will have the first opportunity to purchase two neighbouring lots, one of which includes a beautifully restored 1946 garage.
74 days
|
15
|
0
|
Zillow last checked:
Listing updated:
Listed by:
Leslie Tracy, Salesperson,
RE/MAX Avante Brokerage,
Eric Murray, Salesperson168241,
RE/MAX Avante
Source: New Brunswick Real Estate Board,MLS®#: NB138227
Parking features: Each Unit Has Private Paved Parking, Asphalt, ParkingYN, No Garage
Has uncovered spaces: Yes
Features
Has view: Yes
View description: River
Has water view: Yes
Water view: River
Waterfront features: Other
Lot
Size: 3,200 Square Feet
Features: Landscaped, 0.5 -0.99 Acres
Details
Parcel number: 05116660
Other equipment: Fuel Tank(s)
Construction
Type & style
Home type: MultiFamily
Property subtype: Triplex
Materials
Vinyl Siding
Foundation: Concrete, Stone/Rock
Roof: Asphalt
Utilities & green energy
Sewer: Municipal
Water: Municipal
Community & HOA
Location
Region: Hillsborough
Financial & listing details
Price per square foot: C$146/sqft
Annual tax amount: C$5,837
Date on market: 4/29/2026
Ownership: Freehold
Leslie Tracy, Salesperson
Leslie Tracy, Salesperson
(506) 850-3663
By pressing Contact Agent, you agree that the real estate professional identified above may call/text you about your search, which may involve use of automated means and pre-recorded/artificial voices. You don't need to consent as a condition of buying any property, goods, or services. Message/data rates may apply. You also agree to our Terms of Use. Zillow does not endorse any real estate professionals. We may share information about your recent and future site activity with your agent to help them understand what you're looking for in a home.