Google street view image for 40118 Rosewood Rd, Hancock, IA 51536

Off market sep 2023 for $65K

$174,621

Est. refi paymentEst. refi $455/mo

•

1 ba

•

960

sq ft

40118 Rosewood Rd, Hancock, IA 51536

About this home

40118 Rosewood Rd is a 960 square foot house on a 9.37 acre lot with 5 bedrooms and 1 bathroom. - it last sold on September 18, 2023 for $65,500. Based on Redfin's Hancock data, we estimate the home's value is $174,621.

Single-familyProperty Type

1924Year Built

9.37 acresLot Size

$182Est. Price/Sq.Ft.

Source:Public Records

Redfin Estimate

$174,621

$109K since sold in September 2023$2,000 since October

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 70.5% higher than the average sale price ($102K) of 6 comparable homes.

SOLD SEP 28, 2026
$27,500
A
Land— sq ft
328 E Kimball St, Hancock, IA 51536
SOLD JUL 1, 2026
$25,000
B
Land— sq ft
838 Palmer St, Oakland, IA 51560
SOLD JUL 15, 2026
$110,000
C
4 beds1 bath2,490 sq ft
516 N Frost Ave, Avoca, IA 51521
SOLD AUG 10, 2026
$182,000
D
3 beds1 bath1,464 sq ft
502 Western Ave, Shelby, IA 51570
SOLD SEP 23, 2026
$60,000
E
2 beds1 bath816 sq ft
706 N Walnut St, Avoca, IA 51521
SOLD OCT 15, 2026
$210,000
F
2 beds2 baths1,161 sq ft
42998 Tamarack Rd, Avoca, IA 51521

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$1,711/mo

Redfin rental estimate

List your home for rent

Market trends in 51521, IA

Last updated October 2026

Buyer's Market

Seller's Market

Balanced market

Sale-to-list price

94.4%

1.5% MoM

Median sale price

$188K

$8K MoM

Avg. days on market

24d

13 days MoM

Recently sold homes

2 MoM

Provided by Redfin

Sale history for 40118 Rosewood Rd

Year

Property tax

Land + Additions

Assessment*

2026

$1,096 (+8.1%)

$84,500 + $27,400

$111,900

2025

$1,014 (+0.6%)

$84,500 + $27,400

$111,900

2024

$1,008 (−17.9%)

$84,500 + $27,400

$111,900

2023

$1,228 (+1.2%)

$73,500 + $23,500

$97,000

2022

$1,214 (+30.8%)

$73,500 + $23,500

$97,000

2021

$928 (+1.8%)

$64,600 + $32,700

$97,300

2020

$912 (−1.1%)

$64,600 + $32,700

$97,300

2019

$922 (+3.8%)

$42,271 + $32,779

$75,050

2018

$888 (−6.3%)

$42,271 + $32,779

$75,050

2017

$948 (+0.9%)

$42,271 + $32,779

$75,050

2016

$940 (−2.9%)

$42,271 + $32,779

$75,050

2015

$968 (+3.0%)

$42,271 + $32,779

$75,050

2014

$940

$42,271 + $32,779

$75,050

Tax history for 40118 Rosewood Rd

Year

Property tax

Land + Additions

Assessment*

2026

$1,096 (+8.1%)

$84,500 + $27,400

$111,900

2025

$1,014 (+0.6%)

$84,500 + $27,400

$111,900

2024

$1,008 (−17.9%)

$84,500 + $27,400

$111,900

2023

$1,228 (+1.2%)

$73,500 + $23,500

$97,000

2022

$1,214 (+30.8%)

$73,500 + $23,500

$97,000

2021

$928 (+1.8%)

$64,600 + $32,700

$97,300

2020

$912 (−1.1%)

$64,600 + $32,700

$97,300

2019

$922 (+3.8%)

$42,271 + $32,779

$75,050

2018

$888 (−6.3%)

$42,271 + $32,779

$75,050

2017

$948 (+0.9%)

$42,271 + $32,779

$75,050

2016

$940 (−2.9%)

$42,271 + $32,779

$75,050

2015

$968 (+3.0%)

$42,271 + $32,779

$75,050

2014

$940

$42,271 + $32,779

$75,050

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Zoning

A-2

Agricultural Production District

The Class A-2 District is intended to preserve the land best suited for agricultural production by protecting prime agricultural lands in farmable tracts from the encroachment of scattered residential, commercial and industrial development; to promote efficiency and economy in the delivery of public services by restricting non-farm development in unincorporated areas of the County, which are without existing or planned services, and to encourage development in areas where services are provided or can efficiently be provided.

Permitted uses

Include but are not limited to:

Agriculture
Winery & vineyard
Housing-Single unit

Property details

Interior

Basement Information
Basement Finish: Full
Basement Type: Full

Bathroom Information
# of Full Baths: 1

Room Information
# of Rooms: 8

Exterior

Exterior Information
Physical Condition: Poor
Foundation Type: Block
Exterior Wall: Wood
Roof Covering Type: Asphalt
Roof Shape Type: Asphalt
Building Type: Single Family

Property Information
Ground Floor Sq. Ft: 960
# of Stories: 2
Stories Type: 2
Legal Description: PLEASANT TWP 35-77-40 PT SW SW COMM SW COR THE832.76' NLY542.74' WLY577.08' SE74.24' W29.69' W325.14' S458.88' TO POB (PARCEL A)

Parking & Garage Information
Garage/Parking Sq. Ft: 400

Lot Information
# of Buildings: 1
Land Sq. Ft: 408,157
Acres: 9.37
County Use Description: SINGLE-FAMILY/OWNER OCCUPIED

Financial

