Your AI Navigator in Commercial Real Estate
Sign Up Successful!
You now have access to more from Realmo!
    For Sale
    • For Sale
    • For Lease
    • Recently Sold
    • Property Lookup
    • Brokers
    AI Search
    Back to Search

    259 Lohrville Ave Redgranite, WI 54970

    For Sale
    $326,000

    Established Business, Live-Above Opportunity

    Property size:
    5,600 SF

    Description

    Added:
    Feb 3, 2025
    Days on Market:
    315
    This exceptional Redgranite, WI commercial property presents a unique live-work opportunity. The 5,600 square foot building, situated on a 0.9-acre lot at 259 W Lohrville Ave, boasts a long and rich history, previously serving as a boarding house and a popular destination for quarry workers. Currently operating as "The Unbearable Pub," this well-established business has thrived for over 17 years, benefiting from its prime location directly on the Bannerman Trail – a popular snowmobile trail and former rail line. The pub itself features a spacious layout with both a long bar and a face-to-face bar, ample seating areas, a large walk-in cooler, and three freezers. Most furnishings, inventory, supplies, and equipment will remain with the sale. Note that game machines are leased. The upper level offers comfortable living quarters, including a five-bedroom, one-bathroom apartment complete with laundry facilities, a deck, a kitchen, a living room, an office, and two storage rooms. The entire property has been meticulously maintained, both inside and out, presenting a turnkey opportunity for a new owner to step into a successful business and comfortable living space. The asking price is $326,000.

    Property Features for 259 Lohrville Ave

    General Information

    Property type
    Other commercial real estate
    Square Feet
    5,600 SF
    Lot Size
    39,204 SF

    Building Details

    Year Built
    1900
    Location Intelligence

    Current Use by Public Records

    Commercial real estate

    Suggested Use

    Restaurant Building Supply Wholesale Shop Auto Repair Shop Hotel & Motel Department Store Grocery Store Storage Facility Bar & Pub Furniture Store

    Zoning and permitted uses should be independently verified with local authorities.

    Location Insight

    • Map
    • Local Demand
    City
    Redgranite
    County
    WAUSHARA
    State
    Wisconsin
    Longitude
    -89.12172
    Latitude
    44.03361

    Nearby Comparable

    • $312,500

      Restaurant, Tavern, Apartment Building

      Mixed-use property with established pub, apartment, and historical significance.
      259 W Lohrville Ave, Redgranite, WI 54970
      View Details
    • $350,000
      40.00 Acres

      40 Acres of Vacant Land

      40 acre parcel with wooded area and harvest ready quarry stone.
      County Road Ee, Redgranite, WI 54970
      View Details
    • $249,900
      41.00 Acres

      Neshkoro, WI 41-Acre Property

      41 acres ideal for hunting, farming, and outdoor activities.
      N402 24Th Ave, Neshkoro, WI 54960
      View Details

    Nearby Similar for Sale

    • $312,500

      Restaurant, Tavern, Apartment Building

      Mixed-use property with established pub, apartment, and historical significance.
      259 W Lohrville Ave, Redgranite, WI 54970
      View Details

    FAQs

    What type of property is this?
    Commercial real estate - Established Business, Live-Above Opportunity
    Where is this commercial real estate located?
    The property is located at 259 Lohrville Ave Redgranite, WI.
    What is the asking price?
    The asking price for this property is $326,000.
    (608) 356-4100
    Request Owner's contact information
    259 Lohrville Ave Redgranite, WI 54970
    Message sent successfully
    Error
    If you are the owner or broker of this property and would like to edit or remove this listing please send a message to web site administrator.
    259 Lohrville Ave
    Redgranite, WI 54970
    Message sent successfully
    Error
    Email to Your Friends
    Link copied to clipboard
    Separate multiple addresses with a comma
    Message sent successfully
    Error

    Realmo Value Estimation

    Realmo estimates a property’s market value using a proprietary methodology that incorporates public data and user-submitted information. This cumulative value is generated by integrating a variety of conventional and innovative methods. 

    Disclaimer

    These figures are not official appraisals and should not be used as a substitute for a valuation performed by a licensed appraiser.

    Actual market value may differ due to factors not captured in the data. Estimates are offered for informational purposes only, and users should conduct independent research before making financial or investment decisions.

    By using this feature, you acknowledge that Realmo is not responsible for actions taken based on these estimates.

    AI approach

    Realmo AI Method estimates property value using machine learning models trained on millions of comparable listings, transactions, and market signals. It analyzes property features, location intelligence data, and current market dynamics to predict the most probable market value in real time.

    Cap approach

    Capitalization Method calculates value based on estimated net operating income (NOI) and applying a market-based capitalization rate (cap rate), we estimate what a typical investor might be willing to pay for it.

    Comparable approach

    Comparable estimate is based on recent sales of similar nearby properties, adjusted for factors like size, condition, and location.

    Relative

    Relative property class coefficient uses factors that account for typical price differences between various asset types (e.g., retail vs. industrial) to provide a more accurate market-aligned estimate.

    Geo

    Comparable Sales Method, enhanced by Geo coefficients — location-based adjustment factors that reflect differences in price levels across neighborhoods, cities, or regions ensuring a more accurate, market-sensitive valuation.

    Alternative use

    Estimate considers the property’s potential value if used for a different purpose-based on zoning, demand, and market feasibility.

    More about this property
    259 Lohrville Ave Redgranite, WI 54970
    Thanks! Your message was sent.
    Error! Your message wasn't sent.
    Please enter your name
    Please enter email
    Please enter the email in the correct format
    Please enter phone
    Please enter the number in the correct format
    Please enter message
    Google sign-in failed. Please try again or use another login method.
    Create New Password
    • At least 8 characters
    • Contains both letters and numbers
    • Contains uppercase and lowercase letters
    • At most 32 characters
    • Password required
    • Password reset link has expired. Please request a new one.