Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Coastal Homes

700 Sandy Lane #5, 
Warwick, RI 02889

$524,900


2

Beds


2

Baths


1,350

Sq Ft


Condo

Active

Listed by

Nicolas Lamoureux

Mahogany Shoals, Inc

Last updated:

December 31, 2025, 05:24 PM

MLS#

1402327

Source:

RI STATEWIDE

About This Home

700 Sandy Lane #5

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, 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!

Home Facts

Condo

2 Baths

2 Bedrooms

Built in 2026

Price Summary

524,900

$388 per Sq. Ft.

MLS #:

1402327

Last Updated:

December 31, 2025, 05:24 PM

Added:

3 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

2

Bathrooms

Total Bathrooms:

2

Full Bathrooms:

2

Interior

Living Area:

1,350 Sq. Ft.


Structure

Structure

Building Area:

1,350 Sq. Ft.

Year Built:

2026


Finances & Disclosures

Finances

Price:

$524,900

Price per Sq. Ft:

$388 per Sq. Ft.

MLS Logo
The data relating to real estate for sale on this web site comes in part from the IDX Program of the State-Wide Multiple Listing Service, Inc. Real estate listings held by brokerage firms other than Coldwell Banker Coastal Homes are marked with the MLS logo and detailed information about them includes the name of the listing brokers. Information deemed reliable but not guaranteed. Copyright 2026 State-Wide MLS, Inc. All rights reserved. Date Last Update: December 31, 2025

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.