$475,000
OPEN SUN 1PM - 2:30PM

40 Old Louisquisset Pike Unit 1804 North Smithfield, RI 02896

Estimated payment $3,305/month

Total Views 67
2 Beds
2 Baths
1,800 Sq Ft
$264 Price per Sq Ft

Highlights

  • Wood Flooring
  • 1 Car Attached Garage
  • Storage Room
  • North Smithfield Middle School Rated A-
  • Living Room
  • Public Transportation

About This Home

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.

Listing Agent

Anna Cote

Century 21 Limitless PRG License #RES.0048370 Listed on: 08/14/2025

Century 21 Limitless PRG

Open House Schedule

Property Details

Home Type

  • Condominium

Est. Annual Taxes

  • $4,700

Year Built

  • Built in 2015

Lot Details

  • Fenced

HOA Fees

  • $325 Monthly HOA Fees

Parking

  • 1 Car Attached Garage
  • Assigned Parking

Home Design

  • Vinyl Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • 1-Story Property
  • Gas Fireplace
  • Family Room
  • Living Room
  • Storage Room
  • Utility Room

Kitchen

  • Oven
  • Range
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 2 Bedrooms
  • 2 Full Bathrooms

Laundry

  • Dryer
  • Washer

Partially Finished Basement

  • Basement Fills Entire Space Under The House
  • Interior and Exterior Basement Entry

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Gas
  • Gas Water Heater
  • Cable TV Available

Listing and Financial Details

  • Tax Lot 1804
  • Assessor Parcel Number 40OLDLOUISQUISSETPIKE1804NSMF

Community Details

Overview

  • 80 Units
  • On-Site Maintenance
  • Maintained Community

Amenities

  • Shops
  • Restaurant
  • Public Transportation

Pet Policy

  • Pets Allowed

Property Details

Home Type

Condominium

Est. Annual Taxes

$4,700

Year Built

Built in 2015

Lot Details

0

HOA Fees

$325 per month

Parking

1

Listing Details

  • Property Sub Type: Condominium
  • Prop. Type: Residential
  • Above Grade Finished Sq Ft: 1192.0
  • Building Name: RockCliff Farm
  • Entry Level: 1804
  • Garage Yn: Yes
  • Unit Levels: One
  • New Construction: No
  • Building Stories: 1
  • Year Built: 2015
  • Property Sub Type Additional: Condominium
  • Pets No Pets Comments: Cats
  • Special Features: OpenHouse
  • Stories: 1

Interior Features

  • Appliances: Dryer, Dishwasher, Exhaust Fan, Disposal, Gas Water Heater, Microwave, Oven, Range, Refrigerator, Washer
  • Has Basement: Exterior Entry, Full, Interior Entry, Partially Finished
  • Basement YN: Yes
  • Full Bathrooms: 2
  • Total Bedrooms: 2
  • Below Grade Sq Ft: 608.0
  • Fireplace Features: Gas
  • Fireplaces: 1
  • Fireplace: Yes
  • Flooring: Ceramic Tile, Hardwood, Carpet
  • Interior Amenities: Cable TV
  • Living Area: 1800.0
  • Dining Room Type: Family Room, Living Room, Storage Room, Utility Room
  • Stories: 1

Exterior Features

  • Fencing: Fenced
  • Construction Type: Drywall, Vinyl Siding
  • Foundation Details: Concrete Perimeter

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 1.0
  • Garage Spaces: 1.0
  • Parking Features: Assigned, Built In
  • Total Parking Spaces: 3.0

Utilities

  • Laundry Features: Common Area
  • Cooling: Central Air
  • Cooling Y N: Yes
  • Heating: Forced Air, Gas
  • Heating Yn: Yes
  • Electric: 150 Amp Service
  • Sewer: Connected, Public Sewer
  • Utilities: Sewer Connected
  • Water Source: Connected, Multiple Meters

