247 Randall Ave, Warwick, RI 02889
PENDING
0.31 ACRES

247 Randall Ave
Warwick, RI 02889

  • 3 Beds
  • 2.5 Baths
  • 2,654 sqft (on 0.31 acres)

$650,000

$650,000

3 Beds
2.5 Baths
2,654 sqft
(on 0.31 acres)

Local Information

Map showing home location
© Google
-- mins to
Commute Destination

Description

Desirable Warwick Neck Colonial located on a dead-end street, abutting the fourth hole of Harbour Lights Golf Course and Marina. Built in 2001, this thoughtfully designed home blends modern amenities with everyday comfort. The open floor plan features an updated kitchen with stainless steel appliances, a pantry, and a breakfast bar. The kitchen flows seamlessly into the dining area and a sun-drenched family room. A den and a new half bath complete the first floor. Upstairs, the primary suite offers partial water views, a large walk-in closet with custom cabinetry and a private bath with a dual-sink vanity. Two generously sized bedrooms with spacious closets share a full bath. A standout feature is the expansive second-floor bonus room—offering approximately 750 square feet with skylights, built-in cabinetry, and additional storage—ideal for a family room, home office, playroom, or gym. An oversized two-car garage adds convenience. Enjoy the tranquil setting from the large deck with distant water views of Narragansett Bay, plus a firepit perfect for outdoor entertaining. Additional features include a new roof and hot water tank. Located in a picturesque coastal community with water access nearby, and close to Rocky Point Park, marinas, scenic trails, local farms, cafés, golf, tennis, and boating. Convenient to TF Green International Airport and MBTA commuter rail. A wonderful opportunity to enjoy coastal living!

Home Highlights

Parking
2 Car Garage
Outdoor
Porch, Deck
A/C
Heating & Cooling
HOA
None
Price/Sqft
$245
Listed
30 days ago

Home Details for 247 Randall Ave

Interior Features

Interior Details
Basement: Full,Interior and Exterior,Unfinished,Laundry,Storage Space,UtilityNumber of Rooms: 8Types of Rooms: Bathroom
Beds & Baths
Number of Bedrooms: 3Number of Bathrooms: 3Number of Bathrooms (full): 2Number of Bathrooms (half): 1
Dimensions and Layout
Living Area: 2654 Square Feet
Appliances & Utilities
Utilities: Sewer Available, Water ConnectedAppliances: Gas Water Heater, Dishwasher, Microwave, Oven/Range, RefrigeratorDishwasherMicrowaveRefrigerator
Heating & Cooling
Heating: Natural Gas,Baseboard,Forced WaterHas CoolingAir Conditioning: Wall Unit(s)Has HeatingHeating Fuel: Natural Gas
Fireplace & Spa
Fireplace: NoneNo Fireplace
Gas & Electric
Electric: 200+ Amp Service, 220 Volts, Circuit Breakers
Windows, Doors, Floors & Walls
Window: Skylight(s)Flooring: Ceramic Tile, Hardwood, Carpet
Levels, Entrance, & Accessibility
Number of Stories: 2Floors: Ceramic Tile, Hardwood, Carpet
View
Has a ViewView: Water

Exterior Features

Exterior Home Features
Patio / Porch: Deck, PorchFoundation: Concrete PerimeterSkylight
Parking & Garage
Number of Garage Spaces: 2Number of Covered Spaces: 2No CarportHas a GarageHas an Attached GarageHas Open ParkingParking Spaces: 6Parking: Attached,Driveway
Frontage
Waterfront: Walk to Salt Water
Water & Sewer
Sewer: Septic Tank
Finished Area
Finished Area (above surface): 2654 Square Feet

Days on Market

Days on Market: 30

Property Information

Year Built
Year Built: 2001
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family ResidenceArchitecture: Colonial
Building
Construction Materials: Dry Wall, Plaster, Vinyl SidingNot a New Construction

Price & Status

Price
List Price: $650,000Price Per Sqft: $245

Active Status

MLS Status: Pending

Media

Location

Direction & Address
City: WarwickCommunity: Warwick Neck

Agent Information

Listing Agent
Listing ID: 1409311

Building

Building Area
Building Area: 2654 Square Feet

Community

Community Features: Near Public Transport, Golf, Highway Access, Hospital, Marina, Private School, Public School, Restaurants, Schools, Near Shopping, Near Swimming, TennisNot Senior Community

HOA

No HOA

Lot Information

Lot Area: 0.31 acres

Miscellaneous

BasementMls Number: 1409311Water ViewWater View: WaterAbove Grade Unfinished Area: 2654

Additional Information

Near Public TransportGolfHighway AccessHospitalMarinaPrivate SchoolPublic SchoolRestaurantsSchoolsNear ShoppingNear SwimmingTennis
Last check for updates: about 5 hours ago
Listing courtesy of Sasha Mellor
Residential Properties Ltd.
Source: StateWide MLS RI, MLS#1409311
Also Listed on StateWide MLS RI.

Price History for 247 Randall Ave

