Scott J. Alvarez
Licensed Real Estate Salesperson
REALTOR®
Slingerlands, NY
New - 24 Hours Ago
View Full Photo Gallery

Property Description

Overlooking Green Lake in the Town of Catskill, 627 Green Lake pairs four acres of privacy with a beautifully constructed home offering an incredible amount of space and flexibility. Built in 2004 and meticulously maintained, the 4,184-square-foot property features four bedrooms and four bathrooms, including two en-suite primary suites, one of which is on the first floor. Lake views stretch across the front of the property, while a mature, manicured yard with fruit trees and wooded acreage create a private setting behind the house. Inside, soaring ceilings, expansive windows, and generous proportions give the home an effortless sense of scale. Wide oak floors, a limestone fireplace, and cathedral ceilings bring character to the main living spaces. The kitchen is equally substantial, with granite countertops, double ovens, a commercial-grade refrigerator and freezer, wine cooler, and abundant workspace. A wine cellar, cedar-lined closets, and custom storage add thoughtful touches throughout. The home has been exceptionally well cared for, with a timeless foundation that can be enjoyed as is or personalized over time. Outside, the property is designed to be enjoyed in every season. A Trex deck wraps around most of the house, with a nine-person hot tub, mature trees, a large fenced dog run, and plenty of room for a pool. The three-car attached garage is complemented by additional garage space off the basement and a separate detached garage with ample potential for a studio, workshop, or creative space. The finished basement includes a custom golf simulator and even more room to spread out. Extensive upgrades since 2019. With two primary suites, the layout lends itself beautifully to multigenerational living, and the home's generous footprint could easilallow for the conversion of part of the house into a separate apartment. Whether used as a full-time residence, weekend escape, or rental, the home is ready to enjoy now while leaving room to shape it over time.

627 Green Lake Road | MLS# 202628092

This single family home located at 627 Green Lake Road, Catskill, NY 12414 is currently listed for sale with an asking price of $1,249,500. This property was built in 2004 and has 4 bedrooms and 4 full and 1 partial baths with 4184 sq. ft. Green Lake Road is located within the Catskill school district. Search Catskill real estate on scott-alvarez.coldwellbankerprime.com today.

Upcoming Open Houses

Open House Saturday October 17th, 1:00pm - 3:00pm

Gallery

Property Features

Property Type: Residential - Single Family
Basement: Yes
Basement: Finished
Cooling: Central Air, Geothermal
Fireplaces: 1
Garage: 5 car attached
Heating: Baseboard, Forced Air, Heat Pump, Radiant Floor
Home Style: Contemporary
Lot Size: 4.00 Acres
Taxes: $16,580
Year Built: 2004

Feature Descriptions

Appliances: Ice Maker, Convection Oven, Dishwasher, Disposal, Double Oven, Dryer, Freezer, Geothermal Water Heater, Microwave, Refrigerator, Washer, Water Purifier, Water Softener, Wine Cooler
Days on Site: 1
Doors: French Doors, Sliding Doors, Storm Door(s)
Exterior: Vinyl Siding
Exterior: Drive-Paved, Lighting, Outdoor Shower
Fencing: Back Yard, Gate
Fireplace: Living Room, Wood Burning
Flooring: Tile, Wood
Interior: Steam Shower, Walk-In Closet(s), Wine Cellar, Cathedral Ceiling(s), Kitchen Island
Laundry: Laundry Room
Parcel #: 192289 103.00-4-32
Parking: Storage, Workshop in Garage, Paved, Attached, Circular Driveway, Detached, Driveway, Garage Door Opener
Parking Total: 20
Parking Total: 20
Patio/Porch: Rear Porch, Side Porch, Composite Deck, Deck
Rooms Total: 9
Sewer: Septic Tank
Special View Info: Lake
SQFT Above Grade Finished: 4184
SQFT Building Total: 4184

Room Sizes

Bedroom: Level - Second
Primary Bedroom: Level - Second
Dining Room: Level - First
Kitchen: Level - First
Foyer: Level - First
Basement: Level - Basement

Local Schools

School District: Catskill

Estimate Your Payment

Estimated Payment

$ 4,526.95 per month $2,780.85 Principal & Interest $1,381.67 Property Tax $364.44 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Demographics

Listed By / Shown By

Listing By

Agency Name: Compass Greater NY LLC
Agency Phone: 1 838-877-8283

Shown By

Agent Name: Scott J. Alvarez
Agent Phone: (518) 522-7265
Agency Title: Coldwell Banker Prime Properties

IDX logo

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided 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. Information on this site was last updated 10/13/2026. The listing information on this page last changed on 10/13/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Tue 10/13/2026 12:04:37 AM EST) or Global MLS (last updated Mon 10/12/2026 11:52:29 PM EST) or New York State Alliance MLS (last updated Tue 10/13/2026 12:03:12 AM EST) or Hudson Valley Catskill Region MLS (last updated Tue 10/13/2026 12:01:13 AM EST) or Berkshire MLS (last updated Mon 10/12/2026 8:13:28 PM EST) or OneKey MLS (last updated Tue 10/13/2026 12:00:30 AM EST). Real estate listings held by brokerage firms other than Coldwell Banker Prime Properties may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

C.B. Prime Properties, Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each franchise is independently owned and operated.

Homestead Funding Corp. Company NMLS# 3232. Equal Housing Lender. State Licensing Information

Coldwell BankerĀ®. All rights reserved. The Coldwell Banker System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices. Coldwell Banker Real Estate LLC, fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Any services or products provided by independently owned and operated franchisees are not provided by, affiliated with, or related to Coldwell Banker Real Estate LLC nor any of its affiliated companies.


Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder