148 Andrew Comstock Rd, Warwick, RI 02886
Property image
Property image
OFF MARKET

$740,000

Trulia Estimate
as of Sep 4, 2026
  • 3 Beds
  • 1.5 Baths
  • 2,250 sqft

148 Andrew Comstock Rd, Warwick, RI 02886

Home Highlights

Single-Family Home
2,250 sqft
$329/sqft

Local Information

  • Map ViewExplore the area around 148 Andrew Comstock Rd.
  • Schools1 Elementary School1 Middle School1 High School
  • Shop & Eat
-- mins to
Commute Destination

About this House

5 or 17 MONTH LEASE TERM AVAILABLE. This home has terrific views of Greenwich Bay from every room in the house. The house was completely remodeled in 2013 so everything inside and out is young and in very good condition. The kitchen has a breakfast nook and a slider that leads out to a waterview deck. The living room and dining area are in one wide open room with space for a desk in the corner closest to the Bay. There are two generous bedrooms on the second floor along with a beautiful bathroom with coastal decor. On the third floor is the primary bedroom with a walk-in closet, a second closet, and a 6 x 15 balcony with unobstructed views. Buttonwood Beach has a number of amenities that you will be able to take advantage of, including three tennis courts (two clay), a pickle ball court, a playground, a basketball court, and a baseball field. No smokers, pets are negotiable. Credit and background check will be required. Available for immediate occupancy.

Owners willing to enter into a 6 or 18 month lease.
148 Andrew Comstock Rd, Warwick, RI 02886 is a 3 bedroom, 2 bathroom, 2,250 sqft single-family home. It last sold for $582,000 on Aug 2, 2021 (17,536% above the $3,300 asking price). More recently, it was listed as a rental in October 2024 with an asking price of $3,600 per month. That rental listing was removed on December 13, 2024. This property is not currently displayed as for sale or rent on Trulia. The Trulia Estimate is $740,000, with a rent estimate of $3,629/month.

Home Details for 148 Andrew Comstock Rd

Interior Features

Heating & Cooling
Heating: BaseboardAir ConditioningCooling System: Window UnitHeating Fuel: Baseboard
Appliances & Utilities
DishwasherDryerMicrowaveRefrigeratorWasher
Levels, Entrance, & Accessibility
Floors: Hardwood, Tile

Property Information

Property Type / Style
Property Type: Single Family Home

Rental Terms, Policies & Fees

Lease Term: 6 Month

Exterior Features

Parking & Garage
Parking: Off Street Parking, On Site

Comparable Sales for 148 Andrew Comstock Rd

Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
5 Mill Wheel Rd, Warwick, RI
0.22
Single-Family Home
$662,500
01/30/26
3
2.5
2,420 sqft
35 Saratoga Rd, Warwick, RI
0.42
Single-Family Home
$469,000
11/21/25
3
2
2,090 sqft
191 Claypool Dr, Warwick, RI
0.47
Single-Family Home
$420,000
06/17/26
3
1
1,932 sqft
190 Capron Farm Dr, Warwick, RI
0.56
Single-Family Home
$499,000
11/03/25
3
2
1,882 sqft
568 Buttonwoods Ave, Warwick, RI
0.44
Single-Family Home
$405,000
10/17/25
3
1
1,750 sqft
41 8th Ave, Warwick, RI
0.39
Single-Family Home
$1,025,000
09/29/25
3
2.5
2,238 sqft
311 Capron Farm Dr, Warwick, RI
0.48
Single-Family Home
$840,000
03/30/26
3
2.5
2,109 sqft
247 Asylum Rd, Warwick, RI
0.72
Single-Family Home
$549,000
07/24/26
3
2
1,913 sqft
22 Hagerstown Rd, Warwick, RI
0.45
Single-Family Home
$400,000
07/10/26
3
1
1,040 sqft
73 Houston Dr, Warwick, RI
0.51
Single-Family Home
$330,000
09/15/25
3
2
1,402 sqft

Nearby homes

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

Rental Market Trends in Warwick

Last updated Sep 2026
Trulia Rent Estimate$3,629/mo
Average rent
$2.16K
$41MoM
Available listings
82
View rental market trends in Warwick, RI

Around this home

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

Price and Tax history

DateEventPrice
Dec 13, 2024
Source: Zillow Rentals
ListingRemoved
$3,300
Nov 8, 2024
Source: Zillow Rentals
PriceChange
$3,500
Price decreased by 3%
Oct 19, 2024
Source: Zillow Rentals
Listed For Rent
$3,600
Oct 16, 2024
Source: StateWide MLS RI #1359159
ListingRemoved
$625,000
Oct 4, 2024
Source: StateWide MLS RI #1359159
PriceChange
$625,000
Price decreased by 4%

Frequently asked questions about 148 Andrew Comstock Rd

  • What is 148 Andrew Comstock Rd estimated to be worth?
    Trulia's estimated value for 148 Andrew Comstock Rd in Warwick, RI is $740,000.
  • What is the price history for 148 Andrew Comstock Rd?
    148 Andrew Comstock Rd in Warwick, RI last sold for $582,000 in August 2021.
  • Is Warwick a buyer's or seller's market?
    Warwick is currently a seller's market, based on recent for-sale activity.
  • What's the median sale price in Warwick?
    The median sale price in Warwick is $432K. That is up $5K from the prior month.
  • Does 148 Andrew Comstock Rd have air conditioning?
    Yes, 148 Andrew Comstock Rd in Warwick, RI has air conditioning.
  • Does 148 Andrew Comstock Rd have laundry facilities?
    Yes, 148 Andrew Comstock Rd in Warwick, RI has in-unit laundry.

Homes for rent near 148 Andrew Comstock Rd

Skip to last item
Skip to first item

Affordability

TIP:Try to keep your rent within a third of your gross household income. Learn why in our Renter's Guide.
For this property
PER YEAR
is the suggested income
Win over prospective landlords with your smart budgeting. As a good rule of thumb, ideally you would have at least three times your monthly rent in combined household income.
Skip to last item
  • Results are loading
Skip to first item