- Overview
- Description
- Property Details
- Location
- HOA Management
- Facts & Features
- Getting Around
- Nearby Homes
$545,000
Monthly Est:$2,713
2 Beds
- 3 Baths
2 full baths + 1 half bath
2,700sqft
40 Old Louisquisset Pike #203, North Smithfield, RI 02896
$545,000
$2,713/moEst:
Get Pre-Approved
Condominium
Built in 2007
$325/mo HOA
-- sqft lot
$202/sq.ft
Description
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*
- Houzeo last checked: 14 minutes ago
- Listing updated: October 19, 2026 at 9:45 pm
- Listing Provided by: The ALBA Group | Innovations Realty (401) 414-7414
- Source: RI StateWide MLS-RI | MLS#: 1426270

Property Details
Status
Active
Type
Condominium
No. of Stories
2
County
City
Neighborhood
--
Year Built
2007
HOA Fees
$325/mo
Finished Area
2,700 sqft
Lot Size
-- sqft lot
Basement Area
- sqft
MLS Name
RI StateWide MLS
MLS Number
1426270
MLS Status
Active
Days on Market
2
Open House

Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
HOA Management
N/A
HOA Fees
$325/ Monthly
Amenities
Amenities and services may be covered by one or multiple associations and service providers.
Water
Snow Removal
Maintenance
Trash Pickup
Disclaimer: Amenities are based on third-party information and may vary; buyers must independently verify all amenities, as information is deemed reliable but not guaranteed.
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 2
Bathrooms: 3
Interior
Heating
Forced Air, Gas
Cooling
Central Air
Exterior Features
Deck, Porch
Sewer
Connected
Appliances
Dishwasher, Gas Water Heater, Microwave, Oven, Range, Refrigerator, Water Heater
Flooring
Carpet, Hardwood
Construction
Year Built
Year Built: 2007
Home type
Condominium
Foundation Details
Combination
Construction Materials
Vinyl Siding
Utilities & Energy
Fireplace Features
Gas
Electric
Amps200or More
Water Source
Connected, Water Tap Fee
Basement
Full, Finished, Interior Entry
Parking Features
Assigned, Attached, Garage
Utilities
Sewer Connected
Other Features
Patio And Porch Features
Deck, Porch
Price History
| Date | Event | Price |
|---|---|---|
10/17/2026 Source: | Listed for Sale | $545,000 -0.79% $202/sqft |
09/07/2026 Source: | Pending | $549,333 $203/sqft |
09/07/2026 Source: | Off Market | $549,333 $203/sqft |
08/19/2026 Source: | Listed for Sale | $549,333 +80.11% $203/sqft |
12/31/2020 Source: | Price Decreased | $305,000 -1.58% $113/sqft |
Show more
Nearby Homes
Find Homes by Property Features in North Smithfield, RI
Based on information from State-Wide MLS through Oct 20, 2026, 02:30PM. Information is provided exclusively for consumers’ personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties that consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed accurate by the MLS. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. © 2026 State-Wide MLS, Inc. All rights reserved.
Advertising Broker: Derek Greene | The Greene Realty Group
