Search
Price Range
Save
Ask
Tour
Hide
Share
$510,000
2 Days On Site

RockCliff Farm
40 Old Louisquisset Pike 1804
North Smithfield, RI 02896

For Sale|Condominium|Active
2
Beds
2
Total Baths
2
Full Baths
1,800
SqFt
$283
/SqFt
2015
Built
County:
Providence
Upcoming Open Houses
Sat, Apr 11, 11:00 AM - 1:00 PM
Sun, Apr 12, 10:30 AM - 12:00 PM
40 Old Louisquisset Pike 180440 Old Louisquisset Pike 180440 Old Louisquisset Pike 180440 Old Louisquisset Pike 1804
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$2,327
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.

Welcome to this beautifully maintained condo located in a quiet, highly sought-after association. From the moment you arrive, you'll appreciate the charming curb appeal and inviting setting. Step inside to discover a thoughtfully designed layout with everything you need on the main level, including the primary bedroom, full bathrooms, laundry, and kitchen perfect for easy, single-level living. The open-concept kitchen is equipped with granite countertops and stainless steel appliances, seamlessly flowing into a spacious living area featuring cathedral ceilings, a gas-fired fireplace, and an abundance of natural light. Step out onto your private deck an ideal space to relax, enjoy your morning coffee, or entertain guests. The finished lower level offers additional versatile living space, complete with a walk-out sliding door to the back of the unit, providing even more room to unwind or host. Combining comfort, style, and convenience, this home offers the perfect blend of low-maintenance living and modern appeal.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$510,000
Days On Site 
2 Days
Bedrooms 
2
Inside Area (SqFt) 
1,800 sqft
Total Baths 
2
Full Baths 
2
Partial Baths 
N/A
Lot Size 
N/A
Year Built 
2015
MLS® Number 
1409388
Status 
Active
Property Tax 
$4,700
HOA/Condo/Coop Fees 
$325 monthly
Sq Ft Source 
Public Records
Friends & Family
Recent Activity
3 days agoListing first seen on site
3 days agoListing updated with changes from the MLS®
General Features
Attached Garage 
Yes
Foundation 
Concrete Perimeter
Garage 
Yes
Garage Spaces 
1
Levels 
One
Number Of Stories 
1
Parking 
AssignedAttached
Parking Spaces 
3
Pets 
Yes
Property Sub Type 
Condominium
Sewer 
Public Sewer
SqFt Above 
1192
SqFt Below 
608
SqFt Total 
1800
Utilities 
Cable AvailableSewer ConnectedWater Connected
Water Source 
Public
Interior Features
Appliances 
DryerDishwasherExhaust FanDisposalGas Water HeaterMicrowaveOvenRangeRefrigeratorWasher
Basement 
Exterior EntryFullInterior EntryPartially Finished
Cooling 
Central Air
Electric 
150 Amp Service
Fireplace 
Yes
Fireplace Features 
Gas
Fireplaces 
1
Flooring 
Ceramic TileHardwoodCarpet
Heating 
Natural GasForced Air
Laundry Features 
Common Area
Bedroom 1 
Level - First
Family Room 
Level - Lower
Kitchen 
Level - First
Laundry 
Level - Second
Living Room 
Level - First
PrimaryBedroom 
Level - First
StorageRoom 
Level - Lower
Utility Room 
Level - Lower
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Vinyl Siding
Community Features
Association Amenities 
Maintenance
Association Dues 
325
Community Features 
PoolRestaurant
HOA Fee Frequency 
Monthly
Listing courtesy of Pacheco Homes Team of Century 21 Limitless (401) 808-0673



Listing information is provided by Participants of the State-Wide MLS of Rhode Island, Inc. 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 2026, State-Wide MLS of Rhode Island, Inc.
Last checked: 2026-04-11 12:18 PM UTC

Neighborhood & Commute
Source: Walkscore
Save
Ask
Tour
Hide
Share