14 days on rocket

15870 Farnham Ave N, Hugo, MN, 55038

$599,995

Home List Price

$7,125*

Closing Credit

5 Bedrooms
2 Full Baths
3,488 SqFt
$172/SqFt
House
Schools Nearby

Location

Image provided by Mapbox

Get An Agent. Get A Mortgage.

Save BIG.

Rocket Homes logo

15870 Farnham Ave N, Hugo$599,995

Buyer Closing Credits

$7,125*

1.25% Loan Amount

Rocket Homes logo

Still Have Questions? Contact Us.

Contact Us Phone Number1 (855) 200-2001

Property Highlights

Home TypeSingle Family Residence
ParkingAttached Garage, Concrete, Heated Garage, Insulated Garage
Attached Garage2 spaces
Year Built2005
HeatingForced Air
CoolingCentral Air
BasementYes
FireplaceFamily Room, Gas
MLS #6538302
StatusActive

About 15870 Farnham Ave N

Stunning custom home in Hugo featuring beautiful hardwood floors. Modern kitchen boasts granite countertops, center island, breakfast bar, and stainless-steel appliances, including new range and dishwasher. Walk-out lower level has a huge family room with gas fireplace and wet bar, perfect for entertaining. Enjoy the outdoors from the large deck and patio. Spacious primary bedroom suite includes new carpeting and ample closet space. Oversized 2-car garage is insulated and heated, with secondary entrance from the lower level. With the addition of a stove, the lower level could easily be converted to a separate living space, as there is already a sink. Freshly painted interior offers a move-in ready experience. Located in a quiet neighborhood near shopping, dining, parks, and trails. Association amenities include a clubhouse, banquet hall, pool, and gym. Additional highlights include a newer roof and Pella windows. Don’t miss this exceptional property!

Property Details

Property Features

Property Information:

  • Year Built: 2005
  • Living Area: 3,488 SqFt

Listing Office:

  • Office Name: HomeAvenue Inc

Interior Features

Interior Information:

  • Appliances: Dishwasher, Disposal, Exhaust Fan, Humidifier, Microwave, Range, Refrigerator, Stainless Steel Appliances
  • Basement: Yes
  • Fireplace: Family Room, Gas

Bedroom and Bathroom Information:

  • Full Bathrooms: 2
  • Total Bedroom Count: 5

Exterior Features

Parking Information:

  • Garage Space: 2 spaces
  • Attached Garage: Yes
  • Parking: Attached Garage, Concrete, Heated Garage, Insulated Garage

Lot Features

Lot Information:

  • Lot: Few Trees

Utilities

Utilities Information:

  • Heating: Forced Air
  • Cooling: Central Air

School Info

Assigned Schools Information:

  • White Bear Lake Area High School - North Campus, Public District Grades 9-10
  • White Bear Lake Area High School - South Campus, Public District Grades 11-12
  • Central Middle School, Public District Grades 6-8
  • Oneka Elementary School, Public District Grades 2-5

Other

Directions Information:

  • Directions: 35E to Cty 14 (Main St), go east; left on Oneka Pkwy; right on Falcon Cir; right on 158th St; left on Farnham Ave; north to property on right

Price Information

Listing Price Info

Price Summary:

  • List Price: $599,995
  • Price Per SqFt: $172/SqFt

HOA Fees:

  • Amount: $65
  • Frequency: Monthly

Tax Information:

  • Annual Amount: $4,926
  • Tax Year: 2020
House and calculator

What can I afford?

Understand what home price range makes sense for your budget.

Housing Market Comparison

See how this home compares to others in Hugo, MN.

Map thumbnail provided by MapBox

Hugo, MN

City

Med. Sold Price

$443.2K

Med. Price/SqFt

$195

Avg. Days On Market

28

# of Sold Homes

44

15870 Farnham Ave N vs Hugo

14 DAYS ON ROCKET

-14 Days

$599,995

+$156.7K More

$172/SqFt

-$24 Less

KEY TAKEAWAY

This property is $156.7K more than the Median Sold Price and $24/SqFt less than other homes in Hugo, MN.

Based on homes sold in the last 12 months

MLS Details

MLS Information:

  • MLS Name: NORTHSTAR
  • MLS Number: #6538302

Listing Office:

  • Office Name: HomeAvenue Inc

IDX Broker Reciprocity Copyright © 2024 Regional Multiple Listing Service of Minnesota, Inc. All rights reserved.

By searching, you agree to the EULA Terms Agreement.

