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

15812 Weston Glen
Huntertown, IN 46748
Amanda Blackburn with North Eastern Group Realty, original listing - (260) 489-7095

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,000
Beds: 5
Baths: Full: 5, ½: 1
Status: Active
SqFt: 4618 Square Feet
Agency: North Eastern Group Realty
Agency Phone: (260) 489-7095

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2012
Notes: Let's celebrate the holidays in this immaculate Northwest Allen home with 4,600+ sq ft of living space. Located in Coves at Twin Eagles and situated on a quiet, cul-de-sac street on 0.5+ acre lot, nestled next to a serene treelines & gorgeous pond. This home offers 5 Bedrooms, 5 full bathrooms & 1 half bath, 4 car garage & more! Entering into the home, you will be greeted with stunning hardwood floors, a formal main floor den/office, a formal dining space, stunning great room with floor to ceiling fireplace stone, custom built-ins, stained decorative trusses & the perfect water view. Kitchen features Kenmore Elite appliances, Bosch dishwasher, granite countertops and deep stained, maple cabinetry & over the range custom hood vent. Off of the kitchen, the owners have added a custom butler's pantry with brick paver flooring & custom shelving & cabinetry. A secondary pantry, half bath & owners' suite are also located on the main level. The owners' suite features a spacious bedroom with a quaint sitting area overlooking the pond, floor-to-ceiling walk in tile shower, jetted tub, water closet & large walk in closet. Heading to the daylight basement, home features a wet bar, large rec room perfectly set up for a projector space, a separate exercise room/den, spacious basement bedroom & a full bathroom. Basement has plenty of storage space. Owners have added custom storage shelving throughout the basement, including a quaint under the stair storage with sensor lighting. On the second level, you will find three bedrooms, each with their own private ensuite bathrooms! Plan to spend much of your time outdoors as you will fall in love with the views from both the main floor concrete deck space down to the stamped concrete patio & firepit below overlooking the water. Warm up in the hot tub which will remain for the new owners. Home features unique trim work, ceiling treatments, columns, wainscoting, crown molding, metal stair balusters & offers character that is hard to find in many new construction homes. Other notable features include an attached 4 car side load garage & epoxy floors, Flow Wall built in garage cabinetry, mudroom lockers plus a large laundry room with custom cabinetry, countertops & utility sink. Some notable mechanical upgrades include a newer tankless water heater (2021), a 3 zoned HVAC system, reverse osmosis system, & new central vac system. Neighborhood pool access, minutes from Fort Wayne, restaurants, Parkview Hospital & Pufferbelly Trail.
MlsNumber: --
ListingId: 202445853


Listing Provided By: North Eastern Group Realty, original listing
Phone: (260) 715-1115
Office Phone: (260) 489-7095
Agent Name: Amanda Blackburn
Disclaimer: Copyright © 2024 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.


Local Real Estate Expert

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 = 703 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;
Real Estate Expert Photo for Terri Sonner
Terri Sonner
ASCIILife Key Realty LLC
Call Today!: (260) 701-9384

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App