Property Lookup
    • For Sale
    • For Lease
    • Recently Sold
    • Property Lookup
    • Brokers
    You're browsing as guest. Top-line numbers are free. Full reports — owner contacts, refine, methodology — are paid. Guest mode. Top-line is free.
    New search
    Property profile & analytics
    OFF-MARKET
    Motels

    5900 Pfeiffer Rd, Blue Ash, OH 45242-4822

    17,184 SF 3.81 ac lot Built 1983
    Entity Owned 1-yr Hold Free & Clear
    Property ID
    US66-0428491
    Property summary
    AI-generated overview

    This exceptional 1.3-acre commercial land parcel presents a prime opportunity for retail development. Located at 5900 Pfeiffer Road in Blue Ash, Ohio, this single-tenant site boasts unparalleled visibility and accessibility. Situated directly off Interstate 71 at a signalized intersection, the property ensures high traffic counts and maximum brand exposure. The existing building offers 7,020 square feet of vacant space, providing ample room for a variety of retail uses. The property's location within the thriving Blue Ash submarket of Hamilton County offers a strong demographic profile and significant consumer spending power. This high-profile pad site is ideal for businesses seeking a strategic location with exceptional visibility and convenient access for customers. The 1.3-acre lot size provides flexibility for development, allowing for ample parking and potential for expansion. This is a rare opportunity to secure a prominent retail location in a highly desirable area. The property is zoned for commercial use and is ready for immediate development. The address is 5900 Pfeiffer Road, Cincinnati, OH 45242. This location offers easy access to major transportation arteries, making it an attractive option for both businesses and customers. The property's strategic location and significant size make it an exceptional investment opportunity.

    Property profile
    Verified
    Property type Motels
    Use group MOTEL
    Year built 1983
    Total area 17,184 SF
    Lot 3.81 ac (165,746 SF)
    APN 612-0140-0266-00
    UPID US66-0428491
    Cap rate & NOI
    Priority signal for investors
    Implied cap rate, NOI & suggested price
    Cap rate vs submarket · NOI estimate · 3 price anchors
    Implied cap rate, NOI & suggested price
    Cap vs submarket · NOI estimate · 3 price anchors
    Value estimations
    Realmo proprietary · 4 methods
    AI Approach AI
    by Request
    CAP Approach CAP
    by Request
    Comparable Approach Comparable
    by Request
    Blend (final) Blend
    by Request
    Owner & transaction history
    Stnl Blue Ash LLC · 1 yrs held
    Stnl Blue Ash LLC
    since 2025
    Last sale
    $4.0M
    7 recorded transactions
    2025
    2025
    $4.0M
    2018
    2012
    $1.9M
    2007
    2007
    $5.0M
    2000
    $3.8M
    Zoning & alternative use
    Permitted uses
    Permitted uses
    Allowed · conditional · prohibited
    Try Rey
    Ask anything about this address in plain English.
    “Is 15.6% cap rate sustainable?” · “Best tenant mix for BU1?” · “What’s the redev upside?”
    You own 5900 Pfeiffer Rd?
    List it free. Reach 20,000 daily buyers.
    We’ve already pulled the facts. Confirm photos + price and you’re live in 2 minutes.
    List this address →
    More about this property
    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