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

1800 W 950 North
Markle, IN 46770
Aaron Hoover with Keller Williams Realty Group, original listing - (260) 460-7707

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,200,000
Beds: 4
Baths: Full: 3, ½: 3
Status: Active
SqFt: 4898 Square Feet
Agency: Keller Williams Realty Group
Agency Phone: (260) 460-7707

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 25 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1998
Notes: Welcome to an exceptional 4-bedroom, 7-bathroom 5900+ sqft homestead set on over 25 acres of serene countryside, perfect for those seeking a private luxury retreat. This stunning home offers a grand first impression, from the long, winding driveway past the 2.5 acre pond, to the all-brick exterior, and the charming circle drive welcoming guests to the front custom walkway. The property also boasts a modern horse stable and pasture, ideal for equestrian enthusiasts. Step inside to a breathtaking living room featuring a floor-to-ceiling wall of windows that flood the space with natural light. A stylish fireplace, shared with the spacious breakfast nook, adds warmth and charm. The top-of-the-line kitchen is an entertainer’s dream, complete with two sinks, a built-in drink fridge, a double oven, and a generously sized island. The main floor also includes a formal dining room, a dramatic den with built-in bookshelves, and the luxurious master suite, offering an intimate sanctuary. Two additional bedrooms on this level share a thoughtfully designed Jack and Jill bathroom. If you aren't already blown away by this home, the expansive walk-out basement will completely change your perception of what a basement can be. Featuring a kitchenette, a large rec room, a family room, the 4th bedroom, storage, and unique spaces throughout, this level provides endless possibilities for customization. Accessible from both the main floor and walkout basement, the back of the home opens to a thoughtfully crafted two-tiered deck and expansive concrete patio. Two built-in fire pits and beautiful landscaping make the outdoor space perfect for entertaining or relaxing in seclusion. This remarkable estate combines luxury, comfort, and the tranquility of rural living, perfect for discerning buyers seeking this one-of-a-kind retreat.
MlsNumber: --
ListingId: 202432253


Listing Provided By: Keller Williams Realty Group, original listing
Phone: (260) 460-7707
Office Phone: (260) 460-7707
Agent Name: Aaron Hoover
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App