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

13 Tamarack Drive
Newburgh, NY 12550
Ewa Kusmierek with eXp Realty, original listing - (888) 276-0630

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $645,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2572 Square Feet
Agency: eXp Realty
Agency Phone: (888) 276-0630

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: Welcome to Magnolia, a stunning 2,572-square-foot colonial-style home that perfectly blends elegance and functionality. This residence features 4 spacious bedrooms and 2.5 baths, providing ample space for both relaxation and entertainment.<br /> <br /> As you enter, you’ll be greeted by an open-concept floor plan that seamlessly connects the family room, kitchen, and breakfast nook, making it the ideal setting for gatherings and daily life. The formal dining room offers a sophisticated space for special occasions.<br /> <br /> Practicality meets style in the mud hallway, which includes a convenient closet and bench for organizing daily essentials. The primary bedroom suite is a true retreat, showcasing a tray ceiling, a luxurious soaking tub, and a generous walk-in closet. Three additional spacious bedrooms, each with its own walk-in closet, ensure comfort and privacy for family and guests.<br /> <br /> Step outside to the inviting front porch, a perfect spot for outdoor enjoyment and relaxation. The full unfinished basement provides endless possibilities for future living space, allowing you to customize the home to suit your needs.<br /> <br /> Located in the picturesque Hudson Valley, Elm Farm Estates offers a vibrant and tight-knit community atmosphere, where neighbors become friends and every corner holds a story. Enjoy easy access to an array of amenities, from quaint village shops to bustling eateries, enriching daily life. With 52 brand-new construction homes, we present six carefully selected floor plans that cater to every preference, from elegant colonials to charming ranches and contemporary bi-levels. Each residence boasts modern features and spacious layouts designed to accommodate your lifestyle. Enjoy the serene backdrop of surrounding trees and views, creating an idyllic setting for your dream home. Conveniently situated off Highways I-84 and I-87, Elm Farm Estates provides seamless access for your daily commute. Explore neighboring towns, or venture into New York City, just 60 miles away, via the nearby Metro North. Newburgh is a fast-growing hub for businesses and new work opportunities with major companies established in the area and more on the horizon. Don't forget to visit our website for more information, including a 3D simulation video of Elm Farm Estates.
MlsNumber: --
ListingId: 813890


Listing Provided By: eXp Realty, original listing
Phone: (845) 494-0865
Office Phone: (888) 276-0630
Agent Name: Ewa Kusmierek
Disclaimer: Copyright © 2025 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 3383 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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;
Real Estate Expert Photo for JoAnn Maxwell
JoAnn Maxwell
ASCIIHoward Hanna Rand Realty
Call Today!: (914) 850-2782

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App