15870 Farnham Avenue N, Hugo, MN 55038

Save Contact


(15,600) 07/10/2024

15870 Farnham Avenue N Hugo, MN 55038

For Sale MLS# 6538302

5 beds 3 baths 3,488 sq ft Single Family



To receive email notifications, you need to update your profile with your email address.
Data current as of 16/07/2024 03:53:10

Details for 15870 Farnham Avenue N

MLS# 6538302

Description for 15870 Farnham Avenue N, Hugo, MN, 55038

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!

Listing Information

Property Type: Residential, Single Family

Status: Active

Bedrooms: 5

Bathrooms: 3

Lot Size: 0.22 Acres

Square Feet: 3,488 sq ft

Year Built: 2005

Foundation: 1,486 sq ft

Garage: Yes

Stories: Three Level Split

Subdivision: Waters Edge

County: Washington

Days On Market: 60

Construction Status: Previously Owned

School Information

District: 624 - White Bear Lake

Room Information

Main Floor

Bedroom 1: 11x11

Bedroom 2: 11x11

Bedroom 3: 10x10

Deck: 11x10

Dining Room: 12x10

Kitchen: 12x11

Laundry: 9x6

Living Room: 16x13

Upper Floor

Bedroom 4: 24x16

Lower Floor

Bedroom 5: 15x12

Family Room: 32x18

Patio: 25x15


Full Baths: 2

3/4 Baths: 1

Additonal Room Information

Family: Family Room,Lower Level

Dining: Informal Dining Room

Bath Description: 3/4 Basement,Bathroom Ensuite,Full Primary,Jetted Tub,Main Floor Full Bath,Private Primary,Separate Tub & Shower,Upper Level Full Bath,Walk-In Shower Stall

Interior Features

Square Footage above: 2,242 sq ft

Square Footage below: 1,246 sq ft

Appliances: Furnace Humidifier, Disposal, Air-To-Air Exchanger, Microwave, Range, Refrigerator, Exhaust Fan/Hood, Dishwasher, Stainless Steel Appliances

Basement: Daylight/Lookout Windows, Egress Windows, Drain Tiled, Full, Walkout, Concrete Block, Finished (Livable)

Fireplaces: 1, Family Room, Gas Burning

Additional Interior Features: Sun Room, Walk-In Closet, Kitchen Window, Kitchen Center Island, Tile Floors, Main Floor Laundry, 3 BR on One Level, All Living Facilities on One Level, Main Floor Bedroom, Ceiling Fan(s), Vaulted Ceiling(s), Hardwood Floors, Washer/Dryer Hookup


Water: City Water/Connected

Sewer: City Sewer/Connected

Cooling: Central

Heating: Forced Air, Natural Gas

Exterior / Lot Features

Attached Garage: Attached Garage

Garage Spaces: 2

Parking Description: Insulated Garage, Attached Garage, Driveway - Concrete, Heated Garage, Garage Dimensions - 25x21, Garage Sq Ft - 525.0

Exterior: Vinyl, Brick/Stone

Roof: Age 8 Years or Less, Asphalt Shingles

Lot Dimensions: 97x130x51x130

Zoning: Residential-Single Family

Fencing: Wood, Partial

Additional Exterior/Lot Features: Deck, Patio, Tree Coverage - Light, Road Frontage - City, Curbs, Paved Streets, Sidewalks

Out Buildings: Shed - Storage

Community Features

HOA Dues Include: Shared Amenities, Professional Mgmt, Sanitation

Homeowners Association: Yes

Association Name: HOAliving MN

HOA Dues: $65 / Monthly

Driving 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

Financial Considerations

Covenants/Deed Restrictions: Mandatory Owners Assoc, Architecture Committee

Tax/Property ID: 1803121110028

Tax Amount: 5626

Tax Year: 2024

HomeStead Description: Non-Homesteaded

Price Changes

$599,995 Original Price
$559,900 Current Price
-$40,095 Total Change
Date Price Change
07/10/2024 02.46 PM $559,900 -$15,600
06/06/2024 10.33 AM $575,500 -$24,495
05/17/2024 05.02 PM $599,995
Property price
Down payment
Interest rate
Loan term
Property taxes
HOA dues
Homeowners insurance
Show advanced features

The loan's interest rate will depend upon the specific characteristics of the loan transaction and credit profile up to the time of closing.

Sales History

Date Price Change
Currently not available.

Tax Summary

Tax Year Estimated Market Value Total Tax
Currently not available.

Data powered by ATTOM Data Solutions. Copyright© 2024. Information deemed reliable but not guaranteed.

Schools nearby 15870 Farnham Avenue N

Schools in attendance boundaries Grades Distance Rating

Schools nearby Grades Distance Rating

Data powered by ATTOM Data Solutions. Copyright© 2024. Information deemed reliable but not guaranteed.

The schools shown represent both the assigned schools and schools by distance based on local school and district attendance boundaries. Attendance boundaries change based on various factors and proximity does not guarantee enrollment eligibility. Please consult your real estate agent and/or the school district to confirm the schools this property is zoned to attend. Information is deemed reliable but not guaranteed.

SchoolDigger ® Rating

The SchoolDigger rating system is a 1-5 scale with 5 as the highest rating. SchoolDigger ranks schools based on test scores supplied by each state's Department of Education. They calculate an average standard score by normalizing and averaging each school's test scores across all tests and grades.

Coming soon properties will soon be on the market, but are not yet available for showings.