15870 Farnham Avenue N, Hugo, MN 55038 - Photo 1

1/1

$500,000

Sold
Closed
Single Family
5 Beds
2 Full Baths
1 Partial Bath
3,488 Sq. Ft.
3 Car Garage

1/1

Property Description

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!

Full Property Details

Full Property Details for 15870 Farnham Ave N

General

Sold For: $500,000
HOA FEE: $65/month
Taxes: $5,626 (2024)
Status: Closed
Type: Single Family
Source: NorthStarMLS_RMLS
MLS ID: 6582873
Added to Site: 527 day(s) ago

Parking

Garage: Yes
Attached garage: Yes
Garage Description: 25 x 21
Garage Spaces: 3
Parking Features: Attached Garage, Concrete, Electric, Heated Garage, Insulated Garage, Storage

School Information

School District: 624 - White Bear Lake
High School District: White Bear Lake

Community

Association: Yes
Assoc. Name: HOAliving MN
Assoc. Fees Include: Professional Management, Shared Amenities

Heating & Cooling

Central air: Yes
Cooling Type: Central Air
Heating Type: Forced Air, Fireplace(s)
Heating Fuel: Natural Gas

Utilities

Sewer: City Sewer Connected
Water: City Water (Connected)

Additional Structures

Other Structures: Storage Shed

Financial Considerations

Association Fee: $65
Assoc Fee Freq.: Monthly
Tax Amount: $5,626
Tax Year: 2024
Terms: Conventional, VA, FHA, Cash

Disclosures and Reports

Legal Description: SUBDIVISIONNAME WATERS EDGE LOT 4 BLOCK 5 SUBDIVISIONCD 01314 SUBJ TO EASE
CC&Rs: Yes
Restrictions: Mandatory Owners Assoc, Other
Property ID: 1803121110028

Listed by eXp Realty
Sold by eXp Realty

What's Your Home Worth?

* Indicates a required field

For a complimentary comparative market analysis, please contact us so we can discuss your home's value.

Your Property Information

Address optional

City *State *

Zip Code *

Your Contact Information

First Name *Last Name *

Email Address *

Phone Number *

Comment *

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Submit, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

Listing agents

— 15870 Farnham Ave N —

eXp Realty

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender

NMLS#: 1598647

Get Pre-Approved

Schools

Schools serving 15870 Farnham Ave N

School District:White Bear Lake School District

Name	Grades	Distance
Oneka Elementary School 4888 Heritage Parkway, Hugo, MN 55038	2-5	0.4 mi
Hugo Elementary School 14895 Francesca Avenue North, Hugo, MN 55038	K-1	1.2 mi
Central Middle School, White Bear Lake, MN 4857 Bloom Avenue, White Bear Lake, MN 55110	6-8	6.3 mi
White Bear North Campus Senior 5045 Division Avenue, White Bear Lake, MN 55110	9-10	6 mi
White Bear South Campus Senior 3551 McKnight Road North, White Bear Lake, MN 55110	11-12	9.1 mi

Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 15870 Farnham Ave N

Date

Details

Price

Change

Source

12/16/2024

Sold

$500,000

—

MLS

9/27/2024

Price Reduced

$499,995

-3.83%

MLS

9/05/2024

Price Reduced

$519,900

-5.46%

MLS

8/15/2024

Listed

$549,900

—

MLS

Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

4030 Jay Ln, White Bear Lake, MN 55110 - Photo 1

Just Listed

$310,000

4030 Jay Ln White Bear Lake, MN 55110

Single Family
Active
Updated 3 days ago

3
Beds
2
Total Baths
1,430
Sq. Ft.

Listed by Keller Williams Premier Realty

3440 McKnight Rd N, White Bear Lake, MN 55110 - Photo 1

Just Listed

$390,000

3440 McKnight Rd N White Bear Lake, MN 55110

Single Family
Active
Updated 4 days ago

5
Beds
4
Total Baths
2,319
Sq. Ft.

Listed by eXp Realty

3407 Emerald Dr, White Bear Lake, MN 55110 - Photo 1

Just Listed

$350,000

3407 Emerald Dr White Bear Lake, MN 55110

Single Family
Active
Updated 4 days ago

3
Beds
2
Total Baths
2,128
Sq. Ft.

Listed by LPT Realty, LLC

7 Benttree Ct, North Oaks, MN 55127 - Photo 1

Just Listed

$3,200,000

7 Benttree Ct North Oaks, MN 55127

Single Family
Active
Updated 2 days ago

4
Beds
6
Total Baths
6,517
Sq. Ft.

Listed by Krista Wolter (612) 247-5106

600 Haywood Dr, Lino Lakes, MN 55014 - Photo 1

600 Haywood Dr Lino Lakes, MN 55014

Single Family
Active
Updated 5 days ago

4
Beds
3
Total Baths
2,293
Sq. Ft.

Listed by M/I Homes

7590 Swan St, Lino Lakes, MN 55038 - Photo 1

Price Reduced

-$33,900 (-5.61%)

$569,940

7590 Swan St Lino Lakes, MN 55038

Single Family
Active
Updated 17 hours ago

4
Beds
3
Total Baths
3,312
Sq. Ft.

Listed by Lennar Sales Corp

2106 Richard Ave, White Bear Lake, MN 55110 - Photo 1

Price Reduced

-$43,650 (-15%)

$247,350

2106 Richard Ave White Bear Lake, MN 55110

Single Family
Active
Updated 4 days ago

2
Beds
1
Total Bath
1,744
Sq. Ft.

Listed by Robin Sook (612) 978-9610

4847 Bloom Ave, White Bear Lake, MN 55110 - Photo 1

Price Reduced

-$10,100 (-1.98%)

$499,900

4847 Bloom Ave White Bear Lake, MN 55110

Multi-Family
Active
Updated 5 days ago

2
Units
6
Total Beds

Listed by Edina Realty, Inc.

15922 Farnham Ave N, Hugo, MN 55038 - Photo 1

Sold

$430,000

15922 Farnham Ave N Hugo, MN 55038

Single Family
Closed

5
Beds
3
Total Baths
2,190
Sq. Ft.

Listed by RE/MAX Advantage Plus
Sold by Rize Realty

5261 Fenson Ct N, Hugo, MN 55038 - Photo 1

Sold

$475,000

5261 Fenson Ct N Hugo, MN 55038

Single Family
Closed

3
Beds
3
Total Baths
1,887
Sq. Ft.

Listed by POP Realty MN
Sold by Dellwood Realty LLC

5080 159th St N, Hugo, MN 55038 - Photo 1

Sold

$475,000

5080 159th St N Hugo, MN 55038

Single Family
Closed

5
Beds
3
Total Baths
2,508
Sq. Ft.

Listed by Brick & Banister Real Estate
Sold by Edina Realty, Inc.

15769 Falcon Cir N, Hugo, MN 55038 - Photo 1

Sold

$470,000

15769 Falcon Cir N Hugo, MN 55038

Single Family
Closed

4
Beds
3
Total Baths
2,421
Sq. Ft.

Listed by Counselor Realty, Inc.
Sold by National Realty Guild

15870 Farnham Avenue N, Hugo, MN 55038 (MLS# 6582873) is a Single Family property that was sold at $500,000 on December 16, 2024. Want to learn more about 15870 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.

15870 Farnham Ave N Hugo, MN 55038