Skip main navigation
Sold for $510,000 on 10/24/25
  • $510,000

    40 Old Louisquisset Pike #1804, North Smithfield, RI 02896

    2beds
    1,800sqft
    Condominium
    Built in 2015
    -- sqft lot
    $510,200 Zestimate®
    $283/sqft
    $3,194 Estimated rent

    Owner options

    List your home for rent

    $3,194/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $3,194/mo

    Rent Zestimate®

    Refinance and save

    $2,978/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $2,978/mo

    Est. payment

    What's special

    Located in the highly sought-after Rockcliff community, this beautifully maintained 2-bedroom, 2-bath condo offers nearly 1,800 sg. ft. of single-level living. The open-concept kitchen features granite countertops, stainless steel appliances, and flows into a spacious living room with cathedral ceilings, a gas fireplace, and direct walkout access to a private deck perfect for relaxing or entertaining. Additional highlights include first-floor laundry, well-appointed bedrooms, and a layout designed for both convenience and style.

    Zillow last checked: 8 hours ago

    Listing updated: October 27, 2025 at 08:28am

    Listed by:

    Marianna Cote 401-678-8329,

    Century 21 Limitless PRG

    Bought with:

    Pacheco Homes Team

    Century 21 Limitless

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

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 2
    • Bathrooms: 2
    • Full bathrooms: 2
    Primary bedroom
    • Level: First
    Other
    • Level: First
    Family room
    • Level: Lower
    Kitchen
    • Level: First
    Laundry
    • Level: Second
    Living room
    • Level: First
    Storage
    • Level: Lower
    Utility room
    • Level: Lower
    Heating
    • Natural Gas, Central Air, Forced Air
    Cooling
    • Central Air
    Appliances
    • Included: Gas Water Heater, Dishwasher, Dryer, Exhaust Fan, Disposal, Microwave, Oven/Range, Refrigerator, Washer
    • Laundry: In Building
    Features
    • Wall (Dry Wall), Plumbing (PVC), Ceiling Fan(s)
    • Flooring: Ceramic Tile, Hardwood, Carpet
    • Basement: Full,Interior and Exterior,Partially Finished,Family Room,Living Room,Storage Space,Utility
    • Number of fireplaces: 1
    • Fireplace features: Gas
    Interior area
    • Total structure area: 1,192
    • Total interior livable area: 1,800 sqft
    • Finished area above ground: 1,192
    • Finished area below ground: 608

    Property

    Parking
    • Total spaces: 3
    • Parking features: Integral, Assigned
    • Attached garage spaces: 1
    Features
    • Stories: 1
    • Fencing: Fenced
    Details
    • Parcel number: NSMIM0013L0018U1804
    • Special conditions: Conventional/Market Value
    • Other equipment: Cable TV

    Construction

    Type & style
    • Home type: Condo
    • Property subtype: Condominium
    Materials
    • Dry Wall, Vinyl Siding
    • Foundation: Concrete Perimeter
    Condition
    • New construction: No
    • Year built: 2015

    Utilities & green energy

    • Electric: 150 Amp Service
    • Sewer: Public Sewer
    • Water: Individual Meter
    • Utilities for property: Sewer Connected, Water Connected

    Community & neighborhood

    Community
    • Community features: Near Public Transport, Commuter Bus, Highway Access, Restaurants, Near Shopping, Near Swimming, On-Site Maintenance
    Location
    • Region: North Smithfield

    HOA & financial

    HOA
    • Has HOA: No
    • HOA fee: $325 monthly
    Sell for more on Zillow
    Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
    $510,200
    2% more+$10,204
    With Zillow Showcase(estimated)$520,404