The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity℠ Program of the Regional Multiple Listing Service of Minnesota, Inc. Real estate listings held by brokerage firms other than this broker are marked with the Broker Reciprocity℠ logo or the Broker Reciprocity℠ thumbnail logo (a little black house) and detailed information about them includes the name of the listing brokers. Some or all of the property listings above may have been submitted to the Regional Multiple Listing Service (RMLS) by the listing broker for distribution to cooperating brokers through Broker reciprocity. Attribution of the listing broker may be found on the detail page for all properties. The broker providing these data believes them to be correct, but advises interested parties to confirm them before relying on them in a purchase decision.

Any use of search facilities of data on this site, other than by a consumer looking to purchase real estate, is prohibited. No part of this search utility may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise. Home sale information is not an appraisal, competitive or comparative market analysis, CMA or home valuation.

DMCA Notice
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 6/1/2024, 11:22:32 AM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.

Property Sales & Tax

Listing History

Jun 20, 2007Home Sold
$307,000

Tax History

YEARPROP. TAXASSESSMENT
2020$4,926$390,700
2019$5,024$379,400
2018$4,414$354,100
2017$4,414$337,600

History based on county public records data.

Payment Calculator

$3,127

Per Month

Recommended Financing

30-Year Fixed

Rate/APR

7.5% / 6.68%

Total Monthly Payment

$1,865

Powered By

Rocket Mortgage

Advertisement

NMLS#3030

Schools

Schools Nearby

The school rating is a score out of 10, where 10 is the highest and 1 is the lowest. Assigned schools have a bold outline.

Elementary School

school-card-donut-6377552
6
/10

  • Oneka Elementary School

  • 4888 Heritage Pkwy

  • 0.70 miles

  • Public District Grades 2-5

Middle School

school-card-donut-6377553
6
/10

  • Central Middle School

  • 4857 Bloom Ave

  • 6.28 miles

  • Public District Grades 6-8

High School

school-card-donut-6377554
3
/10

  • White Bear Lake Area High School - North Campus

  • 5045 Division Ave

  • 5.98 miles

  • Public District Grades 9-10

school-card-donut-6377555
8
/10

  • White Bear Lake Area High School - South Campus

  • 3551 Mcknight Rd N

  • 9.13 miles

  • Public District Grades 11-12

All data from GreatSchools

Neighborhood

What Are The Neighbors Like?

The neighbors living near this home have an average income of $78,248. The most common annual income of people living in Hugo, MN is between $35k-100k. Most families are single, no kids. Typical level of education for residents in this area is post secondary degree.

All data provided by Home Junction and Claritas

Frequently Asked Questions About 15870 Farnham Ave N

What is the listing price of this property?

The listing price of 15870 Farnham Ave N property is $599,995.

What type of property is this?

The property 15870 Farnham Ave N is a house located in Hugo, Minnesota, 55038.

Is this property for sale now?

Active Listing: 15870 Farnham Ave N is For Sale (Active/New) which means the seller is accepting offers.

What are the assigned schools for this property?

The assigned schools for 15870 Farnham Ave N are:
Oneka Elementary School: GreatSchools Rating 6/10
Central Middle School: GreatSchools Rating 6/10
White Bear Lake Area High School - North Campus: GreatSchools Rating 3/10
White Bear Lake Area High School - South Campus: GreatSchools Rating 8/10

What is the annual property tax for this property?

According to the records, the last property tax for 2020 is $4,926 (source: MLS/based on county public records data).

When was this property sold last time and for how much?

The last sale was on June 20, 2007 for $307,000. (source: MLS/tax record).

How many bedrooms and bathrooms does this property have?

The property at 15870 Farnham Ave N has 5 bedrooms and 3 bathrooms.

What is the square footage of this property?

The property 15870 Farnham Ave N is 3,488 SqFt (source: MLS/tax record).

Which year was this property built?

The year of construction for 15870 Farnham Ave N is 2005.

Rocket Homes›Minnesota›Washington County›Hugo›55038›15870 Farnham Ave N

This home is located at 15870 Farnham Ave N in Hugo, MN and zip code 55038. This 3,488 square foot home was built in 2005. Features: 5 bedrooms, 3 bathrooms. It has been listed on Rocket Homes since May 17, 2024 and is currently priced at $599,995.

Over 9 listings were sold over their listed price in April 2024 in Hugo, MN. In the same period over 17 listings were sold below the listed price and 18 listings were sold for the listed price. The number of homes for sale in Hugo, MN increased by 8.4% between March 2024 and April 2024. Listings spent 28 days on the market in April 2024, and had a median list price of $443,253 during the same period.

From Rocket Homes Real Estate and based on county public records data.

More Resources