Skip main navigation
For sale
  • $549,333

    40 Old Louisquisset Pike Unit 203, North Smithfield, RI 02896

    2beds
    2,700sqft
    : 
    $3,809/mo
    Get pre-qualified
    Townhouse
    Built in 2007
    -- sqft lot
    $-- Zestimate®
    $203/sqft
    $325/mo HOA

    What's special

    Cozy gas fireplaceAdditional storageWell-appointed kitchenCenter islandFinished basementCentral airConveniently located half bath
    Welcome to highly sought-after Rock Cliff Farms! Offering approximately 2,700 sq. ft. of living space, this beautiful oversized condo offers an exceptional amount of space, plenty of storage, and a flexible and functional layout. Step inside to a well-appointed kitchen featuring granite countertops, stainless steel appliances, center island, abundant cabinetry, and a pantry closet, along with a conveniently located half bath. The kitchen flows into the spacious dining and living areas, highlighted by a cozy gas fireplace and slider leading to the outdoor deck. Also located on the first floor is one of two primary suites, complete with a private en-suite bath, double closets, and the added convenience of a washer and dryer. Upstairs, an additional living area offers endless possibilities—perfect for a home office, second living room, rec room, playroom, or flex space. Continue into the second spacious primary suite, also featuring its own en-suite bath and double closets. The finished basement provides even more space to enjoy, along with additional storage, while central air and an attached garage add to the comfort and convenience of this impressive condo. Enjoy the beautifully maintained grounds of Rock Cliff Farms and a location that is hard to beat, with easy highway access and close proximity to shopping, restaurants, and everyday amenities. This beautiful condo is ready to welcome its new owner! *Subject to seller finding suitable housing*
    1 day
    |
    59
    |
    1
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    The ALBA Group,

    Innovations Realty

    Source: StateWide MLS RI,MLS#: 1421117MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 2
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      Heating
      • Natural Gas, Forced Air
      Cooling
      • Central Air
      Appliances
      • Included: Gas Water Heater, Dishwasher, Microwave, Oven/Range, Refrigerator
      Features
      • Flooring: Hardwood, Carpet
      • Basement: Full,Interior Entry,Finished
      • Number of fireplaces: 1
      • Fireplace features: Gas
      Interior area
      • Total structure area: 1,866
      • Total interior livable area: 2,700 sqft
      • Finished area above ground: 1,866
      • Finished area below ground: 834
      Video & virtual tour

      Property

      Parking
      • Total spaces: 2
      • Parking features: Attached, Assigned
      • Attached garage spaces: 1
      Features
      • Stories: 3
      • Patio & porch: Deck, Porch
      Details
      • Parcel number: NSMIM0013L0018U203

      Construction

      Type & style
      • Home type: Townhouse
      • Property subtype: Townhouse
      Materials
      • Vinyl Siding
      • Foundation: Mixed
      Condition
      • New construction: No
      • Year built: 2007

      Utilities & green energy

      • Electric: 200+ Amp Service
      • Water: In Fee
      • Utilities for property: Sewer Connected, Water Connected

      Community & HOA

      HOA
      • Has HOA: No
      • HOA fee: $325 monthly
      Location
      • Region: North Smithfield

      Financial & listing details

      • Price per square foot: $203/sqft
      • Tax assessed value: $328,400
      • Annual tax amount: $5,592
      • Date on market: 8/19/2026

        Estimated market value

        Not available

        Estimated sales range

        Not available

        Not available

        Price history

        DateEventPrice
        8/19/2026Listed for sale$549,333+80.1%$203/sqft
        Source: StateWide MLS RI #1421117 Report a problem
        12/30/2020Sold$305,000-1.6%$113/sqft
        Source: StateWide MLS RI #1271651 Report a problem
        12/11/2020Listed for sale$309,900-6.9%$115/sqft
        Source: RE/MAX Real Estate Center #1271651 Report a problem
        9/17/2007Sold$332,900$123/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$4,850 $328,400
        2024$4,850 +6.2%$328,400
        2023$4,568 $328,400
        2022$4,568 -6.8%$328,400 +9.1%
        2021$4,902 $300,900
        2020$4,902 +2.7%$300,900
        2019$4,775 -1.4%$300,900 +7.2%
        2018$4,841 +2.5%$280,800
        2017$4,723 +2.8%$280,800
        2016$4,594 -3.3%$280,800 -1.4%
        2015$4,749 +4.1%$284,700
        2014$4,561 +1%$284,700
        2013$4,515 -1.2%$284,700 +850.3%
        2012$4,569 -0.5%$29,960 -90%
        2011$4,590 -8%$299,600 -8%
        2010$4,987 +18.3%$325,500 +6.1%
        2009$4,214 +2.7%$306,900 -1%
        2008$4,104 +15%$310,000 +5.7%
        2007$3,568 $293,400
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 02896

        Getting around

        1 / 100
        Car-Dependent
        20 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes