- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
Listed by: Valerie Shelton | Appledore Real Estate (603) 659-0199
$1,025,000
Monthly Est:$5,102
4 Beds
- 5 Baths
4 full baths + 1 half bath
1,992sqft
237 Cushing Rd, Newmarket, NH 03857
$1,025,000
$5,102/moEst:
Get Pre-Approved
Condominium
Built in 2004
$-- HOA
-- sqft lot
$515/sq.ft
Description
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.
- Houzeo last checked: 3 hours ago
- Listing updated: October 22, 2026 at 5:39 pm
- Source: NEREN/Prime MLS-NH | MLS#: 5114165

Property Details
Status
Active Under Contract
Type
Condominium
No. of Stories
-
County
City
Neighborhood
--
Year Built
2004
HOA Fees
-
Finished Area
1,992 sqft
Lot Size
-- sqft lot
Basement Area
- sqft
MLS Name
NEREN/Prime MLS
MLS Number
5114165
MLS Status
(31) Under Contract - Active Under Contract
Days on Market
15

Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 4
Bathrooms: 5
Interior
Interior Features
Central Vacuum, Blinds, Ceiling Fan(s), Dining Area, Gas Fireplace, 2 Fireplaces, Living/dining, Primary Br W/ Ba, Natural Light, Vaulted Ceiling(s), Walk In Closet(s), Whirlpool Tub, 1st Floor Laundry
Cooling
Central Air, Zoned
Appliances
Dishwasher, Dryer, Microwave, Refrigerator, Water Heater Off Boiler, Tank Water Heater, Dual Fuel Range
Exterior Features
Deck, Patio, Row To Water, Window Screens
Heating
Propane, Baseboard, Direct Vent, Forced Air, Hot Air, Hot Water, Zoned
Sewer
Community, Public, Pumping Station
Flooring
Hardwood, Tile
Construction
Year Built
Year Built: 2004
Home type
Condominium
Property Condition
Existing
Architectural Style
Contemporary, Ranch
Foundation Details
Poured Concrete
Roof
Architectural Shingle
Construction Materials
Wood Frame, Cedar, Clapboard
Utilities & Energy
Association Amenities
Clubhouse, Insurance, Landscaping, Common Acreage, Day Dock, Snow Removal, Trash
Electric
200+ Amp Service, Circuit Breakers, Underground
Basement
Full, Partially Finished, Storage Space, Exterior Entry
Water Source
Public
Utilities
Cable, Propane, Phone Connected, Underground Utilities
Other Features
Lot Features
Condo Development, Level, Trail/near Trail, Views, Walking Trails, Near Paths
Price History
| Date | Event | Price |
|---|---|---|
10/22/2026 Source: | Contingent (Active Under Contract) | $1,025,000 +69.48% $515/sqft |
02/21/2020 Source: | Sold | $604,800 $304/sqft |
Nearby Homes
Find Homes by Property Features in Newmarket, NH
Based on information from PrimeMLS Inc. through Oct 29, 2026, 02:16PM. This display of listings may or may not be the entire Compilation from the PrimeMLS database, and PrimeMLS does not guarantee the accuracy of such information. The listing broker's offer of compensation is made only to other real estate licensees who are participant members of PrimeMLS. 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 Oct 29, 2026, 02:16PM. © 2026 PrimeMLS, Inc. All Rights Reserved.
Advertising Broker: Derek Greene | The Greene Realty Group







