Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$310,000 Coming Soon

  • For Sale
  • Coming Soon
  • Single Family
  • 4 Beds
  • 1 Full Bath
  • 2 Partial Baths
  • 1,914 Sq. Ft.
  • 2 Car Garage
  • Updated 12 hours ago
See This Home
Save This Home
See This Home
Save This Home
This end-unit townhome stands out with rare privacy, abundant natural light, and a setting that faces peaceful nature views-something few homes in the neighborhood offer. The main level is built for entertaining, featuring an open layout with upgraded flooring, a huge kitchen with pantry, and generously sized living spaces. A gas fireplace with stone surround adds a high-end focal point, while the kitchen flows seamlessly to a private deck-perfect for relaxing or hosting. A dedicated home office adds flexibility for work or daily life. Upstairs, you'll find three bedrooms, including a spacious primary suite with a large walk-in closet and a beautifully upgraded bathroom featuring a double vanity, ceramic tile, and a walk-in shower with a custom glass door. Just two blocks away, you'll find one of the best community centers in the north metro, featuring a private pool, playground, splash pad, basketball court, clubhouse, and fitness center - bringing standout amenities right into your everyday routine.

Full Property Details for 15162 Farnham Ave N

General

  • Price: $310,000
  • HOA FEE: $375/month
  • Taxes: $3,370 (2026)
  • Status: Coming Soon
  • Type: Single Family
  • Source: NorthStarMLS_RMLS
  • MLS ID: 7054129
  • Updated: 4/15/2026
  • Added to Site: 1 day(s) ago
  • Expected Market Date: 4/17/2026

Interior

  • Fireplace: Yes
  • Number of Fireplaces: 1
  • Fireplace(s): Gas, Living Room
  • Appliances: Dishwasher, Dryer, Microwave, Range, Refrigerator, Washer

Rooms

Bathrooms

  • Total Bathrooms: 3
  • Full Bathrooms: 1
  • 3/4 Bathrooms: 1
  • Half Bathrooms: 1

Bedrooms

  • Total Bedrooms: 4

Other Rooms

  • Laundry: Main Level, Main Level

Additional Information

  • Amenities: Ceiling Fan(s), Deck, French Doors, Kitchen Window, Primary Bedroom Walk-In Closet, Natural Woodwork, In-Ground Sprinkler, Tile Floors, Vaulted Ceiling(s), Washer/Dryer Hookup, Walk-In Closet
  • Shared Amenities: In-Ground Sprinkler System
  • Shared Pool: Yes
  • Pool: Yes
  • Pool Description: Below-Ground, Heated, Outdoor, Shared

Exterior

  • Porch/Patio/Deck: Deck

Parking

  • Garage: Yes
  • Garage Description: 20 x 20
  • Garage Spaces: 2
  • Parking Features: Asphalt, Finished Garage, Storage, Tuckunder Garage

Location

  • County: Washington
  • Township: Hugo
  • Subdivision: Waters Edge South Fourth Add
  • Driving Directions: Hwy 61 N, W onto Frenchman Rd, N onto Oneka Pkwy N, W onto 149th St N, NW onto Farnham Ave N.

School Information

  • School District: 2099 - White Bear Lake
  • High School District: White Bear Lake

Community

  • Association: Yes
  • Assoc. Name: HOA Living
  • Assoc. Fees Include: Hazard Insurance, Lawn Care, Maintenance Grounds, Professional Management, Recreation Facility, Shared Amenities, Snow Removal

Heating & Cooling

  • Central air: Yes
  • Cooling Type: Central Air
  • Heating Type: Forced Air
  • Heating Fuel: Natural Gas

Utilities

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

Structural Information

  • Basement: Yes
  • Finished basement: Yes
  • Basement Desc.: Finished, Full, Walk-Out
  • Foundation Size: 833
  • Roof: Age Over 8 Years
  • Disability Access: None
  • Square Feet: 1,914
  • Above Ground: 1,612 Sq. Ft.
  • Below Ground: 833 Sq. Ft.
  • Finished Down/Base.: 2,445 Sq. Ft.
  • Year Built: 2008

