477 Sycamore Street Prescott, WI 54021

$379,900
Active
estimated monthly payment
1,750 Sq Ft  |  Duplex Up and Down  |  MLS # 6719122
  • 1747143157445_1747095230893ef9a0273.jpg
    1747143157445_1747095230893ef9a0273.jpg
  • 1747143156321_1747095186922ef9a0267.jpg
    1747143156321_1747095186922ef9a0267.jpg
  • 1747143155762_1747095164266ef9a0264.jpg
    1747143155762_1747095164266ef9a0264.jpg
  • 1747143142633_1747094798210ef9a0192.jpg
    1747143142633_1747094798210ef9a0192.jpg
  • 1747143156935_1747095207506ef9a0270.jpg
    1747143156935_1747095207506ef9a0270.jpg
  • 1747143158010_1747095254253ef9a0276.jpg
    1747143158010_1747095254253ef9a0276.jpg
  • 1747143148943_1747094963146ef9a0225.jpg
    1747143148943_1747094963146ef9a0225.jpg
  • 1747143158578_1747095276397ef9a0279.jpg
    1747143158578_1747095276397ef9a0279.jpg
  • 1747143143412_1747094822763ef9a0196.jpg
    1747143143412_1747094822763ef9a0196.jpg
  • 1747143144126_1747094838560ef9a0199.jpg
    1747143144126_1747094838560ef9a0199.jpg
  • 1747143144811_1747094856811ef9a0202.jpg
    1747143144811_1747094856811ef9a0202.jpg
  • 1747143145370_1747094872762ef9a0205.jpg
    1747143145370_1747094872762ef9a0205.jpg
  • 1747143146251_1747094888423ef9a0208.jpg
    1747143146251_1747094888423ef9a0208.jpg
  • 1747143146777_1747094903826ef9a0211.jpg
    1747143146777_1747094903826ef9a0211.jpg
  • 1747143147454_1747094920106ef9a0214.jpg
    1747143147454_1747094920106ef9a0214.jpg
  • 1747143147957_1747094935632ef9a0217.jpg
    1747143147957_1747094935632ef9a0217.jpg
  • 1747143148457_1747094951338ef9a0223.jpg
    1747143148457_1747094951338ef9a0223.jpg
  • 1747143149450_1747094986215ef9a0229.jpg
    1747143149450_1747094986215ef9a0229.jpg
  • 1747143149977_1747095003185ef9a0232.jpg
    1747143149977_1747095003185ef9a0232.jpg
  • 1747143150669_1747095018805ef9a0235.jpg
    1747143150669_1747095018805ef9a0235.jpg
  • 1747143154067_1747095119017ef9a0256.jpg
    1747143154067_1747095119017ef9a0256.jpg
  • 1747143155111_1747095154225ef9a0262.jpg
    1747143155111_1747095154225ef9a0262.jpg
  • 1747143151172_1747095035255ef9a0238.jpg
    1747143151172_1747095035255ef9a0238.jpg
  • 1747143152391_1747095070050ef9a0244.jpg
    1747143152391_1747095070050ef9a0244.jpg
  • 1747143153075_1747095085881ef9a0247.jpg
    1747143153075_1747095085881ef9a0247.jpg
  • 1747143154585_1747095136752ef9a0259.jpg
    1747143154585_1747095136752ef9a0259.jpg
  • 1747143151845_1747095051795ef9a0241.jpg
    1747143151845_1747095051795ef9a0241.jpg
  • 1747143153562_1747095102308ef9a0250.jpg
    1747143153562_1747095102308ef9a0250.jpg

About The Listing

Rare Prescott Investment Opportunity in this 2 bedroom per level Duplex. Live in one unit and rent out the other or rent out both. Situated on a corner lot with detached 2 car garage, deck with pergola, patio area and numerous updates. Each unit has washer/dryer, range, microwave and dishwasher. Anderson windows new on upper level within 8-9 years and lower level within a year. Electric baseboard heat and Mini Split with hyper heat and A/C. Each unit is separately metered for electric and their own hot water heaters. So much potential in this home.


Listing courtesy of Wendy L. McIntyre, Wissota Real Estate, Inc.
Purchase Price
Loan Type
Down Payment
Interest Rate
Estimated Property Taxes
Homeowner's Insurance
HOA Dues
Private Mortgage Insurance
Ask a Question
Your message has been sent.
Oops! that doesn't seem right.
SEND
Sign Up for a Free Monthly Market Report
Never miss out on the latest stats trends and homes in your community.
Get It Now

Property Details

Features

 
 
 
Property Type: Other
Status: Active
Contingency Type: None
Year Built: 1977
MLS #: 6719122
Square Feet: 1,750
Price Per Square Foot: $217
Garage Spaces: 2
Parking Description: Detached, Concrete
Sewer Description: City Sewer/Connected
Water: City Water/Connected
Heat Type: Baseboard, Ductless Mini-Split
Basement: Block, Finished, Full
Construction Description: Vinyl Siding
Roof Description: Age Over 8 Years, Asphalt, Pitched
Days On Market (Continuous): 1
Disability Features: None
Latest Update: 05/14/2025
List Date: 05/13/2025
Listing Agent ID: 505001276
Listing Office: Wissota Real Estate, Inc.
Listing Office ID: 12484
Data Source: NorthstarMLS - The Regional MLS of Minnesota
Fence: None
Lot Dimensions: 111x39x204x174
Lot Size: 0.31 Acres
Lot Features: Corner Lot
School District: Prescott
Tax Year: 2024
Estimated Taxes: $4,276
Contingency Type: None
City: Prescott
Zip: 54021
County: Pierce
State: WI

Similar Homes

Listing last updated: 05/14/25

® Copyright 2025 Regional Multiple Listing Service of Minnesota, Inc. All rights reserved. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the Regional Multiple Listing Service of Minnesota, Inc. Real estate listings held by brokerage firms other than the owner of this website are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo and detailed information about them includes the name of the listing brokers. Digital Millennium Copyright Act (DMCA) Notice The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA"), provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices and counter-notices should be sent in writing by mail to Michael Bisping, Director, Customer Relations, Regional Multiple Listing Service of Minnesota, Inc, 2550 University Avenue West, Suite 259S Saint Paul, MN 55114 or by email to mbisping@northstarmls.com. Questions can be directed by phone to 651-251-3200. The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and e-mail address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint. Information Deemed Reliable but not guaranteed.