Title Page Background
DEBUG FN args: Array ( [0] => 1833 [1] => [2] => [3] => agent ) BEFORE: Site: 1833 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1833 Igate: njhud LocID: 1833 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1833 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1833 [1] => [2] => [3] => lender ) BEFORE: Site: 1833 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1833 Igate: njhud LocID: 1833 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1833 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1833 [1] => [2] => [3] => other ) BEFORE: Site: 1833 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1833 Igate: njhud LocID: 1833 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1833 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

338 Maple Lane
Kinderhook, NY 12184

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $749,000
Beds: 3
Baths:
Status: Pending
SqFt: 2097 Square Feet
Agency: Houlihan Lawrence Millbrook Of

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Range, Refrigerator, Dryer
Architectural Style: Colonial
Construction Materials: Wood Siding, Stone, Frame, HardiPlank Type, Cement Siding
Flooring: Tile, Wood, Hardwood, Laminate, Tile - Ceramic
Heating: Forced Air
Interior Features: High Speed Internet, Kitchen Island
Rooms: Office, Basement, Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Den, Dining Room, Kitchen, Family Room, Living Room, Utility Room

Window Features

Exterior Features: Patio, Wooded, Enclosed, Landscaped, Gentle Sloping
Parking Features: Off Street, Driveway
Patio and Porch Features: Patio
Roof: Metal, Rubber
Vegetation: Wooded
View: Mountain

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name:

Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1888
Notes: Introducing Historic 1880 Maple Lane Farmhouse, original home of sprawling Heald Orchard. Farmhouse is loaded with antique charm and original details, and offers an extremely versatile layout. Work from home, enjoy creative pursuits, host guests as easily as you can find a quiet corner to curl up with a book. Oversized kitchen features soapstone sink, countertops & island bar, excellent for throwing together simple dinners or composing sumptuous holiday feasts, with plenty of room for friends & helpers to gather. Adjacent dining room has garden views, stunning terra cotta floor & easily fits a table for 12. Two generous living rooms, both with exposed hand-hewn ceiling beams. One perfect for cocktails in front of the marble-hearth fireplace, the other perfect for movie nights. 3 bedrooms & 3 baths spaced well across house for optimal guest privacy. Downstairs office & gym can be additional bedroom. Soak in clawfoot tub after a harvest from your sweet fenced vegetable garden. Original carriage barn revitalized to state-of-the-art recording studio/creative space. Many notable artists have worked here, producing albums, voiceovers & audiobooks. Studio features vaulted ceilings with oodles of light, perfect 3-room canvas for making music, writing, workshop, yoga, home office or even pool house. Stone patios wrap around house, offering plenty of areas large enough for socializing & stargazing. Super cozy fire pit in rear, catch fireflies off one side. On warm days, enjoy a dip in the salt-water pool & grab shade & a sip under the pergola. Stroll through to fenced-in dog run to check on Fido. New small barn and patio shed keeps seasonal outdoor items both nearby & out of sight. Enjoy professional landscaping year-round: plum & apple trees perfume spring air, old growth maples provide fall foliage. "Magic hour'' really is magic here! Elevation & western view are enough to wash house in pink & orange light every sunset, with the light streaming through original wavy glass front windows. Go apple-picking or visit the distillery, smokehouse and enjoy award-winning apple cider donuts at local Golden Harvest. Perfect proximity to Kinderhook village, home of Morningbird Cafe, the Aviary, the best bagels, yoga and village festivities. 20 minutes to Hudson & Chatham, quick hop to Berkshires, Albany Intl. Airport. Local bike riding on long country road loops, passing farms, horses, acres of corn fields.
MlsNumber: --


Listing Provided By: Houlihan Lawrence Millbrook Of, original listing
Phone: (917) 975-9926
Office Phone: (845) 677-6161
Agent Name: Joseph Briggs
Disclaimer: Copyright © 2024 Multiple Listing Service of Ulster County. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App