Located in the highly sought-after Rockcliff community, this beautifully maintained 2-bedroom, 2-bath condo offers nearly 1,800 sg. ft. of single-level living. The open-concept kitchen features granite countertops, stainless steel appliances, and flows into a spacious living room with cathedral ceilings, a gas fireplace, and direct walkout access to a private deck perfect for relaxing or entertaining. Additional highlights include first-floor laundry, well-appointed bedrooms, and a layout designed for both convenience and style.
Sold for $510,000 on 10/24/25
$510,000
40 Old Louisquisset Pike #1804, North Smithfield, RI 02896
2beds
1,800sqft
Condominium
Built in 2015
-- sqft lot
$510,200 Zestimate®
$283/sqft
$3,194 Estimated rent
Owner options
What's special
Zillow last checked: 8 hours ago
Listing updated: October 27, 2025 at 08:28am
Listed by:
Marianna Cote 401-678-8329,
Century 21 Limitless PRG
Bought with:
Pacheco Homes Team
Century 21 Limitless
Source: StateWide MLS RI,MLS#: 1392660
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 2
- Full bathrooms: 2
Primary bedroom
- Level: First
Other
- Level: First
Family room
- Level: Lower
Kitchen
- Level: First
Laundry
- Level: Second
Living room
- Level: First
Storage
- Level: Lower
Utility room
- Level: Lower
Heating
- Natural Gas, Central Air, Forced Air
Cooling
- Central Air
Appliances
- Included: Gas Water Heater, Dishwasher, Dryer, Exhaust Fan, Disposal, Microwave, Oven/Range, Refrigerator, Washer
- Laundry: In Building
Features
- Wall (Dry Wall), Plumbing (PVC), Ceiling Fan(s)
- Flooring: Ceramic Tile, Hardwood, Carpet
- Basement: Full,Interior and Exterior,Partially Finished,Family Room,Living Room,Storage Space,Utility
- Number of fireplaces: 1
- Fireplace features: Gas
Interior area
- Total structure area: 1,192
- Total interior livable area: 1,800 sqft
- Finished area above ground: 1,192
- Finished area below ground: 608
Property
Parking
- Total spaces: 3
- Parking features: Integral, Assigned
- Attached garage spaces: 1
Features
- Stories: 1
- Fencing: Fenced
Details
- Parcel number: NSMIM0013L0018U1804
- Special conditions: Conventional/Market Value
- Other equipment: Cable TV
Construction
Type & style
- Home type: Condo
- Property subtype: Condominium
Materials
- Dry Wall, Vinyl Siding
- Foundation: Concrete Perimeter
Condition
- New construction: No
- Year built: 2015
Utilities & green energy
- Electric: 150 Amp Service
- Sewer: Public Sewer
- Water: Individual Meter
- Utilities for property: Sewer Connected, Water Connected
Community & neighborhood
Community
- Community features: Near Public Transport, Commuter Bus, Highway Access, Restaurants, Near Shopping, Near Swimming, On-Site Maintenance
Location
- Region: North Smithfield
HOA & financial
HOA
- Has HOA: No
- HOA fee: $325 monthly
Sell for more on Zillow
Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
$510,200
2% more+$10,204
With Zillow Showcase(estimated)$520,404