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!
Sold for $514,900
Street View
$514,900
700 Sandy Ln #6, Warwick, RI 02889
2beds
1,350sqft
Condominium
Built in 2025
-- sqft lot
$518,200 Zestimate®
$381/sqft
$3,203 Estimated rent
Home value
$518,200
$461,000 - $580,000
$3,203/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$3,203/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$3,203/mo
Rent Zestimate®
Refinance and save
$3,530/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$3,530/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked: 7 hours ago
Listing updated: February 05, 2026 at 12:50pm
Listed by:
Nicolas Lamoureux 401-499-3930,
Mahogany Shoals, Inc
Bought with:
Slocum Home Team
eXp Realty
Source: StateWide MLS RI,MLS#: 1399709
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
- Entry location: First Floor Access
- Waterfront features: Walk to Fresh Water
Lot
- Features: Sprinklers
Details
- Special conditions: Conventional/Market Value
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 & neighborhood
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: Sandy Lane
HOA & financial
HOA
- Has HOA: No
- HOA fee: $220 monthly
Price history
| Date | Event | Price |
|---|---|---|
| 1/20/2026 | Sold | $514,900-1%$381/sqft |
Source:  StateWide MLS RI #1399709 Report a problem | ||
| 11/7/2025 | Pending sale | $519,900$385/sqft |
Source: StateWide MLS RI #1399709 Report a problem | ||
| 11/7/2025 | Listed for sale | $519,900$385/sqft |
Source: StateWide MLS RI #1399709 Report a problem | ||
Public tax history
Tax history is unavailable.
Neighborhood: 02889
Nearby schools
GreatSchools rating
- 5/10Lippitt SchoolGrades: K-5Distance: 0.9 mi
- 5/10Winman Junior High SchoolGrades: 6-8Distance: 4.2 mi
- 5/10Toll Gate High SchoolGrades: 9-12Distance: 4.2 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$518,200
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$518,200
- Rhode Island
- Kent County
- Warwick
- 02889
- 700 Sandy Ln Unit 6