2.76 km
Distance
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.
Source: Public Records
| Street Address | Beds | Baths | Sold Date | List Price |
|---|---|---|---|---|
| 206 Upper Golden Grove Road | 2 | 3 | May 16, 2026 | $199,900 |
Discover key demographics, population statistics, and environmental insights for the Quispamsis, NB area.
0/100
Car-Dependent
Walk Score ®
0/100
Minimal Transit
Transit Score ®
26/100
Bikable
Bike Score ®
Almost all errands require a car. It is possible to get on a bus. Minimal bike infrastructure.
The average walkability score in the surrounding area is Walk Score: 3/100, Transit Score: 0/100, Bike Score: 25/100.
2.76 km
Distance
3.18 km
Distance
3.18 km
Distance
2.64 km
Distance
3.37 km
Distance
3.3 km
Distance
3.3 km
Distance
3.37 km
Distance
499 m
Distance
1.8 km
Distance
1.96 km
Distance
2.69 km
Distance
2.7 km
Distance
2.78 km
Distance
2.86 km
Distance
3.34 km
Distance
5 bds • 2 ba • 25 sqft
26 Paige Street, Rothesay, NB E2E 0N8
3 bds • 2 ba • 28 sqft
6 Crestwood Drive, Rothesay, NB E2E 5H4
2 bds • 1 ba • 26 sqft
209 CRAWFORD, Saint John, NB E2N 1K8
2 bds • 2 ba • 29 sqft
1330 Route 705, Wickham, NB E5T 3W1
3 bds • 2 ba • 28 sqft
2121 Route 102, Gagetown, NB E5M 1K3
4 bds • 2 ba • 26 sqft
22 Burton Evergreen Drive, Burton, NB E2V 3E7
3 bds • 2 ba • 31 sqft
288 Pleasant Drive, Minto, NB E4B 2T1
4 bds • 2 ba • 26 sqft
584 Whittaker Road, Rusagonis, NB E3B 7Z7
4 bds • 2 ba • 25 sqft
20 Centennial Drive, Minto, NB E4B 3R9
4 bds • 2 ba • 24 sqft
412 Wetmore Road, Fredericton, NB E3B 5L5
3 bds • 3 ba • 32 sqft
67 Dewitt Acres, Fredericton, NB E3A 6S3
5 bds • 3 ba • 24 sqft
57 Oliver Crescent, New Maryland, NB E3C 1E2
3 bds • 2 ba • 28 sqft
6 Kennedy Court, St George, NB E5C 3G4
4 bds • 2 ba • 28 sqft
15 Brookside Lane, St George, NB E5C 1A5
4 bds • 2 ba • 31 sqft
285 Winslow Street, Fredericton, NB E3B 2A3
4 bds • 2 ba • 2572 sqft
45 Stock Farm Road
3 bds • 3 ba • 3043 sqft
111 Porter Road
3 bds • 3 ba • sqft
111 Porter Road
6 bds • 2 ba • 1806 sqft
680 Hampton Road
3 bds • 2 ba • 940 sqft
110 Model Farm Road
3 bds • 3 ba • sqft
3 Regal Drive
3 bds • 3 ba • 2576 sqft
3 Regal Drive
3 bds • 3 ba • 1920 sqft
39 Meteor Drive
3 bds • 3 ba • sqft
39 Meteor Drive
3 bds • 3 ba • 1620 sqft
7 Sycamore Drive
3 bds • 3 ba • sqft
11 Evergreen Park Drive
3 bds • 3 ba • 1868 sqft
11 Evergreen Park Drive
5 bds • 2 ba • 2675 sqft
19 Cliff Street
4 bds • 2 ba • 1852 sqft
36 Cliff Street
4 bds • 2 ba • 2300 sqft
37 Millican Drive
2 bds • 2 ba • sqft
28 Hamel Drive
3 bds • 2 ba • 1750 sqft
16 Banshee Court
3 bds • 2 ba • sqft
16 Banshee Court
3 bds • 1 ba • 1424 sqft
8 Saunders Street
Source: Realty.com
45 Stock Farm Road, Quispamsis, NB E2G 2A1 in Quispamsis, NB E2G 2A1 is a single family residence listed at $399,900. Highlights include 4 bedrooms, 2 bathrooms, 28 sq. ft., $14,282 per sq. ft.. Realty.ca has 48 photos, sales history, school insights, and mortgage tools for this listing.
Realty.com has 48 photos of 45 Stock Farm Road.
The full address for this home is 45 Stock Farm Road, Quispamsis, NB E2G 2A1.
45 Stock Farm Road has been listed on Realty.com since Tue June 02, 2026
Almost all errands require a car. It is possible to get on a bus. Minimal bike infrastructure.
The average walkability score in the surrounding area is Walk Score: 3/100, Transit Score: 0/100, Bike Score: 25/100.
Listing provided courtesy of:
Royal LePage Select Realty
(tel: (506) 847-0522)
Listing agent:
ADAM KETCHUM
(tel: (506) 977-1975)
This content last refreshed on 2026-06-04 22:20:02. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.