Skip to content
×
Pro Members Get
Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
ANNUAL Save 16%
$32.50 /mo
$390 billed annualy
MONTHLY
$39 /mo
billed monthly
7 day free trial. Cancel anytime
Copied
Photo
Copied
Photo
Photo
Photo
Photo
See all photos

$998,000

For Sale - Active
20010 Prescott Pl, Westfield, IN 46074
4 Beds
4 Baths
3,952 Square Feet
0.20 Acres Lot
Built in 2020
For Sale - Active
Units n/a
Checked: 10 hours ago
Updated: Jun 27, 2025 at 03:31AM

Investment Summary


Potential Missing Expenses

We noticed that property taxes are missing—this is a standard expense and should be considered in your estimate.

Monthly Cash Flow
-$1,367
Cap Rate
4.5%
Cash-on-Cash Return
-7.1%
Debt Coverage Ratio
0.73
Internal Rate of Return (5 years)
-2.9%

Property Description


0.20 Acres Lot
Built in 2020
For Sale - Active
Units n/a

Beautiful views of Chatham Hills Executive Course! This impeccably designed ranch home by Wedgewood Custom Builder offers a seamless blend of sophistication and comfort! Easy-flow floor plan with fine details include natural light in every corner! Soaring ceilings, hardwood floors, 8' wood doors & 7 1/4" base moldings! Spectacular windows! The gourmet kitchen is equipped w/top-of-the-line Bosch appliances, a spacious island ideal for casual dining & cooking adventures. The expansive living area opens to a covered porch w/fireplace & sunshade blinds-an ideal spot for year-round outdoor enjoyment and entertaining. The luxurious primary suite is a sanctuary, boasting a spa-like ensuite bathroom shower, tile & a walk-in closet. Two other generously sized bedrooms & full bath on the main floor. The finished basement is an entertainment haven, complete w/a full sized refrigerator, microwave, wet bar, & cabinetry. Large egress windows, a 4th bedroom and full bath complete the lower level. Walk to the spectacular clubhouse, Home is located on a gated cul-de-sac.

Build Your Team


Quickly find investor-friendly professionals who can help you succeed in real estate investing at any stage of the investing journey.

Agents

Match with investor-friendly agents who can help you find, analyze, and close your next deal

Find an Agent

Lenders

Get the best funding…find investor-friendly lenders who specialize in your deal strategy

Find a Lender

Property Managers

Transition to passive investing. Find a trusted property management partnership that lasts.

Find a Property Manager

Tax Pros & Accountants

Taxes and financial reporting made easy—find experts to create tax savings strategies, file taxes, and more

Find a Tax Pro

Location


Property Details


Parking

  • Description: Attached, Garage Door Opener, Finished Garage, Keyless Entry, Courtyard Load Garage
  • Details: Garage Door Opener, Attached
  • Garage Spaces: 3
  • Spaces Total: 0

Bedroom Information

  • # of Bedrooms: 4

Bathroom Information

  • # of Baths (Full): 3
  • # of Baths (Total): 4.0

Interior Features

  • # of Rooms: 10
  • # of Stories: 1
  • Basement: Yes
  • Basement Description: Sump Pump, Finished
  • Fireplace: Yes

HOA

  • Has HOA: Yes
  • HOA Fee: $1,430/annually

Land Information

  • Land Use: Residential
  • Land Use Subtype: Single Family Residential

Lot Information

  • Parcel ID: 290524002019.000015
  • Lot Size: 8712 sqft

Property Information

  • Property Type: Single Family Residence
  • Style: Craftsman, Ranch
  • Year Built: 2020

Tax Information

  • Annual Tax: $0

Utilities

  • Heating: Forced Air, Natural Gas

Location

  • County: Hamilton

Listing Details


Listed by:
Mick Scheetz
CENTURY 21 Scheetz
(317) 418-9878

Source:
MIBOR Broker Listing Cooperative
MLS#: 22038793
MIBOR Broker Listing Cooperative

Investment Summary


Potential Missing Expenses

We noticed that property taxes are missing—this is a standard expense and should be considered in your estimate.

Monthly Cash Flow
-$1,367
Cap Rate
4.5%
Cash-on-Cash Return
-7.1%
Debt Coverage Ratio
0.73
Internal Rate of Return (5 years)
-2.9%

Purchase Details

Find an Agent

Purchase price:
$998,000
Amount financed:
-$798,400
Down payment:
$199,600
Closing costs:
$29,940
Rehab costs:
$0
Initial cash invested:
$229,540
Square feet:
3,952
Cost per square foot:
$253
Monthly rent per square foot:
$1.42

Financing Details

Find a Lender

Loan amount:
$798,400
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
6.625%
Principal & interest:
$5,112
Property tax:
$0
Insurance:
$392
Private mortgage insurance (PMI):
$0
Monthly payment:
$5,504

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$5,600 $67,200
Vacancy loss: (6%)
6% -$336 -$4,032
Operating income:
$5,264 $63,168

Operating Expenses


% Rent Monthly Yearly
Property taxes: (n/a)
n/an/an/a
Insurance: (7%)
7%-$392-$4,704
Property management: (8%)
8%-$448-$5,376
Repairs & maintenance: (5%)
5%-$280-$3,360
Capital expenditures: (5%)
5%-$280-$3,360
HOA fees: (2%)
2%-$119-$1,428
Total operating expenses: (27%)
27%-$1,519-$18,228

Cash Flow


Monthly Yearly
Net operating income:
$3,745 $44,940
Mortgage payments:
-$5,112 -$61,344
Cash flow:
$1,367 $16,404