Waterfront Retreat with Airbnb Potential! Down a quiet lane where the wild winds play, Sits a treasure by the water in a tucked away bay. With 4.17 acres and a beach, And 164 feet of water front within reach. Whether you're dreaming of staying or choosing to share, This setup’s ideal for an Airbnb affair. Bring in the guests, or simply unwind You’ve got the room, the views, and peace of mind. A Keystone RV, 9 foot ceilings, and stunning view. California King and a Queen too Two slide-outs keep it spacious and clean. An electric fireplace glows to make it a cozy place Fridge, microwave, stove in line, Double sink and storage, That's perfectly fine. Central vac, stand-alone A/C, and tv Hooked to septic and well, all turnkey. A deck connects from the RV to a one bedroom, bachelor suite With a full bathroom, it’s quite the treat! Overlooking the water at bay through the screened in wall I must say! 100-amp panel, well, and new rocks laid, A cottage awaits, with room to grow, Aluminum stairs, beach bridge too, An ice shack for winter? It’s ready for you! An escape, for swimming and play, Or simply to sit and watch boats drift away. Whether sunrise or sunset, the views are divine, You’ll never grow tired of this shoreline! To live or earn Airbnb cheer, This waterfront dream is crystal clear. Contact your Realtor as if you delay, This waterfront opportunity could be gone right away!! Drone video was taken by vendors June 2024
For sale
C$287,000
5340 117th Rte, Hardwicke, NB E9A 1C9
1beds
320sqft
Mixed Use
Built in ----
4.17 Acres Lot
$-- Zestimate®
C$897/sqft
C$-- HOA
What's special
Stunning viewElectric fireplaceFridge microwave stoveDouble sinkCentral vacOne bedroom bachelor suite
- 45 days
- on Zillow |
- 86 |
- 6 |
Zillow last checked: 7 hours ago
Listing updated: June 28, 2025 at 03:21am
Listed by:
Barbara Mackinnon, Salesperson 210004061,
Royal LePage Atlantic Brokerage
Source: New Brunswick Real Estate Board,MLS®#: NB121319
Originating MLS®#: Northern & Valley

Travel times
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 1
- Bathrooms: 1
- Full bathrooms: 1
Other
- Level: Main
Other
- Level: Main
Heating
- Baseboard, Electric
Cooling
- Electric
Features
- Flooring: Other
- Basement: Block
- Has fireplace: No
Interior area
- Total structure area: 320
- Total interior livable area: 320 sqft
- Finished area above ground: 320
Video & virtual tour
Property
Parking
- Parking features: Gravel, Parking Spaces, RV Access/Parking, No Garage
- Has uncovered spaces: Yes
Features
- Has view: Yes
- View description: Water, Ocean
- Has water view: Yes
- Water view: Water,Ocean
- Waterfront features: Beach Access, Waterfront, Ocean Front, Other
- Body of water: Baie St.Anne
- Frontage length: Water Frontage(164 Ft)
Lot
- Size: 4.17 Acres
- Features: Beach, Cleared, Cleared-Part, Level, Treed, 3.0 - 9.99 Acres
Details
- Parcel number: 40452492
- Other equipment: No Rental Equipment
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Mixed Use
Materials
- Vinyl Siding
- Foundation: Posts
- Roof: Asphalt
Utilities & green energy
- Sewer: Septic Tank
- Water: Well
Community & HOA
Location
- Region: Hardwicke
Financial & listing details
- Price per square foot: C$897/sqft
- Annual tax amount: C$565
- Date on market: 6/26/2025
- Ownership: Freehold
- Loading