Listing provided courtesy of Water Street Real Estate GroupMLS# 100578207MLS Provider
  • 27 days on site
  • 16 views

Rare Mixed-Use Downtown Opportunity - Completely Turnkey! This unique mixed-use property presents a rare opportunity to own an iconic downtown commercial restaurant space complete with attached residential accommodations, established short-term rental income, and additional third-floor living or development potential. Located in the heart of downtown, this fully turnkey property features an established commercial restaurant on the main level with seating for 48 guests, offering strong visibility, charm, and operational flexibility. Designed for a seamless transition, the restaurant is positioned for an owner-operator, investor, or hospitality entrepreneur ready to step into an existing downtown destination. The second floor currently operates as a successful income-producing Airbnb, generating exceptional supplemental revenue while offering attractive live/work or investment flexibility. Adding even greater value, the third floor presents exciting opportunities for expanded living space, owner's quarters, luxury suite, creative studio, additional short-term rental accommodations, or future development potential. Combining commercial success, residential versatility, proven income streams, and expansion opportunity, this rare downtown property is a truly exceptional turnkey investment and lifestyle opportunity ready for its next chapter.

Source: Hive MLS, MLS#: 100578207

Love this property?
Create a profile so you can receive updates on this property as soon as they happen!
  • Property Type
    Residential
  • Lot
    0.16 acres

Get in Contact

Would you like to know more about this property? We're here to help! Let's connect and find what you're looking for.

Susan Pender

Create a profile so you can receive updates on this property as soon as they happen!

  • Median Age
    40
  • Population Density
    157
  • College Educated
    33%
  • Estimated Median Income
    $54,455
  • Estimated Total Home Owners
    9,150
  • Estimated Total Renters
    5,641
  • Owner / Renter Divide
    62% / 38%
  • Estimated Average Household Size
    3
  • Total Population
    39,804
  • Community data courtesy of LiveBy, Inc.

Owning this Home

$
$ %
%
* All calculations are estimates and provided by Reliance Network, for informational purposes only. Actual amounts may vary. ** Assumes 6.50% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information. Any mortgage broker or insurance agent that may appear is independent and is not affiliated with, endorsed by, or provided by the MLS.

Want to talk? Contact us here.

  • Skip Templeton
  • RW Towne Mortgage
  • Vice President | Mortgage Loan Officer
  • (757) 287-1902

Want to talk? Contact us here.

Want to talk? Contact us here.

Life at 104 W Main Street


Schools


School data courtesy of LiveBy, Inc.
Ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating. The schools displayed on this website are for informational purposes only and may not represent a complete or up-to-date list. School assignments are subject to change and should be verified directly with the local school district. Please contact the appropriate school district to confirm school zoning and enrollment eligibility for this property.

History

Date Event Value Agent
6/9/2026Source: REIN MLS Status Change
Active
6/9/2026Source: REIN MLS Status Change
Active
6/2/2026Source: Hive MLS Added to Database
June 02, 2026
6/2/2026Source: Hive MLS Added to Database
June 02, 2026
6/1/2026Source: REIN MLS Added to Database
June 01, 2026
6/1/2026Source: REIN MLS Added to Database
June 01, 2026
12/9/2025Source: Hive MLS Added to Database
December 09, 2025

This site uses cookies to improve your user experience. Continuing to browse means you accept our use of cookies. Our Privacy Policy.