Loading listing
Active
$123,000 price cut · was $1,998,000
$1,875,000
248 Van Wies Point Road
Glenmont, NY 12077 · Albany County
4Beds
4.5Baths
5,582Sq Ft
1.94acres lot
2006Year Built
$336Per Sq Ft
MLS# 202617794 Updated 1 week ago
Sharon’s Take
This 5,582 square foot Hudson River estate on nearly two acres offers direct waterfront access with approximately 300 feet of riverfront. The 2006 home contains four bedrooms, four and a half baths, and an in-law suite, along with a finished basement featuring a recreation room. The main residence includes a gourmet kitchen, first-floor office and library, master suite with private terrace, and great room, while the guest cottage provides three additional bedrooms with parking and deck. The property features an in-ground infinity pool, tennis court, central vacuum, wet bar, and is situated in the Bethlehem Central school district in Glenmont, where residents enjoy access to riverfront parks and orchards.
Sharon Fronk · Howard Hanna Capital Region
About this property
Sitting gracefully along the Hudson River, this spectacular waterfront estate offers breathtaking panoramic scenery of an unparalleled luxury lifestyle. Beautifully designed, every room captures the property in all its glory. You can immerse yourself in the waterfront views plus views of the gunite infinity pool, tennis court & guest cottage from almost anywhere in the home. The guest house features 3BR's, parking + deck overlooking 300ft of beach front. Features incl gourmet kitchen, 1st flr office+ library. Master suite w/private terrace, large great room, lower level recreation room & more. This is a one of a kind property in Bethlehem School District.
Is it priced right?
The price signals we can read on this listing today. For a true sense of value against recent Glenmont sales, Sharon will pull the comparable closings and walk you through them.
Price per sq ft
$336
Days on market
116
Price reduced
$123,000
from $1,998,000
Curious whether this home is priced right for the neighborhood?
Ask Sharon for the compsProperty details
35 facts pulled straight from the MLS listing.
Overview
Property TypeSingle Family
Sub-TypeSingle Family Residence
Year Built2006
Days on Market116
StatusActive
MLS Number202617794
ListedMay 21, 2026
Interior
Bedrooms4
Bathrooms4 full, 1 half
Living Area5,582 sq ft
Below-Grade Finished925 sq ft
Fireplaces2
Heating
Forced AirRadiantWood Stove
Cooling
Central Air
Flooring
CarpetCeramic TileHardwood
Basement
FinishedFullSump Pump
Interior Features
Full Finished BasementHigh Speed InternetPaddle FanSolid Surface CountersVaulted Ceiling(s)Walk-In Closet(s)Wet BarWired for Sound1 Family + In-LawBuilt-in FeaturesCentral VacuumCrown MoldingEat-in KitchenKitchen IslandWood Burning StoveFamily RoomLiving Room
Exterior & Lot
Lot Size1.94 acres
Lot Features
SlopedViewsClearedLandscaped
Garage Spaces2
Parking
Off StreetPavedGarage Door Opener
Exterior Features
GardenLightingTennis Court(s)PoolIn GroundInfinityWaterfrontRiver FrontBeach FrontOtherRiverWaterGarage2 Car GarageOff StreetPavedGarage Door Opener
Building & Construction
Construction
Cedar
Roof
Asphalt
Sewer
Septic Tank
Financial
List Price$1,875,000
Price per Sq Ft$336
Original List Price$2,225,000
Special Conditions
Standard
Est. Monthly P&I$9,481/mo
Location
CountyAlbany
School DistrictBethlehem
Listing Details
Listed ByCindy Taylor of Howard Hanna Capital Inc
Data SourceSpark Platform / Global MLS
Last UpdatedSep 2, 2026
Is it priced right?
The price signals we can read on this listing today. For a true sense of value against recent Glenmont sales, Sharon will pull the comparable closings and walk you through them.
Price per sq ft
$336
Days on market
116
Price reduced
$123,000
from $1,998,000
Curious whether this home is priced right for the neighborhood?
Ask Sharon for the compsEstimated monthly payment
per mo$13,778
- Principal & Interest$9,481
- Property Tax$3,750
- Insurance$547
Loan Term
Tax estimated at the Albany County rate. Insurance and PMI are estimates. Sharon can connect you with a lender for real numbers.
Get pre-approved →What's nearby
Google Maps view. Pan, zoom, click a pin to read about a business or place.
Commute Planner
Plan a multi-stop route from this address: drop-off the kid, hit the office, head home. Live traffic from Google.
- Start248 Van Wies Point Road, Glenmont, NY 12077
Try a preset
Schools
The district this address is assigned to. Ratings and reviews are hosted on GreatSchools.
Bethlehem
Assigned school district
Assigned districts can change and are not guaranteed. Confirm enrollment boundaries with the district directly before relying on them.
About Glenmont, NY
Glenmont is in Albany County, NY. There are currently 54 active listings here, ranging from $39,900 to $1,875,000. Listings in this address fall under the Bethlehem school district. Priced 341% above the Glenmont median of $424,950.
See Sharon's Glenmont community guideListed by
Who holds this listing, and where the data comes from.
- Listing agent
- Cindy Taylor
- Listing office
- Howard Hanna Capital Inc
- Office phone
- 518-421-7517
- MLS number
- 202617794
- Source
- Global MLS
- Listed on
- May 21, 2026
You might also like
Sharon represents buyers for this property. Your tour, offer, and inquiries go through her, not the listing brokerage.
Howard Hanna Capital Inc · Listed by Cindy Taylor (2064)
Contact: 518-421-7517
MLS #202617794 · Source: Global MLS, Inc.
IDX information is provided exclusively for consumers' personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS. Sharon Fronk Real Estate is committed to compliance with the Fair Housing Act and provides equal opportunity in housing.
