Listing Tools

Welcome to the beautiful Twin Rivers community, where every day feels like a getaway. This pet-friendly waterfront condo offers direct access to the Lamprey River, with a community dock and boat launch. Enjoy kayaking, canoeing, fishing, swimming, or simply explore the surrounding conservation land and nature trails. Inside, a welcoming breezeway leads to a bright and inviting home featuring a spacious eat-in kitchen with a charming sunny bay window. The living room showcases beautiful water views and opens to a cozy private deck- the perfect spot to relax with your morning coffee or unwind while watching herons and local wildlife along the river. Upstairs, you will find two generously sized bedrooms with large closets and a full bathroom. The finished basement provides valuable additional living space and features a walkout slider to a private patio. Bring the beauty of the waterfront right to your doorstep. Enjoy the ease of condo living with landscaping, plowing, and trash removal included. Two assigned parking spaces plus ample visitor parking make everyday living convenient for you and your guests. Just a short walk to downtown Newmarket's shopping, restaurants, and entertainment. Walk to the nearest bus stop (Coast Connector) which provides easy access to Exeter and Stratham. Whether you are looking for a peaceful retreat, and active outdoor lifestyle, or the convenience of being close to everything, this is a rare opportunity to experience the best of Newmarket living. Don't miss your chance to call this beautiful community home!

Property Details of 709 Piscassic Street

Property Details

Interior Features

Exterior Features

Utilities and Appliances

Community

Other Details

Nearest Landvest Office

Concord, NH

Concord, NH

3 Eagle Square,
Concord, NH 03301

Never Miss New Listings

Never miss new listings between $328,000 - $401,000 in this neighborhood
Successfully Subscribed!
Do not fill in this field:

We respect your privacy. By submitting this form, you agree to receive communication from LandVest. We will never share or sell your information. You can opt-out at any time.

We will never spam you or sell your details. You can unsubscribe whenever you like.

Map Location

Do not fill in this field:

We respect your privacy. By submitting this form, you agree to receive communication from LandVest. We will never share or sell your information. You can opt-out at any time.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Schedule A Visit

Schedule a Visit

We respect your privacy. By submitting this form, you agree to receive communication from LandVest. We will never share or sell your information. You can opt-out at any time.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Broker Reciprocity 

Copyright 2026 PrimeMLS, Inc. All rights reserved. This information is deemed reliable, but not guaranteed. The data relating to real estate displayed on this display 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 October 11, 2026 6:52 AM UTC

 

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

We respect your privacy. By submitting this form, you agree to receive communication from LandVest. We will never share or sell your information. You can opt-out at any time.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.