Active Under Contract
3D Tour3D Tour
Condo for sale at 237 Cushing Rd, Newmarket, NH 03857 | MLS# 5114165 | Listing updated on 2026-10-22
Photo 1 of Condo for sale at 237 Cushing Rd, Newmarket, NH 03857 | MLS# 5114165 | Listing updated on 2026-10-22
Photo 2 of Condo for sale at 237 Cushing Rd, Newmarket, NH 03857 | MLS# 5114165 | Listing updated on 2026-10-22
Photo 3 of Condo for sale at 237 Cushing Rd, Newmarket, NH 03857 | MLS# 5114165 | Listing updated on 2026-10-22
Photo 4 of Condo for sale at 237 Cushing Rd, Newmarket, NH 03857 | MLS# 5114165 | Listing updated on 2026-10-22
52+
Beds Icon

Virtual Tour

Beds Icon

Street View

Listed by: Valerie Shelton | Appledore Real Estate (603) 659-0199

$1,025,000

Monthly Est:$5,102

  • Beds Icon4 Beds
  • Beds Icon
    5 Baths
  • Beds Icon1,992sqft

237 Cushing Rd, Newmarket, NH 03857

$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 NEREN/Prime MLS-NH

Property Details

  • Status

    Active Under Contract

  • Type

    Condominium

  • No. of Stories

    -

  • County

    Nh Rockingham County

  • City

    Newmarket

  • 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!

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

DateEventPrice

10/22/2026

Source: mls_logoNEREN/Prime MLS-NH #5114165

Contingent (Active Under Contract)

$1,025,000 +69.48%

$515/sqft

02/21/2020

Source: mls_logoNEREN/Prime MLS-NH #4752240

Sold

$604,800

$304/sqft

Nearby Homes

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

Skip to Main Content