Save
Ask
Tour
Hide
Share
$643,999
27 Days On Site

Rockcliff Farm
40 Louisquisset Pike 603
North Smithfield, RI 02896

For Sale|Condominium|Active
3
Beds
3
Total Baths
2
Full Baths
1
Partial Bath
2,403
SqFt
$268
/SqFt
2006
Built
County:
Providence

Due to the health concerns created by Coronavirus we are offering personal 1-1 online video walkthough tours where possible.

Call Now: ​401-559-7674
Is this the listing for you? We can help make it yours.
​401-559-7674
40 Louisquisset Pike 60340 Louisquisset Pike 60340 Louisquisset Pike 60340 Louisquisset Pike 603
Save
Ask
Tour
Hide
Share

Welcome to Rock Cliff Farm, one of North Smithfield's most desirable condominium communities. This spacious and beautifully maintained townhouse offers over 2,400 square feet of living space, featuring 2 bedrooms, 2.5 bathrooms, and an attached garage. The open-concept main level showcases gleaming hardwood floors, a granite kitchen, formal dining area, and a bright living room with a cozy gas fireplace. Upstairs you'll find a generous primary suite with a private bath, a second bedroom, full bath, and a versatile loft/den perfect for a home office or additional living space. The finished walkout lower level provides an expansive family room, gym, or recreation area with direct outdoor access. Enjoy central air, natural gas heat, low-maintenance living, and a peaceful setting just minutes from Route 146, shopping, restaurants, and everyday conveniences. Move-in ready and offering the perfect blend of comfort, space, and location.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$643,999
Days On Site 
27 Days
Bedrooms 
3
Inside Area (SqFt) 
2,403 sqft
Total Baths 
3
Full Baths 
2
Partial Baths 
1
Lot Size 
N/A
Year Built 
2006
MLS® Number 
1418510
Status 
Active
Property Tax 
$4,452
HOA/Condo/Coop Fees 
$325 monthly
Sq Ft Source 
Public Records
Friends & Family
Recent Activity
a week agoPrice changed to $643,999
a week agoListing updated with changes from the MLS®
4 weeks agoListing first seen on site
General Features
Attached Garage 
Yes
Foundation 
See Remarks
Garage 
Yes
Garage Spaces 
1
Levels 
Two
Number Of Stories 
2
Parking 
AssignedAttachedGarage
Parking Spaces 
3
Pets 
Yes
Property Sub Type 
Condominium
Sewer 
Public Sewer
SqFt Above 
1572
SqFt Below 
831
SqFt Total 
2403
Water Source 
Public
Interior Features
Appliances 
Gas Water Heater
Basement 
Exterior EntryFullFinishedInterior Entry
Cooling 
Central Air
Electric 
200+ Amp Service
Fireplace 
Yes
Fireplace Features 
Gas
Fireplaces 
1
Flooring 
Hardwood
Heating 
Natural GasForced Air
Laundry Features 
Laundry RoomIn Unit
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Vinyl Siding
Community Features
Association Dues 
325
HOA Fee Frequency 
Monthly
Listing courtesy of Fabiana Correia of Keller Williams South Watuppa (401) 538-0211



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-08-18 01:01 PM UTC

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share