Skip main navigation
Off market
    • $695,000

    154 Andrew Comstock Rd, Warwick, RI 02886

    3beds
    1,503sqft
    Apartment
    Built in ----
    -- sqft lot
    $695,000 Zestimate®
    $462/sqft
    $3,210 Estimated rent

    Home value

    $695,000

    $619,000 - $778,000

    $3,210/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,210/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,210/mo

    Rent Zestimate®

    Refinance and save

    $3,685/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,685/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 started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Property Representative: Sara Whitney Don't miss this rare opportunity to rent an updated, beautifully furnished 3 bedroom, 2 bath single family home conveniently located in Warwick! Offering 1,500 square feet of living space, plus ample storage in the attic, basement and shed, this home is truly move-in ready. The rental fee includes water, electricity and landscaping. Pets are negotiable. Call today!

    This property is not currently displayed as for sale or rent on Zillow. This may be different from what's on other websites or public sources.

    Zillow last checked:

    Listing updated:

    Source: Zillow Rentals

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 2
    • Full bathrooms: 2
    Interior area
    • Total interior livable area: 1,503 sqft

    Property

    Parking
    • Parking features: On Street
    • Details: Contact manager
    Features
    • Exterior features: Electricity included in rent, Landscaping included in rent, Water included in rent
    Details
    • Parcel number: WARWM373B0030L0000

    Construction

    Type & style
    • Home type: Apartment
    • Property subtype: Apartment

    Utilities & green energy

    • Utilities for property: Electricity, Water

    Community & HOA

    Community
    • Deposit fee: $3,800
    Location
    • Region: Warwick

    Financial & listing details

    • Price per square foot: $462/sqft
    • Tax assessed value: $490,200
    • Annual tax amount: $7,093
    • Date on market: 5/29/2026
    • Date available: 06/01/2026
    • Lease term: 1 Year

    Price history

    DateEventPrice
    6/7/2026Listing removed$3,800$3/sqft
    Source: Zillow Rentals Report a problem
    5/29/2026Listed for rent$3,800+8.6%$3/sqft
    Source: Zillow Rentals Report a problem
    9/2/2024Listing removed$3,500$2/sqft
    Source: Zillow Rentals Report a problem
    8/14/2024Price change$3,500-2.8%$2/sqft
    Source: Zillow Rentals Report a problem
    7/22/2024Price change$3,600-5.3%$2/sqft
    Source: Zillow Rentals Report a problem
    7/6/2024Listed for rent$3,800$3/sqft
    Source: Zillow Rentals Report a problem
    8/8/2023Listing removed--
    Source: Zillow Rentals Report a problem
    7/30/2023Listed for rent$3,800$3/sqft
    Source: Zillow Rentals Report a problem
    3/7/2023Listing removed--
    Source: Zillow Rentals Report a problem
    2/10/2023Listed for rent$3,800$3/sqft
    Source: Zillow Rentals Report a problem
    1/27/2023Listing removed--
    Source: Zillow Rentals Report a problem
    1/25/2023Listed for rent$3,800$3/sqft
    Source: Zillow Rentals Report a problem
    8/27/2022Listing removed--
    Source: Zillow Rental Manager Report a problem
    7/28/2022Listed for rent$3,800$3/sqft
    Source: Zillow Rental Manager Report a problem
    12/16/2021Sold$490,000+206.3%$326/sqft
    Source: Public Record Report a problem
    4/28/1997Sold$160,000$106/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$7,093 $490,200
    2024$7,093 +2%$490,200
    2023$6,956 -2%$490,200 +29.4%
    2022$7,095 $378,800
    2021$7,095 $378,800
    2020$7,095 $378,800
    2019$7,095 +3.1%$378,800 +14.4%
    2018$6,885 +2.8%$331,000
    2017$6,699 $331,000
    2016$6,699 -3.1%$331,000 -0.7%
    2015$6,914 +3.4%$333,200
    2014$6,684 +1.4%$333,200
    2013$6,594 +9.2%$333,200 -2.4%
    2011$6,041 +1.2%$341,500
    2010$5,969 -2.2%$341,500 -20.9%
    2009$6,106 +5.5%$431,800
    2008$5,790 +25.1%$431,800 +44.2%
    2007$4,629 $299,400
    2006$4,629 +4.4%$299,400
    2004$4,434 +7.5%$299,400 +102%
    2003$4,125 $148,210
    Find assessor info on the county website

    Neighborhood: 02886

    Nearby homes

    Nearby schools

    GreatSchools rating
    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
    $695,000
    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
    $695,000

    Nearby cities

    Nearby zip codes

    Other Warwick Topics

      Search
      Updates
      Favorites
      Plan
      Inbox