Assessor Information
Assessment Year: 2026

Public facts

Beds: 5
Baths: 1.0
Sq. Ft.: 960
Stories: 2.0
Lot Size: 9.37 acres
Style: Single Family Residential
Year Built: 1924
Year Renovated: —
County: Pottawattamie County
APN: 7740 35 300 007

Home facts updated by county records on Oct 16, 2026

Around this home

Schools

K - 12
Preschool & daycare

AHSTW Primary School

Public PreK-3 • Assigned • 5.4mi

7/10

AHSTW Intermediate School

Public 4-8 • Assigned • 5.4mi

9/10

A-H-S-T High School

Public 9-12 • Assigned • 5.4mi

6/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

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 104° expected this year, 15 days in 30 years

2/10 Wind Factor

Minor risk of severe winds over next 30 years

1/10 Air Factor

0 unhealthy days expected this year, 0 days in 30 years

Provided by First Street

Historical weather

Hancock, IA • 51536

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 10.3 hours in June and 4.2 hours in December, which is comparable to the U.S. average for solar exposure.

10.3 hrs

4.2 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$166,000 – $201,000

Sell confidently with a local market expert in Hancock. 3 minutes to get started.

Nearby similar homes

$250,000

3 beds1 bath1,172 sq ft

26477 230th St. St, Underwood, IA 51576

New septic system • Shared well • Convenient location

FOR SALE BY OWNER

$34,900

4 beds1 bath722 sq ft

208 Lincoln St, Minden, IA 51553

Built 1996 • Listed 19 days

$630,000

Land2,940 sq ft

26420 510th St, Walnut, IA 51577

Stone berm home • Three separate shops

NEW CONSTRUCTION

$349,900

3 beds2 baths1,471 sq ft

505 Brady St, Minden, IA 51553

Covered front porch • Walk in pantry • Garage

$109,900

2 beds1 bath1,148 sq ft

707 N Chestnut St, Avoca, IA 51521

0.26 acre lot • Garage • Built 1910

$219,000

3 beds2 baths2,188 sq ft

311 E Kearney St, Avoca, IA 51521

Bright sunroom • Hot tub • 0.55 acre lot

Home values near 40118 Rosewood Rd

Data from public records.

Address	Redfin Estimate
41616 Rosewood Road, Avoca, IA 3 Beds \| 1 Baths \| 384 Sq. Ft.	$113,034
41537 Mahogany Road, Hancock, IA 3 Beds \| 1 Baths \| 768 Sq. Ft.	$218,281
27476 390th Street, Hancock, IA 2 Beds \| 1 Baths \| 1176 Sq. Ft.	$245,866
39978 Pinoak Road, Hancock, IA 3 Beds \| 3 Baths \| 3564 Sq. Ft.	$578,107
28457 410th Street, Avoca, IA 4 Beds \| 1 Baths \| 504 Sq. Ft.	$174,030
39043 Sumac Road, Avoca, IA 3 Beds \| 1 Baths \| 896 Sq. Ft.	$170,153
40746 Sumac Road, Avoca, IA 3 Beds \| 2 Baths \| 1456 Sq. Ft.	$301,999

Address	Redfin Estimate
40363 Mahogany Road, Hancock, IA 4 Beds \| 1 Baths \| 970 Sq. Ft.	$352,455
41338 Mahogany Road, Hancock, IA 2 Beds \| 1 Baths \| 1272 Sq. Ft.	$271,910
26693 400th Street, Hancock, IA 3 Beds \| 1 Baths \| 1480 Sq. Ft.	$240,646
27075 410th Street, Hancock, IA 4 Beds \| 1 Baths \| 432 Sq. Ft.	$194,688
28959 410th Street, Avoca, IA 3 Beds \| 1 Baths \| 360 Sq. Ft.	$210,561
38589 Sumac Road, Avoca, IA 3 Beds \| 1 Baths \| 1196 Sq. Ft.	$180,512
40214 Sumac Road, Avoca, IA 4 Beds \| 3 Baths \| 2226 Sq. Ft.	$447,019

Address	Redfin Estimate
40954 Mahogany Road, Hancock, IA 3 Beds \| 1 Baths \| 1520 Sq. Ft.	$400,742
39683 Mahogany Road, Hancock, IA 4 Beds \| 1 Baths \| 1144 Sq. Ft.	$258,049
40052 Mahogany Road, Hancock, IA 3 Beds \| 1 Baths \| 1232 Sq. Ft.	$426,225
27877 410th Street, Hancock, IA 2 Beds \| 1 Baths \| 1752 Sq. Ft.	$357,147
40357 Sumac Road, Avoca, IA 6 Beds \| 1 Baths \| 640 Sq. Ft.	$509,599
29383 410th Street, Avoca, IA 4 Beds \| 1 Baths \| 1168 Sq. Ft.	$330,082
26277 390th Street, Hancock, IA 2 Beds \| 1 Baths \| 1116 Sq. Ft.	$211,982

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

Redfin Brokerage Licenses

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Houses for sale near me	Des Moines, IA homes for sale	Davenport, IA homes for sale
Land for sale near me	Iowa City, IA homes for sale	Dubuque, IA homes for sale
Open Houses near me	Cedar Rapids, IA homes for sale	Avoca Property Records
Condos for sale near me	West Des Moines, IA homes for sale	IA New Listings
Agents near me	Ankeny, IA homes for sale	Avoca Housing Market

Harlan homes for sale
Neola homes for sale
Atlantic homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 51521, IA

Sale history for 40118 Rosewood Rd

Tax history for 40118 Rosewood Rd

Zoning

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

Home values near 40118 Rosewood Rd

More real estate resources