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;

18058 Tullymore Lane
Leo, IN 46765
Mindy Fleischer with Mike Thomas Associates, Inc., original listing - (260) 489-2000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $989,900
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3378 Square Feet
Agency: Mike Thomas Associates, Inc.
Agency Phone: (260) 489-2000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: **Open House Sunday, Oct 6, 4:00-6:00pm. Luxury Custom-Built Home by Robert Koors Custom Building & Design**Step into unparalleled luxury with this meticulously crafted home by Koor Custom Building & Design. From the moment you enter the stunning foyer, you're greeted with elegance and sophistication. Adjacent to the entrance is a versatile space, perfect for an office, nursery, or sitting room. The main level boasts an expansive open-concept layout, ideal for entertaining. The Great Room is the heart of the home, featuring a gas fireplace, beamed ceiling, and breathtaking views of the backyard. The chef’s dream kitchen is equipped with double islands, solid surface countertops, custom cabinets, double ovens, a gas range with pot filler, tile backsplash, wine cooler, under-cabinet lighting, and an oversized walk-in pantry. The adjoining dining room and kitchen seamlessly flow into a four-season room, enhancing the space for gatherings. This room includes double sliding doors, a gas fireplace, a high decorative wood ceiling, surround sound, and access to a composite deck and pool area. The main level also houses the luxurious primary suite. This serene bedroom with a luxury bath, featuring a double vanity and walk-in shower. Dual walk-in closets provide ample storage, with one measuring an impressive 18x12, complete with an island for additional storage. Conveniently, the walk-in closets connect to the laundry room, which includes abundant cabinetry and a utility sink. The lower level is designed for relaxation and entertainment. It features a family room with a wet bar, including a wine cooler and custom cabinets, and two bedrooms, each with private baths. Additional amenities include 2 oversized storage areas with one section hosting all the pool equipment. This home is equipped with modern conveniences and high-end features: surround sound throughout, electric blinds, granite countertops, a water softener (salt system upstairs), an alarm sump pump, jets in the pool, and an elaborate landscape design. The outdoor area is equally impressive with an Elephant cover for the pool, a fenced yard, an irrigation system, a Ring security system, motion lights, and decorative driveway and sidewalk with a designer garage door. The dramatic stone front porch entrance and a walk-up attic from the garage add to the home’s unique charm and functionality. Every detail has been thoughtfully designed to offer the ultimate in comfort and style.
MlsNumber: --
ListingId: 202438017


Listing Provided By: Mike Thomas Associates, Inc., original listing
Phone: (260) 414-7728
Office Phone: (260) 489-2000
Agent Name: Mindy Fleischer
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