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

4970 Emerson Lane Nw
Depauw, IN 47115
Ashley Bullington with Debby Broughton Realty, original listing - (812) 946-3393

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $249,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 1782 Square Feet
Agency: Debby Broughton Realty
Agency Phone: (812) 946-3393

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Welcome home to this beauty nestled within the tree lined 1.5 acres. This 4-bedroom, 2-bath residence is situated to provide the perfect retreat from the hustle and bustle of daily life. Tucked away on a dead-end road, this move-in-ready gem offers spacious living room that flows seamlessly into the den complete with a cozy fireplace—ideal for autumn evenings or a peaceful morning coffee. The beautifully remodeled kitchen offers lots of storage with cabinets PLUS pantry! Ample counter space and island offer workspace galore! The main bedroom is a true haven, boasting generous dimensions and abundant closet space, ensuring ample storage and comfort for everyone. Across the home the additional 3 bedrooms offers privacy for everyone. Outdoors, unwind on the generously sized front porch, where you can bask in the gentle sounds of nature or enjoy quiet evenings under the stars. This large porch is perfect for gatherings, or simply soaking in the beauty of your surroundings. With its perfect blend of comfort, space, and natural beauty, this home is not just a place to live; it’s a lifestyle waiting to be embraced. Plus who doesn’t want their very own clubhouse! The clubhouse is a fun play area or extra storage in addition to the shed. Don't miss the opportunity to make it yours!
MlsNumber: --
ListingId: 2024012486


Listing Provided By: Debby Broughton Realty, original listing
Phone: (812) 499-8384
Office Phone: (812) 946-3393
Agent Name: Ashley Bullington
Disclaimer: Copyright © 2024 Southern Indiana REALTORS Association. 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