45 Stock Farm Road Quispamsis, NB E2G 2A1
Listing Courtesy of: NEW BRUNSWICK REAL ESTATE BOARD / Royal Lepage Select Realty

  45 Stock Farm Road Quispamsis, NB E2G 2A1

Active
$399,900 (CAD)
4
BED
2
BATH
2,572
SQFT

Description

Nestled along the picturesque shores of the Hammond River, this beautifully maintained waterfront home offers the perfect blend of comfort, privacy, and year-round outdoor adventure. Set on a mature, treed lot this property provides a peaceful retreat while remaining conveniently located just minutes from Hampton and Quispamsis.

From the moment you arrive, you'll be captivated by the warm character of the cedar-style exterior, expansive decking, and stunning river views. Whether you're enjoying your morning coffee overlooking the water or entertaining family and friends on the oversized deck, every outdoor space has been designed to take full advantage of this incredible setting. Launch your kayak from your own shoreline, spend the afternoon casting a line, or simply sit back and enjoy the sights and sounds of the river from your backyard.

Inside, the spacious kitchen features abundant cabinetry, modern finishes, and easy access to the dining area, where large windows frame beautiful water views. The adjoining living spaces are warm and welcoming, making this home ideal for everyday living.

The home offers 3 bedrooms plus a den/office, 2 full bathrooms, and a fully finished walkout basement, providing flexibility for growing families, guests, or those working from home. Comfort is ensured year-round with a heat pump, electric baseboard heating, and the added charm and warmth of a wood stove. Some recent updates include: metal roof, finished basement, deck, and appliances.

If you've been dreaming of waterfront living where you can fish, kayak, canoe, entertain, and unwind in a truly beautiful natural setting, 45 Stock Farm Road delivers a lifestyle that's hard to match. Don't miss your opportunity to own this exceptional Hammond River property and experience the very best of riverfront living.

MLS®:
NB140762
Taxes
$3,716(2026)
Lot Size
0.52 acres
Type
Single-Family Home
County
Quispamsis

Listed By

Adam Ketchum, Coldwell Banker Select Realty
Source
NEW BRUNSWICK REAL ESTATE BOARD
Last checked Jun 2 2026 at 7:30 PM GMT+0000
Bathroom Details
Interior Features
  • Laundry
Property Features
  • Cleared-Part
  • Beach
  • Fireplace: 0
Heating and Cooling
  • Stove - Wood
  • Baseboard
  • Electric
  • Heat Pump - Ductless
Flooring
  • Wood
  • Carpet
  • Other
Exterior Features
  • Wood
  • Roof: Metal
Location
   
Calculate drive times to this property
 
Powered by INRIX® Drive Time

Powered by Walk Score®
Disclaimer: Copyright 2026 The New Brunswick Real Estate Board, All rights reserved. This information is deemed reliable, but not guaranteed. The information being provided is for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated 6/2/26 12:30