Property photo 1
Property photo 2
Property photo 3
Property photo 4
Property photo 5
0 Baths
9,888 sqft

$950,000

459 N Main Street, Lexington TN, 38351

Price per sqft$96.08
Built in1996
Property size9,888 sqft
Property typeCondominium

Overview

Active

Listed Aug 17, 2026

Updated Aug 17

Unique Investment Opportunity - Ideal for Hotel, Airbnb, Apartments & Rental Income Discover a rare and highly versatile investment opportunity in Henderson County, Tennessee, offering approximately 9,888 square feet of existing space with an exceptional layout for an investor looking to create multiple rental units, mini-apartments, extended-stay accommodations, a boutique hotel, Airbnb/short-term rentals, or other hospitality concepts. Conveniently located just minutes from the popular Beech Lake Resort area, known for boating, fishing, recreation, and summer water sports, this property offers tremendous potential for generating multiple income streams. Upstairs - Exceptional Potential for Rental Units or Hospitality. The upstairs features 19 individual rooms, offering an existing configuration that could provide an excellent starting point for mini-apartments, efficiency units, extended-stay lodging, Airbnb accommodations, or individual rental suites. The upper level includes 19 private rooms of varying sizes, 4 bathrooms, 2 additional showers, a kitchenette, 2 additional sinks, 4 central HVAC units, 4 electrical breaker boxes, and existing network/cabling infrastructure. Two separate exits, including one with a private exterior stairwell, provide additional flexibility. Numerous private rooms already in place, this level presents exciting opportunity for an investor seeking to convert existing space into multiple income-producing units rather than starting from the ground up. Downstairs - Additional Income & Flexible Use Potential The downstairs offers approximately 10 rooms, 3 restrooms, 10 additional sinks, 3 central HVAC units, and multiple large open areas, including a 65' x 48' room, 27' x 34' room, and 28' x 17' room, along with offices and storage areas. This space could provide additional opportunities for rental suites, offices, business space, hospitality amenities, leasing space, or other income-producing uses. A large front foyer, multiple exits, handicap-accessible access, tile and ceramic flooring, existing workstations, and a recently installed security system add to the property's functionality. Additional Investment Opportunity The property offers approximately 30 marked parking spaces plus additional surrounding parking. There is also an opportunity to acquire the two adjacent properties, including an approximately 4,200-square-foot commercial shop/garage and a 1,130-square-foot home, creating even greater potential for additional rental income, storage, residential accommodations, commercial space, or mixed-use development. With nearly 10,000 square feet already divided into numerous individual rooms, substantial HVAC and electrical infrastructure, multiple bathrooms and sinks, abundant parking, and a location near Beech Lake, this property offers an investor the opportunity to explore a unique hospitality or multi-unit rental concept with the potential for multiple income streams. Ideal uses to explore include: Boutique Hotel • Airbnb/Short-Term Rentals • Extended-Stay Lodging • Mini-Apartments • Efficiency Rentals • Rental Suites • Office Suites • Mixed-Use Investment. Contact Debbie Mays at 731-307-9536 to schedule a private showing and explore the income-producing possibilities of this unique Henderson County investment property.

$6,320/mo

Est. mortgage payment based on a $950,000 home price.

All estimates are provided by Luxury Presence for informational purposes only. Actual amounts may vary.

Additional information

MLS® ID
2603910

Interior Features

Bathrooms
0
Cooling
Yes
Heating
Yes
Basement
No

Exterior Features

Lot Size
0.4 Acres

Other Property Details

Taxes
$6,606
Tax Frequency
Annually
MLS provider logo

Listed by Debbie Mays with 7 Lakes Realty Inc.
Listing Contact: 731-307-9536 

The IDX display contains information sourced from the Central West Tennessee Association of REALTORS® as of 8/17/2026. This data is intended solely for personal, non-commercial use and is not to be utilized for any other purposes except to identify potential properties for purchase. Although the MLS data displayed is typically considered reliable, it is not guaranteed to be accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and are advised to conduct their own investigations or seek professional assistance. Other sources besides the Listing Agent may have contributed to the MLS data presented. Unless expressly specified in writing, the Broker/Agent has not confirmed any information obtained from external sources. The Broker/Agent may or may not have acted as the Listing and/or Selling Agent and cannot guarantee the accuracy of property locations displayed on any map. Any compensation offers are solely made to participants of the MLS where the listing is registered.

©2026 Central West Tennessee Association of REALTORS® all rights reserved.

Data last updated on 8/17/2026 at 7:02 PM UTC

Powered by Luxury Presence