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

    18 Sheffield Ave Newport, RI 02840-1618

    • Investment properties
    • 5,975 SF
    • 0.30 lot acres
    OFF-MARKET
    Value Estimation
    $1,290,000
    Last Sale
    Jun 15, 2021
    $1,075,000
    Location Intelligence
    Property ID
    US76-0227097
    The Realmo ID is a unique identifier assigned to every property, incorporating country codes and precise geo-coordinates for 300x300-foot land blocks. It enables standardized data collection and seamless integration of disparate sources such as ownership, tax, title data and physical specifications. By aggregating current and historical records, the Realmo ID powers advanced analytics and delivers deep, verifiable insights for real estate professionals.

    Current Use by Public Records

    • Investment properties

    Property Details for 18 Sheffield Ave

    Year built
    1948
    Construction
    MASONRY/CONCRETE MASONRY UNITS (CMUS)
    Lot size
    0.30 lot acres
    Property size
    5,975 SF
    Zone code
    R10
    Property type
    Investment properties
    Property subtype
    Live-work space
    APN
    NEWP M:010 B:0185
    APU
    NEWPM010B0185

    Description

    This stunning Newport, RI mixed-use property, located at 18 Sheffield Ave, offers a unique blend of residential and commercial space. The 5,975 square foot building, constructed in 1948 and renovated in 2003, sits on a 2.16-acre lot and is zoned R-10. The upper floors comprise a spacious 5-bedroom, 2.5-bathroom residential unit featuring wide oak floors, ornate details, high ceilings, a marble fireplace, and a dry bar. Modern amenities include in-unit laundry and elevator access. A large dry basement provides ample storage. The exterior boasts a private, bamboo-lined yard. The first floor offers 2,625 square feet of versatile commercial space, perfect for various business ventures. Thirteen parking spaces are available. This property presents an exceptional live-work opportunity or a strong investment prospect, combining the comfort of a luxurious home with the potential for substantial commercial income. The asking price is $2,100,000. This is a rare opportunity to acquire a meticulously maintained property in a desirable Newport location.

    Value Estimation

    by Realmo proprietary methodology Last update: July 3, 2025

    • AI approach

      CAP return
      Estimation
      Estimation
      $1,375,000

    • CAP approach

      CAP return
      Estimation
      6%
      $1,020,000
      6.5%
      $1,150,000
      7%
      $1,005,000

    • Comparable approach

      Method
      Estimation
      Relative Method
      $1,255,000
      Geo Method
      $1,100,000

    • Alternative Use

      Use
      Estimation
      Distribution
      $1,170,000
      Retail
      $1,235,000
      Mixed-Use
      $975,000
      Hospitality
      $1,120,000
      Educational
      $915,000
      Residential Income
      $1,205,000
      Energy
      $1,180,000
      Income-Based Land
      $1,265,000
      Food Service
      $1,030,000

    Location Insight

    • Map
    • Local Demand
    City
    Newport
    County
    Newport
    State
    Rhode Island
    Longitude
    -71.3112
    Latitude
    41.5022
    CBSA code
    39300
    CBSA name
    PROVIDENCE-NEW BEDFORD-FALL RIVER, RI-MA METROPOLITAN STATISTICAL AREA

    Property Tax & Assessments

    Tax date
    Tax Amount
    Assessed Land Value
    Assessed Improvement Value
    Total Assessed Value
    Applied Tax Rate
    Land Market Value
    Improvement Market Value
    Total Market Value
    2023
    $0.00
    $197,800
    $382,500
    $580,300
    -
    $0.00
    $0.00
    $0.00

    Comparable in this City

    • Value Estimation by Request
      16,235 SF

      21 Marlborough St, Unit 41

      OFFICE/RESIDENTIAL (MIXED USE) • 16,235 SF
      21 Marlborough St, Newport, RI 02840-2544
      View Details
    • Value Estimation by Request
      6,720 SF

      148 Spg St, Unit 160

      OFFICE/RESIDENTIAL (MIXED USE) • 6,720 SF
      148 Spg St, Newport, RI 02840-6806
      View Details
    • Value Estimation by Request
      96,672 SF

      76 Broadway

      OFFICE/RESIDENTIAL (MIXED USE) • 96,672 SF
      76 Broadway, Newport, RI 02840-7722
      View Details
    • Value Estimation by Request
      7,586 SF

      130 Broadway

      OFFICE/RESIDENTIAL (MIXED USE) • 7,586 SF
      130 Broadway, Newport, RI 02840-2748
      View Details
    • Value Estimation by Request
      5,248 SF

      35 Touro St

      OFFICE/RESIDENTIAL (MIXED USE) • 5,248 SF
      35 Touro St, Newport, RI 02840-2912
      View Details
    • Value Estimation by Request
      5,482 SF

      130 Thames St

      OFFICE/RESIDENTIAL (MIXED USE) • 5,482 SF
      130 Thames St, Newport, RI 02840-6629
      View Details

    Similar Nearby for Sale

    • $1,950,000
      2,930 SF

      Mixed-Use Property in Desirable Location

      Updated multi-family property with commercial potential in downtown Newport.
      604 Dixon St, Newport, RI 02840
      View Details
    • $2,200,000
      6,330 SF

      Historic Mixed-Use Building in Newport

      Classic Newport building with retail and residential units in downtown.
      130 Spring St, Newport, RI 02840
      View Details
    • $3,250,000
      4,800 SF

      Renovated Mixed-Use Building, Newport

      High-visibility, renovated mixed-use building with income potential in Newport.
      491 Thames St, Newport, RI 02840
      View Details
    • $1,800,000
      4,352 SF

      Newport Commercial Property with Apartment

      Unique commercial property with retail space and finished apartment.
      283 Broadway Ave, Newport, RI 02840
      View Details
    • $1,800,000
      5,312 SF

      Newport Multifamily Property with Income Potential

      Two-family home near Bellevue Ave and Broadway district, Newport, RI.
      1 Pell St, Newport, RI 02840
      View Details
    • $1,400,000
      2,313 SF

      Newport Multifamily with Converted Barn

      Two-unit residence with converted barn in historic Newport neighborhood.
      74 3Rd St, Newport, RI 02840
      View Details

    Similar Nearby for Lease

    • $58 SF/Yr
      348 SF

      Newport Shipyard Office Suites

      Prime Newport Office Space Available
      1 Washington St, Newport, RI 02840
      View Details
    • $10 SF/Yr
      12,000 SF

      Newport Warehouse Space For Lease

      12,000 SF Industrial Warehouse Space
      181 Bellevue Ave, Newport, RI 02840
      View Details
    • $34 SF/Yr
      1,000 SF

      Travers Block Office Suites in Newport

      Historic Newport Office Space Available
      174 Bellevue Ave, Newport, RI 02840
      View Details
    • Contact for pricing
      4,270 SF

      Office Space in Newport

      Office space available for rent in Newport, Rhode Island.
      320 Thames St, Newport, RI 02840
      View Details
    • $16 SF/Yr
      10,850 SF

      Newport Office Space for Lease

      Prime Downtown Newport Location, Flexible Suites Available
      28 Pelham St, Newport, RI 02840
      View Details
    • $16 SF/Yr
      3,490 SF

      Newport Commercial Space For Lease

      Prime Newport location, 3,490 sq ft office/retail
      76 Broadway, Newport, RI 02840
      View Details
    Request Owner's contact information
    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.
    18 Sheffield Ave
    Newport, RI 02840-1618
    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
    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.