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
$268,000
15123 Artesian St, Detroit, MI 48223
3beds
2,378sqft
Single Family Residence
Built in 1927
6,098 Square Feet Lot
$282,600 Zestimate®
$113/sqft
$2,235 Estimated rent
Home value
$282,600
$252,000 - $317,000
$2,235/mo
Zestimate® history
Owner options
List your home for rent
$2,235/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$2,235/mo
Rent Zestimate®
Refinance and save
$1,909/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$1,909/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 startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Beautiful landscapingPrestigious streetsNew soaking tubNew faux wood blindsNatural wood burning fireplaceFormal dining roomLarge kitchen
Zillow last checked:
Listing updated:
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
Primary bedroom
- Level: Second
- Area: 180
- Dimensions: 15 x 12
Bedroom
- Level: Second
- Area: 99
- Dimensions: 11 x 9
Bedroom
- Level: Second
- Area: 143
- Dimensions: 13 x 11
Other
- Level: Basement
- Area: 35
- Dimensions: 7 x 5
Other
- Level: Second
- Area: 63
- Dimensions: 9 x 7
Other
- Level: Entry
- Area: 12
- Dimensions: 4 x 3
Dining room
- Level: Entry
- Area: 169
- Dimensions: 13 x 13
Kitchen
- Level: Entry
- Area: 200
- Dimensions: 20 x 10
Living room
- Level: Entry
- Area: 299
- Dimensions: 23 x 13
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 Square Feet
- 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 & HOA
Community
- Security: Smoke Detectors
- Subdivision: ROSEDALE PARK (PLATS)
HOA
- Has HOA: Yes
- HOA fee: $47 annually
- HOA phone: 313-770-7695
Location
- Region: Detroit
Financial & listing details
- Price per square foot: $113/sqft
- Tax assessed value: $16,469
- Annual tax amount: $1,663
- Date on market: 8/9/2024
- Cumulative days on market: 59 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional,FHA,Va Loan,Warranty Deed
Price history
| Date | Event | Price |
|---|---|---|
| 3/10/2025 | Pending sale | $259,999-3%$109/sqft |
Source:  Realcomp II #20240054258 Report a problem | ||
| 3/7/2025 | Sold | $268,000+3.1%$113/sqft |
Source: Realcomp II #20240054258 Report a problem | ||
| 10/25/2024 | Price change | $259,999-3.3%$109/sqft |
Source: Realcomp II #20240054258 Report a problem | ||
| 10/7/2024 | Price change | $269,000-3.6%$113/sqft |
Source: Realcomp II #20240054258 Report a problem | ||
| 8/21/2024 | Pending sale | $279,000$117/sqft |
Source: Realcomp II #20240054258 Report a problem | ||
| 8/17/2024 | Price change | $279,000-3.5%$117/sqft |
Source: Realcomp II #20240054258 Report a problem | ||
| 8/9/2024 | Listed for sale | $289,000+261.3%$122/sqft |
Source: Realcomp II #20240054258 Report a problem | ||
| 12/22/2023 | Sold | $80,000+14.3%$34/sqft |
Source: Realcomp II #20230092109 Report a problem | ||
| 10/31/2023 | Pending sale | $70,000$29/sqft |
Source: Realcomp II #20230092109 Report a problem | ||
| 10/28/2023 | Listed for sale | $70,000+26.7%$29/sqft |
Source: Realcomp II #20230092109 Report a problem | ||
| 2/1/2008 | Sold | $55,250-43.6%$23/sqft |
Source: Public Record Report a problem | ||
| 5/18/2004 | Sold | $97,957-17.9%$41/sqft |
Source: Public Record Report a problem | ||
| 1/31/2003 | Sold | $119,371$50/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $91,000 +22.5% |
| 2024 | -- | $74,300 +39.4% |
| 2023 | -- | $53,300 +37.7% |
| 2022 | -- | $38,700 +23.6% |
| 2021 | -- | $31,300 |
| 2020 | $854 -42.4% | $31,300 +24.2% |
| 2019 | $1,481 | $25,200 +17.2% |
| 2018 | $1,481 | $21,500 +12.6% |
| 2017 | -- | $19,100 -35% |
| 2016 | $2,803 | $29,400 |
| 2015 | $2,803 +44.1% | $29,400 -20.1% |
| 2013 | $1,946 -30.6% | $36,800 -28% |
| 2010 | $2,803 | $51,125 -18% |
| 2009 | -- | $62,347 -14% |
| 2008 | -- | $72,497 -5% |
| 2007 | -- | $76,313 +5.5% |
| 2005 | $878 | $72,335 +3% |
| 2004 | -- | $70,228 +170.7% |
| 2001 | $2,160 +10.1% | $25,943 +3.2% |
| 2000 | $1,962 | $25,139 |
Find assessor info on the county website
Neighborhood: Rosedale Park
Nearby homes
- $171,500-- bd1 ba1.5k sqft15083 Artesian St, Detroit, MI 48223Off Market
- $189,100-- bd1 ba1.4k sqft15095 Artesian St, Detroit, MI 48223Off Market
- $147,8003 bd1 ba1.4k sqft15071 Artesian St, Detroit, MI 48223Off Market
- $154,700-- bd1 ba1.4k sqft15071 Artesian St, Detroit, MI 48223Off Market
- $234,5003 bd2 ba1.7k sqft15103 Artesian St, Detroit, MI 48223Off Market
- $243,700-- bd2 ba1.5k sqft15063 Artesian St, Detroit, MI 48223Off Market
- $169,400-- bd1 ba1.7k sqft15063 Artesian St, Detroit, MI 48223Off Market
- $192,5003 bd2 ba1.7k sqft15115 Artesian St, Detroit, MI 48223Off Market
Nearby schools
GreatSchools rating
- 3/10Gompers Elementary-Middle SchoolGrades: PK-8Distance: 1.1 mi
- 3/10Cody High SchoolGrades: 9-12Distance: 2.8 mi
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
$282,600
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
$282,600
- Michigan
- Wayne County
- Detroit
- 48223
- Rosedale Park
- 15123 Artesian St
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Detroit Topics
