Title Page Background
DEBUG FN args: Array ( [0] => 1068 [1] => [2] => [3] => agent ) BEFORE: Site: 1068 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1068 Igate: njhud LocID: 1068 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1068 AND i.igate IN ('nwhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1068 [1] => [2] => [3] => lender ) BEFORE: Site: 1068 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1068 Igate: njhud LocID: 1068 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1068 AND i.igate IN ('nwhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1068 [1] => [2] => [3] => other ) BEFORE: Site: 1068 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1068 Igate: njhud LocID: 1068 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1068 AND i.igate IN ('nwhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1683 Taylor Barrow Road
Auburn, KY 42206
Mario Gattavara with Berkshire Hathaway HomeServices, original listing - (270) 783-4515

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $539,900
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2979 Square Feet
Agency: Berkshire Hathaway HomeServices
Agency Phone: (270) 783-4515

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Country custom farm view home on outskirts of Auburn, Kentucky. Solid 2x6 constructed 2023 built custom home with brick & stone exterior finish. This country custom sits on 1.19 acres with an additional 1.19 acre lot adjacent that can be acquired together with this home and land for an additional $37,500. This home was built as a forever home in 2023 and life plans changed. 4 Bed/2.5 Bath. Walk into tall ceilings, a large entryway and dining area offshoot. Large family room and additional separate living area, both with custom stone floor to ceiling fireplaces. Good sized kitchen with island and dining nook offering panoramic window views. In fact, the majority of the windows in this beautiful home offer farm views. Good sized main suite with soaking tub, walk in custom tiled shower, double sinks and large walk in closet on lower level. Upper level offers 3 bedrooms, office, loft and full bath. A few features include large laundry, pantry as well as instant hot water. Front and rear custom covered patio/porch areas. Long driveway with home set back off road. Located along a scenic stretch of road with new homes in the general area. County water supply, septic and internet available. Just a short 12 miles into Bowling Green. Lower area gently lived in until transfer of ownership. Please have qualifications ready to provide your realtor prior to viewing. NOTE: There may be available seller terms on this with “LARGE” down, inquire or have your agent inquire with the list agent for details.
MlsNumber: --
ListingId: RA20250856


Listing Provided By: Berkshire Hathaway HomeServices, original listing
Phone: (270) 598-1648
Office Phone: (270) 783-4515
Agent Name: Mario Gattavara
Disclaimer: Copyright © 2025 REALTOR® Association of Southern Kentucky, 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