Welcome to this charming, solid brick ranch located in a quiet, well-established Roseville neighborhood. Built during the era of craftsmanship in 1952, this home offers a highly functional layout, classic suburban appeal, and a fantastic opportunity for personalization. Perfect for a first-time homebuyer, small family, or anyone looking for comfortable, single-level living in Macomb County. Enjoy your wonderful outdoor living area with a covered gazebo. A poured concrete slab is located below the gazebo and ready for the installation of your new hot tub.
Pending
Price cut: $1K (8/5)
$193,999
28460 Hollywood St, Roseville, MI 48066
3beds
1,000sqft
Single Family Residence
Built in 1952
5,662 Square Feet Lot
$192,700 Zestimate®
$194/sqft
$-- HOA
What's special
- 54 days |
- 465 |
- 21 |
Zillow last checked:
Listing updated:
Listed by:
James Looman 313-268-8431,
KW Platinum 586-949-0200
Source: MiRealSource,MLS#: 50213253
Originating MLS: MiRealSource
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 1
- Full bathrooms: 1
Rooms
- Room types: Bathroom
Bedroom 1
- Level: First
- Area: 110
- Dimensions: 10 x 11
Bedroom 2
- Level: First
- Area: 80
- Dimensions: 8 x 10
Bedroom 3
- Level: First
- Area: 108
- Dimensions: 9 x 12
Bathroom 1
- Level: First
- Area: 40
- Dimensions: 8 x 5
Kitchen
- Level: First
- Area: 90
- Dimensions: 9 x 10
Living room
- Level: First
- Area: 260
- Dimensions: 20 x 13
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Included: Gas Water Heater
Features
- Bar
- Flooring: Ceramic Tile, Hardwood
- Basement: Full
- Has fireplace: No
Interior area
- Total structure area: 2,000
- Total interior livable area: 1,000 sqft
- Finished area above ground: 1,000
- Finished area below ground: 0
Property
Parking
- Total spaces: 2
- Parking features: Garage, Detached, Electric in Garage, Garage Door Opener
- Garage spaces: 2
Features
- Levels: One
- Stories: 1
- Patio & porch: Deck, Porch
- Frontage type: Road
- Frontage length: 52
Lot
- Size: 5,662 Square Feet
- Dimensions: 52 x 100
- Features: Sidewalks, City Lot
Details
- Parcel number: 081417108007
- Zoning description: Residential
- Special conditions: Private
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Brick
- Foundation: Basement
Condition
- Year built: 1952
Utilities & green energy
- Sewer: Public At Street
- Water: Public
Community & HOA
Community
- Security: Security System
- Subdivision: Stieners Renaud Hill
HOA
- Has HOA: No
Location
- Region: Roseville
Financial & listing details
- Price per square foot: $194/sqft
- Tax assessed value: $84,900
- Annual tax amount: $2,499
- Date on market: 6/30/2026
- Cumulative days on market: 49 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
- Road surface type: Paved
Estimated market value
Zestimate®
$192,700
Estimated sales range
$183,000 - $202,000
Rent Zestimate®
$1,517/mo
Price history
| Date | Event | Price |
|---|---|---|
| 8/7/2026 | Pending sale | $193,999$194/sqft |
Source: | ||
| 8/5/2026 | Price change | $193,999-0.5%$194/sqft |
Source: | ||
| 7/24/2026 | Listed for sale | $195,000$195/sqft |
Source: | ||
| 7/24/2026 | Pending sale | $195,000$195/sqft |
Source: | ||
| 7/11/2026 | Listed for sale | $195,000$195/sqft |
Source: | ||
| 7/6/2026 | Pending sale | $195,000$195/sqft |
Source: | ||
| 6/30/2026 | Listed for sale | $195,000+66%$195/sqft |
Source: | ||
| 3/3/2006 | Sold | $117,486+62%$117/sqft |
Source: Public Record Report a problem | ||
| 1/19/1995 | Sold | $72,500$73/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $2,396 +4.5% | $84,900 +2.3% |
| 2024 | $2,292 +7.1% | $83,000 +11.1% |
| 2023 | $2,140 +3% | $74,700 +18.6% |
| 2022 | $2,078 | $63,000 +8.8% |
| 2021 | -- | $57,900 +6% |
| 2020 | -- | $54,600 +17.4% |
| 2019 | -- | $46,500 |
| 2018 | $1,465 +55.9% | -- |
| 2017 | $940 | $31,741 |
| 2016 | $940 | $31,741 +3.5% |
| 2015 | $940 | $30,663 +7.2% |
| 2013 | -- | $28,607 -15.8% |
| 2011 | -- | $33,974 -11.8% |
| 2010 | -- | $38,512 -25.7% |
| 2009 | -- | $51,854 -16.3% |
| 2008 | -- | $61,958 -8.1% |
| 2007 | -- | $67,383 -4.1% |
| 2006 | -- | $70,281 |
| 2005 | -- | -- |
| 2004 | -- | $60,119 +67.8% |
| 2001 | $1,238 +3.3% | $35,827 +3.2% |
| 2000 | $1,198 | $34,717 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 48066
Nearby schools
GreatSchools rating
- 5/10Fountain Elementary SchoolGrades: PK-5Distance: 0.2 mi
- 3/10Roseville Middle SchoolGrades: 6-8Distance: 0.5 mi
- 5/10Roseville High SchoolGrades: 9-12Distance: 1 mi
Schools provided by the listing agent
- District: Roseville Community Schools
Source: MiRealSource. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- $195,7003 bd2 ba938 sqft28490 Hollywood St, Roseville, MI 48066Off Market
Save 
- $170,0003 bd1 ba967 sqft28440 Hollywood St, Roseville, MI 48066Off Market
Save - $197,4003 bd2 ba945 sqft28459 Hollywood St, Roseville, MI 48066Off Market
Save - $176,0003 bd1 ba945 sqft28604 Hollywood St, Roseville, MI 48066Off Market
Save - $194,6003 bd1 ba1k sqft28410 Hollywood St, Roseville, MI 48066Off Market
Save - $180,8003 bd1 ba967 sqft28489 Hollywood St, Roseville, MI 48066Off Market
Save - $204,6003 bd1 ba945 sqft28439 Hollywood St, Roseville, MI 48066Off Market
Save - $184,3003 bd2 ba945 sqft28459 Bohn St, Roseville, MI 48066Off Market
Save
A local agent can set up tours, give advice and negotiate with sellers.






