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

$700,000

For Sale - Active
1149 167th Ave NW, Andover, MN 55304
5 Beds
5 Baths
4,226 Square Feet
0.33 Acres Lot
Built in 2018
For Sale - Active
Units n/a
Checked: 19 hours ago
Updated: Aug 08, 2025 at 12:34AM

Investment Summary


Monthly Cash Flow
-$862
Cap Rate
4.2%
Cash-on-Cash Return
-6.4%
Debt Coverage Ratio
0.74
Internal Rate of Return (5 years)
-2.2%

Property Description


0.33 Acres Lot
Built in 2018
For Sale - Active
Units n/a

Welcome to this stunning custom-built home by Reggie Award-winning Tristar Homes, where exceptional craftsmanship meets thoughtful design and luxury finishes throughout. Step inside to a spacious open-concept main level that seamlessly connects the kitchen, dining, and living areas—perfect for entertaining or everyday living. The chef’s kitchen is a true showstopper, featuring granite countertops, a large center island with seating, high-end stainless steel appliances (including a double oven gas range), and abundant custom cabinetry. Just off the main living space, a private office with glass French doors offers the perfect work-from-home retreat. Upstairs, you'll find four generously sized bedrooms. The luxurious owners’ suite includes a tray-vaulted ceiling, a spacious walk-in closet, and an elegant ensuite with dual vanities, a soaking tub, and a separate walk-in shower. Two bedrooms share a Jack and Jill bath with a dual-sink vanity, while the fourth has its own private ¾ bath and walk-in closet. A convenient upper-level laundry room with built-in cabinetry and a utility sink adds to the home’s smart layout. The finished lower level offers even more living space with a large family room ideal for a home theater, gaming area, or play zone—complete with daylight windows and walk-out access to the backyard. It also features a fifth bedroom, an additional ¾ bath, and a workshop area perfect for hobbies or projects. The oversized, insulated, and heated three-car garage includes an extra-deep bay—ideal for your vehicles, tools, and toys year-round. Outside, enjoy multiple outdoor living spaces including a spacious deck and a ground-level patio overlooking the beautifully landscaped backyard. An irrigation system and invisible fence add convenience and peace of mind. With custom details at every turn, a flexible and functional layout, and a peaceful yet connected location—this home truly has it all. Schedule your visit today!

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, Driveway - Concrete
  • Details: Garage Door Opener, Heated Garage, Garage
  • Garage Spaces: 3
  • Spaces Total: 0

Bedroom Information

  • # of Bedrooms: 5

Bathroom Information

  • # of Baths (Full): 2
  • # of Baths (Partial): 1
  • # of Baths (Total): 5.0

Interior Features

  • # of Rooms: 11
  • # of Stories: 2
  • Basement: Yes
  • Basement Description: Concrete
  • Fireplace: Yes

Exterior Features

  • Exterior Walls Materials: Siding (Alum/Vinyl)
  • Roof Type: Hip

Land Information

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

Lot Information

  • Parcel ID: 113224430019
  • Lot Size: 14374 sqft

Property Information

  • Property Type: Single Family Residence
  • Style: (SF) Single Family
  • Year Built: 2018

Tax Information

  • Annual Tax: $7,023

Utilities

  • Water & Sewer: Public
  • Heating: Forced Air
  • Cooling: Central Air

Location

  • County: Anoka

Listing Details


Listed by:
Rodney Schimmel
Weichert, Realtors-Integrity
(612) 387-5718

Source:
FargoMoorhead Area Association of REALTORS
MLS#: 6768421
FargoMoorhead Area Association of REALTORS

Investment Summary


Monthly Cash Flow
-$862
Cap Rate
4.2%
Cash-on-Cash Return
-6.4%
Debt Coverage Ratio
0.74
Internal Rate of Return (5 years)
-2.2%

Purchase Details

Find an Agent

Purchase price:
$700,000
Amount financed:
-$560,000
Down payment:
$140,000
Closing costs:
$21,000
Rehab costs:
$0
Initial cash invested:
$161,000
Square feet:
4,226
Cost per square foot:
$166
Monthly rent per square foot:
$1.04

Financing Details

Find a Lender

Loan amount:
$560,000
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
5.875%
Principal & interest:
$3,313
Property tax:
$585
Insurance:
$308
Private mortgage insurance (PMI):
$0
Monthly payment:
$4,206

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$4,400 $52,800
Vacancy loss: (6%)
6% -$264 -$3,168
Operating income:
$4,136 $49,632

Operating Expenses


% Rent Monthly Yearly
Property taxes: (13%)
13%-$585-$7,023
Insurance: (7%)
7%-$308-$3,696
Property management: (8%)
8%-$352-$4,224
Repairs & maintenance: (5%)
5%-$220-$2,640
Capital expenditures: (5%)
5%-$220-$2,640
HOA fees: (n/a)
n/an/an/a
Total operating expenses: (38%)
38%-$1,685-$20,223

Cash Flow


Monthly Yearly
Net operating income:
$2,451 $29,412
Mortgage payments:
-$3,313 -$39,756
Cash flow:
$862 $10,344