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

12378 N Creek Bend Lane
Milford, IN 46542

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $309,900
Beds: 4
Baths: 3
Status: Active
SqFt: 1914
Agency: Patton Hall Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1994
Notes: Embracing both elegance and comfort, this impeccably maintained two-story residence in Creek Bend offers a sanctuary where memories are made and cherished moments unfold. From the moment you step onto the welcoming wrap-around porch, you'll be captivated by the home's timeless charm and inviting spirit.Inside, the flowing layout seamlessly blends formal living and dining areas with more casual spaces, creating an ambiance that effortlessly transitions from sophisticated entertaining to cozy gatherings. The updated kitchen, complete with a new gas stove, dishwasher, and refrigerator, serves as the heart of the home, where culinary adventures and lively conversations come to life.Ascend to the second level, where the luxurious master suite awaits, offering a private retreat with dual closets and an en-suite bath. Three additional bedrooms provide ample space, fostering a sense of togetherness while allowing for personal privacy when desired.Step outside and discover a true backyard oasis, where a sparkling 20x40 inground pool beckons you to cool off on warm summer days. Surrounded by a white vinyl privacy fence and lush landscaping, this outdoor haven invites you to host unforgettable gatherings or simply unwind in the tranquility of your own backyard paradise.Nestled in Creek Bend subdivision, this home offers the perfect blend of comfort and convenience. With recent updates, including a new shed, furnace, central air, and water heater, you can rest assured that your investment is well-protected.Home Details: 4 beds, 2.5 baths, 2 car garage, unfinished basement, in-ground pool.
MlsNumber: 202409375


Listing Provided By: Patton Hall Real Estate, original listing
Name: Patton Hall Real Estate
Phone: (260) 450-1812
Office Name: Patton Hall Real Estate
Office Phone: (574) 267-7501
Agent Name: Julie Hall
Disclaimer: Copyright © 2024 Kosciusko Board of Realtors 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