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...
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
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#: 20240054258

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