Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$479,900 Just Listed

  • For Sale
  • Active
  • Single Family
  • 4 Beds
  • 1 Full Bath
  • 2 Partial Baths
  • 2,802 Sq. Ft.
  • 3 Car Garage
  • Updated 21 hours ago

Next open house:

Open House: 10:30 AM - 12:00 PM

Sunday 9/27 10:30 AM - 12:00 PM

15740 Yellow Pine Street NW,Andover, MN 55304

15740 Yellow Pine Street NWAndoverMN55304

Get directions
See This Home
Save This Home
See This Home
Save This Home
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!

Full Property Details for 15740 Yellow Pine St NW

General

  • Price: $479,900
  • Taxes: $4,568 (2026)
  • Status: Active
  • Type: Single Family
  • Source: NorthStarMLS_RMLS
  • MLS ID: 7146509
  • Updated: 9/25/2026
  • Added to Site: 4 day(s) ago

Interior

  • Fireplace: Yes
  • Number of Fireplaces: 1
  • Fireplace(s): Family Room, Gas
  • Appliances: Air-To-Air Exchanger, Dishwasher, Disposal, Dryer, Electric Water Heater, Microwave, Other, Range, Refrigerator, Washer, Water Softener Owned

Rooms

Bathrooms

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

Bedrooms

  • Total Bedrooms: 4

Other Rooms

  • Dining Room: Breakfast Bar, Kitchen/Dining Room, Living/Dining Room
  • Formal Dining Room: Breakfast Bar, Kitchen/Dining Room, Living/Dining Room
  • Laundry: Lower Level, Lower Level

Additional Information

  • Amenities: 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 Closet

Exterior

  • Porch/Patio/Deck: Composite Decking, Deck, Patio

Parking

  • Garage: Yes
  • Attached garage: Yes
  • Garage Description: 29 x 24
  • Garage Spaces: 3
  • Parking Features: Attached Garage, Asphalt, Garage Door Opener

Location

  • County: Anoka
  • Township: Andover
  • Subdivision: Woodland Oaks
  • Driving Directions: 161st Ave/Constance Blvd to south on Yellow Pine St, slight right to stay on Yellow Pine, south to home on right.

School Information

  • School District: 11 - Anoka-Hennepin
  • High School District: Anoka-Hennepin

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)

Structural Information

  • Exterior Const.: Block
  • Basement: Yes
  • Finished basement: Yes
  • Basement Desc.: Daylight/Lookout Windows, Drain Tiles, Finished, Full, Sump Pump, Walk-Out
  • Foundation Size: 1492
  • Roof: Age Over 8 Years, Asphalt
  • Disability Access: None
  • Square Feet: 2,802
  • Above Ground: 1,492 Sq. Ft.
  • Below Ground: 1,492 Sq. Ft.
  • Finished Down/Base.: 2,984 Sq. Ft.
  • Year Built: 2004

Lot Features

  • Lot Size (Acres): 0.55
  • Lot Dimensions: 91 x 261 x 168 x 180
  • Frontage: City Street
  • Zoning: Residential-Single Family
  • Lot Description: Irregular Lot

Financial Considerations

  • Tax Amount: $4,568
  • Tax Year: 2026
  • Terms: Conventional, VA, FHA, Cash

Disclosures and Reports

  • Legal Description: LOT 14 BLOCK 4 WOODLAND OAKS
  • Property ID: 143224340028

Listed by Premier Real Estate Services

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 agents

— 15740 Yellow Pine St NW —

  • Premier Real Estate Services

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 15740 Yellow Pine St NW

School District:Anoka-Hennepin School District
NameGradesDistance
Rum River Elementary School
16950 Verdin Street Northwest, Andover, MN 55304
K-52.2 mi
Oak View Middle School
15400 Hanson Boulevard Northwest, Andover, MN 55304
6-80.6 mi
Andover Senior High School
2115 Andover Boulevard Northwest, Andover, MN 55304
9-121.5 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 15740 Yellow Pine St NW Get Price Alerts and Save Property

Date
Details
Price
Change
Source
9/25/2026
Listed
$479,900
18.49%
MLS
7/13/2021
Sold
$405,000
—
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 15740 Yellow Pine St NW

Year
Property Taxes
Change
Tax Assessment
Change
2026
$4,696
7%
$447,000
-1%
2025
$4,390
6%
$451,900
8%
2024
$4,125
2%
$420,000
—
2023
$4,049
4%
$420,200
—
2022
$3,891
5%
$421,900
16%
2021
$3,690
-2%
$363,500
100%
2020
$3,756
2%
-100%
2021
$3,690
7%
$338,300
19%
2018
$3,435
13%
$284,855
14%
2017
$3,039
-5%
$250,847
—
2016
$3,202
4%
$250,193
2%
2015
$3,080
5%
$244,416
20%
2014
$2,933
—
$204,413
—
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 15740 Yellow Pine St NW

$
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

Down Payment Resource

Listed by Premier Real Estate Services

Similar Properties near 15740 Yellow Pine St NW

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

2155 128th Ave NW, Coon Rapids, MN 55448 - Photo 1
$470,000

2155 128th Ave NW  Coon Rapids, MN 55448

  • Single Family
  • Active
  • Updated 7 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,892
    Sq. Ft.
Listed by Keller Williams Classic Realty
940 Douglas Ct, Anoka, MN 55303 - Photo 1
$480,000

940 Douglas Ct  Anoka, MN 55303

  • Single Family
  • Active
  • 4
    Beds
  • 3
    Total Baths
  • 2,295
    Sq. Ft.
