~ See video
Large beautiful ranch to be built. Step into the latest upscale living at Brookwood Estates Phase 2, Halfmoon's premier luxury home community. Crafted by the renowned CGM CONSTRUCTION ~ this development has 17 lots ranging from 1 to 4 acres, positioned on 2 cul-de-sacs within a neighborhood of high end residences. Each home is uniquely designed, with no duplicates among the ''custom'' plans.
SELECT YOUR PREFERRED LOT, noting that larger lots carry a premium. Whether you bring your own vision or collaborate with the builder and architect, your dream home awaits. Located in the Shenendehowa school district, this community is just minutes from shopping,,parks, and major highways. Welcome home to Brookwood Estates, where luxury meets individuality in the heart of Halfmoon.
Pending
$1,238,700
1 Ceremuga Court, Halfmoon, NY 12188
3beds
2,536sqft
Single Family Residence, Residential
Built in ----
1 Acres Lot
$1,272,000 Zestimate®
$488/sqft
$-- HOA
What's special
- 112 days |
- 7 |
- 0 |
Zillow last checked:
Listing updated:
Listed by:
REMAX Solutions 518-318-3800,
Sandra Jacobson 518-858-8083,
Richard C Jacobson 518-857-8093,
REMAX Solutions
Source: Global MLS,MLS#: 202614198
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Level: First
Bedroom
- Level: First
Bedroom
- Level: First
Primary bathroom
- Level: First
Half bathroom
- Level: First
Full bathroom
- Level: First
Dining room
- Level: First
Family room
- Level: First
Foyer
- Level: First
Kitchen
- Level: First
Laundry
- Level: First
Mud room
- Level: First
Office
- Level: First
Office
- Level: First
Other
- Level: First
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Included: Dishwasher, ENERGY STAR Qualified Appliances, Microwave, Oven, Range, Refrigerator
- Laundry: Laundry Room, Main Level
Features
- Other, Walk-In Closet(s), Ceramic Tile Bath, Eat-in Kitchen, Kitchen Island
- Flooring: Ceramic Tile, Hardwood, Laminate
- Doors: ENERGY STAR Qualified Doors, Sliding Doors
- Windows: ENERGY STAR Qualified Windows
- Basement: Other,Full,Unfinished
- Number of fireplaces: 1
- Fireplace features: Gas
Interior area
- Total structure area: 2,536
- Total interior livable area: 2,536 sqft
- Finished area above ground: 2,536
- Finished area below ground: 0
Property
Parking
- Total spaces: 6
- Parking features: Paved, Attached, Garage Door Opener
- Garage spaces: 2
Features
- Patio & porch: Front Porch
- Exterior features: Other, None
- Fencing: None
- Has view: Yes
- View description: Trees/Woods
Lot
- Size: 1 Acres
- Features: Level, Private, Cul-De-Sac
Details
- Parcel number: 1
- Zoning description: Single Residence
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Custom,Ranch
- Property subtype: Single Family Residence, Residential
Materials
- Other, Vinyl Siding
- Foundation: Concrete Perimeter
- Roof: Asphalt
Condition
- New construction: Yes
Utilities & green energy
- Electric: Underground, Circuit Breakers
- Sewer: Septic Tank
- Water: Public
- Utilities for property: Cable Available, Underground Utilities
Community & HOA
Community
- Security: Smoke Detector(s), Carbon Monoxide Detector(s)
- Subdivision: Brookwood Estates
HOA
- Has HOA: No
Location
- Region: Halfmoon
Financial & listing details
- Price per square foot: $488/sqft
- Date on market: 4/1/2026
- Listing terms: Other
Estimated market value
$1,272,000
$1.21M - $1.34M
$3,160/mo
Price history
| Date | Event | Price |
|---|---|---|
| 4/1/2026 | Pending sale | $1,238,700$488/sqft |
Source:  Global MLS #202614198 Report a problem | ||
| 4/1/2026 | Listed for sale | $1,238,700$488/sqft |
Source: Global MLS #202614198 Report a problem | ||
Public tax history
Tax history is unavailable.
Monthly payment
Climate risks
Neighborhood: 12188
Nearby schools
GreatSchools rating
- 7/10Shatekon Elementary SchoolGrades: K-5Distance: 4.7 mi
- 9/10Koda Middle SchoolGrades: 6-8Distance: 5.8 mi
- 8/10Shenendehowa High SchoolGrades: 9-12Distance: 5.4 mi
Schools provided by the listing agent
- Elementary: Shatekon
- High: Shenendehowa
Source: Global MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- $1,317,2634 bd4 ba5.5k sqft91 Devitt Rd, Waterford, NY 12188Off Market
- $975,0004 bd4 ba2.6k sqft8 Faulkner Dr, Waterford, NY 12188Sold
- $950,0003 bd4 ba2.8k sqft3 Faulkner Dr, Halfmoon, NY 12188New Construction
- $955,0004 bd3 ba1.9k sqft15 Faulkner Dr #15, Waterford, NY 12188New Construction
- $1,100,0004 bd4 ba2.7k sqft2 Ceremuga Ct, Waterford, NY 12188New Construction
- $249,08351.65 AcresBrookwood Rd, Waterford, NY 12188Off Market
- $870,0004 bd3 ba2.2k sqftLOT 3 Faulkner Dr, Waterford, NY 12188New Construction
- $1,250,0004 bd4 ba3k sqft4 Faulkner Dr, Waterford, NY 12188New Construction
A local agent can set up tours, give advice and negotiate with sellers.
Similar homes
- $1,250,0004 bd4 ba3k sqft4 Faulkner Drive, Waterford, NY 12188Active
MLS ID #202530652, Sandra Jacobson, Listing by: REMAX Solutions. Global MLS - $1,100,0004 bd4 ba2.7k sqft2 Ceremuga Court, Waterford, NY 12188Active
MLS ID #202612897, Sandra Jacobson, Listing by: REMAX Solutions. Global MLS - $955,0004 bd3 ba1.9k sqft15 Faulkner Drive #15, Waterford, NY 12188ActiveMLS ID #202612898, Sandra Jacobson, Listing by: REMAX Solutions. Global MLS
- $870,0004 bd3 ba2.2k sqftLot 3 Faulkner Drive, Waterford, NY 12188Active
MLS ID #202529669, Sandra Jacobson, Listing by: REMAX Solutions. Global MLS - $789,9003 bd3 ba1.9k sqftLot 1 Brookwood Road, Halfmoon, NY 12188ActiveMLS ID #202612947, Sandra Jacobson, Listing by: REMAX Solutions. Global MLS
- $1,200,0003 bd2 ba1.7k sqft264 Upper Newtown Road, Mechanicville, NY 12118ActiveMLS ID #202613407, Shane Wagner, Listing by: Vera Cohen Realty, LLC. Global MLS
- $842,7003 bd3 ba2.4k sqftL17 Van Patten Drive, Clifton Park, NY 12065ActiveMLS ID #202621587, James C Furey, Listing by: eXp Realty. Global MLS
- $1,098,5003 bd3 ba2.1k sqft548 NYS Route 9P, Stillwater, NY 12170ActiveMLS ID #202618498, Richard Gargiulo, Listing by: Sterling Real Estate Group. Global MLS
- $749,2003 bd2 ba2.1k sqftL12 Van Patten Drive, Clifton Park, NY 12065ActiveMLS ID #202621586, James C Furey, Listing by: eXp Realty. Global MLS
- $739,9003 bd3 ba2.8k sqft7 Jack Drive, Mechanicville, NY 12118ActiveMLS ID #202616800, John W Mesko, Listing by: Coldwell Banker Prime Properties. Global MLS
- $785,0003 bd2 ba2.1k sqft617 Kinns Road, Clifton Park, NY 12065ActiveMLS ID #202619726, Ferdinando Bruno, Listing by: REMAX Solutions. Global MLS
- $664,7004 bd3 ba2.4k sqft11 Jack Drive, Mechanicville, NY 12118ActiveMLS ID #202616807, John W Mesko, Listing by: Coldwell Banker Prime Properties. Global MLS
- $709,5004 bd3 ba2.1k sqft45 McBride Road, Mechanicville, NY 12118ActiveMLS ID #202610801, Douglas Bricker, Listing by: KW Platform. Global MLS
- $837,7954 bd3 ba2.5k sqft9 Mapleton Court, Clifton Park, NY 12065ActiveMLS ID #202615486, Christa Swistak, Listing by: Sterling Real Estate Group. Global MLS
- $779,9004 bd3 ba2.4k sqft360 Watervliet Shaker Road, Watervliet, NY 12189ActiveMLS ID #202617551, John W Mesko, Listing by: Coldwell Banker Prime Properties. Global MLS
- $814,6953 bd3 ba2.6k sqft5 Mapleton Court, Clifton Park, NY 12065ActiveMLS ID #202615281, Christa Swistak, Listing by: Sterling Real Estate Group. Global MLS
- from $655,9003 bd3 ba2.1k sqftOxford Plan, Juniper Ridge, Clifton Park, NY 12065New ConstructionBelmonte Builders
- $659,0003 bd2 ba1.9k sqft43 McBride Road, Clifton Park, NY 12065ActiveMLS ID #202610422, Douglas Bricker, Listing by: KW Platform. Global MLS
- $809,0004 bd3 ba3.1k sqft619 Kinns Road, Clifton Park, NY 12065ActiveMLS ID #202619727, Ferdinando Bruno, Listing by: REMAX Solutions. Global MLS
- $636,9953 bd2 ba1.8k sqft2 Clover Leaf Drive, Halfmoon, NY 12065ActiveGlobal MLS
