Listing Tools

Listed by Lee Ann Parks of EXP Realty (Cell: 603-978-6666)
Experience luxury waterfront living in this exceptional executive rental, masterfully designed by TMS Architects and offering 2,360 square feet of sophisticated living space with spectacular west-facing water views. Thoughtfully appointed with premium finishes and upscale amenities, this beautifully maintained end-unit condominium features three bedrooms, two full baths, two half baths, and a private elevator servicing every level. The chef's kitchen is designed to impress with custom wood cabinetry, quartz countertops, and a professional Thermador appliance package, while wide-plank rustic white oak flooring, designer lighting, custom plantation shutters, and a sleek linear gas fireplace create an elegant yet comfortable atmosphere throughout. The spacious primary suite offers a luxurious retreat with a spa-inspired bath featuring a custom-tiled walk-in shower. A dramatic 12-foot sliding French door opens to a private balcony where you can unwind while taking in breathtaking sunsets over the water. Additional amenities include a two-car garage with an EV charging station, standby generators for added peace of mind, and designer window treatments throughout. For boating enthusiasts, a deeded deep-water dock slip in the new marina is available, providing direct access to New Hampshire's navigable rivers and the Atlantic Ocean. Perfectly located just six miles from downtown Portsmouth, this premier executive rental offers convenient access to Portsmouth, Durham, Pease International Tradeport, and major commuter routes while providing a peaceful waterfront setting unlike any other. Whether you're relocating, on an extended work assignment, or simply seeking a luxury furnished residence, this remarkable home offers an unparalleled coastal lifestyle with every modern convenience.

Property Details of 28 Little Bay Drive, Unit 28

Map Location

Driving Directions

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 June 30, 2026 7:53 PM UTC

 

Hi there! How can we help you?

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

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from Waterville Estates Realty. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

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.