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

588 W State Rd 62
Boonville, IN 47601
Jenna Hancock-Wargel with Berkshire Hathaway HomeServices Indiana Realty, original listing - (812) 455-0370

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $299,900
Beds: 3
Baths: Full: 2
Status: Pending
SqFt: 1520 Square Feet
Agency: Berkshire Hathaway HomeServices Indiana Realty
Agency Phone: (812) 455-0370

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1944
Notes: Charming Country Retreat on 2.5 Acres minutes from town! Move-in ready 3 bed (split floor plan), 2 bath home nestled on a picturesque 2.5-acre lot, perfect for those seeking peaceful country living. Enjoy abundance of natural window light and stunning views from the covered two-tier deck overlooking the backyard. The 1,520 SF home features beautiful tongue-and-groove ceilings in the living and dining areas, can lighting throughout the main areas and tasteful paint palette throughout. Gorgeous kitchen with quartz countertops, breakfast bar, subway tile backsplash, white cabinets with easy close drawers, pantry cabinet for storage, deep drawers for pots and pans as well as trash drawer for 2 cans. Stainless appliances are included (refrigerator, microwave, dishwasher & range). Both spare & primary bathrooms have been updated with solid surface countertops, white vanities, tub/shower combos and primary bath with large make up vanity. The primary bedroom boasts double closets, accent wall & has the flattering view of backyard. Another added bonus, one of the spare bedrooms features a stylish shiplap wall and the other features deep closet. Modern conveniences include, Pergo Laminate flooring throughout and a laundry area with ample storage and spacious living room. Concrete around home and in the pole barn was added in 2021 as well as the electric and LED lighting in Pole Barn. To complete this idilic setting are the trails in the wooded acreage which extends the fenced in area of backyard. Sellers have included a 1 year home warranty, roof is approximately 5-6 years old, replacement windows, keyless entry and so much more you will want to see this home in person so you can capture the true picture.
MlsNumber: --
ListingId: 202519382


Listing Provided By: Berkshire Hathaway HomeServices Indiana Realty, original listing
Phone: (812) 568-4774
Office Phone: (812) 455-0370
Agent Name: Jenna Hancock-Wargel
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