Listed by DMR Realty INC
2960 Rice Creek Pkwy NE, Blaine, MN 55449 - Photo 1 Just Listed
$485,000

2960 Rice Creek Pkwy NE  Blaine, MN 55449

  • Single Family
  • Active
  • Updated 21 hours ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,571
    Sq. Ft.
Listed by Tom & Kari Drompp (651) 336-5518 and Kari & Tom Drompp (651) 336-5532
983 114th Ave NE, Blaine, MN 55434 - Photo 1 Price Reduced
-$13,900 (-2.78%)
$486,000

983 114th Ave NE  Blaine, MN 55434

  • Single Family
  • Active
  • Updated 1 day ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,257
    Sq. Ft.
Listed by RE/MAX Results

Just Listed near 15740 Yellow Pine St NW

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

4407 Crosstown Blvd NE, Ham Lake, MN 55304 - Photo 1 Just Listed
$399,900

4407 Crosstown Blvd NE  Ham Lake, MN 55304

  • Single Family
  • Active
  • Updated 1 day ago
  • 2
    Beds
  • 1
    Total Bath
  • 1,431
    Sq. Ft.
Listed by Keller Williams Classic Realty
1330 157th Ave NE, Ham Lake, MN 55304 - Photo 1 Just Listed
$599,900

1330 157th Ave NE  Ham Lake, MN 55304

  • Single Family
  • Active
  • Updated 21 hours ago
  • 5
    Beds
  • 4
    Total Baths
  • 3,368
    Sq. Ft.
Listed by Counselor Realty, Inc.
13733 Terrace Rd NE, Ham Lake, MN 55304 - Photo 1 Just Listed
$949,900

13733 Terrace Rd NE  Ham Lake, MN 55304

  • Single Family
  • Active
  • Updated 2 days ago
  • 5
    Beds
  • 5
    Total Baths
  • 4,704
    Sq. Ft.
Listed by Home Avenue Flat Fee Realty
14954 Durant St NE, Ham Lake, MN 55304 - Photo 1 Just Listed
$575,000

14954 Durant St NE  Ham Lake, MN 55304

  • Single Family
  • Active
  • Updated 2 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,442
    Sq. Ft.
Listed by Keller Williams Realty Integrity Lakes

Price Reduced near 15740 Yellow Pine St NW

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

14731 Naples St NE, Ham Lake, MN 55304 - Photo 1 Price Reduced
-$15,000 (-2.22%)
$660,000
Open House

14731 Naples St NE  Ham Lake, MN 55304

  • Single Family
  • Active
  • Updated 3 days ago
  • 5
    Beds
  • 3
    Total Baths
  • 3,812
    Sq. Ft.
Listed by RE/MAX Results
17356 Hiawatha Beach Dr NE, Ham Lake, MN 55304 - Photo 1 Price Reduced
-$11,000 (-2.16%)
$499,000

17356 Hiawatha Beach Dr NE  Ham Lake, MN 55304

  • Single Family
  • Active
  • Updated 4 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,595
    Sq. Ft.
Listed by Counselor Realty, Inc.
1939 168th Ave NE, Ham Lake, MN 55304 - Photo 1 Price Reduced
-$10,000 (-2.38%)
$410,000

1939 168th Ave NE  Ham Lake, MN 55304

  • Single Family
  • Active
  • Updated 16 hours ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,486
    Sq. Ft.
Listed by Realty ONE Group Choice
3035 165th Ln NE, Ham Lake, MN 55304 - Photo 1 Price Reduced
-$10,000 (-2.74%)
$355,000
Open House

3035 165th Ln NE  Ham Lake, MN 55304

  • Single Family
  • Active
  • Updated 4 days ago
  • 4
    Beds
  • 2
    Total Baths
  • 1,804
    Sq. Ft.
Listed by RE/MAX Results

Recent Sales near 15740 Yellow Pine St NW

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

1261 156th Ln NW, Andover, MN 55304 - Photo 1 Sold
$490,000

1261 156th Ln NW  Andover, MN 55304

  • Single Family
  • Closed
  • 5
    Beds
  • 4
    Total Baths
  • 3,098
    Sq. Ft.
Listed by Edina Realty, Inc.
Sold by eXp Realty
1249 156th Ln NW, Andover, MN 55304 - Photo 1 Sold
$549,000

1249 156th Ln NW  Andover, MN 55304

  • Single Family
  • Closed
  • 4
    Beds
  • 4
    Total Baths
  • 3,182
    Sq. Ft.
Listed and Sold by LPT Realty, LLC
1294 153rd Ln NW, Andover, MN 55304 - Photo 1 Sold
$505,000

1294 153rd Ln NW  Andover, MN 55304

  • Single Family
  • Closed
  • 4
    Beds
  • 4
    Total Baths
  • 2,995
    Sq. Ft.
Listed by North Coast Realty
Sold by eXp Realty
15989 Xeon Street NW, Andover, MN 55304 - Photo 1 Sold
$490,000

15989 Xeon Street NW  Andover, MN 55304

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 2,332
    Sq. Ft.
Listed by Edina Realty, Inc.
Sold by Keller Williams Classic Rlty NW

15740 Yellow Pine Street NW, Andover, MN 55304 (MLS# 7146509) is a Single Family property with 4 bedrooms, 1 full bathroom and 2 partial bathrooms. 15740 Yellow Pine Street NW is currently listed for $479,900 and was received on September 22, 2026. Want to learn more about 15740 Yellow Pine Street NW? Do you have questions about finding other Single Family real estate for sale in Andover? You can browse all Andover real estate or contact a Coldwell Banker agent to request more information.

Tour this property