DatePriceEventSource
05/20/2026$650,000PendingStateWide MLS RI #1409311
05/06/2026$650,000ContingentStateWide MLS RI #1409311
05/06/2026$650,000PendingToActiveStateWide MLS RI #1409311
04/24/2026$650,000ContingentStateWide MLS RI #1409311
04/21/2026$650,000Listed For SaleStateWide MLS RI #1409311
12/06/2022$520,000Sold
StateWide MLS RI #1323071
11/28/2022$534,900PendingStateWide MLS RI #1323071
11/05/2022$534,900ContingentStateWide MLS RI #1323071
10/28/2022$534,900Listed For SaleStateWide MLS RI #1323071
10/24/2022ListingRemovedRE/MAX International
09/12/2022$534,900PendingRE/MAX International #1317490
09/12/2022$534,900ContingentStateWide MLS RI #1317490
09/04/2022$534,900PriceChange
StateWide MLS RI #1317490
08/09/2022$550,000Listed For SaleStateWide MLS RI #1317490
08/30/2002$310,000Sold
N/A

Similar Homes You May Like

Skip to last item
Skip to first item

New Listings near 247 Randall Ave

Skip to last item
Skip to first item

Property Tax and Assessment

Year2025
Tax$8,044
Assessment$555,900
Home facts updated by county records

Comparable Sales for 247 Randall Ave

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
175 Randall Ave, Warwick, RI
0.14
Single-Family Home
$465,000
01/05/26
4
3
2,147
234 Leroy Ave, Warwick, RI
0.49
Single-Family Home
$513,000
05/30/25
3
2
2,744
100 Paine St, Warwick, RI
0.43
Single-Family Home
$479,000
01/14/26
3
2
2,532
21 Hampton Ave, Warwick, RI
0.41
Single-Family Home
$610,000
04/30/26
3
2
1,966
332 Tiffany Ave, Warwick, RI
0.59
Single-Family Home
$550,000
07/02/25
3
2
2,067
6 Crawford Ave, Warwick, RI
0.52
Single-Family Home
$850,000
06/30/25
3
1.5
1,785
48 PROGRESS ST, WARWICK, RI
0.50
Single-Family Home
$980,000
07/28/25
4
2.5
2,272

Nearby homes

Get a sense of prices in the area by checking nearby homes.
Skip to last item
Skip to first item

Assigned Schools

These are the assigned schools for 247 Randall Ave.
View nearby schools on GreatSchools
The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

What Locals Say about Warwick

At least 579 Trulia users voted on each feature.

  • 88 % Say parking is easy

  • 88 % Say it's dog friendly

  • 88 % Say car is needed

  • 81 % Say yards are well-kept

  • 78 % Say there's holiday spirit

  • 71 % Say people would walk alone at night

  • 67 % Say there's wildlife

  • 63 % Say it's quiet

  • 60 % Say kids play outside

  • 57 % Say it's walkable to restaurants

  • 53 % Say neighbors are friendly

  • 52 % Say they plan to stay for at least 5 years

  • 51 % Say streets are well-lit

  • 46 % Say there are sidewalks

  • 44 % Say it's walkable to grocery stores

  • 28 % Say there are community events

