{"Id":1418765,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6801046","MLSAGENTID":"NST506008655","MLSOFFICEID":"NST26141","ADDRESS":"W11011 470th Avenue","ACRES":3.443,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Drain Tiled,Egress Window(s),Full,Sump Pump,Unfinished","BATHSTOTAL":3.0,"BEDROOMS":5,"CITY":"Prescott","CONTINGENCY":"None","COUNTY":"Pierce","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LAKEWATERFRONT":"Association Access","LASTPRICE":625000.0,"LASTPRICEDATE":"2025-12-08T22:55:06.47","LATITUDE":44.710133,"LENDEROWNED":"No","LISTDATE":"2025-10-08T05:00:00","LISTPRICE":599000.0,"LIVINGAREA":3072.0,"LONGITUDE":-92.68586,"LOTDESCRIPTION":"Corner Lot,Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2025-12-08T22:55:06.471","OFFICE_OFFICENAME":"Brick & Banister Real Estate","PHOTOCOUNT":1,"POSTALCODE":"54021","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Spacious, Sunny, and Stylishly Remodeled Rambler in a Peaceful Rural Setting Welcome to this beautifully updated rambler offering the best of both worlds—quiet country living with unbeatable convenience. The sun-drenched main level features a fantastic floorplan with a private owner’s wing, plus two additional main-floor bedrooms perfect for family, guests, or a dedicated office space. Recent upgrades make this home move-in ready and worry-free: new roof (2023), A/C within the last 5 years, freshly refinished hardwood floors, a fully remodeled primary suite, and exterior paint that gives instant curb appeal. The fully finished lower level is ideal for entertaining or hosting overnight guests, with room to spread out and relax. Step outside to a large fenced backyard—great for pets, play, or peaceful evenings under the stars. Located in a highly rated school district and just minutes from Prescott’s charming downtown, scenic riverfront, and endless outdoor recreation opportunities—this home checks all the boxes. Modern updates, room to roam, and a location that gives you access to everything you need. Don’t miss your chance to make this one yours!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"1738-Prescott","SCHOOLDISTRICTPHONE":"7152625782","SEWER":"Private Sewer","STATEORPROVINCE":"WI","STATUS":"Active","STATUSDATE":"2025-10-08T11:11:03.883","LASTSTATUS":"Active","STREETNAME":"470th","STREETNUMBER":"W11011","STREETSUFFIX":"Avenue","TRANSACTIONTYPE":"For Sale","WATER":"Shared System,Well","WATERFRONTPRESENT":false,"WATERFRONTVIEW":"Association Access","YEARBUILT":2004,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-12-08T22:40:06.199","PHOTOORDER":"1","SOURCE":"MG_NST"}
{"ListingKey":"NST7812928","Appliances":"Dishwasher,Dryer,Microwave,Range,Refrigerator,Washer,Water Softener Rented","AssociationYN":"True","AssociationFee":"315","AssociationName":"Trumpeter Valley","Basement":"Drain Tiled,Egress Window(s),Full,Sump Pump,Unfinished","City":"Prescott","Contingency":"None","Directions":"35 South (6 min So of Prescott) to 1100th St, So to 470th Ave, E. to home on Corner.","FireplaceYN":"True","NST_Fuel":"Propane","Latitude":"44.710133","ListPrice":"599000","LivingArea":"3072","Longitude":"-92.68586","LotSizeDimensions":"irregular","LotSizeUnits":"Acres","ParcelNumber":"020010740404","PostalCity":"Prescott","PostalCode":"54021","PublicRemarks":"Spacious, Sunny, and Stylishly Remodeled Rambler in a Peaceful Rural Setting Welcome to this beautifully updated rambler offering the best of both worlds—quiet country living with unbeatable convenience. The sun-drenched main level features a fantastic floorplan with a private owner’s wing, plus two additional main-floor bedrooms perfect for family, guests, or a dedicated office space. Recent upgrades make this home move-in ready and worry-free: new roof (2023), A/C within the last 5 years, freshly refinished hardwood floors, a fully remodeled primary suite, and exterior paint that gives instant curb appeal. The fully finished lower level is ideal for entertaining or hosting overnight guests, with room to spread out and relax. Step outside to a large fenced backyard—great for pets, play, or peaceful evenings under the stars. Located in a highly rated school district and just minutes from Prescott’s charming downtown, scenic riverfront, and endless outdoor recreation opportunities—this home checks all the boxes. Modern updates, room to roam, and a location that gives you access to everything you need. Don’t miss your chance to make this one yours!","NST_RoadBetweenWaterfrontAndHomeYN":"Y","Roof":"Age 8 Years or Less,Asphalt,Pitched","NST_SchoolDistrictPhone":"7152625782","Sewer":"Private Sewer","StateOrProvince":"WI","StreetName":"470th","StreetNumber":"W11011","StreetNumberNumeric":"11011","StreetSuffix":"Avenue","TaxYear":"2025","YearBuilt":"2004","NST_AboveGradeSqFtTotal":"1764","AboveGradeFinishedArea":"1764","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Ceiling Fan(s),Deck,Hardwood Floors,Kitchen Window,Natural Woodwork,In-Ground Sprinkler,Tile Floors,Washer/Dryer Hookup,Walk-In Closet","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Yes","AssociationFeeFrequency":"Annually","AssociationFeeIncludes":"Other","AssociationPhone":"6512105970","BasementYN":"True","NST_BathDesc":"Private Primary,Main Floor Full Bath,Rough In,Separate Tub & Shower","BathroomsFull":"3","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"3","BedroomsTotal":"5","NST_BelowGradeSqFtTotal":"1308","BelowGradeFinishedArea":"1308","CumulativeDaysOnMarket":"70","NewConstructionYN":"False","Cooling":"Central Air","CountyOrParish":"Pierce","CultivatedArea":"0","NST_DPResource":"Yes","NST_DiningRoomDescription":"Breakfast Area,Eat In Kitchen,Informal Dining Room,Kitchen/Dining Room,Living/Dining Room,Separate/Formal Dining Room","DaysOnMarket":"0","Fencing":"None","FireplaceFeatures":"Gas,Living Room","FireplacesTotal":"1","FoundationArea":"1911","NST_FractionalOwnershipYN":"No","NST_GarageSquareFeet":"512","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Prescott","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","NST_LenderOwned":"No","Levels":"One","ListingContractDate":"2025-10-08T05:00:00Z","ListingId":"NST6801046","LotFeatures":"Corner Lot,Tree Coverage - Light","LotSizeArea":"3.443","NST_MainLevelFinishedArea":"1764","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2025-10-08T06:07:30Z","NST_SchoolDistrictNumber":"1738","ParkingFeatures":"Attached Garage,Gravel,Garage Door Opener,Insulated Garage","PastureArea":"0","PhotosCount":"1","PhotosChangeTimestamp":"2025-12-08T22:40:06.199Z","PoolFeatures":"None","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertyType":"Residential","RoadFrontageType":"Paved Streets,Private Road,Township","NST_SpecialSearch":"3 BR on One Level,Main Floor Laundry","StandardStatus":"Active","SubdivisionName":"Trumpeter Valley","TaxAnnualAmount":"6421","NST_TaxWithAssessments":"6426","Township":"Prescott","WaterSource":"Shared System,Well","WaterfrontFeatures":"Association Access","WoodedArea":"0","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST97737","ListAgentMlsId":"NST506008655","ListOfficeMlsId":"NST26141","ListOfficeName":"Brick & Banister Real Estate","ListOfficeKey":"NST26141","ModificationTimestamp":"2025-12-08T22:55:06.471Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7812928\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7812928/ff2fcf12-78d4-491d-885b-f0fa72f9639c.jpeg\",\"MediaModificationTimestamp\":\"2025-11-20T17:25:33.104Z\",\"MediaKey\":\"691f4f0d7e004c67d1644743\"}]","Rooms":"[{\"RoomDimensions\":\"12x11\",\"RoomKey\":\"NST115682965\",\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":6,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"12x11\",\"RoomKey\":\"NST115682964\",\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"12x14\",\"RoomKey\":\"NST115682967\",\"RoomType\":\"Bedroom 4\",\"NST_RoomSortOrder\":8,\"RoomLevel\":\"Lower\"},{\"RoomDimensions\":\"10x10\",\"RoomKey\":\"NST115682966\",\"RoomType\":\"Informal Dining Room\",\"NST_RoomSortOrder\":7,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"13x11\",\"RoomKey\":\"NST115682961\",\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"18x16\",\"RoomKey\":\"NST115682960\",\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"16x13\",\"RoomKey\":\"NST115682963\",\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"10x10\",\"RoomKey\":\"NST115682962\",\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"11x12\",\"RoomKey\":\"NST115682969\",\"RoomType\":\"Office\",\"NST_RoomSortOrder\":10,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"11x15\",\"RoomKey\":\"NST115682968\",\"RoomType\":\"Bedroom 5\",\"NST_RoomSortOrder\":9,\"RoomLevel\":\"Lower\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1","CustomVTourURL":""}