For Sale: Coon Rapids MLS# 7038959
Active
NEW!
$2,050,000
Single Family: Modified Two Story
5 br • 5 ba • Built 2026
5,255 sqft • 1.31 acres
MLS# 7038959
Open Houses
12p - 6p
12p - 6p
12p - 6p
12p - 6p
Ask Tammy:
Ask the Agent℠
Thank You!
An agent will be in contact with you soon to answer your question.
Property Description
Built by Parent Custom Homes, a boutique custom builder with deep roots in the Twin Cities, this residence is the result of a truly collaborative, hands-on building experience. Known for their personal involvement and dedication to each home they create, the owners work directly with clients from concept to completion, bringing a level of care, communication, and craftsmanship that is increasingly rare in today’s building landscape. Every element of this home reflects that commitment, resulting in a one-of-a-kind riverfront property where thoughtful design, exceptional finishes, and enduring quality come together seamlessly.
Set on 1.3 breathtaking acres along one of the most sought-after stretches of the Mississippi River - known locally as “the pool” - this home was designed to capture the water at every turn. From sunrise reflections to long summer evenings on the water, the setting alone is something special… and Parent Custom Homes made sure the home rose to meet it.
The main level is anchored by a showpiece kitchen that feels pulled straight from a luxury design magazine; quartz surfaces, Monogram appliances, a commercial-grade gas range with pot filler, and a fully appointed walk-in pantry complete with prep sink and additional workspace. The adjacent dining area offers front-row river views and opens seamlessly to a maintenance-free deck, creating an effortless connection between indoor and outdoor living. Just around the corner, the living room continues the experience with soaring ceilings, a gas fireplace, and a dramatic wall of floor-to-ceiling windows that frame the river like a work of art, filling the space with natural light and making the view an integral part of everyday living.
A thoughtfully designed layout offers true main-level living, including a stunning primary suite with boxed vault ceiling, panoramic river views, spa-like bath with soaking tub and dual-head tile shower, and an expansive walk-in closet. A secondary bedroom and guest bath on the main level provide flexibility, while a private upper-level guest suite - complete with its own full bath - offers a quiet retreat for visitors.
The walkout lower level continues the experience with a cozy family room, fireplace, walk-up wet bar, and direct access to the backyard and river beyond. And then… the unexpected showstopper: an incredible indoor sport court unlike any you’ve seen - complete with river views, dedicated workout space, built-in storage/lockers, and its own adjoining bath. It’s a space designed not just to impress, but to be enjoyed.
Even the garage reflects the same level of intention: oversized, heated, insulated, and thoughtfully connected to the home with direct access to the sport court level.
This home is currently featured in the Parade of Homes, offering a rare opportunity to experience firsthand the craftsmanship, creativity, and client-focused building philosophy that define Parent Custom Homes. With extensive experience building in the north metro and along the Mississippi River, their expertise in both design and setting is on full display here, while their reach extends across the entire Twin Cities area for those looking to create something truly custom.
No detail was overlooked. Just a beautifully executed vision brought to life through a builder who treats each home, and each client, like it’s the only one that matters.
Listing
Listing Status:
Active
Contingency:
None
List Price:
$2,050,000
Price per sq ft:
$390
Property Type:
Single Family
City:
Coon Rapids
Garage Spaces:
3
County:
Anoka
Year Built:
2026
State:
MN
Property Style:
Modified Two Story
Zip Code:
55433
Subdivision Name:
River View Farm
Builder Name:
PARENT CUSTOM HOMES LLC
Interior
Bedrooms:
5
Bathrooms:
5
Finished Area:
5,255 ft2
Total Fireplaces:
2
Living Area:
5,255 ft2
Common Wall:
No
Appliances Included:
- Air-To-Air Exchanger
- Chandelier
- Dishwasher
- Disposal
- Dryer
- ENERGY STAR Qualified Appliances
- Exhaust Fan
- Humidifier
- Microwave
- Range
- Refrigerator
- Stainless Steel Appliances
- Tankless Water Heater
- Washer
- Water Softener Owned
- Wine Cooler
Fireplace Details:
- Electric
- Family Room
- Gas
- Living Room
- Stone
Basement Details:
- Daylight/Lookout Windows
- Finished
- Full
- Sump Basket
- Sump Pump
- Walkout
Exterior
Stories:
Modified Two Story
Garage Spaces:
3
Garage Dimensions:
46 x 25
Garage Size:
1,202 ft2
Garage Door Height:
8
Garage Door Width:
18
Air Conditioning:
Central Air
Foundation Size:
2,505 ft2
Handicap Accessible:
None
Road Responsibility:
Public Maintained Road
Heating System:
Forced Air
Parking Features:
- Attached Garage
- Floor Drain
- Garage Door Opener
- Heated Garage
- Insulated Garage
Unit Amenities:
- Ceiling Fan(s)
- Deck
- Kitchen Center Island
- Main Floor Primary Bedroom
- Paneled Doors
- Panoramic View
- Patio
- Porch
- Primary Bedroom Walk-In Closet
- Tile Floors
- Walk-In Closet
- Washer/Dryer Hookup
- Wet Bar
Road Frontage:
- City Street
- Curbs
- Paved Streets
Roof Details:
- Age 8 Years or Less
- Asphalt
- Pitched
Rooms
1/4 Baths:
None
Full Baths:
2
Half Baths:
2
3/4 Baths:
1
Bathroom Details:
- 1/2 Basement
- 3/4 Basement
- Double Sink
- Full Primary
- Main Floor 1/2 Bath
- Private Primary
- Separate Tub & Shower
- Two Basement Baths
- Upper Level Full Bath
- Walk-In Shower Stall
Dining/Kitchen:
- Eat In Kitchen
- Informal Dining Room
- Kitchen/Dining Room
Laundry:
- Electric Dryer Hookup
- Laundry Room
- Main Level
- Sink
- Washer Hookup
| Upper Level | Size | Sq Ft |
|---|---|---|
| Bathroom | 12 x 6 | 72 |
| Bedroom 3 | 20.5 x 27.5 | 540 |
| Main Level | Size | Sq Ft |
|---|---|---|
| Bathroom | 5 x 6 | 30 |
| Deck | 17 x 10 | 170 |
| Dining Room | 12.5 x 12 | 144 |
| Bedroom | 13.5 x 15.5 | 195 |
| Foyer | 10 x 9.5 | 90 |
| Kitchen | 13 x 18 | 234 |
| Laundry | 7 x 9 | 63 |
| Living Room | 16.5 x 17.5 | 272 |
| Primary Bathroom | 14 x 14.5 | 196 |
| Mud Room | 13 x 11.5 | 143 |
| Pantry (Walk-In) | 14.5 x 7 | 98 |
| Porch | 18 x 6.5 | 108 |
| Bedroom 2 | 16 x 12.5 | 192 |
| Walk-In Closet | 18 x 7.5 | 126 |
| Lower Level | Size | Sq Ft |
|---|---|---|
| Athletic Court | 24 x 43 | 1,032 |
| Bar/Wet Bar Room | 4 x 11 | 44 |
| Bathroom | 6 x 11 | 66 |
| Bathroom | 5 x 6 | 30 |
| Family Room | 17 x 17.5 | 289 |
| Bedroom 5 | 13 x 15.5 | 195 |
| Bedroom 4 | 12.5 x 24 | 288 |
Lake & Waterfront
Waterfront View:
River, South
WF Frontage:
119
Waterfront:
River Front
Lot & Land
Acres:
1.31
Geolocation:
45.1800116877, -93.3708304405
Lot Dimensions:
100 x 600 x 119 x 537
Zoning:
Residential-Single Family
Lot Description:
- Accessible Shoreline
- Tree Coverage - Medium
Schools
School District:
663
District Phone:
7635061000
Financial & Taxes
Tax Year:
2026
Annual Taxes:
$4,036
Lender-owned:
No
Assessment Pending:
Unknown
Taxes w/ Assessments:
$4,036
Association Fee Required:
No
Association Fee:
None
Miscellaneous
Fuel System:
Natural Gas
Model Location:
Coon Rapids
Sewer System:
City Sewer/Connected
Water System:
City Water/Connected
Mortgage Calculator
Use this calculator to estimate your monthly mortgage payment, including taxes and insurance. Simply enter
the price of the home, your down payment and loan term. Property taxes are based on the last
known value for this property or 0.012 of property
price when data is unavailable. Your interest rate and insurance rates will vary based on
credit score, loan type, etc.
This amortization schedule shows how much of your monthly payment will go towards the principle and how
much will go towards the interest.
| Month | Principal | Interest | P&I | Balance |
|---|---|---|---|---|
| Year | Principal | Interest | P&I | Balance |
Local Home Mortgage Professionals
Eric Bloomstrand
Branch Sales Manager
Fairway Home Mortgage NMLS#274211
612-961-2600
Eric Bloomstrand is a Branch Sales Manager at Fairway Home Mortgage with 30+ years of experience in the mortgage banking services industry. Eric has extensive skills in construction loans, FHA financing, VA loans, USDA, and first-time buyer down payment assistance programs. He is a well-qualified finance professional with a Bachelor of Science focused in Finance and Marketing from Minnesota State University, Mankato. Helping individuals acquire their dream home is his passion.
Connect with Eric today to get started with your home purchase!
Listing provided by RMLS,
courtesy of RE/MAX Results.
Disclaimer: The information contained in this listing has not been verified by TheMLSonline.com and should be verified by the buyer.
Disclaimer: The information contained in this listing has not been verified by TheMLSonline.com and should be verified by the buyer.