$450,000

40 Old Louisquisset Pike Unit 102A North Smithfield, RI 02896

Estimated payment $3,254/month

Total Views 287
2 Beds
2.5 Baths
2,952 Sq Ft
$152 Price per Sq Ft

Highlights

  • Deck
  • Cathedral Ceiling
  • Attic
  • North Smithfield Middle School Rated A-
  • Wood Flooring
  • Recreation Facilities

About This Home

PRICED TO SELL AND IN GREAT CONDITION! Nearly 3000 sqft of nicely appointed living space awaits in this outstanding 2-bedroom, 2.5-bath Townhome. Sunlight pours into the granite kitchen with center island and cathedral ceilings, seamlessly connecting to the spacious dining area and fireplaced family room, all with hardwood floors. Step out onto the deck to enjoy peaceful views or fire up the grill for your favorite BBQ recipes. The first-floor primary bedroom with ensuite (and laundry) is a tranquil retreat. Upstairs, you'll find a large second bedroom, a full bath with jetted tub and shower, and a large loft-style great room. The 1000+ sqft finished walkout lower-level with private patio offers even more flexibility, perfect for a rec room, guest bedroom, home office, or exercise studio. Additional features include Nest smart thermostats, central air, and an attached one-car garage. Located next to Dowling Village Shopping Center with top retail and dining, and just 18 minutes to Downtown Providence, 30 minutes to T.F. Green Airport, and 90 minutes to Boston. Exceptional opportunity, offered well below market value and town assessment for a quick sale! Call today for more details.

Listing Agent

Steven Miller

Coldwell Banker Realty Listed on: 08/08/2025

Coldwell Banker Realty

Townhouse Details

Home Type

  • Townhome

Est. Annual Taxes

  • $5,723

Year Built

  • Built in 2006

Lot Details

  • Sprinkler System

HOA Fees

  • $325 Monthly HOA Fees

Parking

  • 1 Car Attached Garage
  • Driveway
  • Assigned Parking

Home Design

  • Vinyl Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • 2-Story Property
  • Cathedral Ceiling
  • Skylights
  • Gas Fireplace
  • Family Room
  • Utility Room
  • Home Gym
  • Attic

Kitchen

  • Oven
  • Range
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 2 Bedrooms
  • Bathtub with Shower

Laundry

  • Laundry in unit
  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Outdoor Features

  • Deck
  • Patio
  • Outdoor Grill
  • Porch

Utilities

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

Listing and Financial Details

  • Tax Lot 18
  • Assessor Parcel Number 40OLDLOUISQUISSETPIKE102NSMF

Community Details

Overview

  • Association fees include insurance, ground maintenance, sewer, snow removal, trash, water
  • 71 Units
  • North Smithfield Subdivision

Amenities

  • Shops
  • Restaurant

Recreation

  • Recreation Facilities

Pet Policy

  • Pets Allowed

Townhouse Details

Home Type

Townhome

Est. Annual Taxes

$5,723

Year Built

Built in 2006

Lot Details

0

HOA Fees

$325 per month

Parking

1

Listing Details

  • Property Sub Type: Condominium
  • Prop. Type: Residential
  • Inclusions: **Estate Sale, being sold in "AS-IS" condition. Pre-Foreclosure, subject to seller's lender and foreclosure attorney approval.
  • Subdivision Name: NORTH SMITHFIELD
  • Above Grade Finished Sq Ft: 1866.0
  • Building Name: ROCKCLIFF FARM
  • Entry Level: 1
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Building Stories: 2
  • Structure Type: Townhouse
  • Year Built: 2006
  • Property Sub Type Additional: Condominium
  • Pets No Pets Comments: Cats,Small Dogs (under 25 lbs.)
  • Special Features: 4097
  • Stories: 2

Interior Features

  • Appliances: Dryer, Dishwasher, Disposal, Gas Water Heater, Microwave, Oven, Range, Refrigerator, Water Heater, Washer
  • Owner Pays: Hot Water
  • Has Basement: Full, Finished, Walk-Out Access
  • Basement YN: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 2
  • Below Grade Sq Ft: 1086.0
  • Entry Location: First Floor Access,Private Entry
  • Fireplace Features: Gas
  • Fireplaces: 1
  • Fireplace: Yes
  • Flooring: Ceramic Tile, Hardwood, Carpet
  • Interior Amenities: Attic, Cathedral Ceiling(s), High Ceilings, Skylights, Stall Shower, Tub Shower, Vaulted Ceiling(s), Cable TV
  • Living Area: 2952.0
  • Dining Room Type: Bedroom, Family Room, Gym, Utility Room
  • Stories: 2
  • Window Features: Skylight(s)

