Lori Gustafson

15740 Yellow Pine Street Nw

Andover, MN
$ 479,900 Beds 4 Baths 3 Sq 2,802
Monthly Estimate* How much can I afford?

Welcome home to this spacious 4 bedroom, 3 bathroom split-entry in Andover, offering 2,802 finished square feet and a fantastic combination of space, privacy, and functionality. Built in 2004, this well-designed home features an open-concept main level with beautiful wood floors, generous gathering spaces, and plenty of room to entertain. The upper level offers 1,492 square feet with three bedrooms, including a comfortable primary suite featuring a walk-in closet and private 3/4 bathroom. The kitchen is designed for both everyday living and entertaining, with stainless steel appliances, a convenient breakfast bar, and a walk-in pantry providing excellent storage. The 1,310 square foot lower level expands the living space with a large family room, fourth bedroom, 3/4 bathroom, and gas fireplace creating a warm and inviting setting for relaxing or entertaining. A wet bar adds even more versatility, making the lower level ideal for movie nights, game days, gatherings, or hosting guests. Step outside onto the maintenance-free deck and enjoy the peaceful setting overlooking a wetland, offering added privacy and no backyard neighbors. The sprinkler system helps keep the yard looking its best, while the spacious 3-car garage provides plenty of room for vehicles, storage, and recreational equipment. Conveniently located near Andover schools, restaurants, the YMCA, community center and the local hockey rink, this home offers easy access to many of the amenities that make the Andover community so desirable. With its spacious floor plan, two distinct living areas, private wetland setting, excellent storage, and 3-car garage, this home offers the space and flexibility you've been looking for. Don't miss the opportunity to make this one your own!

Single Family

  • Price
  • $ 479,900
  • City
  • Andover
  • Bedrooms
  • 4
  • Full Bathrooms
  • 3
  • County
  • ANOKA
  • Half Bathrooms
  • 0
  • Area
  • Woodland Oaks
  • Lot Size
  • 0.55 Acres
  • Zip
  • 55304
  • Sqr Footage
  • 2,802
  • Year Built
  • 2004
  • Taxes
  • $ 4568
  • Style
  • Single Family
  • MLS#
  • 7146509
Listed By: Premier Real Estate Services
Data Source: Northstar MLS (NSTAR)

Features

General

Living Area 2802
Sewer City Sewer/Connected
Heating Forced Air,Fireplace(s)
Cooling Central Air
Roof Age Over 8 Years,Asphalt
Appliances Air-To-Air Exchanger,Dishwasher,Disposal,Dryer,Electric Water Heater,Microwave,Other,Range,Refrigerator,Washer,Water Softener Owned
Garage Spaces 3
Construction Materials Block
Year Built 2004
Electric Circuit Breakers,200+ Amp Service
Levels Split Entry (Bi-Level)
Property Subtype Single Family
Tax Year 2026
Accessibility None
County Anoka
New Construction No
Property Type Residential
HOA No
Contingency None
Subdivision Name Woodland Oaks
Full Baths 1
Directions 161st Ave/Constance Blvd to south on Yellow Pine St,slight right to stay on Yellow Pine,south to home on right.
City Andover
High School District Anoka-Hennepin
Zoning Description Residential-Single Family
Lot Size Units Acres
Property Attached Y/N No
Land Lease Y/N No
Tax Annual Amount 4568
Additional Parcels Y/N No
Standard Status Active
Lender Owned No
Amenities Unit Cable,Ceiling Fan(s),Deck,Hardwood Floors,Kitchen Window,Primary Bedroom Walk-In Closet,Natural Woodwork,Patio,In-Ground Sprinkler,Tile Floors,Vaulted Ceiling(s),Washer/Dryer Hookup,Wet Bar,Walk-In C
PostalCity Andover

Interior Features

Basement Daylight/Lookout Windows,Drain Tiled,Finished,Full,Sump Pump,Walkout
Total Fireplaces 1
Fireplace Features Family Room,Gas
Basement (Y/N) Yes
Fireplace Y/N Yes
Above Grade Finished Area 1492
3/4 Baths 2
Laundry Features Lower Level
Total Bedrooms 4
Below Grade Finished Area 1310
Total Baths 3
Bath Desc 3/4 Basement,3/4 Primary,Private Primary,Upper Level Full Bath
Dining Room Description Breakfast Bar,Kitchen/Dining Room,Living/Dining Room
Fuel Natural Gas
Garage Dimensions 29x24
Garage Square Feet 696

Exterior Features

Fencing None
Parking Features Attached Garage,Asphalt,Garage Door Opener
Lot Features Irregular Lot
Water Source City Water/Connected
Lot Size Area 0.55
Building Area Total 2984
Lot Dimensions 91x261x168x180
Waterfront Y/N No
Foundation Area 1492
Road Frontage Type City Street
Road Responsibility Public Maintained Road

Amenities

  • Foreclosure
  • Views
  • Short Sale
  • New Construction
  • Adult 55+
  • Lease To Own
  • No HOA Fees
  • Furnished
  • Primary On Main
  • Air Conditioning
  • Seller Finance
  • Green
  • Fixer Upper
  • Horse
  • Golf
  • Fireplace
  • Deck
  • Garage
  • Basement
  • Pool

Affordability Calculator

$3,786

Per Month

Based on the average sale price from the Faribault, MN office

  • Monthly Principal & interest $2,658
  • Monthly Property Taxes $1,062
  • Monthly Home Insurance $67
Adjust Payment Options
Agent Photo

Let's determine your purchasing power. Working with my mortgage partner, you'll have the information you need to shop for a home with confidence.

Default based on a 30-year fixed rate of 6.49% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA, or jumbo loans.

Mortgage calculator provided courtesy of Inside Real Estate.

Schools

Elementary School Unknown Elementary School
Middle School Unknown Middle School
High School Unknown High School

Price History

9/23/2026 Listed $479,900

Property vs Zip Code Average in 55304

Price
AVG $830K
$480K
Taxes
AVG $4,034
$4,568
Year Built
AVG 2008
2004
Visits
AVG 202
12
Data Provided by Inside Real Estate®

Areas That We Cover

15740 Yellow Pine Street Nw Andover, MN is a Single Family Home for sale at $479900 with 2802 sqft and a lot size of 0.55 Acres Acre(s). 15740 Yellow Pine Street Nw Andover has 4 bedrooms, 3 baths and was built in 2004. The property's zip code is 55304 which is in Andover, MN

*Information deemed reliable but not guaranteed.

Financial calculator disclaimer: Default based on a 30-year fixed rate of 6.49% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA or jumbo loans.

Mortgage calculator provided courtesy of Inside Real Estate.

All information deemed reliable, but not guaranteed, and should be independently verified. The real estate information and related content displayed on this site 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.

Lori Gustafson

Lori Gustafson

Broker Associate/Sales Agent

507-323-4348

By pressing Contact Me, you agree that Weichert® may contact you via phone about your inquiry, which may involve the use of automated means. You are not required to consent as a condition of purchasing any property, goods or services. For any other information please read our Privacy Policy