Skip main navigation
Sold for $268,000 on 03/07/25
  • $268,000

    15123 Artesian St, Detroit, MI 48223

    3beds
    2,378sqft
    Single Family Residence
    Built in 1927
    6,098.4 Square Feet Lot
    $272,400 Zestimate®
    $113/sqft
    $1,877 Estimated rent

    What's special

    OMG... Gorgeous (3) Bedroom, (2) 1/2 Bath Colonial located on one of the most Prestigious Streets in ROSEDALE PARK... PROPERTY HAS BEEN RENOVATED Summer 2024 FROM TOP TO BOTTOM... This HOME features a Spacious living room w/NATURAL WOOD BURNING FIREPLACE, and CONVENIENT first floor POWDER ROOM... Eat-in FORMAL dining room to enjoy family dinners... Large KITCHEN, w/COFFEE BAR & BRAND NEW STAINLESS STEEL APPLIANCES.. Second floor has (3) LARGER SIZED BEDROOMS, One of the bedrooms features a walk-out 3 SEASON ROOM. NEW CERAMIC TILED FULL BATH w/NEW SOAKING TUB. Basement is FULLY FINISHED, and has FULL BATH w/SHOWER & LAUNDRY ROOM... NEW HOT WATER TANK, FURNACE & AC UNIT. Outside has BEAUTIFUL landscaping W/ PATIO STYLE BREEZEWAY, Backyard has NEW DECK STYLE BACK PORCH for entertaining or just a quiet BBQ amongst friends. It has NEW WINDOWS w/NEW FAUX WOOD BLINDS & NEW VINYL FLOORING throughout... This renovated Home is a part of the THOMAS REALTY SIGNATURE SERIES II Collection...Don't miss out on your DREAM HOME... This property is AMAZING and a MUST SEE !!! Back on the Market... Buyer financing fell through... Appraisal @ $270k and Inspection w/Camera Scope have been done...

    Zillow last checked: 7 hours ago

    Listing updated: June 11, 2025 at 11:47am

    Listed by:

    Anthony Thomas 313-310-5295,

    Keller Williams Home,

    Conzella Thomas 248-626-2100,

    Keller Williams Home

    Bought with:

    Jonathan Finger, 6501431785

    Keller Williams Realty-Great Lakes

    Source: Realcomp II,MLS#: 20240054258MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 3
    • Full bathrooms: 2
    • 1/2 bathrooms: 1
    Heating
    • Forced Air, Natural Gas
    Cooling
    • Ceiling Fans, Central Air
    Appliances
    • Included: Dishwasher, Disposal, Free Standing Gas Oven, Free Standing Refrigerator
    Features
    • Basement: Finished
    • Has fireplace: Yes
    • Fireplace features: Living Room
    Interior area
    • Total interior livable area: 2,378 sqft
    • Finished area above ground: 1,658
    • Finished area below ground: 720

    Property

    Parking
    • Total spaces: 2
    • Parking features: Two Car Garage, Detached, Driveway, Electricityin Garage
    • Garage spaces: 2
    Features
    • Levels: Two
    • Stories: 2
    • Entry location: GroundLevel
    • Patio & porch: Breezeway, Covered, Deck, Porch
    • Exterior features: Balcony
    • Pool features: None
    • Fencing: Back Yard,Fenced
    Lot
    • Size: 6,098 sqft
    • Dimensions: 50.00 x 120.00
    Details
    • Parcel number: W22I085132S
    • Special conditions: Agent Owned,Short Sale No

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    • Property subtype: Single Family Residence
    Materials
    • Aluminum Siding
    • Foundation: Basement, Block
    • Roof: Asphalt
    Condition
    • New construction: No
    • Year built: 1927
    • Major remodel year: 2024

    Utilities & green energy

    • Electric: Circuit Breakers
    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Above Ground Utilities

    Community & neighborhood

    Security
    • Security features: Smoke Detectors
    Location
    • Region: Detroit
    • Subdivision: ROSEDALE PARK (PLATS)

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $47 annually
    • Association phone: 313-770-7695

    Other

    Other facts
    • Listing agreement: Exclusive Right To Sell
    • Listing terms: Cash,Conventional,FHA,Va Loan,Warranty Deed
    Services availability
    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

    $272,400

    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

    $272,400