Welcome Home! Discover the 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, a fabulous island, A open to the dining and living areas -perfect for chefs & entertaining. Elevate your entertainment with this stylish wet bar complete with beverage & wine cooler with chic shiplap detailing. The bright and spacious living room boasts a striking dramatic floor to ceiling fireplace, cathedral ceilings, and an open floor plan that enhances the sense of space. Sliders 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 here is a ballroom-sized basement awaiting your personal touch, whether its for storage, exercise, an office, crafts, sewing, or limitless possibilities. Finish it as you like and create your perfect space! Experience the perfect blend of style, function of one level living at its best! Steps away to view Little Pond right in your backyard! SEEING IS BELIEVING .. STOP BY FOR A VISIT! (NO SHOWTIME APPTS, TEXT LIST AGNT)
Pending
Price increase: $5K (5/5)
$519,900
700 Sandy Ln #20, Warwick, RI 02889
2beds
1,350sqft
Condominium
Built in 2025
-- sqft lot
$-- Zestimate®
$385/sqft
$220/mo HOA
What's special
- 238 days |
- 86 |
- 1 |
Zillow last checked:
Listing updated:
Listed by:
Nicolas Lamoureux 401-499-3930,
Mahogany Shoals, Inc
Source: StateWide MLS RI,MLS#: 1399517
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 2
- Full bathrooms: 2
Primary bedroom
- Level: First
Bathroom
- Level: First
Other
- Level: First
Dining area
- Level: First
Other
- Level: First
Kitchen
- Level: First
Laundry
- Level: First
Living room
- Level: First
Heating
- Natural Gas, Forced Air
Cooling
- Central Air
Appliances
- Included: Gas 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 Entry,Unfinished
- Number of fireplaces: 1
- Fireplace features: Gas, Zero Clearance
Interior area
- Total structure area: 1,350
- Total interior livable area: 1,350 sqft
- Finished area above ground: 1,350
- Finished area below ground: 0
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
- Waterfront features: Walk to Fresh Water
Lot
- Features: Sprinklers
Details
- Parcel number: 700SANDYLANE20WARW
Construction
Type & style
- Home type: Condo
- Property subtype: Condominium
Materials
- Dry Wall
- Foundation: Concrete Perimeter
Condition
- New construction: Yes
- Year built: 2025
Utilities & green energy
- Electric: Circuit Breakers, Individual Meter
- Sewer: Assessment to Buyer, Public Sewer
- Water: Individual Meter
- Utilities for property: Underground Utilities, Sewer Connected
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
- Subdivision: Sandy Lane
HOA
- Has HOA: No
- HOA fee: $220 monthly
Location
- Region: Warwick
Financial & listing details
- Price per square foot: $385/sqft
- Date on market: 11/6/2025
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 5/13/2026 | Pending sale | $519,900$385/sqft |
Source:  StateWide MLS RI #1399517 Report a problem | ||
| 5/5/2026 | Price change | $519,900+1%$385/sqft |
Source: StateWide MLS RI #1399517 Report a problem | ||
| 12/29/2025 | Price change | $514,900+3%$381/sqft |
Source: StateWide MLS RI #1399517 Report a problem | ||
| 12/8/2025 | Pending sale | $499,900$370/sqft |
Source: StateWide MLS RI #1399517 Report a problem | ||
| 11/6/2025 | Listed for sale | $499,900$370/sqft |
Source: StateWide MLS RI #1399517 Report a problem | ||
Public tax history
Tax history is unavailable.
Monthly payment
Est. payment$--/mo
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.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 02889
Nearby schools
GreatSchools rating
- 5/10Lippitt SchoolGrades: K-5Distance: 0.9 mi
- 5/10Winman Junior High SchoolGrades: 6-8Distance: 4 mi
- 5/10Toll Gate High SchoolGrades: 9-12Distance: 4 mi
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.
- Rhode Island
- Kent County
- Warwick
- 02889
- 700 Sandy Ln Unit 20
Nearby cities
Nearby zip codes
Other Warwick Topics
