$2,969 Closing Credit¹
#20240094219, Tamara Smith, Listing Office: Coldwell Banker Professionals-GPF
$3,087
closing credit¹
15123 Artesian St Detroit, MI 48223
$259,999 List price
$3,087
Closing credit¹
3 beds
2 full, 1 partial
2,378 sqft
0.1 acres
$109 / sqft
House
Property details
About 15123 Artesian St
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...
Highlights
Home typeSingle Family Residence
HeatingForced Air, Natural Gas
StatusActive
CoolingCeiling Fan(s), Central Air
Size2,378 sqft
BasementYes
Lot size0.14 Acres
Year built1927
ParkingTwoCarGarage, Detached, Driveway, ElectricityinGarage
MLS #20240054258
Garage2 spaces
FireplaceLivingRoom
Summary
- MLS Number: 20240054258
- MLS Name: Realcomp II Ltd
- Office Name: Keller Williams Home
- Office Phone: (248) 626-2100
- Listing Agent: Anthony Thomas, Conzella Thomas
Disclaimer: The data relating to real estate on this web site comes in part from the IDX of Realcomp II Ltd. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
IDX information is provided exclusively for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited.
IDX provided courtesy of Realcomp II Ltd. Copyright © 2025 Realcomp II Ltd. Shareholders. All rights reserved. Originating MLS shown with each listing detail.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 2/3/2025, 5:20:55 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Get an agent. Get a mortgage. Save big.¹
$259,999
15123 Artesian St
$3,087
closing credit¹
Sell your home with Rocket and save even more!
Seller rebate
0.5% sale price²
Price information
Property sales
| Date | Event | Price |
|---|---|---|
| Jan 04, 2024 | Home Sold | $80,000 |
| May 18, 2004 | Home Sold | $97,957 |
Tax history
| Year | Assessment | Property Tax |
|---|---|---|
| 2024 | $91,000 | $1,565 |
| 2023 | $74,300 | $1,565 |
| 2022 | $53,300 | $853 |
| 2021 | $38,700 | $853 |
| 2020 | $31,300 | $1,481 |
| 2018 | $21,500 | $1,481 |
| 2017 | $19,100 | $1,473 |
History based on county public records data.
Nearby schools
1
Cooke STEM Academy
Public District KG-5
0.6 mi
•18800 Puritan St
3
Edison Elementary School
Public District PK-5
0.8 mi
•17045 Grand River Ave
1
Old Redford Academy Elementary School
Public Charter PK-4
2.0 mi
•17195 Redford St
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $77,885. Most Detroit, MI residents have annual incomes between $35k-100k. The most common type of family is single, no kids. The majority of residents in this area have post secondary degree education.
How much money do the neighbors make?
20%
<35k
41%
35k-100k
35%
100k-200k
4%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
Doctorate
What types of families live nearby?
44%
Single, No Kids
15%
Single, with Kids
23%
Married, No Kids
18%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
14%
<11 yrs old
9%
12-17 yrs old
18%
18-34 yrs old
48%
35-64 yrs old
11%
65+ yrs old
What do the neighbors do for fun?
Pro Boxing
Mexican League Soccer
Major League Soccer (MLS)
Where do the neighbors shop?
Burlington
Foot Locker
H&M
Where do the neighbors go to eat?
White Castle
Little Caesars
Popeyes
What do the neighbors drive?
Kia
Dodge
Nissan
What do the neighbors listen to?
Urban Adult Contemporary
Rhythmic Contemporary Hits
All data provided by Home Junction and Claritas
Similar homes for sale
$2,850 Closing Credit¹
#20250002603, Jamel Dorsett, Listing Office: Dorsett Brokerage Development & Mgmt Group LLC
$2,909 Closing Credit¹
#20240093519, Schakerra Edwards, Listing Office: Front Page Properties
$3,177 Closing Credit¹
#20250004078, Brittany Randall, Listing Office: Clyde Realty LLC
$2,589 Closing Credit¹
#20250004843, Shawna Ramsay, Listing Office: RE/MAX Leading Edge
$2,375 Closing Credit¹
#20240064414, Twyla Woolwine, Listing Office: EXP Realty Main
$2,969 Closing Credit¹
#20240092345, Terry W Ozak, Listing Office: RE/MAX Leading Edge
$2,375 Closing Credit¹
#20240081115, Adrienne Ponce, Listing Office: EXP Realty LLC
$3,028 Closing Credit¹
#20250001591, Wael Nehme, Al Baydoun, Listing Office: U.S. Investor Group
$2,690 Closing Credit¹
#20240090393, Sandra J McGee, Listing Office: The Home Store Inc.
Frequently asked questions
About 15123 Artesian St
This home is located at 15123 Artesian St in Detroit, MI and zip code 48223 in the Rosedale neighborhood. This 2,378 square foot home, which was built in 1927, sits on a 0.14 acre lot. Features: 3 bedrooms, 3 bathrooms. It has been listed on Rocket Homes since August 9, 2024 and is currently priced at $259,999.
Over 76 listings were sold over their listed price in January 2025 in Detroit, MI. In the same period over 192 listings were sold below the listed price and 63 listings were sold for the listed price. The number of homes for sale in Detroit, MI increased by 8.7% between December and January 2025. The median list price of listings available in January 2025 was $87,445, while the average time on the real estate market was 58 days.
From Rocket Homes Real Estate and based on county public records data.