NOT LISTED FOR SALE

40 Old Louisquisset Pike Unit 1804 North Smithfield, RI 02896

Estimated Value: $424,000 - $484,000

2 Beds
2 Baths
1,800 Sq Ft
$254/Sq Ft Est. Value

Last Sold December 21, 2023

Last sale price $429,900 $239 Per Sq Ft

Est. 7% increase in value since last sale

Current estimated payment $3,184/month

97 Days on Market

Highlights

  • Golf Course Community
  • Deck
  • Wood Flooring
  • North Smithfield Middle School Rated A-
  • Cathedral Ceiling
  • Recreation Facilities

About This Home

As of December 2023

Welcome to the desirable RockCliff Farm Condominium Association! This single level condominium offers, two bedrooms and two full baths as well as a front porch and first floor laundry! A beautiful and well-appointed kitchen with pantry closet features granite countertops and stainless appliances and gleaming hardwood floors flowing into the spacious living room offering vaulted ceilings and a gas-fireplace. Just off the living room is a large deck with a sun setter awning! The walkout lower level offers a spacious family room, as well as storage and oversized walk-in closet and also has a utility room. A single car, garage and off-street parking add to the convenience of this lovely home. MUST SEE!!!

Last Listed By

Christopher Cote

Alliance Real Estate Group LLC License #RES.0033920 Listed on: 08/14/2023

Townhouse Details

Home Type

  • Townhome

Est. Annual Taxes

  • $3,598

Year Built

  • Built in 2015

HOA Fees

  • $280 Monthly HOA Fees

Parking

  • 1 Car Attached Garage
  • Garage Door Opener
  • Driveway
  • Assigned Parking

Home Design

  • Vinyl Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • 1-Story Property
  • Cathedral Ceiling
  • Gas Fireplace
  • Thermal Windows
  • Family Room
  • Storage Room
  • Utility Room

Kitchen

  • Oven
  • Range
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 2 Bedrooms
  • 2 Full Bathrooms
  • Bathtub with Shower

Laundry

  • Laundry in unit
  • Dryer
  • Washer

Partially Finished Basement

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

Home Security

Accessible Home Design

  • Accessibility Features
  • Low Pile Carpeting

Outdoor Features

  • Deck
  • Porch

Utilities

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

Additional Features

  • Sprinkler System
  • Property near a hospital

Listing and Financial Details

  • Tax Lot 1804
  • Assessor Parcel Number 40OLDLOUISQUISSETPIKE1804NSMF

Community Details

Overview

  • Association fees include ground maintenance, parking, snow removal
  • 80 Units
  • Rockcliff Farm Subdivision

Amenities

  • Shops
  • Restaurant
  • Public Transportation

Recreation

  • Golf Course Community
  • Recreation Facilities

Pet Policy

  • Pets Allowed

Security

  • Storm Doors

Townhouse Details

Home Type

Townhome

Est. Annual Taxes

$3,598

Year Built

Built in 2015

Lot Details

0

HOA Fees

$280 per month

Parking

1

Listing Details

  • Property Sub Type: Condominium
  • Prop. Type: Residential
  • Subdivision Name: RockCliff Farm
  • Above Grade Finished Sq Ft: 1192.0
  • Building Name: RockCliff Farm
  • Entry Level: 1804
  • Garage Yn: Yes
  • Unit Levels: Two, One
  • New Construction: No
  • Building Stories: 1
  • Structure Type: Townhouse
  • Year Built: 2015
  • Property Sub Type Additional: Condominium
  • Special Features: VirtualTour
  • Stories: 1

Interior Features

  • Appliances: Dryer, Dishwasher, Exhaust Fan, Disposal, Gas Water Heater, Microwave, Oven, Range, Refrigerator, Water Heater, Washer
  • Accessibility Features: Accessibility Features, Low Pile Carpet
  • Has Basement: Exterior Entry, Full, Interior Entry, Partially Finished
  • Basement YN: Yes
  • Full Bathrooms: 2
  • Total Bedrooms: 2
  • Below Grade Sq Ft: 608.0
  • Door Features: Storm Door(s)
  • Entry Location: First Floor Access,Private Entry
  • Fireplace Features: Gas
  • Fireplaces: 1
  • Fireplace: Yes
  • Flooring: Ceramic Tile, Hardwood, Carpet
  • Interior Amenities: Cathedral Ceiling(s), Tub Shower, Cable TV
  • Living Area: 1800.0
  • Dining Room Type: Family Room, Storage Room, Utility Room
  • Stories: 1
  • Window Features: Thermal Windows
  • ResoLivingAreaSource: PublicRecords

Exterior Features

  • Lot Features: Sprinkler System
  • Construction Type: Drywall, Vinyl Siding
  • Exterior Features: Deck, Porch, Sprinkler/Irrigation, Paved Driveway
  • Foundation Details: Concrete Perimeter
  • Patio And Porch Features: Deck, Porch

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 1.0
  • Garage Spaces: 1.0
  • Parking Features: Assigned, Built In, Garage Door Opener
  • Total Parking Spaces: 2.0

