$814,900
Under contractAbout this home
Stunning Waterfront Condo with Private Patio & Spectacular Lamprey River Views Experience effortless waterfront living in this immaculate first-floor end-unit condominium, offering the rare combination of one-level living, a private patio, and an expansive courtyard overlooking the scenic Lamprey River. Enjoy morning coffee while watching eagles, osprey, herons, and other wildlife from your own outdoor retreat, or entertain friends against the backdrop of ever-changing river views. Inside, the sun-filled open-concept living, dining, and kitchen area showcases soaring ceilings, exposed brick walls, iron beams, oversized windows, plantation shutters, rich hardwood flooring.. Custom built-in cabinetry adds both elegance and functionality, while the beautifully updated kitchen features quartz countertops, a tile backsplash, an oversized center island, GE Profile stainless steel appliances, a five-burner gas range, and abundant storage. The spacious primary suite offers a walk-in closet and a beautifully renovated ensuite bath complete with a custom double vanity and a luxurious zero-entry tiled shower with premium hardware. A generous second bedroom, ideal as a guest room or home office, features double closets for exceptional storage. Additional amenities include central air conditioning, in-unit laundry, and over $50,000 in recent improvements, making this truly move-in ready. Outdoor enthusiasts will appreciate on-site kayak, paddleboard, and bicycle storage, along with a private dock providing easy access to the river. Residents also enjoy a community fitness room and two assigned on-site parking spaces. Located in one of New Hampshire's most charming historic mill towns, you'll love leaving the car behind and walking to exceptional restaurants, cozy coffee shops, local markets, the library, and live music at The Stone Church. This pet-friendly community offers an unmatched blend of waterfront tranquility and vibrant downtown living. Luxury, convenience, lifestyle.
Highlights
Property details
- MLS
- Prime MLS
- MLS #
- 5098052
- Property type
- Condominium
- Subdivision
- Bryant Rock
- Status
- Under contract
- Days on market
- 6
- On market date
- N/A
- Stories
- N/A
- Total bathrooms
- 2
- Garage spaces
- N/A
- Parking spaces
- N/A
- Lot size
- N/A
Location
Get directions →Nearby schools
Within 10 miles. School directory data from the National Center for Education Statistics (NCES), accessed via the Urban Institute Education Data API. Local Score is calculated by INNOVATE Real Estate; where a state rating is shown, it comes from that state's own official school report card.
- Enrollment
- 482
- Student:teacher ratio
- 11.5:1
- District
- Newmarket School District
- Enrollment
- 237
- Student:teacher ratio
- 11.3:1
- District
- Newmarket School District
- Enrollment
- 270
- Student:teacher ratio
- 9.3:1
- District
- Newmarket School District
Walkability
Blended score for Newmarket's center, calculated by INNOVATE Real Estate from two sources: the EPA's National Walkability Index (street network, transit, land-use mix) and Google Places amenity data (what's actually reachable on foot from this point). 60% EPA National Walkability Index + 40% nearby-amenity density (Google Places).
Market position
How this listing compares to current activity in Newmarket, from live MLS data.
Mortgage calculator
Estimate only - actual rate and payment depend on your lender, credit, and loan program.
Adjust tax / insurance estimates
Similar homes you might like

Copyright 2026 PrimeMLS. All rights reserved. This information is deemed reliable, but not guaranteed. The data relating to real estate displayed on this Site comes in part from the IDX Program of PrimeMLS. 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 07/14/26.
