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

400 Darby Hills Road
Newburgh, IN 47630

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $749,900
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3702 Square Feet
Agency: Berkshire Hathaway HomeServices Indiana Realty
Agency Phone: (812) 455-0370

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1940
Notes: Start Showing Date: 3/7/2025 This 1940’s home has undergone extensive remodeling with not a single corner untouched while maintaining its character and historic charm.  Enjoy all new electrical, plumbing, roofing, HVAC, windows, doors, and hardwood flooring throughout.  You will love the thoughtfully designed kitchen featuring custom Amish built cabinetry with all pull out shelving and drawers. This kitchen is equipped with high end appliances including a wine chiller, refrigerator, dishwasher, and a 5 burner gas range and an additional oven. The sunroom off the kitchen and living room is the perfect place to start and finish your day while taking in the abundant wildlife that call the mature trees on this nearly 1 acre lot home.  You can also enjoy sipping a warm beverage on those cool evenings in front of the St. Meinrad stone outdoor fireplace anchoring the courtyard. The primary suite has hardwood flooring, a custom walk-in shower, private water closet, and large walk in closet. Also on the first floor is the remodeled laundry room, a 1/2 bath, and 1st floor office. On the 2nd floor are 2 additional bedrooms, 2 full bathrooms, a flex space that could serve as a bedroom, a second office or craft/hobby room, and a Large family room showcasing cabinetry topped with a live edge slab top and matching shelving sourced from a storm damaged tree in Newburgh. The basement, while technically unfinished, is clean, bright and updated with epoxy coated floors.  The home has an attached, epoxy floored 3 car garage with a pull through bay accessing both driveways. Enjoy an extra peace of mind and never be left in the dark again with your brand new natural gas whole home 27 KW generator! No stone was left unturned on this one, including the Newburgh cornerstone that is the centerpiece of the outdoor fireplace hearth.
MlsNumber: --
ListingId: 202506527


Listing Provided By: Berkshire Hathaway HomeServices Indiana Realty, original listing
Phone: (812) 483-4894
Office Phone: (812) 455-0370
Agent Name: James Keck
Disclaimer: Copyright © 2025 Southwest Indiana Association of Realtors. 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