This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
$429,900 Coming Soon
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
Full Property Details for 15739 Farnham Ave N
General
- Price: $429,900
- HOA FEE: $424/month
- Taxes: $4,223 (2025)
- Status: Coming Soon
- Type: Single Family
- Source: NorthStarMLS_RMLS
- MLS ID: 7045486
- Updated: 4/10/2026
- Added to Site: 3 day(s) ago
- Expected Market Date: 4/13/2026
Interior
- Fireplace: Yes
- Number of Fireplaces: 1
- Fireplace(s): Gas, Living Room
- Appliances: Dishwasher, Dryer, Microwave, Range, Refrigerator, Washer, Water Softener Owned
Rooms
Bathrooms
- Total Bathrooms: 2
- Full Bathrooms: 2
Bedrooms
- Total Bedrooms: 3
Other Rooms
- Eat-in kitchen: Yes
- Dining Room: Eat-In Kitchen, Informal Dining Room, Living/Dining Room
- Formal Dining Room: Eat In Kitchen, Informal Dining Room, Living/Dining Room
- Laundry: Laundry Room, Main Level, Laundry Room, Main Level
Additional Information
- Amenities: Cable, Ceiling Fan(s), Kitchen Window, Primary Bedroom Walk-In Closet, Main Floor Primary Bedroom, Natural Woodwork, Patio, Paneled Doors, Security System, In-Ground Sprinkler, Sun Room, Tile Floors, Washer/Dryer Hookup, Walk-Up Attic
- Shared Amenities: In-Ground Sprinkler System
- Shared Pool: Yes
- Pool: Yes
- Pool Description: Below-Ground, Outdoor, Shared
Exterior
- Porch/Patio/Deck: Patio
Parking
- Garage: Yes
- Attached garage: Yes
- Garage Description: 24 x 19
- Garage Spaces: 2
- Parking Features: Attached Garage, Asphalt, Garage Door Opener, Heated Garage, Storage
Location
- County: Washington
- Township: Hugo
- Subdivision: Waters Edge
- Driving Directions: Frenchman Rd to Oneka Pkwy, go North to Falcon Circle N, take a right to 157th St N, go East to Farnham Ave N, take a left, 6th house on right.
School Information
- School District: 2099 - White Bear Lake
- High School District: White Bear Lake
Community
- Association: Yes
- Assoc. Name: HOA Living Minnesota
- Assoc. Fees Include: Lawn Care, Professional Management, Recreation Facility, Sanitation, Shared Amenities, Snow Removal
Heating & Cooling
- Central air: Yes
- Cooling Type: Central Air
- Heating Type: Forced Air, Fireplace(s), In-Floor Heating
- Heating Fuel: Natural Gas
Utilities
- Sewer: City Sewer Connected
- Water: City Water (Connected)
Structural Information
- Foundation Size: 1759
- Roof: Asphalt
- Disability Access: No Stairs Internal
- Square Feet: 1,869
- Above Ground: 1,869 Sq. Ft.
- Finished Down/Base.: 1,869 Sq. Ft.
- Year Built: 2006
Lot Features
- Lot Size (Acres): 0.09
- Lot Dimensions: 44 x 90
- Frontage: City Street, Paved Streets
- Zoning: Residential-Single Family
- Lot Description: Light Tree Coverage
Financial Considerations
- Association Fee: $424
- Assoc Fee Freq.: Monthly
- Tax Amount: $4,223
- Tax Year: 2025
- Terms: Conventional, VA, FHA, Cash
Disclosures and Reports
- Legal Description: SUBDIVISIONNAME WATERS EDGE LOT 5 BLOCK 12 SUBDIVISIONCD 01314 (CIC#260-27TH AMEND-CREATED 12/19/05 REC'D PLAT #01619)
- Property ID: 1803121140036
Listed by White Bear Lake Realty
Schools serving 15739 Farnham Ave N
| Name | Grades | Distance |
|---|---|---|
Oneka Elementary School 4888 Heritage Parkway, Hugo, MN 55038 | 2-5 | 0.4 mi |
Central Middle School, White Bear Lake, MN 4857 Bloom Avenue, White Bear Lake, MN 55110 | 6-8 | 6.1 mi |
Price & Sales History for 15739 Farnham Ave N
Tax History for 15739 Farnham Ave N
Estimate the Cost for 15739 Farnham Ave N
15739 Farnham Avenue N, Hugo, MN 55038 (MLS# 7045486) is a Single Family property with 3 bedrooms and 2 full bathrooms. 15739 Farnham Avenue N is currently listed for $429,900 and was received on April 09, 2026. Want to learn more about 15739 Farnham Avenue N? Do you have questions about finding other Single Family real estate for sale in Hugo? You can browse all Hugo real estate or contact a Coldwell Banker agent to request more information.

