Listed By
Agency Name: Coldwell Banker Realty
Agency Phone: 651-426-1671
Shown By
Agent Name: Bill Lieb
Agent Phone: (763) 360-0878
Agency Title: Counselor Realty
Property Description
Welcome to this beautifully updated townhome. Featuring 3 bedrooms, 3 bathrooms, and a 2-car garage, this home blends comfort and style. The main level showcases rich hardwood floors, a cozy gas fireplace and an open-concept layout perfect for everyday living and entertaining. This dream kitchen includes stainless steel appliances and granite countertops. Upstairs, you'll find a luxurious primary suite complete with a custom walk-in closet and an updated custom bathroom with a large walk-in shower, with over head rain shower, granite counter and dual sinks. Laundry room includes custom cabinetry, storage, front-loading washer and dryer. Garage includes plenty of shelving for storage, and the electrical is already set up for an electric vehicle charger. Enjoy outdoor living on your private patio, just off the kitchen. This home is part of the Waters Edge association, and access to fantastic amenities. Including a clubhouse, party room, fitness center, large in-ground pool, kiddie pool, playground and miles of walking paths. This home truly has it all?modern upgrades, ample space, and access to fantastic community features. Don't miss your opportunity to make it yours!
Property Features
Feature Descriptions
Local Schools
15194 Farnham Avenue N, Hugo, MN 55038
I will get in touch with you shortly.
Estimate Your Payment
Estimated Payment
$ 2,008.81 per month $1,649.42 Principal & Interest $269.00 Property Tax $90.39 Homeowner's InsuranceChange Payment Information
Near By
Demographics
15194 Farnham Avenue N, Hugo, MN 55038
Send an email with a link to
15194 Farnham Avenue N, Hugo, MN 55038.
Select a format below, new window will open and will prompt you to print.
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 05/09/2026. The listing information on this page last changed on 05/09/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 Sat 05/09/2026 1:04:08 AM EST) or RMLS-MN MLS (last updated Sat 05/09/2026 12:02:26 AM 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.
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.
STATE OF LICENSURE: MINNESOTA
Privacy Policy / DMCA Notice / ADA Accessibility
15194 Farnham Avenue N | MLS# 7068862
This home located at 15194 Farnham Avenue N, Hugo, MN 55038 is currently listed for sale with an asking price of $309,900. This property was built in 2008 and has 3 bedrooms and 2 full and 1 partial baths with 1909 sq. ft. Farnham Avenue N is located in the Waters Edge subdivision within the White Bear Lake school district. Search Waters Edge real estate on blieb.counselorrealty.com today.