Skip main navigation
Under contract
  • $589,000

    154 Julian Rd, Warwick, RI 02889

    3beds
    1,876sqft
    : 
    Single Family Residence
    Built in 2014
    10,018.8 Square Feet Lot
    $-- Zestimate®
    $314/sqft
    $21/mo HOA

    What's special

    Cedar closet in basementGranite kitchen and bathsBamboo hardwoodsGe profile appliances
    This pristine, well maintained, upgraded and spacious Craftsman Colonial built in 2014 is ready for you to call Home! 3 Bedrooms and 2.5 Baths with additional finished living space in the Basement will provide you with all of the indoor space you need. Interior Upgrades include blower fan w/ remote added to Gas Fireplace; Basement Finished (2021) adding 360 sq ft of living space; Electrical adding separate 60/80 Amp subpanel and whole house generator plug (2021); Gas Water Heater - A.O. Smith commercial grade 50 gallon (2023); Speed Queen commercial grade Washer/Dryer (2024 - $4,400 value). Outside, the home is situated on a 1/4 acre lot, located at the end of a cul-de-sac. 8 home street just recently developed in 2014. Exterior Upgrades include Deck renovation with Trex brand composite decking, white PVC trim boards and white Vinyl railings (2019); UNILOCK brand patio pavers off deck - 17 ft X 17 ft (2020); Anderson ventilating storm door on Front Entry door (2021); Sprinkler/Irrigation watering system with app-based WiFi control and Deduct Meter (2021); Leaf Filter brand gutter protection/gutter guards (2021); Front Porch decking and trim boards completely stripped and refinished (2024). This home spares no details. Granite Kitchen and Baths; GE Profile appliances; Bamboo hardwoods; Luxury Vinyl Plank flooring and Cedar Closet in Basement; Oversized (576 sq ft) 2 Car Garage can easily fit two cars and accommodate all storage needs. Nothing to do but move in. Welcome Home!
    16 days
    on Zillow
    |
    4,813
    |
    331
    |

    Zillow last checked: 7 hours ago

    Listing updated: April 23, 2025 at 11:53am

    Listed by:

    Doug Mittelsteadt 401-585-5007,

    Anchor Real Estate Group, LLC

    Source: StateWide MLS RI,MLS#: 1382087MLS Logo
    Travel times

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 3
    • Full bathrooms: 2
    • 1/2 bathrooms: 1
    Primary bedroom
    • Features: Ceiling Height 7 to 9 ft
    • Level: Second
    Bathroom
    • Features: Ceiling Height 7 to 9 ft
    • Level: First
    Bathroom
    • Features: Ceiling Height 7 to 9 ft
    • Level: Second
    Other
    • Features: Ceiling Height 7 to 9 ft
    • Level: Second
    Other
    • Features: Ceiling Height 7 to 9 ft
    • Level: Second
    Dining room
    • Features: Ceiling Height 7 to 9 ft
    • Level: First
    Family room
    • Features: Ceiling Height 7 to 9 ft
    • Level: Lower
    Kitchen
    • Features: Ceiling Height 7 to 9 ft
    • Level: First
    Living room
    • Features: Ceiling Height 7 to 9 ft
    • Level: First
    Utility room
    • Features: Ceiling Height 7 to 9 ft
    • Level: Lower
    Heating
    • Natural Gas, Forced Air
    Cooling
    • Central Air
    Appliances
    • Included: Gas Water Heater, Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer
    Features
    • Wall (Dry Wall), Cathedral Ceiling(s), Cedar Closet(s), Plumbing (Copper), Plumbing (Mixed), Plumbing (PEX), Plumbing (PVC), Insulation (Cap), Insulation (Ceiling), Insulation (Floors), Insulation (Walls), Ceiling Fan(s)
    • Flooring: Ceramic Tile, Hardwood, Vinyl, Carpet
    • Doors: Storm Door(s)
    • Windows: Insulated Windows
    • Basement: Full,Interior Entry,Partially Finished,Common,Family Room,Media Room,Playroom,Storage Space,Utility
    • Number of fireplaces: 1
    • Fireplace features: Gas
    Interior area
    • Total structure area: 1,516
    • Total interior livable area: 1,876 sqft
    • Finished area above ground: 1,516
    • Finished area below ground: 360
    Video & virtual tour

    Property

    Parking
    • Total spaces: 6
    • Parking features: Attached, Garage Door Opener, Driveway
    • Attached garage spaces: 2
    • Has uncovered spaces: Yes
    Features
    • Patio & porch: Deck, Patio, Porch
    Lot
    • Size: 10,018.8 Square Feet
    • Features: Cul-De-Sac, Sidewalks, Sprinklers
    Details
    • Parcel number: WARWM340B0716L0000
    • Other equipment: Cable TV

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    • Property subtype: Single Family Residence
    Materials
    • Dry Wall, Vinyl Siding
    • Foundation: Concrete Perimeter
    Condition
    • New construction: No
    • Year built: 2014

    Utilities & green energy

    • Electric: 60 Amps, 100 Amp Service, Generator
    • Sewer: Public Sewer
    • Water: Individual Meter, Municipal, Public
    • Utilities for property: Underground Utilities, Sewer Connected

    Community & HOA

    Community
    • Features: Near Public Transport, Commuter Bus, Golf, Highway Access, Hospital, Interstate, Marina, Private School, Public School, Railroad, Recreational Facilities, Restaurants, Schools, Near Shopping, Near Swimming, Tennis
    • Security: Security System Owned
    • Subdivision: Hidden Oaks
    HOA
    • Has HOA: No
    • HOA fee: $250 annually
    Location
    • Region: Warwick

    Financial & listing details

    • Price per square foot: $314/sqft
    • Tax assessed value: $422,200
    • Annual tax amount: $6,109
    • Date on market: 4/9/2025
    • Inclusions: Portable 7500W dual fuel whole house Generator to convey. Some additional furniture negotiable.
    • Loading