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 = 785 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 = 785 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 = 785 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;

4644 E Old Fort Harrison Avenue
Terre Haute, IN 47805
JENNIFER ATTERSON with COLDWELL BANKER REAL ESTATE GROUP, original listing - (812) 238-2526

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,325,000
Beds: 4
Baths: Full: 5, ½: 1
Status: Active
SqFt: 7445 Square Feet
Agency: COLDWELL BANKER REAL ESTATE GROUP
Agency Phone: (812) 238-2526

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 16 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: An estate like this is a rare find! Tucked away on 16.5 acres, this home is surrounded by serene woods and stocked lake.  Almost 7500 sq. ft, 4 bedrooms, 5.5 bathrooms. Two story great room/dining room with fireplace offers an abundance of elegance. Chefs dream kitchen with center island, lots of cabinets and counter space and gorgeous scenic views. Living room with fireplace is surrounded by tall windows and walkout to grand wrap around back patio. Master bedroom is on the main with en-suite, fireplace, wet bar, huge walk in closet, W/D and veranda to take in the peaceful lake view. Upper level has 3 generous sized bedrooms each with their own en-suite completely updated in 2023. There’s also W/D, storage room and wet bar area. Walkout basement has rec area, 2 fireplaces, full bath renovated in 2024, area for office/den and bar area. Barn with 7 stalls, 2 fenced pastures, space for four cars and outdoor equipment. Roof is 3 yrs old, 2 new hvac units, new carpet throughout, new flooring in most areas, fresh paint inside and out. Complete list of updates can be provided to your agent. Don’t miss this one of a kind opportunity!
MlsNumber: --
ListingId: 103884


Listing Provided By: COLDWELL BANKER REAL ESTATE GROUP, original listing
Phone: (812) 208-0446
Office Phone: (812) 238-2526
Agent Name: JENNIFER ATTERSON
Disclaimer: Copyright © 2024 Terre Haute Area 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