Paiva Realty GroupThe Perrino Team
Price ReducedListed Oct 17, 2026 · 34 days on market
1 of 22
Open House · Sat Nov 21, 1–2PM

40 Old Louisquisset Pike #203

North Smithfield, RI 02896 · Providence County

$530,000

$196/sqft

$545,000

Active

2

Beds

3

Baths

2,700

Sq Ft

2007

Year Built

$196/sqft

Price/Sqft

$325/mo HOA

HOA

About This Home

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!

Property Details

Property TypeCondominium
MLS #1426270
Lot Size—
Garage Spaces1
Stories2
Days on Market34
WaterfrontNo
HOA Fee$325 / Monthly
2025 Taxes$5,592
Assessed Value$486,300
Tax Map #013
Tax Lot018-203

Heating

Natural GasForced Air

Cooling

Central Air

Our estimate, not part of the MLS listing

Estimated monthly cost

$3,838/mo

  • Principal & interest

    30-year at 7.25%, estimated rate

    $2,892

  • Property tax

    2025 tax bill (State-Wide MLS)

    $466

  • Homeowners insurance

    Estimate: the greater of $1,400/yr or 0.35% of price

    $155

  • HOA fee

    State-Wide MLS

    $325

  • Total

    $3,838/mo

Checking the FEMA flood map…

%
%

Term

$/yr

Rate: estimate (the current Freddie Mac weekly average couldn't be loaded)

First-time buyer? See RIHousing's homebuyer programs

Plan Your Purchase

Estimate only, not a loan offer. Taxes, insurance and rates vary.

Map and nearby listings

Open in map search →
Loading map…

MLS IDX

Courtesy of: Innovations Realty · The ALBA Group

IDX information is provided exclusively for consumers' 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 is not guaranteed. © 2026 State-Wide Multiple Listing Service. All rights reserved.

Presented by Paiva Realty Group · The Perrino Team · (401) 206-8907

Open House

Sat Nov 21, 1–2PM

Add to Google Calendar
SP

Stephen Perrino

Paiva Realty Group

The Perrino Team

First-time buyer? Learn about buyer representation →

Schedule a Showing

Privacy Policy · Terms of Service

Call Agent