Why buy new when you can purchase this gorgeous, move-in ready home with a finished basement! Nestled in the sought after Water's Edge Pool Community of Hugo this custom built home, updated throughout is turn key & ready for you to call your own! Bright & spacious, open concept main level with fresh paint throughout, new carpet & hardwood floors. Kitchen offers large island, ample cabinet space, granite counters, stainless appliances including new range & dishwasher. Sun room is perfect for slow mornings or extra entertaining space & walks out to large cedar deck. 3 Bedrooms, Laundry & Full Bath on main level. Massive private Owner's Suite on upper level boasts new carpet, vaulted ceilings, large walk in closet & ensuite. Lower Level holds Family Room with gas fireplace & custom wet bar, spacious 5th Bedroom & 3/4 Bathroom with walk in, tiled shower. Large patio & private backyard with storage shed. Oversized insulated/heated 2.5 car garage, large concrete driveway with additional parking. All of this within walking distance to schools, many parks, trails and pool!
Closed
$500,000
15870 Farnham Ave N, Hugo, MN 55038
5beds
3,560sqft
Single Family Residence
Built in 2005
9,583 sqft lot
$503,100 Zestimate®
$140/sqft
$65/mo HOA
What's special
Zillow last checked: 7 hours ago
Listing updated: May 06, 2025 at 07:27pm
Listed by:
Kathryn Johnson 651-283-4147,
eXp Realty,
Kelsie Lembeck 612-986-2858
Bought with:
Joseph P. Torkildson
eXp Realty
Source: NorthstarMLS as distributed by MLS GRID,MLS#: 6582873

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 3
- Full bathrooms: 2
- 3/4 bathrooms: 1
Bedroom 1
- Level: Upper
- Area: 384 Square Feet
- Dimensions: 24x16
Bedroom 2
- Level: Main
- Area: 121 Square Feet
- Dimensions: 11x11
Bedroom 3
- Level: Main
- Area: 121 Square Feet
- Dimensions: 11x11
Bedroom 4
- Level: Main
- Area: 100 Square Feet
- Dimensions: 10x10
Bedroom 5
- Level: Lower
- Area: 180 Square Feet
- Dimensions: 15x12
Deck
- Level: Main
- Area: 110 Square Feet
- Dimensions: 11x10
Dining room
- Level: Main
- Area: 120 Square Feet
- Dimensions: 12x10
Family room
- Level: Lower
- Area: 576 Square Feet
- Dimensions: 32x18
Foyer
- Level: Main
- Area: 96 Square Feet
- Dimensions: 12x8
Kitchen
- Level: Main
- Area: 132 Square Feet
- Dimensions: 12x11
Laundry
- Level: Main
- Area: 54 Square Feet
- Dimensions: 9x6
Living room
- Level: Main
- Area: 208 Square Feet
- Dimensions: 16x13
Patio
- Level: Main
- Area: 375 Square Feet
- Dimensions: 25x15
Sun room
- Level: Main
- Area: 144 Square Feet
- Dimensions: 12x12
Heating
- Forced Air, Fireplace(s)
Cooling
- Central Air
Appliances
- Included: Air-To-Air Exchanger, Dishwasher, Disposal, Dryer, Exhaust Fan, Humidifier, Gas Water Heater, Microwave, Range, Refrigerator, Stainless Steel Appliance(s), Washer
Features
- Basement: Block,Daylight,Drain Tiled,8 ft+ Pour,Egress Window(s),Finished,Full,Storage Space,Sump Pump,Walk-Out Access
- Number of fireplaces: 1
- Fireplace features: Family Room, Gas, Stone
Interior area
- Total structure area: 3,560
- Total interior livable area: 3,560 sqft
- Finished area above ground: 2,242
- Finished area below ground: 1,246
Property
Parking
- Total spaces: 3
- Parking features: Attached, Concrete, Electric, Heated Garage, Insulated Garage, Storage
- Attached garage spaces: 3
- Details: Garage Dimensions (25x21)
Accessibility
- Accessibility features: None
Features
- Levels: Three Level Split
- Patio & porch: Deck, Front Porch, Patio
- Has private pool: Yes
- Pool features: In Ground, Outdoor Pool, Shared
- Fencing: Chain Link,Partial,Wood
Lot
- Size: 9,583 sqft
- Dimensions: 97 x 130 x 51 x 130
Details
- Additional structures: Storage Shed
- Foundation area: 1486
- Parcel number: 1803121110028
- Zoning description: Residential-Single Family
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Brick/Stone, Shake Siding, Vinyl Siding
- Roof: Age 8 Years or Less,Pitched
Condition
- Age of Property: 20
- New construction: No
- Year built: 2005
Utilities & green energy
- Electric: Circuit Breakers
- Gas: Natural Gas
- Sewer: City Sewer/Connected
- Water: City Water/Connected
Community & neighborhood
Location
- Region: Hugo
- Subdivision: Waters Edge
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $65 monthly
- Amenities included: Other, Trail(s)
- Services included: Professional Mgmt, Shared Amenities
- Association name: HOAliving MN
- Association phone: 612-234-6464
Other
Other facts
- Road surface type: Paved
Services availability

Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$503,100