Exterior Features

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

Garage/Parking

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

Utilities

  • Laundry Features: In Unit
  • Cooling: Central Air
  • Cooling Y N: Yes
  • Heating: Forced Air, Gas, Zoned
  • Heating Yn: Yes
  • Electric: Circuit Breakers
  • Sewer: Connected, Public Sewer
  • Utilities: Sewer Connected
  • Water Source: Connected, Public, Water Tap Fee

Condo/Co-op/Association

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

Fee Information

  • Association Fee Includes: Insurance, Maintenance Grounds, Sewer, Snow Removal, Trash, Water

Lot Info

  • Parcel #: 40OLDLOUISQUISSETPIKE102NSMF
  • Zoning: BH

Multi Family

  • Number Of Units In Community: 71

Tax Info

  • Tax Annual Amount: 5723.0
  • Tax Lot: 18
  • Tax Map Number: 13
  • 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,967 $336,300 $0 $336,300
2023 $4,792 $336,300 $0 $336,300
2022 $4,678 $336,300 $0 $336,300
2021 $5,019 $308,100 $0 $308,100
2020 $5,019 $308,100 $0 $308,100
2019 $4,890 $308,100 $0 $308,100
2018 $4,957 $287,500 $0 $287,500
2017 $4,836 $287,500 $0 $287,500
2016 $4,704 $287,500 $0 $287,500
2015 $4,749 $284,700 $0 $284,700
2014 $4,561 $284,700 $0 $284,700
Source: Public Records

Property History

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

Purchase History

Date Type Sale Price Title Company
Public Action Common In Florida Clerks Tax Deed Or Tax Deeds Or Property Sold For Taxes $2,897 None Available
Public Action Common In Florida Clerks Tax Deed Or Tax Deeds Or Property Sold For Taxes $2,897 None Available
Warranty Deed $315,000 --
Warranty Deed $315,000 --
Deed $287,555 --
Deed $287,555 --
Quit Claim Deed -- --
Quit Claim Deed -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $248,000 Stand Alone Refi Refinance Of Original Loan
Previous Owner $252,000 Purchase Money Mortgage
Previous Owner $150,000 No Value Available
Source: Public Records

Similar Homes in North Smithfield, RI

  • 40 Old Louisquisset Pike Unit 802H, North Smithfield, RI 02896

    $499,999

    • 2 Beds
    • 2.5 Baths
    • 2,391 Sq Ft
    • 40 Old Louisquisset Pike
    • Unit 802H
    • North Smithfield, RI

    Located in the desirable Rock Cliff Farm community, this immaculate 2-bed, 2.5-bath townhouse offers approximately 2,391 sq.ft. of finished living space, including a walkout basement. Set on a premium wooded lot with tree-lined views in the front and back, the home is packed with upgrades including a Bosch appliance package with induction range, quartz countertops, custom cabinetry, and elegant

    Kamil Sarji Gold Door Realty

    Section Image
  • 1 Tupperware Dr Unit 226, North Smithfield, RI 02896

    $439,000

    • 3 Beds
    • 1 Bath
    • 1,667 Sq Ft
    • 1 Tupperware Dr
    • Unit 226
    • North Smithfield, RI

    Welcome to The High Rocks Condominiums, a highly sought-after complex that offers timeless living with modern amenities. With access to a community Game Room, Gym, Library, & Rooftop Deck, this truly is the place to call home! The beautifully crafted wood ceilings with custom beam details welcome you as you enter this stylish Second floor unit. Featuring a newly renovated Kitchen that spotlights

    Roxanne Beretta RE/MAX Real Estate Center

    Section Image
See All Homes in North Smithfield

Source: State-Wide MLS

MLS Number: 1392531

State-Wide MLS

APN: NSMI-000013-000018-000102

Rhode Island Providence County North Smithfield 02896

40 Old Louisquisset Pike Unit 102A, North Smithfield, RI

This home is located at 40 Old Louisquisset Pike Unit 102A, North Smithfield, RI 02896 and is currently priced at $450,000, approximately $152 per square foot. This property was built in 2006. 40 Old Louisquisset Pike Unit 102A 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
Steven Miller
Listing Agent
Steven Miller
Section Image
Coldwell Banker Realty
(401) 593-3731