40 Old Louisquisset Pike 1804 North Smithfield, RI 02896
Listing Courtesy of: RHODE ISLAND / Listed By: Jason Pacheco, Century 21 Limitless

  40 Old Louisquisset Pike 1804 North Smithfield, RI 02896

Pending (55 Days)
$495,000 (USD)
2
BED
2
BATH
1,800
SQFT
See Similar Listings

Description

Welcome to this beautifully maintained condo located in a quiet, highly sought-after association. From the moment you arrive, you’ll appreciate the charming curb appeal and inviting setting. Step inside to discover a thoughtfully designed layout with everything you need on the main level, including the primary bedroom, full bathrooms, laundry, and kitchen—perfect for easy, single-level living. The open-concept kitchen is equipped with granite countertops and stainless steel appliances, seamlessly flowing into a spacious living area featuring cathedral ceilings, a gas-fired fireplace, and an abundance of natural light. Step out onto your private deck—an ideal space to relax, enjoy your morning coffee, or entertain guests. The finished lower level offers additional versatile living space, complete with a walk-out sliding door to the back of the unit, providing even more room to unwind or host. Combining comfort, style, and convenience, this home offers the perfect blend of low-maintenance living and modern appeal.

MLS #:
1409388
Taxes
$4,700(2025)
Type
Condo
Building Name
Rockcliff Farm
Year Built
2015
County
Providence County

Listed By

Jason Pacheco, Century 21 Limitless
Source
RHODE ISLAND
Last checked Jun 2 2026 at 12:16 PM GMT+0000
Bathroom Details
  • Full Bathrooms: 2
Interior Features
  • Dishwasher
  • Dryer
  • Oven/Range
  • Refrigerator
  • Washer
  • Gas Water Heater
  • Microwave
  • Laundry: In Building
  • Exhaust Fan
  • Disposal
  • Wall (Dry Wall)
  • Plumbing (Pvc)
Property Features
  • Fireplace: Gas
  • Fireplace: 1
  • Foundation: Concrete Perimeter
Heating and Cooling
  • Forced Air
  • Natural Gas
  • Central Air
Basement Information
  • Full
  • Partially Finished
  • Interior and Exterior
  • Storage Space
  • Utility
  • Family Room
  • Living Room
Homeowners Association Information
  • Dues: $325/Monthly
Flooring
  • Hardwood
  • Ceramic Tile
  • Carpet
Utility Information
  • Sewer: Connected, Public
Garage
  • Attached Garage
Parking
  • Total: 3
  • Integral
  • Assigned
Stories
  • 1
Living Area
  • 1,800 sqft

Listing Price History

Date
Event
Price
% Change
$ (+/-)
Apr 19, 2026
Price Changed
$495,000
-3%
-$15,000
Apr 08, 2026
Listed
$510,000
-
-
Location
Map View | Street View
   
Calculate drive times to this property
 
Powered by INRIX® Drive Time
Powered by Walk Score®
Disclaimer: 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. 6/2/26 05:16

Coldwell Banker - Pensacola

© 2026 Coldwell Banker Real Estate LLC

Terms Of Use | Privacy Policy

Accessibility Statement | Fair Housing Notice

© Coldwell Banker 2023 – 2025. All Rights Reserved. Coldwell Banker and the Coldwell Banker logo are trademarks of Coldwell Banker Real Estate LLC. The Coldwell Banker® System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices which are independently owned and operated. The Coldwell Banker System fully supports the principles of the Fair Housing Act and the Equal Opportunity Act.