Coldwell Banker Home Page

Local Realty Service Provided By: Coldwell Banker Coastal Homes

Property view
Listing view 2
Listing view 3

40 Old Louisquisset Pike #203, 
North Smithfield, RI 02896

$549,333


2

Beds


3

Baths


2,700

Sq Ft


Condo


Virtual Tour

Pending

Listed by

The Alba Group

Innovations Realty

Last updated:

September 8, 2026, 02:05 AM

MLS#

1421117

Source:

RI STATEWIDE

About This Home

40 Old Louisquisset Pike #203

Welcome to highly sought-after Rock Cliff Farms! Offering approximately 2,700 sq. ft. of living space, this beautiful oversized condo offers an exceptional amount of space, plenty of storage, and a flexible and functional layout. Step inside to a well-appointed kitchen featuring granite countertops, stainless steel appliances, center island, abundant cabinetry, and a pantry closet, along with a conveniently located half bath. The kitchen flows into the spacious dining and living areas, highlighted by a cozy gas fireplace and slider leading to the outdoor deck. Also located on the first floor is one of two primary suites, complete with a private en-suite bath, double closets, and the added convenience of a washer and dryer. Upstairs, an additional living area offers endless possibilities perfect for a home office, second living room, rec room, playroom, or flex space. Continue into the second spacious primary suite, also featuring its own en-suite bath and double closets. The finished basement provides even more space to enjoy, along with additional storage, while central air and an attached garage add to the comfort and convenience of this impressive condo. Enjoy the beautifully maintained grounds of Rock Cliff Farms and a location that is hard to beat, with easy highway access and close proximity to shopping, restaurants, and everyday amenities. This beautiful condo is ready to welcome its new owner! *Subject to seller finding suitable housing*

Home Facts

Condo

3 Baths

2 Bedrooms

Built in 2007

Price Summary

549,333

$203 per Sq. Ft.

MLS #:

1421117

Last Updated:

September 8, 2026, 02:05 AM

Added:

a month ago


Rooms & Interior

Bedrooms

Total Bedrooms:

2

Bathrooms

Total Bathrooms:

3

Full Bathrooms:

2

Interior

Living Area:

2,700 Sq. Ft.


Structure

Structure

Building Area:

2,700 Sq. Ft.

Year Built:

2007


Finances & Disclosures

Finances

Price:

$549,333

Price per Sq. Ft:

$203 per Sq. Ft.

MLS Logo
The data relating to real estate for sale on this web site comes in part from the IDX Program of the State-Wide Multiple Listing Service, Inc. Real estate listings held by brokerage firms other than Coldwell Banker Coastal Homes are marked with the MLS logo and detailed information about them includes the name of the listing brokers. Information deemed reliable but not guaranteed. Copyright 2026 State-Wide MLS, Inc. All rights reserved. Date Last Update: September 8, 2026

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.