For Sale: 45 Stock Farm Road, Quispamsis, NB

About this home

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. (id:63626)

Listed by: Adam Ketchum, Salesperson, Royal LePage Select Realty

Home facts and features

Price details

List Price

$399,900

Gross Taxes for 2026

$3,716

Home facts

Bedrooms

Full Bathrooms

Property Type

House

Lot Size

22604 ft²

Depth

Title

Freehold

Exterior Finish

Wood

Heating Type

Heat Pump, Baseboard heaters, Stove, Electric, Wood

Cooling

Heat Pump

Features

Balcony/Deck/Patio, Beach, Visual exposure

Agent details

Primary Agent

Adam Ketchum

Primary Broker

Royal LePage Select Realty

Secondary Agent

Mary Ann Ketchum

Secondary Broker

Royal LePage Select Realty

Listing details

Days on REW

6 Days

MLS® Number

NB140762

Source

Canadian Real Estate Association

Is this your listing? Help it to stand out.

Mortgage Calculator

The displayed rates are provided as guidance only, are not guaranteed, or are to be considered an approval of credit. Approval will be based solely on your personal situation. You are encouraged to speak with a Mortgage Professional for the most accurate information and to determine your eligibility.

Property Insights

Schools nearby

10 Schools are within 8km

Kennebecasis Valley High School

n/a
9 - 12
In Catchment

École Des Pionniers

n/a
K - 5
In Catchment

Quispamsis Middle School

n/a
6 - 8
In Catchment

Chris Saunders Memorial Elementary School

n/a
K - 5
In Catchment

Quispamsis Elementary School

n/a
K - 5
In Catchment

Lakefield Elementary School

n/a
K - 5
In Catchment

Valley Christian Academy

n/a
K - 9
In Catchment

Fairvale Elementary School

n/a
K - 5
In Catchment

Touchstone Community School

n/a
K - 5
In Catchment

Harry Miller Middle School

n/a
6 - 8
In Catchment

45 Stock Farm RoadQuispamsis, NB, E2G 2A1