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

667 Brentwood Drive
Akron, IN 46910
Keli Cordill with Tri Oaks Realty, original listing - (260) 982-2336

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $409,900
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2746 Square Feet
Agency: Tri Oaks Realty
Agency Phone: (260) 982-2336

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Very well-maintained property has so much to offer with 3 bedrooms and 3 full bathrooms and is fully handicapped accessible with an attached (24x24) 2 car garage and (18x20) carport. Main level features an open floor plan kitchen, dining room and (20x14) living room. This fantastic kitchen has a double oven gas stove, large refrigerator, dishwasher & disposal. Laundry room on main level with cabinets, counter and utility sink. Washer & dryer hookup (electric) available, washer & dryer not provided. Master bedroom (17x20) on main level with large walk-in closet and en suite bath with shower & solid surface vanity. 2nd bedroom on main level also has a large walk-in closet, and a full bath with tub & shower combo and stone vanity top, just off the main hallway. The stairs leading to the basement has a 'Stair Chair' attached making it easy to get downstairs. In the lower level which is a full walk-out basement, you will find a 14x14 finished bedroom with a full egress window and closet. Just off the bedroom is a full bath with a zero-threshold tiled shower. The basement, fully drywalled, offers a large living/family room area, and a work and storage area with a utility sink and gas heater. Geothermal energy efficient furnace and central air (New 2017) Furnace has a back-up generator for emergencies. Electric water heater (2017), Water softener stays. 200amp electrical service. From the basement, step out to the pergola covered patio and beautifully landscaped yard. Need a place to park your RV and a workshop to tinker around? Then you will love the additional 30x42 outbuilding with tall, oversized garage doors and separate workshop area. Garden shed stays. This property has everything you could want and is move in ready. It feels like country living but still close to town and restaurants. 2 parcels total 2.45 acres. House parcel is 0.82 acre, and the adjacent fully wooded parcel 1.63 acres.
MlsNumber: --
ListingId: 202513358


Listing Provided By: Tri Oaks Realty, original listing
Phone: (260) 578-0749
Office Phone: (260) 982-2336
Agent Name: Keli Cordill
Disclaimer: Copyright © 2025 Upstate Alliance of REALTORS® Multiple Listing Service, Inc. 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