Title Page Background
HFQUERY 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 ('usahud','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 ('usahud','pahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 ('usahud','pahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

10 Spruce Street
Kinderhook, NY 12184

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $515,000
Beds: 5
Baths: 3
Status: Active
SqFt: 2956
Agency: Red Apple Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1992
Notes: Looking for some Space? We've found it in this wonderful Cape styled home that is more than meets the eye! Situated in a well-established neighborhood that's equidistant between Albany & Hudson makes this the ideal home for commuters in either direction. Set on .616 Acre of attractive lawns & plantings with pastoral views, this yard is ready for fun whether it is a summer's dinner enjoyed on the rear deck or splashing around in the AG Pool. A step inside & you'll immediately know that this home offers spaces & places for everyone with so many possibilities! There can be up to 5 bedrooms if needed, both formal & informal entertaining areas, so get ready to check all the boxes on what you'll want & need; this home has it!The front porch offers room for the rocking chairs & creating the perfect place to relax on a warm evening & watch the world go by. The center hall entry guides you inside, boasting nice built-in closets & creating pathways into the living areas of the home. Straight ahead is the updated & attractive kitchen with loads of cabinetry & the perfect workspace with quartz countertops, & loaded with appliances. Here you can enjoy an open floor plan to the casual dining space that's perfect for everyday meals & grants access through the glass door out to the large rear deck. Venture into the formal dining room, the perfect place for large gatherings and special occasions, while the living room befits the size of the home, incorporating the entire end of the house from front to back & highlighted by its gas fireplace that will not only warm your space, but also create the ambiance you'll desire on a winter's eve! A half bath is conveniently situated on this level, as well as the primary bedroom suite. Bring your large furnishings & all the clothing, as this room is spacious & offers a walk-in closet plus add'l closet, as well as a private bath that boasts double vanities, a garden style tub for soaking & relaxing, and extra shower stall. All of the closets in the home are California Closets, so organization will be easily acheived here. Up the stairs you'll find bedrooms "plus", as the floor plan offers private bedrooms with add'l rooms or spaces to be used as office areas, sitting rooms, play rooms, nurseries, or add'l bedroom spaces; you decide! There are just so many ways to enjoy this home, and let's not forget about the huge bonus room that is an ideal family room space! There's a semi-finished room in the LL; 2 car garage & more!
MlsNumber: 152665


Listing Provided By: Red Apple Realty, original listing
Name: Red Apple Realty
Phone: 851-9601
Office Name: Red Apple Realty
Office Phone: 851-9601
Agent Name: Barbara Robinson
Disclaimer: Copyright © 2024 Columbia Greene and Northern Dutchess MLS. 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