x
Showing 1 of 0
X
Save

150 Front Street 225
Prescott WI 54021 US

$475,000

Active Under Contract Listing ID 6447334
bed icon
2 bed
bath icon
2.00 Bath (2 Full Bath)
home icon
Condominium

$475,000

Active Under Contract Listing ID 6447334
Save

150 Front Street 225 Enjoy spectacular river views from this 2nd floor condo at the confluence of the Mississippi and St. Croix Rivers! This completely updated condo is sure to please. From the expansive covered porch you’ll see over a hundred different towboats with their string of barges, and even more pleasure and cruise boats of all varieties as they leisurely pass by. See supplement for full list of upgrades. Building amenities include a fitness center, billiards room, guest suite, party room and media center.

Collapse all

Property Features

  • Facts
  • Property Type: Residential
  • Property Sub-type: Condominium
  • Features
  • Full Bathrooms: 2
  • Exterior Finish: Brick/Stone, Cement Board
  • Roof Type: Asphalt, Shingle
  • Heating Fuels: Forced Air
  • Additional Features
  • Waterfront

Property

  • propertytype: Residential
  • propertysubtype: Condominium
  • listprice: 475000
  • unparsedaddress: 150 Front Street
  • unitnumber: 225
  • postalcity: Prescott
  • stateorprovince: WI
  • country: US
  • postalcode: 54021
  • bathroomsfull: 2
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0
  • lotsizeunits: Acres
  • livingarea: 1635
  • livingareaunits: Square Feet
  • latitude: 44.74677515
  • longitude: -92.80045688
  • listagentfullname: John D. Becker
  • listagentemail: buddy@buddybecker.net
  • listagentkey: 3yd-RMLSMN-880502323
  • listagentmlsid: 880502323
  • listagentpreferredphone: 6513436063
  • listagentofficephone: 9528985760
  • listofficekey: 3yd-RMLSMN-12127
  • listofficemlsid: 12127
  • disclaimer: Copyright © 2024 Regional Multiple Listing Service of Minnesota [NorthStarMLS]. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: RMLSMN
  • yearbuilt: 2004
  • listingcontractdate: 2023-10-12
  • listagenturl: http://www.resrealtygroup.com
  • countyorparish: Pierce-WI
  • parcelnumber: 271011193721
  • appliances: Dishwasher, Dryer, Microwave, Range, Refrigerator, Washer
  • heating: Forced Air
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 0
  • parkingfeatures: Assigned, Driveway, Garage, Garage - Attached, Heated, Secured, Underground/Basement
  • roof: Asphalt, Shingle
  • waterfrontyn: True
  • exteriorfeatures: Brick/Stone, Cement Board
  • waterfrontfeatures: Waterfront
  • architecturalstyle: High Rise
  • rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -92.800457, 44.746775
  • customfields: {"AlternatePrices":[], "Neighborhoods":[], "Taxes":[], "ListPriceCurrencyType":"USD", "ListingURL":"https://listings.listhub.net/pages/RMLSMN/6447334/?channel=rexren", "LeadRoutingEmail":"buddy@buddybecker.net", "BrokerName":"RES Realty", "ListingTitle":"(CC) High Rise (4+ Levels) - Prescott, WI", "ListOfficeBrokerMlsId":null, "ListOfficeEmail":"joe@joelehrer.com", "ListOfficeAddress1":"12280 Nicollet Avenue Ste. 103", "ListOfficeAddress2":null, "ListOfficeCity":"Burnsville", "ListOfficePostalCode":"55337", "ListOfficeStateOrProvince":"MN", "ListOfficeCountry":"US", "BuilderPhone":null, "BuilderFax":null, "BuilderEmail":null, "UnparsedAddress":null, "UnitNumber":null, "City":null, "StateOrProvince":null, "PostalCode":null, "Country":null, "ListBrokerageName":"RES Realty", "ListBrokeragePhone":"(952) 898-5760", "ListBrokerageEmail":"joe@joelehrer.com", "ListBrokerageWebsiteUrl":"http://www.resrealtygroup.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/RMLSMN/ff808081134e4e5701134f52280a005f/20110907133556568.png", "ListBrokerageUnparsedAddress":"12280 Nicollet Avenue Ste. 103", "ListBrokerageUnitNumber":null, "ListBrokerageCity":"Burnsville", "ListBrokerageStateOrProvince":"MN", "ListBrokeragePostalCode":"55337", "ListBrokerageCountry":"US", "RoomCount":7, "GeocodeOptions":null, "MLSModificationTimestamp":"2024-02-26T21:12:10Z", "Expenses":[{"ExpenseCategory":"Home Owner Assessments Fee", "ExpenseValue":371, "ExpenseFrequency":"Monthly"}]}
Listing Changed: 4/2/2024 6:42:57 AM GMT
Source Updated Date: 4/28/2024 6:53:11 AM GMT

Courtesy of: John D. Becker, RES Realty, buddy@buddybecker.net

Copyright © 2024 Regional Multiple Listing Service of Minnesota [NorthStarMLS]. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

}