Lot Features

  • Lot Size (Acres): 0.051
  • Lot Dimensions: 71 x 31
  • Frontage: Paved Streets, Sidewalks
  • Zoning: Residential-Single Family
  • Lot Description: Light Tree Coverage

Financial Considerations

  • Association Fee: $375
  • Assoc Fee Freq.: Monthly
  • Tax Amount: $3,370
  • Tax Year: 2026
  • Terms: Conventional, VA, FHA, Cash

Disclosures and Reports

  • Legal Description: SUBDIVISIONNAME WATERS EDGE SOUTH FOURTH ADD LOT 63 BLOCK 1 SUBDIVISIONCD 02263 (CIC #258 26TH SUPL CREATED 02/26/2008 REC'D PLAT #02466)
  • Property ID: 1803121440181

Listed by Keller Williams Classic Realty

Quickly Find Out More

* Indicates a required field

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 Send Message, 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.

We Value Your Privacy

Listing agent

— 15162 Farnham Ave N —

  • Keller Williams Classic Realty

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Get a Great Insurance Rate

Find the right home insurance for your new home!

with our affiliated in-house agency

Request a Quote

Save up to an additional 20% by bundling your home and auto together!

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Find the right home insurance for your new home!

with our affiliated in-house agency

Request a Quote

Save up to an additional 20% by bundling your home and auto together!

Schools serving 15162 Farnham Ave N

School District:White Bear Lake School District
NameGradesDistance
Oneka Elementary School
4888 Heritage Parkway, Hugo, MN 55038
2-50.5 mi
Central Middle School, White Bear Lake, MN
4857 Bloom Avenue, White Bear Lake, MN 55110
6-85.6 mi
Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 15162 Farnham Ave N Get Price Alerts and Save Property

Date
Details
Price
Change
Source
4/15/2026
Listed
$310,000
56.49%
MLS
5/26/2017
Sold
$198,100
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 15162 Farnham Ave N

Year
Property Taxes
Change
Tax Assessment
Change
2026
$3,370
2%
$294,100
-6%
2025
$3,308
6%
$311,700
11%
2023
$3,114
—
$281,600
19%
2023
$3,114
15%
$236,200
12%
2021
$2,700
-1%
$210,700
4%
2020
$2,726
25%
$203,000
14%
2019
$2,182
14%
$177,400
12%
2018
$1,908
-5%
$158,100
-6%
2017
$2,004
-4%
$168,400
-1%
2016
$2,082
-7%
$169,800
-6%
2015
$2,228
30%
$181,600
45%
2014
$1,708
—
$125,100
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 15162 Farnham Ave N

$
Down Payment
%
$
%

$
$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Keller Williams Classic Realty

Similar Properties near 15162 Farnham Ave N

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

15240 Fanning Dr N, Hugo, MN 55038 - Photo 1 Just Listed
$309,900
Open House

15240 Fanning Dr N  Hugo, MN 55038

  • Single Family
  • Active
  • Updated 4 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,982
    Sq. Ft.
Listed by eXp Realty
14959 Generation Ave N, Hugo, MN 55038 - Photo 1
$320,000

14959 Generation Ave N  Hugo, MN 55038

  • Single Family
  • Active
  • Updated 12 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,878
    Sq. Ft.
Listed by Assembly MN LLC
4901 132nd St N, Hugo, MN 55038 - Photo 1
$315,000
Open House

4901 132nd St N  Hugo, MN 55038

  • Single Family
  • Active
  • Updated 7 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,700
    Sq. Ft.
Listed by Edina Realty, Inc.
3474 White Bear Ave N, White Bear Lake, MN 55110 - Photo 1
$307,500

3474 White Bear Ave N  White Bear Lake, MN 55110

  • Single Family
  • Active
  • Updated 8 hours ago
  • 3
    Beds
  • 1
    Total Bath
  • 1,150
    Sq. Ft.
Listed by eXp Realty

Just Listed near 15162 Farnham Ave N

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

1545 Peltier Lake Dr, Centerville, MN 55038 - Photo 1 Just Listed
$585,000

1545 Peltier Lake Dr  Centerville, MN 55038

  • Single Family
  • Active
  • Updated 13 hours ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,512
    Sq. Ft.
Listed by Real Broker, LLC
1075 Mehegan Ln, White Bear Township, MN 55127 - Photo 1 Just Listed
$795,000

1075 Mehegan Ln  White Bear Township, MN 55127

  • Single Family
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 3
    Total Baths
  • 3,248
    Sq. Ft.
Listed by Tom Lickteig (612) 227-6227
8195 Haywood Dr, Lino Lakes, MN 55014 - Photo 1 Just Listed
$584,990

8195 Haywood Dr  Lino Lakes, MN 55014

  • Single Family
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,892
    Sq. Ft.
Listed by M/I Homes
2515 Manitou Is, White Bear Lake, MN 55110 - Photo 1 Just Listed
$3,500,000

2515 Manitou Is  White Bear Lake, MN 55110

  • Lots/Land
  • Active
  • Updated 2 days ago
  • 1.565
    Acres
Listed by Edina Realty, Inc.

Price Reduced near 15162 Farnham Ave N

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

5441 Ridgeway St, White Bear Township, MN 55110 - Photo 1 Price Reduced
-$10,100 (-2.32%)
$424,900

5441 Ridgeway St  White Bear Township, MN 55110

  • Single Family
  • Active
  • Updated 21 hours ago
  • 4
    Beds
  • 2
    Total Baths
  • 2,400
    Sq. Ft.
Listed by RE/MAX Results
194 Shetland Ln, Lino Lakes, MN 55014 - Photo 1 Price Reduced
-$2,500 (-0.83%)
$299,500

194 Shetland Ln  Lino Lakes, MN 55014

  • Single Family
  • Active
  • Updated 10 hours ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,738
    Sq. Ft.
Listed by BRIX Real Estate
7549 Lotus Ln, Lino Lakes, MN 55038 - Photo 1 Price Reduced
-$10,654 (-2.15%)
$484,511

7549 Lotus Ln  Lino Lakes, MN 55038

  • Single Family
  • Active
  • Updated 2 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,582
    Sq. Ft.
Listed by Lennar Sales Corp
4584 Lake Ct, White Bear Lake, MN 55110 - Photo 1 Price Reduced
-$12,500 (-2.46%)
$495,000

4584 Lake Ct  White Bear Lake, MN 55110

  • Single Family
  • Active
  • Updated 6 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 3,472
    Sq. Ft.
Listed by Ryan Mann (612) 751-1073

Recent Sales near 15162 Farnham Ave N

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

15086 Farnham Ave N, Hugo, MN 55038 - Photo 1 Sold
$300,500

15086 Farnham Ave N  Hugo, MN 55038

  • Townhouse
  • Closed
  • 3
    Beds
  • 3
    Total Baths
  • 2,404
    Sq. Ft.
Listed by Partners Realty Inc.
Sold by Edina Realty, Inc.
15220 Fanning Dr N, Hugo, MN 55038 - Photo 1 Sold
$285,000

15220 Fanning Dr N  Hugo, MN 55038

  • Townhouse
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 2,004
    Sq. Ft.
Listed by Edina Realty, Inc.
Sold by Lakes Area Realty Hudson
5062 French Dr N, Hugo, MN 55038 - Photo 1 Sold
$295,000

5062 French Dr N  Hugo, MN 55038

  • Townhouse
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 1,909
    Sq. Ft.
Listed by LPT Realty, LLC
Sold by Sonali Vora
15151 French Dr N, Hugo, MN 55038 - Photo 1 Sold
$277,000

15151 French Dr N  Hugo, MN 55038

  • Townhouse
  • Closed
  • 2
    Beds
  • 3
    Total Baths
  • 1,752
    Sq. Ft.
Listed by Luke Team Real Estate
Sold by RE/MAX Synergy

15162 Farnham Avenue N, Hugo, MN 55038 (MLS# 7054129) is a Single Family property with 4 bedrooms, 1 full bathroom and 2 partial bathrooms. 15162 Farnham Avenue N is currently listed for $310,000 and was received on April 15, 2026. Want to learn more about 15162 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.

Tour this property