Skip main navigation
New construction
  • Price cut: $10K (8/14)
    $724,900

    700 Sandy Ln #9, Warwick, RI 02889

    3beds
    2,085sqft
    : 
    $5,051/mo
    Get pre-qualified
    Condominium
    Built in 2026
    -- sqft lot
    $716,000 Zestimate®
    $348/sqft
    $230/mo HOA

    What's special

    **WATERVIEW OASIS - NEW CONSTRUCTION -SINGLE LEVEL CONDOMINIUM** Discover BRAND NEW, ONE LEVEL LIVING at Waterside at Little Pond Condominiums much-anticipated and much-needed True One Level Living. Presenting Waterside at Little Pond Condominiums. This stunning new construction offers a breathtaking, spacious layout designed for comfort and elegance. The beautiful kitchen features an abundance of cabinets along with a fabulous island -perfect for chefs & entertaining. Elevate your entertainment with this stylish wet bar complete with beverage & wine cooler with chic shiplap detailing. Sliders go out to a generous stone patio. Sun drench second bedroom and a full bathroom, along with first-floor laundry and a garage for added convenience. Tremendous amount of closet space too. The luxurious master bath and generous master suite add to the comfort and ease of living in this exceptional condo. But that's not all . . . This water view unit also boasts a finished lower level walkout with a third bedroom, third full bathroom, and even another wet bar for extra entertainment possibilities! (Taxes to be determined by City post completion)
    59 days
    707
    28

    Zillow last checked:

    Listing updated:

    Listed by:

    Nicolas Lamoureux 401-499-3930,

    Mahogany Shoals, Inc

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

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 3
      • Full bathrooms: 3
      Primary bedroom
      • Level: First
      Bedroom 2
      • Level: First
      Bedroom 3
      • Level: Lower
      Bathroom
      • Level: First
      Bathroom
      • Level: Lower
      Dining area
      • Level: First
      Family room
      • Level: Lower
      Other
      • Level: First
      Kitchen
      • Level: First
      Laundry
      • Level: First
      Living room
      • Level: First
      Heating
      • Natural Gas, Forced Air
      Cooling
      • Central Air
      Appliances
      • Included: Electric Water Heater, Dishwasher, Range Hood, Microwave, Oven/Range, Refrigerator
      • Laundry: In Unit
      Features
      • Wall (Dry Wall), Cathedral Ceiling(s), Wet Bar, Plumbing (Mixed), Insulation (Cap), Insulation (Ceiling), Insulation (Floors), Insulation (Walls)
      • Flooring: Ceramic Tile, Hardwood
      • Windows: Insulated Windows
      • Basement: Full,Interior and Exterior,Partially Finished,Bath/Stubbed,Bedroom(s),Family Room
      • Number of fireplaces: 1
      • Fireplace features: Gas, Zero Clearance
      Interior area
      • Total structure area: 1,350
      • Total interior livable area: 2,085 sqft
      • Finished area above ground: 1,350
      • Finished area below ground: 735
      Video & virtual tour

      Property

      Parking
      • Total spaces: 2
      • Parking features: Attached, Integral, Assigned, Driveway
      • Attached garage spaces: 1
      • Has uncovered spaces: Yes
      Accessibility
      • Accessibility features: One Level
      Features
      • Stories: 1
      • Has view: Yes
      • View description: Water
      • Has water view: Yes
      • Water view: Water
      • Waterfront features: Walk to Fresh Water
      Lot
      • Features: Sprinklers
      Details
      • Parcel number: 700SANDYLANE9WARW

      Construction

      Type & style
      • Home type: Condo
      • Property subtype: Condominium
      Materials
      • Dry Wall, Vinyl Siding
      • Foundation: Concrete Perimeter
      Condition
      • New construction: Yes
      • Year built: 2026

      Utilities & green energy

      • Electric: Individual Meter
      • Sewer: Assessment to Buyer, Public Sewer
      • Water: Individual Meter
      • Utilities for property: Sewer Connected, Underground Utilities

      Community & HOA

      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
      HOA
      • Has HOA: No
      • HOA fee: $230 monthly
      Location
      • Region: Warwick

      Financial & listing details

      • Price per square foot: $348/sqft
      • Date on market: 7/6/2026

        Estimated market value

        $716,000

        $652,000 - $780,000

        $4,221/mo

        Price history

        DateEventPrice
        8/14/2026Price change$724,900-1.4%$348/sqft
        Source: StateWide MLS RI #1417119 Report a problem
        7/15/2026Listed for sale$734,900$352/sqft
        Source: StateWide MLS RI #1417119 Report a problem

        Public tax history

        Tax history is unavailable.

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 02889

        Getting around

        51 / 100
        Somewhat Walkable
        25 / 100
        Some Transit
        46 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts