Zip codes 12033 listings for sale


$2,200,000 - Schodack, NY

1297 Brookview Station Road Schodack, NY - Imagine being the proprietor of a 117-acre farm where the views are breath taking and the ambiance includes families and friends stopping by to purchase fresh baked goods in the retail store, picking farm fresh apples eating and drinking in a space where people gather to celebrate milestones events. Welcome to Windy Hill Orchard, a large farm/orchard with retail operations, various event venues and a single-family home as well as housing for seasonal workers. Excellent reputation for quality food, beautiful location, seasonal events. Listing includes real estate, business and furniture, fixtures and equipment.
? | 0 | 0 | 12,648 sqft.
$2,200,000 - Schodack, NY

1279 Brookview Station Road Schodack, NY - Imagine being the proprietor of a 100 plus acre farm where the views are breath taking and the ambiance includes families and friends stopping by to purchase fresh basked goods in the retail store, picking farm fresh apples eating and drinking in a space where people gather to celebrate milestones events. Welcome to Windy Hill Orchard, a large farm/orchard with retail operations, various event venues and a single family home as well as housing for seasonal workers. Excellent reputation for quality food, beautiful location, seasonal events. Listing includes real estate, business and furniture, fixtures and equipment.
1977 | 0 | 0 | 0 sqft.
$2,000,000 - Schodack, NY

1279 Brookview Station Rd. Schodack, NY - Imagine being the proprietor of a 100 plus acre farm where the views are breath taking and the ambiance includes families and friends stopping by to purchase fresh basked goods in the retail store, picking farm fresh apples eating and drinking in a space where people gather to celebrate milestones events. Welcome to Windy Hill Orchard, a large farm/orchard with retail operations, various event venues and a single family home as well as housing for seasonal workers. Excellent reputation for quality food, beautiful location, seasonal events. Listing includes real estate, business and furniture, fixtures and equipment.
1977 | 0 | 0 | 0 sqft.
$2,000,000 - Schodack, NY

1297 Brookview Station Road Schodack, NY - Imagine being the proprietor of a 105-acre farm where the views are breath taking and the ambiance includes families and friends stopping by to purchase fresh baked goods in the retail store, picking farm fresh apples eating and drinking in a space where people gather to celebrate milestones events. Welcome to Windy Hill Orchard, a large farm/orchard with retail operations, various event venues and a single family home as well as housing for seasonal workers. Excellent reputation for quality food, beautiful location, seasonal events. Listing includes real estate, business and furniture, fixtures and equipment.
1830 | 0 | 0 | 12,648 sqft.
$1,295,000 - Schodack, NY

2491 Brookview Road Schodack, NY - Welcome to your private 61 acre retreat! This custom-built 2008 beauty boasts a luxurious primary bedroom suite on the first floor, 9' ceilings, an open-concept kitchen, dining area, and living area perfect for entertaining. Enjoy a dining room, music room, 3/4 bath, mudroom, and laundry room. Step outside to a large deck and covered porch. The second floor features three spacious bedrooms, full bath, entertainment area, plus a huge bonus room. The home has duel heating: radiant floor and forced air. Set on a wooded Private yet ideally located, 25 minutes from the airport, 15 minutes from Albany and Amtrak and close to Adirondacks, Catskills and Saratoga. Highly-rated schools. Schedule a visit and experience peace for yourself.
2008 | 4 | 3 | 3,324 sqft.
$1,295,000 - Schodack, NY

2491 Brookview Road Schodack, NY - Welcome to your 61 acre private retreat! This custom-built 2008 beauty boasts a luxurious primary bedroom suite on the first floor, 9' ceilings, an open-concept kitchen, dining area, and living area perfect for entertaining. Enjoy a dining room, music room, 3/4 bath, mudroom, and laundry room. Step outside to a large deck and covered porch. The second floor features three spacious bedrooms, full bath, entertainment area, plus a huge bonus room.The home has duel heating: radiant floor and forced air. Private yet ideally located, 25 minutes from the airport, 15 minutes from Albany and Amtrak and close to Adirondacks, Catskills and Saratoga. Highly-rated schools. Schedule a visit and experience peace for yourself!
2008 | 4 | 3 | 3,324 sqft.
$1,270,000 - Castleton, NY

