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

5044 Ed Foster Rd
Philpot, KY 42366
Collin Hargus with Five Star Realty, original listing - (270) 298-4674

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,600,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2474 Square Feet
Agency: Five Star Realty
Agency Phone: (270) 298-4674

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 105 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: 1986
Notes: The Essence of Happiness can usually be described with one word- Peace. How do we achieve Peace? For many, it starts with Home. In our ever-changing world, most are seeking solitude at the end of the day. However, creature comforts and conveniences are often sacrificed to achieve this kind of sanctuary. 5044 Ed Foster Rd delivers both Sanctuary and Convenience. Standing atop a gently sloping landscape, there are no neighbors as far as the eye can see. You are completely Removed from the Hustle and Bustle of City Life with Just a 3 Mile Drive to all the Conveniences that the City of Owensboro has to offer! The All Brick 5 Bedroom 3.5 Bath Ranch Style Home is like a time capsule! Built in 1986, it has been Meticulously Maintained over the years and has so many great features. The Spacious Kitchen features Solid Oak Cabinetry, Priceless country views and is handy to the Dining room where you can serve your guests with ease. With 2,474 Square Feet on the first Level and 2,474 Square feet of Basement, this Ranch has room for you and your guests to spread out! Imagine Relaxing in the Living Room accompanied by picture views of country landscape. After Watching the Sun Set, You can cap off the evening cozied up to the Brick Fireplace in the Family Room. The Basement is an Entertainer's Dream! Sporting its own Kitchen, you'll be the hot-spot for any gathering! A full bath and bedroom on the lower level ensures privacy and convenience for your guests! Poured walls and 10ft Ceilings make this Basement a Fortress and Escape from any Inclement Weather Events! A convenient Mud Room is located just off the Attached 2 Car Garage, Keeping all of life's messes contained! If you need more than just an attached garage, you'll find plenty of space for storage and hobbies in the Detached 30'x40' Garage! You will be delighted to know that this 105 Acre Farm Features 77 Acres of some of the most High Producing Soil Types in Daviess County. Approximately 19 Acres of this Farm presents an excellent Land Management Opportunity- offering a potential expansion of row crop after harvesting it's Mature Timber. Priced at $1,600,000.00 An opportunity like this rarely becomes available if at all!
MlsNumber: --
ListingId: 11323860


Listing Provided By: Five Star Realty, original listing
Phone: (270) 363-0516
Office Phone: (270) 298-4674
Agent Name: Collin Hargus
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.


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 = 1027 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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;
Brandi Rone
ASCIIKeller Williams Elite
Call Today!: (270) 485-3612

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App