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

263 Wellfield Drive
Nappanee, IN 46550
P. Scot Honeycutt with Phil Hahn and Associates, original listing - (574) 773-4184

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $749,900
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2590 Square Feet
Agency: Phil Hahn and Associates
Agency Phone: (574) 773-4184

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Be one of the first to buy in Nappanee's new subdivision "Wellfield Community". Welcome to your dream home. This Elegant Modern Farmhouse with high-end finishes is just waiting for you. Step into this meticulously crafted new construction home that combines modern luxury with timeless elegance. The open -concept design connects the living, dining and kitchen areas. This creates the perfect space for entertaining. You will notice a cozy great room with a stone fireplace and spacious dining area. The beautiful gourmet kitchen boasts quartz countertops, custom cabinetry and ceramic tile backsplash, stainless steel appliances, high-end fixtures and a custom butler's pantry. Off the kitchen is a pocket office, with custom made cabinets. Walk through your oversized patio door and you will discover your 12 x 21 covered patio. A great place to entertain family and friends. This Modern Farmhouse also has a completely finished 3car attached heated garage. When you walk into the home from the garage, you will notice a custom mudroom with lockers. As you make your way to the upper level, you will discover 2 guest bedrooms and full bath with quartz countertops, high-end fixtures and an upper-level laundry. The luxurious primary bedroom comes complete with a custom-built walk-in closet, and an elegant primary bathroom, this comes with a dual quartz vanity and a dual ceramic tiled shower. The primary bedroom also has its own custom coffee bar, what a great way to start your day. The full unfinished basement is just waiting for the new owner make their own. The basement is complete with an egress window and is plumbed for the 4th bathroom. This is one of the 2024 Parade of Homes this year. June 15-16 from 1:00 - 8:00 pm, June 20-21 from 4:00 - 8:00 pm and June 22 - 23 from 1:00 - 8:00 pm
MlsNumber: --
ListingId: 11282008


Listing Provided By: Phil Hahn and Associates, original listing
Phone: (574) 773-4184
Office Phone: (574) 773-4184
Agent Name: P. Scot Honeycutt
Disclaimer: Copyright © 2024 My State MLS. 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