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

North Smithfield
Local realty services provided by:ERA Key Realty Services
40 Old Louisquisset Pike #203,North Smithfield, RI 02896
$549,333
Virtual Tour
  • 2 Beds
  • 3 Baths
  • 2,700 sq. ft.
  • Condominium
  • Active
Listed by: the alba group
Office: innovations realty
MLS#:1421117
Source:RI_STATEWIDE

Price summary

  • Price:$549,333
  • Price per sq. ft.:$203.46
  • Monthly HOA dues:$325

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...

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an ERA®  affiliated agent to contact me about my real estate needs. By clicking Send message, 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 an ERA®  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® , Coldwell Banker® , Corcoran® , Sotheby's International Realty® ). I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Year built:2007
  • Listing ID #:1421117
  • Added:1 day(s) ago
  • Updated:August 20, 2026 at 04:54 AM

Rooms and interior

  • Bedrooms:2
  • Total bathrooms:3
  • Full bathrooms:2
  • Half bathrooms:1
  • Rooms Total:5
  • Flooring:Carpet, Hardwood
  • Kitchen Description:Dishwasher, Microwave, Oven, Range, Refrigerator
  • Basement:Yes
  • Basement Description:Finished, Full, Interior Entry
  • Living area:2,700 sq. ft.

Heating and cooling

  • Cooling:Central Air
  • Heating:Forced Air, Gas
  • Central air:Yes

Structure and exterior

  • Year built:2007
  • Building area:2,700 sq. ft.
  • Construction Materials:Vinyl Siding
  • Exterior Features:Deck, Porch
  • Foundation Description:Combination
  • Levels:2 Story

Utilities

  • Water:Connected, Water Tap Fee
  • Sewer:Connected, Sewer Connected

Finances and disclosures

  • Price:$549,333
  • Price per sq. ft.:$203.46
  • Tax amount:$5,592 (2025)

Features and amenities

  • Appliances:Microwave, Range, Refrigerator
  • Amenities:Gas Water Heater, Water Heater

Parking

  • Total parking spaces:2
  • Parking description:Assigned, Attached, Garage
  • Garage:Yes
  • Garage spaces:1
MLS LogoThe 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 ERA Key Realty Services 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: August 20, 2026

New listings near 40 Old Louisquisset Pike #203