Welcome to On The Rocks – A Riverfront Masterpiece at 92 Front St. Gagetown,NB. A fully redesigned, luxurious riverfront home on the Saint John River. Enjoy breathtaking sunrises through panoramic windows & golden sunsets lighting up the opposite shore. Watch grey & blue herons in the shallows, with direct water access to Fredericton, Grand Lake, Cambridge Narrows, the Bay of Fundy & Atlantic Ocean. Main living area features soaring 20’+ cathedral ceilings & a chef’s kitchen w/high-end appliances, oversized island(seats 4), bar & serving station—ideal for entertaining. The primary suite is a true retreat w/in-floor radiant heat, spa-like ensuite w/waterfall shower, stone finishes, soaking tub overlooking the river & a 25’ wall of windows. Attached laundry for added ease. Lower lvl includes 2 ceramic-floored bdrms & a versatile flex space—perfect for a family rm, 2nd kitchen, or Airbnb guest area. Two 1-bdrm apts offer income or guest potential—one above the main home w/sweeping views, stylish kitchen, bath & laundry; the other above the garage w/its own laundry, bath & river views. A 4-car-wide paved drvwy offers RV/boat parking. Shoreline is reinforced w/ \$150K+ of rock, giving the home its name: *On The Rocks*. More detailed information available on this homes own website: tobicolpitts.wixsite.com/on-the-rocks. Yearly rental income $37,200. Listed for less than its appraised value of $1.4 million!
For sale
C$1,295,000
92 Front St, Gagetown, NB E5M 1A1
--beds
--baths
4,275sqft
Triplex
Built in 2002
-- sqft lot
$-- Zestimate®
C$303/sqft
C$-- HOA
What's special
Riverfront homeBreathtaking sunrisesPanoramic windowsHigh-end appliancesOversized islandSpa-like ensuiteWaterfall shower
- 92 days
- on Zillow |
- 16 |
- 0 |
Zillow last checked: 7 hours ago
Listing updated: June 15, 2025 at 02:51am
Listed by:
Tobi Colpitts, Salesperson 220012630,
RE/MAX East Coast Elite Realty Brokerage,
Larry Booker, Salesperson,
RE/MAX East Coast Elite Realty
Source: New Brunswick Real Estate Board,MLS®#: NB117641
Originating MLS®#: Fredericton

Travel times
Facts & features
Interior
Heating
- Air Exchanger, Baseboard, Forced Air, Fireplace(s)
Cooling
- Air Exchanger, Central Air Conditioning
Appliances
- Included: Built-In Appliances, Cooktop, Dishwasher, Dryer, Refrigerator, Washer
- Laundry: Main Level
Features
- Air Exchanger
- Flooring: Ceramic Tile, Heated, Porcelain
- Basement: Concrete,Full,Walk-Out Access
- Has fireplace: Yes
Interior area
- Total structure area: 4,275
- Total interior livable area: 4,275 sqft
Video & virtual tour
Property
Parking
- Parking features: 4 Wide Plus Motor Rv, Asphalt, Paved, RV Access/Parking, ParkingYN, Garage
- Garage spaces: 26
- Has uncovered spaces: Yes
- Details: Garage Size(26x24 W/Loft)
Features
- Stories: 1.5
- Waterfront features: Beach Access, Waterfront, River
- Body of water: Saint John River
- Frontage length: Water Frontage(250')
Lot
- Size: 2,015 Square Feet
- Features: Beach, Cleared, Landscaped, Under 0.5 Acres
Details
- Parcel number: 45167814
Construction
Type & style
- Home type: MultiFamily
- Property subtype: Triplex
Materials
- Shingle Siding, Vinyl Siding
- Roof: Asphalt,Membrane
Condition
- Year built: 2002
Utilities & green energy
- Sewer: Backflow Valve, Municipal
- Water: Drilled
Community & HOA
Community
- Security: Alarm, Fire Alarm, Smoke Detector(s)
Location
- Region: Gagetown
Financial & listing details
- Price per square foot: C$303/sqft
- Annual tax amount: C$7,883
- Date on market: 5/5/2025
- Ownership: Freehold
- Total actual rent: 37200
- Loading