Sign up to get new listings emailed daily! JOIN SIGN IN
Dave Wills
Salesperson
REALTOR®, CRS AGENT

15392 Farnham Avenue N, Hugo, MN 55038

$299,500
BEDS 2
BATHS 2 full
SQUARE FEET 1,604
MLS# 7135980
  • 15392 Farnham Avenue N, Hugo, MN 55038 Main Photo

38 Photos

Ask a Question

Dave Wills

Dave Wills
Call: (763) 670-3678

STATUS: Active
PROPERTY TYPE: Residential -
SUBDIVISION: Waters Edge South Second Add
SCHOOL: White Bear Lake

Property Description

Experience exceptional style and premium finishes in this beautifully updated Waters Edge end-unit townhome, offering a bright, vaulted open-concept main level enhanced by upgraded engineered wood flooring and tile. The kitchen stands out with stainless steel appliances, a built-in ice maker, and sleek finishes, complemented by comfortable upper bedrooms featuring a primary suite with a whirlpool tub, and an unfinished lower level with incredible expansion potential. Enjoy maintenance-free living and top-tier community amenities, including a clubhouse, pool, splash pad, fitness center, playground, and sports courts.

15392 Farnham Avenue N | MLS# 7135980

This home located at 15392 Farnham Avenue N, Hugo, MN 55038 is currently listed for sale with an asking price of $299,500. This property was built in 2006 and has 2 bedrooms and 2 full baths with 1604 sq. ft. Farnham Avenue N is located in the Waters Edge South Second Add subdivision within the White Bear Lake school district. Search Waters Edge South Second Add real estate on dwills.counselorrealty.com today.

Property Features

Property Type: Residential -
Basement: Yes
Basement: Unfinished
Cooling: Central Air
Fuel Type: Natural Gas
Garage: 2 car attached
Heating: Forced Air
Lot Size: 0.06 Acres
Stories: 3.0
Taxes: $3,261
Year Built: 2006

Feature Descriptions

Appliances: Dishwasher, Disposal, Dryer, Microwave, Range, Refrigerator, Washer
Bath: Full Primary, Private Primary, Upper Level Full Bath, Jetted Tub
Bathrooms Full: 2
Days on Site: 9
Down Payment Resource: Yes
Foundation Size: 530
Lot Dimensions: 67X36
Parcel#: 1803121410089
Parking: Attached Garage
Sewer: City Sewer/Connected
Shared Rooms: Amusement/Party Room, Club House, Exercise Room, Play Area
SQ FT Total: 1604
Water: City Water/Connected

Local Schools

School District: White Bear Lake

Listed By / Shown By

Listed By

Agency Name: Classic Lake Realty Inc
Agency Phone: 612-735-7099

Shown By

Agent Name: Dave Wills
Agent Phone: (763) 670-3678
Agency Title: Counselor Realty

IDX logo

TOUR THIS HOME

Choose a date and time to see 15392 Farnham Avenue N, Hugo, MN 55038.
An agent will get in touch to confirm your request shortly.

Request a Showing
Choose your video chat app
  • Friday September 11
  • Saturday September 12
  • Sunday September 13
  • Monday September 14
  • Tuesday September 15
  • Wednesday September 16
  • Thursday September 17
  • Friday September 18
  • Saturday September 19
  • Sunday September 20
  • Monday September 21
  • Tuesday September 22
  • Wednesday September 23
  • Thursday September 24
  • Friday September 25
  • 7:00 AM
  • 7:30 AM
  • 8:00 AM
  • 8:30 AM
  • 9:00 AM
  • 9:30 AM
  • 10:00 AM
  • 10:30 AM
  • 11:00 AM
  • 11:30 AM
  • 12:00 PM
  • 12:30 PM
  • 1:00 PM
  • 1:30 PM
  • 2:00 PM
  • 2:30 PM
  • 3:00 PM
  • 3:30 PM
  • 4:00 PM
  • 4:30 PM
  • 5:00 PM
  • 5:30 PM
  • 6:00 PM
  • 6:30 PM
  • 7:00 PM
  • 7:30 PM
  • 8:00 PM
  • 8:30 PM
  • 9:00 PM
Preferred Communication Method

Estimate Your Payment

Estimated Payment

$ 1,953.17 per month $1,594.06 Principal & Interest $271.75 Property Tax $87.35 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Near By



By searching Listing Data you agree to this End User License Agreement

Copyright 2026 Regional Multiple Listing Service of Minnesota, Inc. All rights reserved.

Terms of Use

Agency License Information: Counselor Realty, Inc. is licensed in Minnesota and Wisconsin; Counselor Realty, Inc. of Alexandria is licensed in Minnesota; Counselor Realty Detroit Lakes, LLC is licensed in Minnesota; Counselor Realty of Rochester is licensed in Minnesota; Counselor Realty of Victoria, LLC is licensed in Minnesota; Counselor Realty of Brainerd is licensed in Minnesota.

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 09/10/2026. The listing information on this page last changed on 09/10/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Thu 09/10/2026 12:00:47 AM EST) or RMLS-MN MLS (last updated Wed 09/09/2026 11:53:29 PM EST). Real estate listings held by brokerage firms other than Counselor Realty may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

By searching Listing Data you agree to this End User License Agreement
© 2026 Regional Multiple Listing Service of Minnesota, Inc. All rights reserved.


Listing data and photos distributed by MLSGRID
Member Participants (and their affiliated licensees, if applicable) shall indicate on their websites that IDX information is provided exclusively for consumers’ personal non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.



Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder