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','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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','nyhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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','nyhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

19 Aitken Avenue
Hudson, NY 12534

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,000
Beds: 3
Baths: Full: 1, ¾: 1
Status: Active
SqFt: 1917 Square Feet
Agency: Red Apple Realty
Agency Phone: 851-9601

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1927
Notes: Absolutely charming!From your first step inside you'll be enchanted with the period details, decor and size of this home that is perfectly placed at Hudson City's edge, easily within walking distance to both downtown shops and restaurants as well as Greenport's conveniences! The one-way lane creates a peaceful setting and the easy yard is accentuated with a beautiful bluestone patio that's ideal for outdoor dining. The walkways and steps into the home are also set in bluestone, and the front door opens into a lovely foyer to greet you, offering closet area for the overcoats and a pretty French door to guide you into the living room. This is a room that beckons you to sit and stay for a while, warmed with its gas fireplace and gleaming hardwood floors, it just feels like home. The formal dining room offers plenty of room for the holidays and special gatherings while the kitchen boasts its own sweet dining area in the breakfast nook which is perfect for causal mealtimes. Granite countertops, a wine rack and spice cabinet all add to the charm of the kitchen! This Arts and Crafts home boasts a first floor primary bedroom with an extra bonus den or office for a private and cozy relaxation space or consider it an office work area. A fully updated bath is also set on the main level, servicing guests and bedroom area alike. French doors, hardwood floors and built-in linens storage along with nautral, unpainted woodwork are some of the many details found in this period home. Up the stairs you'll find two more bedrooms and a full bath with plenty of storage and attic space too. This home is in move-in, fabulous condition, and also offers off-street parking in its two car garage at the end of the paved drive. A true pleasure and a home you won't want to miss!Much of the beautiful furnishings and decor can also be purchased under separate contract if you like the home just as-is and want to move right in! Call for your special viewing!
MlsNumber: --
ListingId: 152713


Listing Provided By: Red Apple Realty, original listing
Phone: (518) 851-9601
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