Condo/Co-op/Association

  • Community Features: Highway Access, Maintenance On-Site, Public Transportation, Restaurant, Shopping
  • Senior Community: No
  • Amenities: Maintenance
  • Association Fee: 325.0
  • Association Fee Frequency: Monthly
  • Pets Allowed: Yes
  • Common Interest: Condominium

Lot Info

  • Parcel #: 40OLDLOUISQUISSETPIKE1804NSMF

Multi Family

  • Number Of Units In Community: 80

Tax Info

  • Tax Annual Amount: 4699.64
  • Tax Lot: 1804
  • Tax Map Number: 013
  • Tax Year: 2025

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $4,093 $277,100 $0 $277,100
2023 $3,949 $277,100 $0 $277,100
2022 $3,854 $277,100 $0 $277,100
2021 $4,138 $254,000 $0 $254,000
2020 $4,138 $254,000 $0 $254,000
2019 $4,031 $254,000 $0 $254,000
2018 $4,469 $259,200 $0 $259,200
2017 $4,360 $259,200 $0 $259,200
2016 $491 $30,000 $0 $30,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/14/2025 08/14/25 For Sale $475,000 -- $264 / Sq Ft
Source: State-Wide MLS

Purchase History

Date Type Sale Price Title Company
Warranty Deed $429,900 None Available
Warranty Deed $429,900 None Available
Quit Claim Deed -- None Available
Quit Claim Deed -- None Available
Warranty Deed $283,500 --
Warranty Deed $283,500 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $343,920 Purchase Money Mortgage
Closed $343,920 Purchase Money Mortgage
Previous Owner $248,000 Stand Alone Refi Refinance Of Original Loan
Previous Owner $277,855 FHA
Source: Public Records

