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

5465 S State Road 75
Jamestown, IN 46147
Joshua Vida with Paradigm Realty Solutions, original listing - (574) 626-8432

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,499,999
Beds: 5
Baths: Full: 4, ½: 3
Status: Active
SqFt: 5920 Square Feet
Agency: Paradigm Realty Solutions
Agency Phone: (574) 626-8432

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 38 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: Own Your Private Paradise on 40 Acres in Boone County! Discover the rare opportunity to make this 6000 sq. ft. dream home yours. Nestled on 40 breathtaking acres in the highly sought-after Western Boone School District. 2 minutes off I 74, 15 mins to Brownsburg and Lebanon, 20 mins to Whitestown. With rolling hills, a winding creek, and mature trees, this property offers unmatched serenity and a view that will take your breath away. Home Highlights: -5 Bedrooms, 5.5 Bathrooms: Spacious and laid out to perfection. HUGE closets -Master Suite on Main Level: Enjoy convenience and luxury. -Finished Basement: Perfect for in-law quarters, a game room/entertainment, or your own private theater with a bar. -New Inground Pool: Stunning, with an automatic cover for ease and safety. -3 Car Garage: Plenty of room for vehicles and storage. -Geothermal -Brand new windows in 2023 -Many updates/upgrades Equestrian & Business Features: -2 Year-Old Livestock Barn: Includes horse stalls, feed room, lounge, wash rack, a small indoor arena, and ample storage. -2 Horse Pastures & Run-In Shed: Ideal for horse enthusiasts. Wedding Venue on Site: A thriving business opportunity with weddings booked through 2025 (details available for serious buyers). Negotiations/Contracts will need to be discussed related to business This property offers endless possibilities whether you're looking for a luxurious retreat, a working farm, or an entrepreneurial venture. Don't miss the chance to own this slice of heaven! Make your dreams a reality with this stunning piece of property--truly endless potential!
MlsNumber: --
ListingId: 22019682


Listing Provided By: Paradigm Realty Solutions, original listing
Phone: (574) 626-8432
Office Phone: (574) 626-8432
Agent Name: Joshua Vida
Disclaimer: Copyright © 2025 MIBOR Service Corporation. 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 = 707 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 Amy Glassburn
Amy Glassburn
ASCIIHouse Smart Realty, Llc
Call Today!: (317) 430-0724

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App