797 Western Road Castleton, NY - Historically known as Enderley Farm this Patroon era Farmhouse has been authentically restored and featured on HGTV. This hilltop property has over 64 acres with spectacular Hudson Valley views and seasonal Hudson River views. The location is a blend of convenience and serenity just 10 minutes from downtown Albany. The farmhouse has a bedroom suite with porch and woodstove and 5 additional bedrooms on the second floor, 3 full baths, 2 dining rooms, and 2 stairways to the 2nd floor. The barn has an office and 3 horse stalls leading to 7 acres of fenced pasture. There are several fields and riding trails which are great for horses or four wheelers as well as an inground garden pool with hot tub. This property is a true gentlepersons farm and perfect venue for equine endeavors or to immerse yourself in a slower paced world. Adjoining 777 Western Rd. is also available for an interested party for a caretaker or other family members to live on this classic Farm property - see last photo for front of this home.
1829 | 6 | 3 | 3,393 sqft.
$1,270,000 - Schodack, NY

797 Western Road Schodack, NY - Historically known as ''Enderley Farm'' this Patroon era Farmhouse has been authentically restored & featured on HGTV. The hilltop property sits on 64 acres with spectacular views. The location is a blend of convenience & serenity just minutes from Albany. The master bedroom has a porch & woodstove with 5 additional bedrooms, 3 full baths, 2 dining rooms, & 2 stairways to the 2nd floor. The barn has 3 horse stalls leading to 7 acres of fenced pasture. This property is a true ''gentlepersons farm'' and perfect venue for raising goats, llamas or equine endeavors or to just immerse yourself in a slower paced world. There are several fields that are ideal for a hobby farmer who wants to grow holiday trees, fruits, apples, or berries etc. It is also possible to have a 1st floor master suite.
1829 | 7 | 3 | 3,393 sqft.
$1,199,999 - Schodack, NY

1300 S Schodack Road Schodack, NY - Solid Investment Property! 3 Buildings w/ a 10 units on a 1 acre parcel. Fully rented w/ a gross annual income of $150,000 Major improvements done in the last year. The original 1840 Farmhouse w/ 4 units (3-1BD & 1-2BD) has a new roof, new siding, double pane insulated windows & extensive soffit & sill work. The side-by-side Duplex has a new roof, double-pane windows & rear decks. Each w/ 2BDs, large living rms, good-sized kitchens, lots of closet space. The last building is a sprawling ranch style w/ 4 identical units. Each has 2BDs, large closets, sliding glass doors. All 10 units have two heat sources w/ separate metered utilities. Coin-operated laundry, off street parking & beautiful green space. 10 mins to East Greenbush or Kinderhook. 15 mins to Rensselaer & Albany. Schodack Schools
1840 | 17 | 10 | 7,608 sqft.
$1,199,999 - Castleton, NY

1300 S Schodack Rd Castleton, NY - Fabulous Money Maker! 3 Buildings with a total of 10 units on a 1 acre parcel. All fully rented with a gross annual income of $150,000. Many major improvements to the property have been made in the last year. The original 1840 Farmhouse has had an amazing transformation with a new roof, new siding, double pane insulated windows and extensive soffit and sill work. Ready to stand another 100 years! These 4 units (3-1 bedrm & 1-2 bedrm) have also had interior work...paint, kitchens and baths freshened up, vinyl flooring in 2 of them. Separate electricity, gas, and hot water.The side-by-side Duplex has a new roof, double-pane windows and rear decks. Each with 2 bedrms, large living rms, good-sized kitchens, lots of closet space. Interior work here too...paint, freshened up kitchens and baths, and both have new vinyl flooring. Separate electricity, gas, and hot water here as well. The last building is a sprawling ranch style with 4 identical units. Each has 2 bedrms, large closets, sliding glass doors to the yard, locked outside storage rooms. 2 have been freshly painted with new flooring, kitchen and bath improvements. Separate electricity & gas too. All 10 units have two heat sources. Natural gas hot air wall mounted and electric baseboards. A coin operated laundry room too. The 1 acre parcel has lots of off street parking and beautiful green space. Surrounded by farmland for peaceful country living. 10 minutes to East Greenbush or Kinderhook. 15 minutes to Rensselaer and downtown Albany. Schodack Schools.
1840 | 17 | 10 | 7,608 sqft.