This beautiful Moody Point on Great Bay detached condo offers extensive upgrades and superior privacy. The open floor plan is well-suited for both entertaining and daily living and features decorative tile and hardware flooring throughout. The designer kitchen includes cherry cabinets, granite countertops, stainless steel appliances, a double pantry with solid shelving, and a raised bar overlooking the dining and living areas. A tray ceiling and gas fireplace with a granite surround and custom built-ins serve as an elegant focal point. The first-floor bedroom provides a custom walk-in closet and a contemporary ¾ ensuite bath equipped with a bidet washlet and step-in shower. The capacious upstairs primary suite presents seasonal bay views and a huge closet with extensive custom organizers illuminated by natural light. An adjoining fully renovated ensuite bathroom is appointed with a spacious glass enclosure decorative tiled shower, dual vanity sinks with quartz countertop and a Toto bidet toilet. The daylight lower level includes a third bedroom, office, full bath, and family room with direct access to a large private outdoor patio. Additional amenities comprise a sizable unfinished storage/mechanical/hobby room, an attached two-car garage, and a covered front porch. Designed for comfort and energy efficiency, the home incorporates LED lighting, WiFi thermostats, hybrid heat pump water heater, and a high-efficiency heat pump heating and cooling system (1st and 2nd floor). The association is exceptionally well managed with a focus on protecting owners’ values. Community amenities include abundant nature, a variety of social activities, private shorefront walking trails, waterfront pavilion with expansive views across Great Bay, and a large pier and dock with kayak launch. The location is conveniently minutes from Newmarket’s vibrant downtown, featuring acclaimed restaurants, boutique shops, a lively arts and music scene, and nearby golf and fitness facilities.
Active
Listed by: Appledore Real Estate
$850,000
228 Cushing Road #A, Newmarket, NH 03857
3beds
2,569sqft
Est.:
Condominium
Built in 2000
-- sqft lot
$-- Zestimate®
$331/sqft
$-- HOA
What's special
Private shorefront walking trailsAttached two-car garageLarge private outdoor patioOpen floor planTray ceilingCovered front porchToto bidet toilet
- 8 hours |
- 457 |
- 8 |
Zillow last checked: 8 hours ago
Listing updated: 11 hours ago
Listed by:
Valerie Shelton,
Appledore Real Estate 603-659-0199
Source: PrimeMLS,MLS#: 5077863
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 4
- 3/4 bathrooms: 3
- 1/2 bathrooms: 1
Heating
- Propane, Multi Fuel, Baseboard, Direct Vent, Electric, Heat Pump, Hot Air, Hot Water, Zoned
Cooling
- Central Air, Zoned
Appliances
- Included: Dishwasher, Dryer, Microwave, Electric Range, Refrigerator, Washer, Induction Cooktop, Heat Pump Water Heater
- Laundry: 1st Floor Laundry
Features
- Ceiling Fan(s), Dining Area, LED Lighting, Living/Dining, Primary BR w/ BA, Vaulted Ceiling(s), Walk-In Closet(s), Programmable Thermostat, Smart Thermostat
- Flooring: Ceramic Tile, Hardwood, Vinyl Plank
- Windows: Blinds
- Basement: Daylight,Full,Partially Finished,Storage Space,Walkout,Walk-Up Access
- Attic: Attic with Hatch/Skuttle
- Number of fireplaces: 1
- Fireplace features: Gas, 1 Fireplace
Interior area
- Total structure area: 2,868
- Total interior livable area: 2,569 sqft
- Finished area above ground: 1,720
- Finished area below ground: 849
Video & virtual tour
Property
Parking
- Total spaces: 2
- Parking features: Paved, Auto Open, Direct Entry, Deeded, Attached
- Garage spaces: 2
Accessibility
- Accessibility features: 1st Floor 3/4 Bathroom, 1st Floor Bedroom, 1st Floor Hrd Surfce Flr, 1st Floor Laundry, Bathroom w/Step-in Shower, Hard Surface Flooring, Kitchen w/5 Ft. Diameter, Paved Parking
Features
- Levels: 2.5
- Stories: 2.5
- Patio & porch: Patio, Covered Porch
- Waterfront features: Deep Water Access, Tidal
- Body of water: Great Bay
Lot
- Features: Condo Development, Landscaped, Level, Trail/Near Trail, Walking Trails, Near Golf Course, Neighborhood
Details
- Zoning description: RESIDENTIAL
- Other equipment: Portable Generator, Radon Mitigation
Construction
Type & style
- Home type: Condo
- Property subtype: Condominium
Materials
- Wood Frame, Cedar Exterior, Clapboard Exterior
- Foundation: Poured Concrete
- Roof: Architectural Shingle
Condition
- New construction: No
- Year built: 2000
Utilities & green energy
- Electric: 200+ Amp Service, Circuit Breakers, Generator Ready, Underground
- Sewer: Metered, Public Sewer
- Utilities for property: Cable, Propane, Underground Utilities, Fiber Optic Internt Avail
Community & HOA
Community
- Security: HW/Batt Smoke Detector
- Subdivision: The Ridge at Moody Point on Great Bay
HOA
- Amenities included: Common Acreage, Day Dock, Landscaping, Master Insurance, Other, Recreation Room, RV/Boat Storage, Snow Removal, Trash Removal
- Services included: Condo Association Fee, Maintenance Grounds, Other, Plowing
- Additional fee info: Fee: $750
Location
- Region: Newmarket
Financial & listing details
- Price per square foot: $331/sqft
- Tax assessed value: $787,900
- Annual tax amount: $15,301
- Date on market: 3/2/2026
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 3/2/2026 | Listed for sale | $850,000$331/sqft |
Source:  PrimeMLS #5077863 Report a problem | ||
Public tax history
Public tax history
Tax history is unavailable.BuyAbility℠ payment
Est. payment
$4,979/mo
Principal & interest
$4001
Property taxes
$978
Climate risks
Neighborhood: 03857
Nearby schools
GreatSchools rating
- 9/10Newmarket Elementary SchoolGrades: PK-5Distance: 2.1 mi
- 4/10Newmarket Jr.-Sr. High (Elem)Grades: 6-8Distance: 1.9 mi
- 7/10Newmarket Jr.-Sr. High SchoolGrades: 9-12Distance: 1.9 mi
Schools provided by the listing agent
- Elementary: Newmarket Elem School
- Middle: Newmarket Junior High School
- High: Newmarket Senior HS
- District: Newmarket SAU #31
Source: PrimeMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Local experts in 03857
