Property Attributes
- MLS#1418723
- TypeSingle Family
- Listing Status Active
- CountyNewport
- CityMiddletown
- NeighborhoodStone Bridge Farm
- Zip02842
- Style
- Year Built2026
- Taxes$ 5717
- Price$ 2,900,000
- Bedrooms3
- Full Bathrooms3
- Half Bathrooms1
- Sqr Footage3300
- Lot Size0.56 Acres
Data Source:
Rhode Island Statewide MLS (RIAR)
Property Description
This stunning new-construction home seamlessly balances contemporary design, first-class finishes, and curated living for today's lifestyle. Perfectly positioned on the coveted south side of Stone Bridge Drive, this exceptional residence is embraced by beautiful, preserved open space available only to Stone Bridge Farm residents. The main level features a luxurious primary suite complete with custom built-ins, a door to the back patio, and an elegant ensuite bath. The open living room, dining room, and gourmet kitchen are bathed in natural light, and complemented by a full pantry designed for effortless preparation and storage. The first floor living areas open out to a large mahogany deck, a perfect place for a swimming pool, or sunny gardens. The second floor is thoughtfully configured for ultimate versatility. A welcoming landing area for a little sitting room or library space connects the upper level, which features two more spacious bedrooms, a dedicated private office with a view of the pond, and an expansive bonus room. The residence, which has a 2-car garage, is beautifully enveloped by Stone Bridge Farm's five acres of open space, an idyllic private pond with stone bridges, a stream, and wildlife habitat. Access to the Aquidneck Greenway trail that spans Middletown and Portsmouth. This exceptional location is minutes from the island's most desirable beaches, local farm stands, pristine nature sanctuaries, and a short drive to all downtown Newport has to offer.
| Price History | |
|---|---|
| 7/23/2026 | Listed $2,900,000 |
General Features
| Sewer | Other,Private Sewer |
|---|---|
| Heating | Hydro Air,Propane,Zoned |
| Cooling | Central Air |
| Utilities | Underground Utilities |
| Possession | Negotiable |
| Garage Spaces | 2 |
| Patio/Porch Features | Deck |
| Construction Materials | Drywall,Clapboard,Wood Siding |
| Year Built | 2026 |
| Electric | Circuit Breakers |
| Stories Count | 2 |
| Levels | Two |
| Property Subtype | Single Family Residence |
| Tax Year | 2026 |
| Community Features | Golf,Near Schools,Other,Pool,Recreation Area,Restaurant,Shopping,See Remarks,Tennis Court(s) |
| County | Newport |
| New Construction | false |
| Property Type | Residential |
| Attached Garage | true |
| Subdivision Name | Stone Bridge Farm |
| Garage Y/N | true |
| Total Rooms | 8 |
| Full Baths | 3 |
| Status | Active |
| City | Middletown |
| Senior Community Y/N | false |
| Lot Size Units | Square Feet |
| Lot Size Square Feet | 24394 |
| Land Lease Y/N | false |
| Tax Annual Amount | 5717 |
| Virtual Tour | https://www.youtube.com/watch?v=bFvco8Zlijc |
| Standard Status | Active |
| Tax Assessed Value | 484900 |
| Tax Lot | 1511 |
| Property Sub Type Additional | Single Family Residence |
Interior Features
| Interior Amenities | Bathtub,Stall Shower,Tub Shower |
|---|---|
| Basement | Full,Interior Entry,Unfinished |
| Flooring | Ceramic Tile,Hardwood |
| Total Fireplaces | 1 |
| Fireplace Features | Gas,Stone |
| Total Stories | 2 |
| Basement (Y/N) | true |
| Air Conditioning Y/N | true |
| Heating Y/N | true |
| Fireplace Y/N | true |
| Half Baths | 1 |
| Total Bedrooms | 3 |
| LivingAreaSource | Other |
| Total Baths | 4 |
Exterior Features
| Exterior Amenities | Deck |
|---|---|
| Parking Features | Attached,Garage |
| Lot Features | Cul-De-Sac |
| Water Source | Well |
| Total Parking | 6 |
| Inclusions | New construction, assesment reflects land only Association fees are approximate This covers open space maintenance, insurance, community septic maintenance contract, storm water management maintenance, water quality testing as well as other misc fees. |
| Lot Size Area | 24394 |
| Foundation Details | Concrete Perimeter |
| Building Area Total | 3300 |
| Lot Size Acres | 0.56 |
| Frontage Length | 120 |
| Covered Spaces | 2 |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
IDX information is provided exclusively for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed. © 2026 State-Wide Multiple Listing Service. All rights reserved.