Skip main navigation
For sale
  • C$399,900

    45 Stock Farm Rd, Quispamsis, NB E2G 2A1

    4beds
    2,572sqft
    SingleFamily
    Built in ----
    2,100 Square Feet Lot
    $-- Zestimate®
    C$155/sqft
    C$-- HOA

    What's special

    Waterfront homeMature treed lotCedar-style exteriorExpansive deckingStunning river viewsOversized deckSpacious kitchen
    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.
    6 hours
    |
    26
    |
    2
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    ADAM KETCHUM, Salesperson,

    Royal LePage Select Realty Brokerage,

    MARY ANN KETCHUM, Salesperson,

    Royal LePage Select Realty

    Source: New Brunswick Real Estate Board,MLS®#: NB140762

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 2
      • Full bathrooms: 2
      Bedroom
      • Level: Main
      Bedroom
      • Level: Second
      Bedroom
      • Level: Second
      Bathroom
      • Level: Main
      Other
      • Level: Lower
      Dining room
      • Level: Main
      Laundry
      • Level: Lower
      Living room
      • Level: Main
      Other
      • Level: Lower
      Rec room
      • Level: Lower
      Heating
      • Baseboard, Electric, Wood Stove
      Cooling
      • Electric, Heat Pump - Ductless
      Appliances
      • Included: Water Heater
      • Laundry: Inside
      Features
      • Flooring: Carpet, Wood, Other
      • Basement: Finished,Walk-Out Access
      • Has fireplace: No
      Interior area
      • Total structure area: 2,572
      • Total interior livable area: 2,572 sqft
      • Finished area above ground: 1,536

      Property

      Parking
      • Parking features: Private, Other, No Garage
      • Has uncovered spaces: Yes
      Features
      • Has water view: Yes
      • On waterfront: Yes
      • Waterfront features: Beach Access, Waterfront, River
      • Body of water: Hammond River
      Lot
      • Size: 2,100 Square Feet
      • Features: Beach, Cleared-Part, Fishing, Visual Exposure, 0.5 -0.99 Acres
      Details
      • Parcel number: 00255133

      Construction

      Type & style
      • Home type: SingleFamily
      Materials
      • Wood Siding
      • Foundation: Concrete
      • Roof: Metal

      Utilities & green energy

      • Sewer: Septic Tank
      • Water: Well

      Community & HOA

      Location
      • Region: Quispamsis

      Financial & listing details

      • Price per square foot: C$155/sqft
      • Annual tax amount: C$3,716
      • Date on market: 6/2/2026
      • Ownership: Freehold
      ADAM KETCHUM, Salesperson

      ADAM KETCHUM, Salesperson

      (506) 977-1975

      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.

        Price history

        Price history is unavailable.

        Public tax history

        Tax history is unavailable.

        Climate risks

        Neighborhood: E2G

        Getting around

        0 / 100
        Car-Dependent
        26 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        No schools nearby

        We couldn't find any schools near this home.

        Similar homes

        Skip to the end of the carouselSkip to the beginning of the carousel