Simplicity, Harmony and a Respect for Nature. Discover Frank Lloyd Wright-inspired architecture, serene Great Bay water views, and carefree condominium living at The Ridge at Moody Point. This exceptional 3,300± SF custom-built detached condominium offers the privacy of a single-family home within one of Newmarket's most distinctive waterfront communities. Designed to embrace its natural surroundings, the expansive windows, soaring ceilings, rich cherry millwork and warm oak flooring combine to create an inviting atmosphere of understated elegance. The dramatic cathedral-ceiling Great Room features a gas fireplace with custom cherry built-ins and flows seamlessly into the dining area and beautifully appointed kitchen with Mission-style cherry cabinetry, Cashmere Gold granite, and stainless appliances. Two generous main-level bedroom suites offer private baths and walk-in closets. The primary retreat features a tray ceiling, beautiful sunrise views over Great Bay, and a spa-inspired bath with whirlpool tub and tiled shower. The daylight lower level provides two additional bedrooms, a full bath, spacious family room with gas fireplace, and abundant storage. Enjoy southerly sunshine and gentle bay breezes from the mahogany deck or retreat to the private garden courtyard off the kitchen. The capacious 2-car garage affords ample room for cars and hobby equipment. A chair lift provides easy access to the main level. Efficient hydro-air heating and central air enhance year-round comfort. Moody Point residents enjoy 3,600± feet of commonly owned shoreline, scenic walking trails, a community dock, waterfront screened pavilion, and boat storage. Association-maintained exteriors, landscaping, and snow removal offer the freedom to enjoy life without the upkeep. Minutes to UNH, Portsmouth, and downtown Newmarket, with easy access to major routes. An extraordinary blend of architecture, nature, and effortless Seacoast living. Delayed showings starting Friday, Oct. 16, 2026.
Active under contract
Listed by: Appledore Real Estate • Valerie Shelton • 603-659-0199
$1,025,000
237 Cushing Road, Newmarket, NH 03857
4beds
3,308sqft
Condominium
Built in 2004
-- sqft lot
$1,006,500 Zestimate®
$310/sqft
$-- HOA
What's special
Beautifully appointed kitchenDramatic cathedral-ceiling great roomMahogany deckStainless appliancesSoaring ceilingsExpansive windowsWarm oak flooring
- 27 days
- 804
- 47
Zillow last checked:
Listing updated:
Listed by:
Valerie Shelton,
Appledore Real Estate 603-659-0199
Source: PrimeMLS,MLS#: 5114165
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Heating
- Propane, Baseboard, Direct Vent, Forced Air, Hot Air, Hot Water, Zoned
Cooling
- Central Air, Zoned
Appliances
- Included: Dishwasher, Dryer, Microwave, Refrigerator, Water Heater off Boiler, Tank Water Heater, Dual Fuel Range
- Laundry: 1st Floor Laundry
Features
- Central Vacuum, Ceiling Fan(s), Dining Area, Living/Dining, Primary BR w/ BA, Natural Light, Vaulted Ceiling(s), Walk-In Closet(s)
- Flooring: Hardwood, Tile
- Windows: Blinds, Screens
- Basement: Full,Partially Finished,Storage Space,Exterior Entry,Interior Entry
- Number of fireplaces: 2
- Fireplace features: Gas, 2 Fireplaces
Interior area
- Total structure area: 3,984
- Total interior livable area: 3,308 sqft
- Finished area above ground: 1,992
- Finished area below ground: 1,316
Video & virtual tour
Property
Parking
- Total spaces: 2
- Parking features: Paved
- Garage spaces: 2
Features
- Levels: One
- Stories: 1
- Patio & porch: Patio
- Exterior features: Deck, ROW to Water
- Has spa: Yes
- Spa features: Bath
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- Body of water: Great Bay
Lot
- Features: Condo Development, Level, Trail/Near Trail, Views, Walking Trails, Near Paths
Details
- Parcel number: NMARMR2B36L71B
- Zoning description: R1
- Special conditions: Standard
- Other equipment: Radon Mitigation
Construction
Type & style
- Home type: Condo
- Architectural style: Contemporary,Ranch
- Property subtype: Condominium
Materials
- Wood Frame, Cedar Exterior, Clapboard Exterior
- Foundation: Poured Concrete
- Roof: Architectural Shingle
Condition
- New construction: No
- Year built: 2004
Utilities & green energy
- Electric: 200+ Amp Service, Circuit Breakers, Underground
- Sewer: Community, Public Sewer, Pumping Station
- Utilities for property: Cable, Propane, Telephone at Site, Underground Utilities, Fiber Optic Internt Avail
Community & HOA
Community
- Security: HW/Batt Smoke Detector
HOA
- Amenities included: Master Insurance, Landscaping, Common Acreage, Day Dock, Snow Removal, Trash Removal
- Services included: Maintenance Grounds, Other, Plowing, Condo Association Fee
- Additional fee info: Fee: $750
Location
- Region: Newmarket
Financial & listing details
- Price per square foot: $310/sqft
- Tax assessed value: $1,061,200
- Annual tax amount: $20,609
- Date on market: 10/14/2026
Estimated market value
$1,006,500
$956,000 - $1.06M
$4,698/mo
Price history
| Date | Event | Price |
|---|---|---|
| 10/14/2026 | Listed for sale | $1,025,000+69.5%$310/sqft |
Source:  PrimeMLS #5114165 Report a problem | ||
| 2/21/2020 | Sold | $604,800-4.8%$183/sqft |
Source: PrimeMLS #4752240 Report a problem | ||
| 10/11/2019 | Price change | $635,000-3.6%$192/sqft |
Source: Appledore Real Estate #4752240 Report a problem | ||
| 8/8/2019 | Price change | $659,000-2.4%$199/sqft |
Source: Appledore Real Estate #4752240 Report a problem | ||
| 8/2/2019 | Price change | $675,000-1.5%$204/sqft |
Source: Appledore Real Estate #4752240 Report a problem | ||
| 5/17/2019 | Listed for sale | $685,000+3.8%$207/sqft |
Source: Appledore Real Estate #4752240 Report a problem | ||
| 1/12/2006 | Sold | $660,000$200/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $18,253 +13.6% | $1,061,200 +94.7% |
| 2023 | $16,072 +9.3% | $545,000 |
| 2022 | $14,710 +6% | $545,000 |
| 2020 | $13,876 +28.4% | $545,000 +47.5% |
| 2018 | $10,804 +9.4% | $369,500 |
| 2017 | $9,877 +5% | $369,500 |
| 2016 | $9,404 +2% | $369,500 |
| 2015 | $9,223 -3.1% | $369,500 |
| 2014 | $9,515 -16.2% | $369,500 -23% |
| 2012 | $11,352 -3.6% | $479,600 -10.9% |
| 2009 | $11,770 | $538,200 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 03857
Nearby schools
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.
Similar homes
- $750,0003 bd4 ba2.5k sqftThe Ridge at Moody Point, Newmarket, NH 03857Active
MLS ID #5077863, Valerie Shelton. PrimeMLS - $699,9003 bd3 ba2.3k sqftThe Ridge at Moody Point, Newmarket, NH 03857Active
MLS ID #5108966, Valerie Shelton. PrimeMLS - $750,0003 bd4 ba2.5k sqftThe Ridge at Moody Point, Newmarket, NH 03857Active
MLS ID #5079540, Valerie Shelton. PrimeMLS - $1,459,0003 bd3 ba3.1k sqft20 Cheswill Street, Newmarket, NH 03857Active
MLS ID #5116197, Foss & Russell Group. PrimeMLS - $1,150,0003 bd3 ba2.3k sqft27 Pocahontas Road, Kittery, ME 03905Active
MLS ID #1683360, The Aland Realty Group. Maine Listings
