OFF MARKET

Off Market Jun 2023 for $250K

$284,894

•

2,352

sq ft

788 Captain Frank Rd, New Albany, IN 47150

About this home

Single-familyProperty Type

1991Year Built

0.88 acresLot Size

$121Est. Price/Sq.Ft.

Listed by Gabby Alderman • Schuler Bauer Real Estate Services ERA Powered (N

Contact: 812-948-2888

Bought with Christina Kaufer • Legacy Real Estate

Bought with Carrie Senn • Legacy Real Estate

Redfin checked: 3 minutes ago

•Source:SIRA #202307666

Redfin Estimate

$284,894

$35K since sold in June 2023$6,000 since August

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 12.3% lower than the average sale price ($325K) of 6 comparable homes.

SOLD AUG 13, 2026
$310,000
A
3 beds2 baths2,514 sq ft
1124 Carriage Ln, New Albany, IN 47150
SOLD AUG 7, 2026
$349,000
B
3 beds3 baths2,295 sq ft
925 Captain Frank Rd, New Albany, IN 47150
SOLD DEC 16, 2025
$367,500
C
3 beds2.5 baths2,177 sq ft
1001 Oakland Dr, New Albany, IN 47150
SOLD MAR 18, 2026
$380,000
D
3 beds2.5 baths2,330 sq ft
111 Trimingham Rd, New Albany, IN 47150
SOLD MAY 18, 2026
$248,500
E
3 beds2 baths1,620 sq ft
319 Amburgey Dr, New Albany, IN 47150
SOLD AUG 26, 2026
$293,000
F
4 beds2 baths2,300 sq ft
2103 Fairway Ct, New Albany, IN 47150

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

Earn from this home

Sell

$78,456

Est. take-home

List your home with Redfin and save $2,849

Rent

$1,758/mo

Redfin rental estimate

List your home for rent

Market trends in 47150, IN

Last updated August 2026

Buyer's Market

Seller's Market

Balanced market

Sale-to-List Price

98.6%

0.1% MoM

Median sale price

$260K

$112 MoM

Avg. days on market

60d

5 days MoM

Recently sold homes

196

3 MoM

New listings for sale

NEW 2 HRS AGO
$270,000
3 beds1.5 baths1,402 sq ft
308 E 9th St, New Albany, IN 47150
NEW 4 HRS AGO
$195,000
4 beds1 bath1,888 sq ft
155 Jackson St, New Albany, IN 47150
NEW 4 HRS AGO
$314,900
4 beds3 baths2,500 sq ft
3212 Slate Creek Ct, New Albany, IN 47150
NEW 25 HRS AGO
$360,000
4 beds2 baths2,570 sq ft
1233 Vance Ave, New Albany, IN 47150
$275,000
3 beds2 baths1,490 sq ft
4102 Mel Smith Rd, New Albany, IN 47150
$239,900
3 beds2 baths1,647 sq ft
102 Maevi Dr, New Albany, IN 47150
$535,000
4 beds2.5 baths2,716 sq ft
2707 Clearstream Ct, New Albany, IN 47150
$236,900
3 beds2 baths1,572 sq ft
759 Linden St, New Albany, IN 47150
$165,000
2 beds2 baths1,176 sq ft
114 Colonial Dr, New Albany, IN 47150
$574,900
4 beds2.5 baths2,893 sq ft
1809 Woodland Rd, New Albany, IN 47150
See all

Provided by Redfin

Sale history for 788 Captain Frank Rd

Date

Event

Price

SIRA #202307666

Jun 20, 2023

Sold

$250,000

$106/sq ft

May 19, 2023

Pending

—

May 16, 2023

Listed

$243,000

$103/sq ft

SIRA #201907948

Aug 23, 2019

Sold

$178,500

$76/sq ft

May 20, 2019

Listed

$178,900

$76/sq ft

+26

Year

Property tax

Land + Additions

Assessment*

2025

$2,365 (+7.4%)

$22,900 + $224,500

$247,400

2024

$2,202 (+9.6%)

$22,900 + $185,000

$207,900

2023

$2,010 (+18.2%)

$22,900 + $160,500

$183,400

2022

$1,700 (+9.0%)

$22,900 + $132,000

$154,900

2021

$1,559 (+2.8%)

$22,900 + $118,600

$141,500

2020

$1,517 (+4.9%)

$22,900 + $114,700

$137,600

2019

$1,446 (+19.8%)

$22,900 + $91,800

$114,700

2018

$1,207 (+25.3%)

$22,900 + $98,600

$121,500

2017

$963 (+6.0%)

$22,900 + $83,900

$106,800

2016

$909 (+13.3%)

$22,900 + $83,900

$106,800

2015

$802 (+41.4%)

$22,900 + $72,900

$95,800

2013

$567

$22,900 + $59,500

$82,400

Tax history for 788 Captain Frank Rd

Year

Property tax

Land + Additions

Assessment*

2025

$2,365 (+7.4%)

$22,900 + $224,500

$247,400

2024

$2,202 (+9.6%)

$22,900 + $185,000

$207,900

2023

$2,010 (+18.2%)

$22,900 + $160,500

$183,400

2022

$1,700 (+9.0%)

$22,900 + $132,000

$154,900

2021

$1,559 (+2.8%)

$22,900 + $118,600

$141,500

2020

$1,517 (+4.9%)

$22,900 + $114,700

$137,600

2019

$1,446 (+19.8%)

$22,900 + $91,800

$114,700

2018

$1,207 (+25.3%)

$22,900 + $98,600

$121,500

2017

$963 (+6.0%)

$22,900 + $83,900

$106,800

2016

$909 (+13.3%)

$22,900 + $83,900

$106,800

2015

$802 (+41.4%)

$22,900 + $72,900

$95,800

2013

$567

$22,900 + $59,500

$82,400

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

Public record

Public record
Zoning

Beds

Baths

Stories

1.5

Lot width

—

Lot depth

—

Lot size

0.88 Acres

Year renovated

1991

Sq. Ft.

2,540

Year built

1991

Style

Single Family Residential

County

Floyd County

APN

220503300102000008

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Aug 13, 2026.

LDR

Low Density Residential

The Low Density Residential district is intended for low density residential Dwellings of a Single Family Dwelling type. Directly related types of uses, such as community services and accessory facilities, may also be allowed. This district provides a variety of Lot sizes and Dwelling types, as well as flexibility in development.

Permitted uses

Include but are not limited to:

Housing-Single unit
Housing-Other
Public service
Post office
Golf related
Park & open space

Property details

Interior

Bathroom Information
# of Full Bathrooms: 2

Room Information
# of Rooms (Total): 8

Room 1 Information
Full Bath
Level: Second

Room 2 Information
Full Bath
Level: First

Room 3 Information
Bedroom
Level: Second

Room 4 Information
Bedroom
Level: Second

Room 5 Information
Other
Description: bonus room
Level: First

Room 6 Information
Bedroom
Level: First

Room 7 Information
Kitchen
Level: First

Room 8 Information
Family Room
Level: First

Laundry Information
Features: Main Level, Laundry Room

Equipment
Appliances: Dishwasher, Oven, Range

Interior Features
Other Features: Ceiling Fan(s), Eat-in Kitchen, Main Level Master, Open Floorplan, Pantry, Split Bedrooms, Utility Room, Walk-In Closet(s)

Exterior

Building Information
Construction Details: Vinyl Siding
Builder Model: Cape cod

Exterior Features
Exterior Features: Landscaping, Paved Driveway
Other Structures: Shed(s)

Lot Information
Lot Size Area: 0.88
Lot Size Acres: 0.88
Lot Size Dimensions: see lot size
Lot Size Source: Assessor
Road Surface Type: Paved
Zoning: Residential
Zoning Description: Residential

Property Information
Has View
Above Grade Finished Area: 2,352
Foundation Details: Poured
Resale

Financial

Tax Information
Annual Tax Amount: $1,700

Lease Information
Lease Expiration: 2023-11-16

Utilities

Utility Information
Sewer: Public Sewer
Water Source: Connected, Public

Heating & Cooling
Has Cooling
Cooling: Central Air
Has Heating
Heating: Forced Air

Public facts

Beds: 3
Baths: 2.0
Sq. Ft.: 2,540
Stories: 1.5
Lot Size: 0.88 acres
Style: Single Family Residential
Year Built: 1991
Year Renovated: 1991
County: Floyd County
APN: 220503300102000008

Home facts updated by county records on Aug 13, 2026

Around this home

Schools

Nathaniel Scribner Middle School

Public 5-8 • Assigned • 0.8mi

7/10

New Albany Senior High School

Public 9-12 • Assigned • 2.1mi

4/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

4/10 Heat Factor

7 days above 106° expected this year, 20 days in 30 years

2/10 Wind Factor

1% chance of strong winds in next 30 years

2/10 Air Factor

1 unhealthy days expected this year, 2 days in 30 years

Provided by First Street

Historical weather

New Albany, IN • 47150

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 9.5 hours in June and 3.7 hours in December, placing it below the U.S. average for solar exposure.

9.5 hrs

3.7 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$271,000 – $328,000

Reach more buyers when you sell with Redfin. Save up to $2,849 in fees. 3 minutes to get started.

Get a free, detailed breakdown of how we calculated your estimate.

Nearby similar homes

$21,500

Land— sq ft

73 E 13th St, New Albany, IN 47150

$167,900

2 beds1 bath848 sq ft

1329 Roosevelt Ave, New Albany, IN 47150

$234,900

3 beds1.5 baths1,830 sq ft

2416 Stover Dr, New Albany, IN 47150

$244,900

3 beds2.5 baths1,695 sq ft

617 E Elm St, New Albany, IN 47150

$259,000

3 beds2 baths1,350 sq ft

2003 Cedar Ridge Dr, New Albany, IN 47150

$99,000

3 beds1 bath1,200 sq ft

821 W 8th St, New Albany, IN 47150

New listings for sale in 47150

NEW 2 HRS AGO

$270,000

3 beds1.5 baths1,402 sq ft

308 E 9th St, New Albany, IN 47150

NEW 4 HRS AGO

$195,000

4 beds1 bath1,888 sq ft

155 Jackson St, New Albany, IN 47150

NEW 4 HRS AGO

$314,900

4 beds3 baths2,500 sq ft

3212 Slate Creek Ct, New Albany, IN 47150

NEW 25 HRS AGO

$360,000

4 beds2 baths2,570 sq ft

1233 Vance Ave, New Albany, IN 47150

$275,000

3 beds2 baths1,490 sq ft

4102 Mel Smith Rd, New Albany, IN 47150

$239,900

3 beds2 baths1,647 sq ft

102 Maevi Dr, New Albany, IN 47150

$535,000

4 beds2.5 baths2,716 sq ft

2707 Clearstream Ct, New Albany, IN 47150

$236,900

3 beds2 baths1,572 sq ft

759 Linden St, New Albany, IN 47150

$165,000

2 beds2 baths1,176 sq ft

114 Colonial Dr, New Albany, IN 47150

Home values near 788 Captain Frank Rd

Data from public records.

Address	Redfin Estimate
789 Captain Frank Road, New Albany, IN 3 Beds \| 2 Baths \| 1830 Sq. Ft.	$308,452
786 Captain Frank Road, New Albany, IN 3 Beds \| 2 Baths \| 1200 Sq. Ft.	$227,055

Address	Redfin Estimate
778 Captain Frank Road, New Albany, IN 3 Beds \| 2.5 Baths \| 1710 Sq. Ft.	$254,538
780 Captain Frank Road, New Albany, IN 3 Beds \| 2 Baths \| 1199 Sq. Ft.	$192,042

Address	Redfin Estimate
782 Captain Frank Road, New Albany, IN 3 Beds \| 2 Baths \| 1200 Sq. Ft.	$246,697
784 Captain Frank Road, New Albany, IN 3 Beds \| 2 Baths \| 1820 Sq. Ft.	$276,720

Property information provided by SIRA when last listed in 2023. This data may not match . Learn more.

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.

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.

47172 homes for sale
47129 homes for sale
40212 homes for sale
47150 homes for sale
47119 homes for sale

Houses for rent in New Albany	Agents near me	Munster, IN homes for sale	New Albany Housing Market
Houses for sale near me	Indianapolis, IN homes for sale	Zionsville, IN homes for sale
Land for sale near me	Carmel, IN homes for sale	Crown Point, IN homes for sale
Open Houses near me	Fishers, IN homes for sale	New Albany Property Records
Condos for sale near me	Hammond, IN homes for sale	IN New Listings

Crestwood homes for sale
Louisville homes for sale
Prospect homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 47150, IN

Sale history for 788 Captain Frank Rd

Tax history for 788 Captain Frank Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 47150

Home values near 788 Captain Frank Rd

More real estate resources