Utilities

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

Condo/Co-op/Association

  • Community Features: Golf, Highway Access, Near Hospital, Near Schools, Public Transportation, Recreation Area, Restaurant, Shopping
  • Senior Community: No
  • Association Fee: 280.0
  • Association Fee Frequency: Monthly
  • Pets Allowed: Yes
  • Common Interest: Condominium

Fee Information

  • Association Fee Includes: Maintenance Grounds, Parking, Snow Removal

Lot Info

  • Parcel #: 40OLDLOUISQUISSETPIKE1804NSMF
  • Zoning: RES
  • ResoLotSizeUnits: SquareFeet

Multi Family

  • Number Of Units In Community: 80

Tax Info

  • Tax Annual Amount: 3598.0
  • Tax Block: 0000
  • Tax Lot: 1804
  • Tax Year: 2023

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 14, 2023
Closed on
Dec 21, 2023
Sold by
Taft William C and Taft Dawn M
Bought by
Salzillo Charlotte A and Salzillo David A
Seller's Agent
Christopher Cote
Alliance Real Estate Group LLC
Buyer's Agent
Premier Group
Century 21 Limitless PRG
List Price
$432,900
Sold Price
$429,900
Premium/Discount to List
-$3,000
-0.69%
Total Days on Market
97
Views
790
Current Estimated Value
$457,888

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$27,988
Avg. Annual Appreciation
4.51%
Original Mortgage
$343,920
Outstanding Balance
$339,919
Interest Rate
7.5%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$117,969

Purchase Details

Closed on
Mar 24, 2022
Sold by
Taft William C
Bought by
Taft William C and Taft Dawn M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$248,000
Interest Rate
3.91%
Mortgage Type
Stand Alone Refi Refinance Of Original Loan

Purchase Details

Listed on
Aug 29, 2015
Closed on
Apr 28, 2016
Sold by
Rockcliff Farm Llc
Bought by
Taft William
Seller's Agent
Kathy Bain Farrell
RE/MAX Town & Country
Buyer's Agent
Sean Hevenor
RI Real Estate Services
List Price
$265,000
Sold Price
$283,500
Premium/Discount to List
$18,500
6.98%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.42%
Original Mortgage
$277,855
Interest Rate
3.73%
Mortgage Type
FHA

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

Similar Home in North Smithfield, RI

See All Homes in North Smithfield

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Salzillo Charlotte A $429,900 None Available
Salzillo Charlotte A $429,900 None Available
Taft William C -- None Available
Taft William C -- None Available
Taft William $283,500 --
Taft William $283,500 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Salzillo Charlotte A $343,920
Closed Salzillo Charlotte A $343,920
Previous Owner Taft William C $248,000
Previous Owner Taft William $277,855
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/21/2023 12/21/23 Sold $429,900 -0.7% $239 / Sq Ft
11/20/2023 11/20/23 Pending -- -- --
08/14/2023 08/14/23 For Sale $432,900 +52.7% $241 / Sq Ft
04/27/2016 04/27/16 Sold $283,500 +7.0% $235 / Sq Ft
03/28/2016 03/28/16 Pending -- -- --
08/29/2015 08/29/15 For Sale $265,000 -- $220 / Sq Ft
Source: State-Wide MLS

Tax History Compared to Growth

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

Agents Affiliated with this Home

  • Christopher Cote

    Seller's Agent in 2023

    Christopher Cote

    Alliance Real Estate Group LLC

    (401) 497-8233

    1 in this area

    15 Total Sales

    Christopher Cote
    Section Image

  • P

    Buyer's Agent in 2023

    Premier Group

    Century 21 Limitless PRG

    (401) 288-3600

    9 in this area

    600 Total Sales

    Premier Group
    Section Image
  • Kathy Bain Farrell

    Seller's Agent in 2016

    Kathy Bain Farrell

    RE/MAX Town & Country

    (401) 374-1211

    11 in this area

    535 Total Sales

    Kathy Bain Farrell
    Section Image
  • Sean Hevenor

    Buyer's Agent in 2016

    Sean Hevenor

    RI Real Estate Services

    (401) 499-5700

    42 Total Sales

    Sean Hevenor
    Section Image
See All Agents

Map

Source: State-Wide MLS

MLS Number: 1341740

State-Wide MLS

APN: NSMI-000013-000000-000018-001804

Rhode Island Providence County North Smithfield 02896

40 Old Louisquisset Pike Unit 1804, North Smithfield, RI

Homes for Sale in North Smithfield, RI

This home is located at 40 Old Louisquisset Pike Unit 1804, North Smithfield, RI 02896 since 14 August 2023 and is currently estimated at $457,888, approximately $254 per square foot. This property was built in 2015. 40 Old Louisquisset Pike Unit 1804 is a home located in Providence County with nearby schools including North Smithfield Elementary School, North Smithfield Middle School, and North Smithfield High School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

State-Wide MLS IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.
Copyright © 2025 State-Wide MLS, Inc. All rights reserved.

Nearby Homes