BRAND NEW ROOF INSTALLED SEPTEMBER 5TH 2026! This isn't your typical Roseville ranch. From the moment you step inside, the soaring cathedral ceiling accented by a striking exposed wood beam creates an unforgettable first impression, while abundant natural light fills the home with warmth and character. Built in 2001, this move-in-ready 3-bedroom ranch offers a refreshing combination of modern construction, timeless charm, and effortless comfort. Fresh paint and brand-new carpet mean you can unpack and start enjoying your new home from day one. The spacious eat-in kitchen provides plenty of room for everyday meals and gathering with family and friends, complete with a dishwasher and microwave. Downstairs, the expansive open basement offers endless possibilities, whether you envision a home gym, recreation room, workshop, additional living space, or abundant storage. A washer and dryer are also included. Outside, the fully fenced corner lot offers extra privacy and flexibility, complete with a storage shed and an oversized parking pad accommodating approximately 2-3 vehicles. Central air keeps you comfortable through Michigan summers. Perfectly situated on Roseville's desirable west side, just south of 12 Mile Road, you'll enjoy quick access to I-696, I-94, shopping, dining, parks, and everyday conveniences. Homes that combine soaring architectural details, newer construction, move-in-ready condition, and this exceptional value are increasingly difficult to find. Schedule your private showing today before someone else calls it home.
BRAND NEW ROOF INSTALLED SEPTEMBER 5TH 2026! This isn't your typical Roseville ranch. From the moment you step inside, the soaring cathedral ceiling accented by a striking exposed wood beam creates an unforgettable first impression, while abundant natural light fills the home with warmth and character. Built in 2001, this move-in-ready 3-bedroom ranch offers a refreshing combination of modern construction, timeless charm, and effortless comfort. Fresh paint and brand-new carpet mean you can unpack and start enjoying your new home from day one. The spacious eat-in kitchen provides plenty of room for everyday meals and gathering with family and friends, complete with a dishwasher and microwave. Downstairs, the expansive open basement offers endless possibilities, whether you envision a home gym, recreation room, workshop, additional living space, or abundant storage. A washer and dryer are also included. Outside, the fully fenced corner lot offers extra privacy and flexibility, complete with a storage shed and an oversized parking pad accommodating approximately 2–3 vehicles. Central air keeps you comfortable through Michigan summers. Perfectly situated on Roseville's desirable west side, just south of 12 Mile Road, you'll enjoy quick access to I-696, I-94, shopping, dining, parks, and everyday conveniences. Homes that combine soaring architectural details, newer construction, move-in-ready condition, and this exceptional value are increasingly difficult to find. Schedule your private showing today before someone else calls it home.
REALCOMP #81026006314
Apr 13, 2026
Relisted
—
Apr 13, 2026
Listing Removed
—
Apr 3, 2026
Contingent
—
Mar 12, 2026
Price Changed
$175,000
$91/sq ft
Feb 20, 2026
Listed
$195,000
$102/sq ft
Greater Lansing AoR #70515991
Apr 13, 2026
Listing Removed
—
Apr 13, 2026
Listing Removed
—
Apr 3, 2026
Contingent
—
Mar 12, 2026
Price Changed
$175,000
$91/sq ft
Feb 20, 2026
Listed
$195,000
$102/sq ft
SW Michigan MLS #1
Mar 12, 2026
Price Changed
$175,000
$91/sq ft
Greater Lansing AoR #40082095
Aug 31, 2020
Sold
$125,900
$66/sq ft
Aug 31, 2020
Sold
$125,900
$66/sq ft
Jul 25, 2020
Pending
—
Jul 23, 2020
Listed
$129,900
$68/sq ft
Jul 23, 2020
Listed
$129,900
$68/sq ft
Greater Lansing AoR #50018305
Aug 31, 2020
Sold
$125,900
$66/sq ft
Aug 31, 2020
Sold
$125,900
$66/sq ft
Jul 25, 2020
Pending
—
Jul 23, 2020
Listed
$129,900
$68/sq ft
Jul 23, 2020
Listed
$129,900
$68/sq ft
REALCOMP #2200056999
Aug 31, 2020
Sold
$125,900
$66/sq ft
Jul 25, 2020
Pending
—
Jul 23, 2020
Listed
$129,900
$68/sq ft
Public Records
Feb 1, 2002
Sold
$114,000
$59/sq ft
Public Records
Jan 16, 1991
Sold
$18,000
$9/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$6,013 (+9.2%)
2024
$5,507 (+4.6%)
2023
$5,262 (+6.6%)
2022
$4,936 (+3.0%)
2021
$4,790 (+136.4%)
2020
$2,026 (+5.3%)
2019
$1,925 (+1.9%)
2018
$1,889 (+7.2%)
2017
$1,762 (+0.6%)
2016
$1,751 (+0.5%)
2015
$1,742 (+0.4%)
2014
$1,735 (−0.4%)
2013
$1,742
Public record
Public record
Permits
Beds
3
Baths
1
Stories
1
Lot width
40 ft.
Lot depth
110 ft.
Lot size
4,356 Sq. Ft.
Year renovated
—
Finished Sq. Ft.
960
Unfinished Sq. Ft.
—
Total Sq. Ft.
960
Year built
2001
Style
Single Family Residential
County
Macomb County
APN
08-14-17-155-034
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 13, 2026.
Jan 28, 2022 • Final
Mechanical
HVAC
Jan 27, 2022 • Final
Electrical
Electrical
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
3/10 Heat Factor
7 days above 96° expected this year, 15 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
4/10 Air Factor
4 unhealthy days expected this year, 5 days in 30 years
Provided by First Street
Historical weather
Roseville, MI • 48066 2834
Average low and high temperatures (°F)
29
17
34
21
51
33
59
42
66
49
80
62
83
68
79
63
75
59
65
48
50
39
37
26
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
88/ 100
Very good sunlight
Sunscore
This home receives average direct sun exposure in the zip code. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.1 hrs
6.2 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 17245 Martin Rd
$167,182
$3,282 over list price of $164K
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $145K to $200K.