Title Page Background
DEBUG FN args: Array ( [0] => 1048 [1] => [2] => [3] => agent ) BEFORE: Site: 1048 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1048 Igate: njhud LocID: 1048 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 = 1048 AND i.igate IN ('usahud','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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1048 [1] => [2] => [3] => lender ) BEFORE: Site: 1048 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1048 Igate: njhud LocID: 1048 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 = 1048 AND i.igate IN ('usahud','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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1048 [1] => [2] => [3] => other ) BEFORE: Site: 1048 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1048 Igate: njhud LocID: 1048 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 = 1048 AND i.igate IN ('usahud','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 = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1651 S Green St
Henderson, KY 42420-9999
LINDA MEUTH with ERA FIRST ADVANTAGE, original listing - (270) 577-8701

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $750,000
Beds: --
Baths: ½: 4
Status: Active
SqFt: 4400 Square Feet
Agency: ERA FIRST ADVANTAGE
Agency Phone: (270) 577-8701

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Commercial Sale-Other
Year Built: --
Notes: Prime Commercial Opportunity in Henderson, KY Nestled at 1651 S Green St, this versatile commercial property is an opportunity waiting to be seized. Built in 1989 and offering 4,400 square feet of space, it's tailored for businesses aiming for growth without the plunge into city congestion. Perfectly poised near the bypass, this location offers convenience and accessibility to potential clients. Features and Amenities Designed for adaptability, this property is well-suited for a variety of commercial purposes. The building boasts a commercial store front, complete with a double door entry and a handicap ramp for accessibility. The interior is thoughtfully laid out with 4 service doors and an overhead door for ease of operation. A total of two offices provide dedicated workspaces, while an employee lounge—with a sink and washer/dryer hookups—offers comfort for staff. The utility room is equipped with a mop station, ensuring practicality in maintenance. Security won’t be a concern, as the building is wired for protection. Functional and Practical For convenience, the property includes a lunchroom with a storage pantry and a kitchen fitted with cabinetry, a commercial sink, and a grease trap. With a partially fenced area and a concrete pad at the back, there’s added flexibility for storage or additional workspace. The water fountain and four bathrooms, including one that’s wheelchair accessible, cater to both employees and patrons alike. Outdoors, the property offers a durable mansard metal roof and a solid metal exterior. The concrete parking lot accommodates up to 16 cars comfortably with rear of the building parking also, a significant advantage for businesses needing high customer turnover. Additionally, a 10' x 15' storage building remains on the premises for supplementary storage needs. Unique Selling Proposition What sets this property apart is its strategic location that combines ease of access with the benefits of being slightly removed from city center traffic. This makes it an optimal choice for a retail medical equipment business, pharmacy, or medical office, providing a rare blend of visibility and convenience. Ready to take the next step? Contact your trusted real estate expert in Western Kentucky and Southern Indiana. Let’s explore how this property can elevate your business prospects.
MlsNumber: --
ListingId: 250256


Listing Provided By: ERA FIRST ADVANTAGE, original listing
Phone: (270) 577-7617
Office Phone: (270) 577-8701
Agent Name: LINDA MEUTH
Disclaimer: Copyright © 2025 Henderson Audubon Board of Realtors. 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