Sourced by Trulia users. Learn more about our methodology.
  • Rebecca Warner
    "Good schools. Convenient shopping. Minutes from Providence and 45 minutes to Boston.lots of nice parks and schools with playgrounds."
    0
    Flag
  • Hms1960
    "I’ve lived here for 10 years and love it!!! I love living by the ocean! Everything is 5 miles or less to get to. Airport, train, hospital and a lot of stores!"
    0
    Flag
  • Howard.a.merten
    "Very nice people, diverse ages and wealth, good mix. Friendly, sense of community. We talk to our neighbors. "
    0
    Flag
  • 4kentheroad
    "It’s a very family friendly area and for the most part very quiet and peaceful. Close to a lot of amenities "
    0
    Flag
  • Paul Tremblay
    "I grew up in this neighborhood and bought my own home here 3 years ago. Family homes, walkable and safe for the most part."
    0
    Flag
  • Howard.a.merten
    "Gaspee Days are a special time in our neighborhood, great for the whole family. Parade, fireworks, craft fair. Pawtuxet Village is also a lively gem. "
    0
    Flag
  • Zachary Lyons
    "Commuting is great have access to all highways and cities around every corner it is amazing I highly recommend living here "
    0
    Flag
  • 4kentheroad
    "Halloween parade through the neighborhood with a escort by police and firefighters and most everyone in the neighborhood participates in passing out candy "
    0
    Flag
  • Tbella9
    "They blow through the stop signs without even tapping their breaks. As long as you have a yard you’re safe "
    0
    Flag
  • Dillonevansjr
    "Friendly and safe. Everyone we have met has been very welcoming. Also centrally located in RI and right near highway access "
    0
    Flag
  • Alicia Cotrone
    "Have a trashy neighbor but other than that everyone is super kind, kids feel safe, dog friendly neighborhood "
    1
    Flag
  • Trulia User
    "Lots of dog walkers always on leash, but no sidewalks, lots of cars parked on the road so it’s hard to get around. "
    2
    Flag
  • Trulia User
    "Nothing! People walk their dogs all the time. Quiet neighborhood, people respect each other’s property. "
    1
    Flag
  • Danyal Y.
    "There is a dog park nearby at the local City Park. I’ve been multiple times with both my pups and never had any issues. "
    9
    Flag
  • S. C.
    "Great access to the highways, PVD, and TF Green Airport. Some traffic on Route 4 and Interstate 295 during peak rush hour, but nothing like city traffic. "
    5
    Flag
  • Chelsea R.
    "Great dog park at City Park in Warwick! Even a hose to fill the available water dishes very large and roomy for dogs to run in shade and sun! "
    4
    Flag
  • Kerri C.
    "there's a bus stop right around the corner, and the driving isn't too hectic, as long as people actually obey traffic laws "
    0
    Flag
  • Petterson G.
    "Warwick is convenient and safe. close to everything and less stressful than Providence. I lived in here for almost two years and I like it."
    2
    Flag
  • Erik L.
    "The dog park is great, very animal friendly , clean and great people! I lived here for 6 years now and love it here"
    8
    Flag
  • Lisa J.
    "Short. No traffic. Easy to navigate No highways. Not long. Easy to drive. No traffic Short "
    0
    Flag
  • Dave S.
    "I have lived in Warwick for 20 years and enjoy living here today. the town has beaches, restaurants on the water along with fine dining. "
    2
    Flag
  • Raceday
    "the people who live here make all the difference in the world. it has always felt like home right from the first week 20 years ago when we first stepped foot in our house."
    0
    Flag
  • Angela P.
    "Meadowbrook is a very quiet neighborhood. Everyone is friendly and yards are always kept up nicely. "
    12
    Flag
  • Raceday
    "I've lived In this neighborhood for 20 and have never had a bad day here. we would have to have a good reason go leave which doesn't seem possible. "
    0
    Flag
  • Tara E.
    "everyone has a doggie or 2! great neighborhood, wide sidewalks, plenty of route options. leash law is common. i don't think there is local dog park, but possibly a wuixk drive to nearest."
    1
    Flag
  • Ajtwed
    "Other dogs barking late at night when your own dog doesn’t make a sound. Hours upon hours of it. Really gets annoying "
    7
    Flag
  • Mattferreira90
    "Love it here!!!!!! Everyone’s friendly and nice cute lil shops and stores around too!!!!!!!!!gvggbgbhbb"
    3
    Flag
  • Ladyjohannapadilla.lp
    "all good with the neighborhood I love it. is a good place to leave I wish to find another house for rent closed here"
    6
    Flag
  • Alicia C.
    "Many young families, very Convenient location grocery stores Dunkin’ Donuts banks are all very very close by usually walking distance"
    2
    Flag
  • Rgilbert394
    "I’ve lived in Warwick for 15 years. I just love it. Roads are decent. People are nice. Easy to access highways, gas stations, etc "
    2
    Flag
  • Danielle568
    "It’s a quiet safe and friendly neighborhood. Have lived here 4ys and I love it. Just be careful on the main road "
    4
    Flag
  • Robin D.
    "Only 7 miles to the capital city and literally everything you need is within 10 minutes drive or less"
    3
    Flag
  • Michael J.
    "Very quiet and safe neighborhood. Everyone is very friendly and never have any issues. My family loves it here"
    2
    Flag
  • Chuck A.
    "Rhode Island is 45 miles long and just 25 miles wide. It’s the smallest state in the union, as well as the 13th colony. It’s a amazing place to visit."
    3
    Flag
  • Gina R.
    "Main Street strolls are always excellent and Main Street has a lot to offer in restaurants and many other fabulous shops"
    1
    Flag
  • Jusman420.jp
    "I’ve lived in this neighborhood for 5 years now and the street I live on the neighbors are very nice and helpful. Can be traffic heavy and loud during the summer. "
    0
    Flag
  • Lacy R. M.
    "neighbors are way too nosey. taxes are way too high. warwick is overrated and over policed. I'll be happy to be out. "
    4
    Flag
  • Seedahw
    "It's very quiet and so I don't get to see my neightbors often. Very safe. I arrive home @ 3:00 am with no problem."
    1
    Flag
  • Trulia User
    "Drive to Providence. Usually takes about fifteen minutes, but traffic seems to be getting heavier lately."
    0
    Flag
  • Melanie M.
    "very safe community and people know each other. nice neighborhood with a lot of people and kids. I've lived here for over 15 years and love it."
    0
    Flag

LGBTQ Local Legal Protections

Sasha Mellor, Residential Properties Ltd.
IDX information is provided exclusively for 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 not guaranteed. Copyright © 2026 State-Wide MLS, Inc. All rights reserved.
247 Randall Ave, Warwick, RI 02889 is a 3 bedroom, 3 bathroom, 2,654 sqft single-family home built in 2001. This property is currently available for sale and was listed by StateWide MLS RI on Apr 21, 2026. The MLS # for this home is MLS# 1409311.