Recently updated Solid Brick Ranch located in the prime location in the City of Warren. It has full finished basement, attached garage, new roof, new Central Air condition, new carpet, new kitchen floor, freshly painted and hardwood floor through out the house. Huge cement work has done recently included porch, patio and walkway.
Recently updated Solid Brick Ranch located in the prime location in the City of Warren. It has full finished basement, attached garage, new roof, new Central Air condition, new carpet, new kitchen floor, freshly painted and hardwood floor through out the house. Huge cement work has done recently included porch, patio and walkway.
REALCOMP #216036683
Apr 27, 2016
Sold
$80,200
$59/sq ft
Apr 21, 2016
Pending
—
Apr 19, 2016
Listed
$79,900
$58/sq ft
Greater Lansing AoR #21134101
Apr 27, 2016
Sold
$80,200
$59/sq ft
Apr 27, 2016
Sold
$80,200
$59/sq ft
Apr 22, 2016
Pending
—
Apr 19, 2016
Listed
$79,900
$58/sq ft
Apr 19, 2016
Listed
$79,900
$58/sq ft
MiRealSource-MiMLS #31287691
Apr 27, 2016
Listing Removed
—
Apr 27, 2016
Sold
$80,200
$59/sq ft
Apr 27, 2016
Sold
$80,200
$59/sq ft
Apr 21, 2016
Pending
—
Apr 19, 2016
Listed
$79,900
$58/sq ft
Apr 19, 2016
Listed
$79,900
$58/sq ft
Public Records
Oct 11, 1994
Sold
$98,000
$72/sq ft
MiRealSource-MiMLS #304515
Sep 27, 1994
Listing Removed
—
Sep 26, 1994
Sold
$98,000
$72/sq ft
Aug 4, 1994
Listed
$99,900
$73/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$4,909 (+2.2%)
2024
$4,803 (+5.3%)
2023
$4,561 (+23.2%)
2022
$3,701 (−1.7%)
2021
$3,765 (+0.6%)
2020
$3,742 (+3.8%)
2019
$3,604 (+1.4%)
2018
$3,555 (−7.1%)
2017
$3,826 (+52.6%)
2016
$2,508 (−6.6%)
2015
$2,685 (+10.4%)
2014
$2,431 (+1.2%)
2013
$2,403
Tax history for 4710 SHELL
Year
Property tax
Land + Additions
Assessment*
2025
$4,909 (+2.2%)
2024
$4,803 (+5.3%)
2023
$4,561 (+23.2%)
2022
$3,701 (−1.7%)
2021
$3,765 (+0.6%)
2020
$3,742 (+3.8%)
2019
$3,604 (+1.4%)
2018
$3,555 (−7.1%)
2017
$3,826 (+52.6%)
2016
$2,508 (−6.6%)
2015
$2,685 (+10.4%)
2014
$2,431 (+1.2%)
2013
$2,403
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Beds
3
Baths
1.5
Stories
1
Lot width
57 ft.
Lot depth
131 ft.
Lot size
7,405 Sq. Ft.
Year renovated
—
Sq. Ft.
1,368
Year built
1967
Style
Single Family Residential
County
Macomb County
APN
12-13-20-178-006
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 13, 2026.
Property details
Parking
Parking/Garage Information
Has Garage
Garage Dimensions: 20X20
# of Parking Spaces in Garage: 2
Garage Type: Attached Garage
Interior
Interior Features
Has Fireplace
# of Rooms (Total): 8
Appliances: Dishwasher, Disposal
Has Fireplace
Fireplace Features: Family Room Fireplace
Bathroom Information
# of Lavatories: 1
# of Bathrooms (Full): 1
# of Baths/Lavatories (Total): 2
Laundry/Basement Information
Basement : Has Basement
Basement Type: Finished
Exterior
Exterior Features
Exterior Construction: Brick
Exterior Features: Fenced Yard, Patio, Porch
Foundation Type: Basement
Property Information
Property Type: Residential
Structure Style: 1 Story
Year Built: 1967
Below Grade Sq. Ft.: 1200
Below Grade Sq. Ft. (Finished): 1000
Lot Information
Lot Size: 57,131
Land Information
Land Contract: No
Acreage: 0.17
Roads: Paved Street
Frontage: 57
Financial
Tax/Assessments Information
Total Tax Amount: $2,685
Summer Tax Amount: $2,615
Winter Tax Amount: $70
Utilities
Utility Information
Heat/Fuel Type: Natural Gas
Water Heater: Gas
Cooling System: Central A/C
Heating System: Forced Air
Location
Unit 5 Information
Living Room Dimensions: L=2369
School Information
School District: Warren Consolidated Schools
School District: Warren Consolidated Schools
Location Details
Directions: From Frazho onto Cunningham than make right on Shell Ct
Municipality Type: City
Municipality: Warren
Mail City: Warren
Subdivision: SEGUIN PARK # 02
Municipality: Warren
Area (Municipality): Warren (50023)
Public facts
Beds: 3
Baths: 1.5
Sq. Ft.: 1,368
Stories: 1.0
Lot Size: 7,405 square feet
Style: Single Family Residential
Year Built: 1967
Year Renovated: —
County: Macomb County
APN: 12-13-20-178-006
Home facts updated by county records on Aug 13, 2026
Other
Listing Information
Originating MLS: RealComp
No
Around this home
Schools
Siersma Elementary School
Public PreK-6 • Assigned • 0.8mi
5/10
Beer Middle School
Public 6-8 • Assigned • 1.1mi
7/10
Warren Mott High School
Public 9-12 • Assigned • 1.7mi
5/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
8/10 Flood Factor
Estimated 80%+ chance 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 97° expected this year, 15 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
3/10 Air Factor
3 unhealthy days expected this year, 5 days in 30 years
Provided by First Street
Historical weather
Warren, MI • 48091 1163
Average low and high temperatures (°F)
29
18
34
21
52
33
61
42
68
49
81
62
84
68
80
63
77
59
66
48
50
39
37
26
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.3 hours in
June and 2.5 hours in December, placing it below the
U.S. average for solar exposure.
9.3 hrs
2.5 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$249,000 – $301,000
Reach more buyers when you sell with Redfin. Save up to $2,617 in fees.3 minutes to get started.