Similar Homes in North Smithfield, RI

  • 36 Old Louisquisset Pike Unit 110, North Smithfield, RI 02896

    $439,900

    • 2 Beds
    • 2 Baths
    • 1,250 Sq Ft
    • 36 Old Louisquisset Pike
    • Unit 110
    • North Smithfield, RI

    Welcome to your new home! With 9 ft ceilings, hardwoods and tile throughout, your carefree maintenance free life awaits you. This is the lifestyle that you have been hoping for! The spacious primary suite has a large walk-in closet, oversized ensuite bathroom with beautiful walk-in shower and double sink vanity. Your guest room may have your guests staying longer with ample closet space and

    Irene Schmitt CrossRoads Real Estate Group

    Section Image
  • 36 Old Louisquisset Pike Unit 104, North Smithfield, RI 02896

    $429,900

    • 2 Beds
    • 2 Baths
    • 1,250 Sq Ft
    • 36 Old Louisquisset Pike
    • Unit 104
    • North Smithfield, RI

    Welcome to your new home! With 9 ft ceilings, hardwoods and tile throughout, your carefree maintenance free life awaits you. This is the lifestyle that you have been hoping for. The spacious primary suite has a large walk-in closet, oversized ensuite bathroom with beautiful walk-in shower and double sink vanity. Your guest room may have your guests staying longer with ample closet space and

    Irene Schmitt CrossRoads Real Estate Group

    Section Image
  • 36 Old Louisquisset Pike Unit 106, North Smithfield, RI 02896

    $439,900

    • 2 Beds
    • 2 Baths
    • 1,250 Sq Ft
    • 36 Old Louisquisset Pike
    • Unit 106
    • North Smithfield, RI

    Welcome to your new home! With 9 ft ceilings, hardwoods and tile throughout, your carefree maintenance free life awaits you. This is the lifestyle that you have been hoping for. The spacious primary suite has a large walk-in closet, oversized ensuite bathroom with beautiful walk-in shower and double sink vanity. Your guest room may have your guests staying longer with ample closet space and

    Irene Schmitt CrossRoads Real Estate Group

    Section Image
  • 36 Old Louisquisset Pike Unit 108, North Smithfield, RI 02896

    $429,900

    • 2 Beds
    • 2 Baths
    • 1,250 Sq Ft
    • 36 Old Louisquisset Pike
    • Unit 108
    • North Smithfield, RI

    Welcome to your new home! With 9 ft ceilings, hardwoods and tile throughout, your carefree maintenance free life awaits you. This is the lifestyle that you have been hoping for! The spacious primary suite has a large walk-in closet, oversized ensuite bathroom with beautiful walk-in shower and double sink vanity. Your guest room may have your guests staying longer with ample closet space and

    Irene Schmitt CrossRoads Real Estate Group

    Section Image
  • 36 Old Louisquisset Pike Unit 105, North Smithfield, RI 02896

    $459,900

    • 2 Beds
    • 2 Baths
    • 1,250 Sq Ft
    • 36 Old Louisquisset Pike
    • Unit 105
    • North Smithfield, RI

    Welcome to your new home! With 9 ft ceilings, hardwoods and tile throughout, your carefree maintenance free life awaits you. This is the lifestyle that you have been hoping for! The spacious primary suite has a large walk-in closet, oversized ensuite bathroom with beautiful walk-in shower and double sink vanity. Your guest room may have your guests staying longer with ample closet space and

    Irene Schmitt CrossRoads Real Estate Group

    Section Image
  • 36 Old Louisquisset Pike Unit 101, North Smithfield, RI 02896

    $459,900

    • 2 Beds
    • 2 Baths
    • 1,250 Sq Ft
    • 36 Old Louisquisset Pike
    • Unit 101
    • North Smithfield, RI

    Welcome to your new home! With 9 ft ceilings, hardwoods and tile throughout, your carefree maintenance free life awaits you. This is the lifestyle that you have been hoping for! The spacious primary suite has a large walk-in closet, oversized ensuite bathroom with beautiful walk-in shower and double sink vanity. Your guest room may have your guests staying longer with ample closet space and

    Irene Schmitt CrossRoads Real Estate Group

    Section Image
  • 36 Old Louisquisset Pike Unit 102, North Smithfield, RI 02896

    $429,900

    • 2 Beds
    • 2 Baths
    • 1,250 Sq Ft
    • 36 Old Louisquisset Pike
    • Unit 102
    • North Smithfield, RI

    Welcome to your new home! With 9 ft ceilings, hardwoods and tile throughout, your carefree maintenance free life awaits you. This is the lifestyle that you have been hoping for! The spacious primary suite has a large walk-in closet, oversized ensuite bathroom with beautiful walk-in shower and double sink vanity. Your guest room may have your guests staying longer with ample closet space and

    Irene Schmitt CrossRoads Real Estate Group

    Section Image
  • 36 Old Louisquisset Pike Unit 103, North Smithfield, RI 02896

    $454,900

    • 2 Beds
    • 2 Baths
    • 1,250 Sq Ft
    • 36 Old Louisquisset Pike
    • Unit 103
    • North Smithfield, RI

    Welcome to your new home! With 9 ft ceilings, hardwoods and tile throughout, your carefree maintenance free life awaits you. This is the lifestyle that you have been hoping for! The spacious primary suite has a large walk-in closet, oversized ensuite bathroom with beautiful walk-in shower and double sink vanity. Your guest room may have your guests staying longer with ample closet space and

    Irene Schmitt CrossRoads Real Estate Group

    Section Image
  • 170 Providence Pike Unit 36, North Smithfield, RI 02896

    $485,000

    • 2 Beds
    • 1.5 Baths
    • 1,621 Sq Ft
    • 170 Providence Pike
    • Unit 36
    • North Smithfield, RI

    Here it is!!! Check out this PRISTINE, single-level, 2 bedroom condo at Laurelwood, northern RI's premier 55+ community. This gorgeous home is set at the back of a cul-de-sac abutting the woods and features a comfortable floorplan with living room, dining room, eat-in-kitchen, bedroom/den, laundry room and master suite. There is hardwood and tile flooring throughout, 9' ceilings, crown moldings,

    Duane Boucher Boucher Real Estate

    Section Image

Source: State-Wide MLS

MLS Number: 1392660

State-Wide MLS

APN: NSMI-000013-000000-000018-001804