Welcome Home! As you enter, you'll be greeted by a stunning loft entrance with cathedral ceilings. This spectacular 2-bedroom, 2.5-bath townhouse, located in the desirable Rock Cliff Farms community was the Model Unit, offers a wealth of features. With gorgeous hardwood flooring, the open floor plan is perfect for entertaining. The spacious kitchen comes fully equipped with appliances, granite countertops, and a breakfast bar with seating. The dining area flows seamlessly into a cozy living room that features sliders leading to an outdoor deck overlooking a picturesque wooded area. The beautiful wood staircase guides you to the second level overlooking the loft brings you to a spacious full bath, the primary suite boasts cathedral ceilings that allow plenty of natural light in, full bathroom, a large walk-in closet, large second bedroom also features cathedral ceilings, and for added convenience the laundry area is located on the second level. Additionally, the fully finished basement includes a family room with gas zero clearance fireplace and ample storage, complete with sliders that open to the patio. Other notable features include a one-car garage, a private entrance, a private alarm system, a new air conditioning unit, a new water heater, freshly installed carpet, and fresh paint throughout.
Sold for $492,450 on 01/29/25
$492,450
40 Old Louisquisset Pike UNIT 803, North Smithfield, RI 02896
2beds
2,063sqft
Townhouse
Built in 2008
-- sqft lot
$503,800 Zestimate®
$239/sqft
$3,076 Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: January 30, 2025 at 10:19am
Listed by:
Debra Fonger 401-588-2523,
Jack Conway & Co Inc.
Bought with:
Kelli Dawley, RES.0041920
BHHS Commonwealth Real Estate
Source: StateWide MLS RI,MLS#: 1373485

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Level: Second
Bathroom
- Level: First
Bathroom
- Level: Second
Other
- Level: Second
Dining area
- Level: First
Family room
- Level: Lower
Kitchen
- Level: First
Living room
- Level: First
Heating
- Natural Gas, Forced Air
Cooling
- Central Air
Appliances
- Included: Gas Water Heater, Dishwasher, Dryer, Exhaust Fan, Disposal, Microwave, Oven/Range, Refrigerator, Washer
- Laundry: In Unit
Features
- Wall (Plaster), Cathedral Ceiling(s), Skylight, Stairs, Plumbing (Mixed), Insulation (Ceiling), Insulation (Floors), Insulation (Walls), Ceiling Fan(s)
- Flooring: Ceramic Tile, Hardwood, Carpet
- Windows: Storm Window(s), Skylight(s)
- Basement: Full,Interior and Exterior,Partially Finished,Family Room,Playroom,Storage Space,Utility
- Number of fireplaces: 1
- Fireplace features: Zero Clearance
Interior area
- Total structure area: 1,647
- Total interior livable area: 2,063 sqft
- Finished area above ground: 1,647
- Finished area below ground: 416
Property
Parking
- Total spaces: 3
- Parking features: Integral, Unassigned, Driveway
- Attached garage spaces: 1
- Has uncovered spaces: Yes
Features
- Stories: 2
- Entry location: Private Entry
- Patio & porch: Deck, Patio
Lot
- Features: Sprinklers, Wooded
Details
- Parcel number: NSMIM0013L0018U803
- Zoning: BH
- Special conditions: Conventional/Market Value
- Other equipment: Cable TV
Construction
Type & style
- Home type: Townhouse
- Property subtype: Townhouse
Materials
- Plaster, Vinyl Siding
- Foundation: Concrete Perimeter
Condition
- New construction: No
- Year built: 2008
Utilities & green energy
- Electric: 150 Amp Service
- Utilities for property: Underground Utilities, Sewer Connected, Water Connected
Community & neighborhood
Security
- Security features: Security System Owned
Community
- Community features: Near Public Transport, Commuter Bus, Golf, Highway Access, Hospital, Interstate, Public School, Recreational Facilities, Restaurants, Near Shopping
Location
- Region: North Smithfield
- Subdivision: Rock Cliff Farms
HOA & financial
HOA
- Has HOA: No
- HOA fee: $310 monthly
Services availability

Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.
Sell for more on Zillow
Get a free Zillow Showcase℠ listing and you could sell for .
$503,800
2% more+ $10,076
With Zillow Showcase(estimated)
$513,876