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;

925 Augusta Drive Se
Corydon, IN 47112

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $439,900
Beds: 4
Baths: 3
Status: Active
SqFt: 2978
Agency: Schuler Bauer Real Estate Services ERA Powered

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1996
Notes: This meticulously one-owner home is well maintained and has been well loved. Not a thing to do but move in. total of 4 bedrooms and 3 full baths. With nearly 3,000 sqft of living space, a full finished walk-out basement, and a private patio there is room for your whole crew! Stepping inside, the living room welcomes you with its warm gas log fireplace, vaulted ceilings, and rich hardwood floors, effortlessly leading out to the spacious deck. The heart of the home, the kitchen, features granite countertops, custom tiled flooring, and updated appliances, opening to a dining area large enough to host memorable gatherings. With 3 bedrooms on the main floor - The main bedroom, boasts roominess and an updated en suite bathroom equipped with dual sinks, a privacy water closet, and a luxurious step-in tiled oversized shower. Two additional main-floor bedrooms offer comfort and style, each with ample space and natural light. The lower level has an oversized family room that opens to the oversized private patio, a fourth bedroom, a large full bathroom, abundant storage, and an office. Close to Corydon Central Schools, golf course convenient shopping, restaurants, Hayswood Park/ playground & trail & Rice Island Park for outdoor enjoyment. Country Club Estates is a well-maintained beautiful subdivision with mature trees and friendly neighbors! The sellers are offering $5,000 to the buyers for any changes they would like to make. Sellers are Motivated!
MlsNumber: 202407204


Listing Provided By: Schuler Bauer Real Estate Services ERA Powered, original listing
Name: Schuler Bauer Real Estate Services ERA Powered
Phone: (812) 738-4232
Office Name: Schuler Bauer Real Estate Services ERA Powere
Office Phone: (812) 738-4232
Agent Name: Robin Bays
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