Skip main navigation
Sold for $779,000 on 09/30/25
  • $779,000

    123 Castle Rocks Rd, Warwick, RI 02886

    4beds
    2,908sqft
    Single Family Residence
    Built in 1999
    0.58 Acres Lot
    $801,200 Zestimate®
    $268/sqft
    $4,293 Estimated rent

    Owner options

    List your home for rent

    $4,293/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $4,293/mo

    Rent Zestimate®

    Refinance and save

    $4,430/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $4,430/mo

    Est. payment

    What's special

    Welcome to your dream home in the coveted Seventeen Farms community, this exquisite center hall Colonial offers everything you’ve been searching for.. With 4 spacious bedrooms, 2 full and a half baths, this meticulously maintained residence provides ample space for both relaxation and entertainment.As you approach the home, you'll be greeted by a charming Farmers porch. Step inside to discover a thoughtfully designed layout featuring hardwood floors that flow seamlessly throughout the downstairs area.The heart of this home is the chef's eat-in kitchen, equipped with top-of-the-line Bosch appliances. Whether you're preparing a family meal or hosting a dinner party, this kitchen is a culinary dream. The primary suite is a sanctuary, featuring a California walk-in closet that will make organizing your wardrobe a breeze. Unwind in your private space after a long day. A home office provides the perfect environment for remote work or study.Venture downstairs to find a finished walkout basement that opens up to your beautifull backyard, where you can entertain guests. The outdoor space is complete with a deck, patio, and firepit—ideal for summer barbecues and fall gatherings. The lush, wooded backdrop offers privacy and tranquility. Seventeen Farms Development is known for its friendly atmosphere, proximity to amenities, and excellent schools, making it a wonderful place to call home. Don’t miss this opportunity to own a slice of paradise in a highly sought-after neighborhood

    Zillow last checked: 8 hours ago

    Listing updated: September 30, 2025 at 12:01pm

    Listed by:

    Belinda Nattress 401-487-2279,

    Keller Williams Coastal

    Bought with:

    Wendy Bowen, RES.0040653

    Greenwich Bay Brokers

    Source: StateWide MLS RI,MLS#: 1387429MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 3
    • Full bathrooms: 2
    • 1/2 bathrooms: 1
    Bathroom
    • Features: Bath w Tub & Shower
    Heating
    • Natural Gas, Central Air, Forced Air, Gas Connected, Zoned
    Cooling
    • Central Air
    Appliances
    • Included: Gas Water Heater, Dishwasher, Dryer, Disposal, Range Hood, Microwave, Oven/Range, Refrigerator, Washer
    Features
    • Wall (Dry Wall), Plumbing (Mixed), Insulation (Ceiling), Insulation (Floors), Insulation (Walls), Ceiling Fan(s)
    • Flooring: Ceramic Tile, Hardwood, Carpet
    • Doors: Storm Door(s)
    • Windows: Insulated Windows
    • Basement: Full,Walk-Out Access,Partially Finished,Common,Playroom,Storage Space
    • Number of fireplaces: 1
    • Fireplace features: Tile
    Interior area
    • Total structure area: 2,186
    • Total interior livable area: 2,908 sqft
    • Finished area above ground: 2,186
    • Finished area below ground: 722

    Property

    Parking
    • Total spaces: 8
    • Parking features: Attached, Driveway
    • Attached garage spaces: 2
    • Has uncovered spaces: Yes
    Features
    • Patio & porch: Deck, Patio
    Lot
    • Size: 0.58 Acres
    • Features: Cul-De-Sac, Sprinklers, Wooded
    Details
    • Additional structures: Outbuilding
    • Parcel number: WARWM224B0045L0000
    • Special conditions: Conventional/Market Value
    • Other equipment: Cable TV

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    • Property subtype: Single Family Residence
    Materials
    • Dry Wall, Vinyl Siding
    • Foundation: Concrete Perimeter
    Condition
    • New construction: No
    • Year built: 1999

    Utilities & green energy

    • Electric: 150 Amp Service
    • Sewer: Septic Tank
    • Water: Individual Meter, Municipal
    • Utilities for property: Underground Utilities, Water Connected

    Community & neighborhood

    Security
    • Security features: Security System Leased
    Community
    • Community features: Near Public Transport, Commuter Bus, Golf, Highway Access, Hospital, Interstate, Marina, Private School, Public School, Railroad, Recreational Facilities, Restaurants, Schools, Near Shopping, Near Swimming, Tennis
    Location
    • Region: Warwick
    • Subdivision: Seventeen Farms

    HOA & financial

    HOA
    • Has HOA: No
    • HOA fee: $325 annually
    Sell for more on Zillow
    Get a Zillow Showcase℠ listing at no additional cost and you could sell for —faster.
    $801,200
    2% more+$16,024
    With Zillow Showcase(estimated)$817,224