Bay Lake Realty
Bruce Johnson
Broker/Owner
Bay Lake Realty is Licensed in the State of Minnesota
15929 Wakeman Rd.
Deerwood, MN 56444
Cell Phone: 218-838-1111
E-mail: bruce@baylakerealty.com

MLS# 6817770 - 787 154th Street Hammond, WI 54023

Neighborhoods

eXp Realty is the brokerage office representing the seller for this listing.

Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.

The data relating to real estate for sale on this 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 are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Bay Lake Realty is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Bay Lake Realty, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.

{"Id":1432178,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6817770","MLSAGENTID":"NST506012249","MLSCOAGENTID":"NST506017567","MLSOFFICEID":"NST25792","ADDRESS":"787 154th Street","ACRES":2.0,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Drain Tiled,Egress Window(s),Full,Walkout","BATHSTOTAL":3.0,"BEDROOMS":3,"CITY":"Hammond","CONTINGENCY":"None","COUNTY":"St. Croix","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":549900.0,"LASTPRICEDATE":"2025-11-14T22:34:04.443","LATITUDE":44.976305,"LENDEROWNED":"No","LISTDATE":"2025-11-14T06:00:00","LISTPRICE":549900.0,"LIVINGAREA":1850.0,"LONGITUDE":-92.48875,"LOTDESCRIPTION":"Corner Lot","MODIFICATIONTIMESTAMP":"2025-11-15T11:23:07.143","OFFICE_OFFICENAME":"eXp Realty","OUTBUILDINGS":"Pole Building","PHOTOCOUNT":3,"POSTALCODE":"54023","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Beautiful large rambler on 2 acres with incredible extras.\nThis property features a versatile 36 x 48 pole building with concrete floors, 12 ft side walls, a 10 x 16 ft overhead door, rough-in for a bathroom, bar area, rough-in for in-floor heat, and full utilities including sewer, water, and newly added natural gas to both the pole shed and the home.\n\nInside the home, enjoy newly refinished Appalachian Eastern Red Oak hardwood floors in the kitchen and dining area. Recent updates include a new dishwasher, new water heater, and new roof. The lower level is framed for an office, bedroom, family room, and a rough-in bath. Sheetrock is included and will stay for the next owner to finish as desired.\n\nThe property offers beautiful mature pines that create natural privacy, along with fiber optic internet options from 3 providers.\nFantastic location with room to spread out and endless potential. Do not miss this one.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt","SCHOOLDISTRICTNUMBER":"2422-Saint Croix Central","SCHOOLDISTRICTPHONE":"715-796-2256","SEWER":"Private Sewer","STATEORPROVINCE":"WI","STATUS":"Active","STATUSDATE":"2025-11-14T22:34:04.443","LASTSTATUS":"Active","STREETNAME":"154th","STREETNUMBER":"787","STREETSUFFIX":"Street","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"Well","WATERFRONTPRESENT":false,"YEARBUILT":2005,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-11-14T22:35:04.849","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Photos Coming 11/17\"}]","PHOTOORDER":"1,2,3","SOURCE":"MG_NST"}
{"ListingKey":"NST7827370","LotSizeArea":"2","NST_AgeOfProperty":"20","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Hardwood Floors,Kitchen Window,Natural Woodwork,Washer/Dryer Hookup","Appliances":"Dishwasher,Microwave,Range,Refrigerator","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","NST_AttributionContact":"651-336-4835","NST_AttributionName":"Jesse Penman","Basement":"Daylight/Lookout Windows,Drain Tiled,Egress Window(s),Full,Walkout","BasementYN":"True","NST_BathDesc":"Basement,Full Primary,Main Floor 1/2 Bath,Main Floor Full Bath,Rough In","BathroomsOneQuarter":"0","BathroomsFull":"2","BathroomsHalf":"1","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"3","BedroomsTotal":"3","City":"Hammond","PropertyType":"Residential","NST_ConstructionMaterialsDesc":"Concrete","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"St. Croix","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","NST_DiningRoomDescription":"Kitchen/Dining Room","Directions":"Take I-94 east to Exit 10. Follow Highway 65 north to County Road TT, then go east to Emerald Acres.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Brick/Stone,Vinyl Siding","FireplaceFeatures":"Living Room","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","FoundationArea":"1850","NST_FractionalOwnershipYN":"No","RoadFrontageType":"Township","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage","NST_GarageSquareFeet":"3","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-11-14T22:28:33Z","NST_InternetOptions":"Fiber Optic","LandLeaseYN":"False","NST_LastUpdateDate":"2025-11-15","Latitude":"44.976305","NST_LenderOwned":"No","ListAgentKey":"NST103183","ListAgentMlsId":"NST506012249","CoListAgentKey":"NST227714","CoListAgentMlsId":"NST506017567","ListingContractDate":"2025-11-14T06:00:00Z","ListOfficeKey":"NST25792","ListOfficeName":"eXp Realty","ListOfficeMlsId":"NST25792","ListPrice":"549900","LivingArea":"1850","Longitude":"-92.48875","LotFeatures":"Corner Lot","LotSizeDimensions":"401x217x401x217","LotSizeSquareFeet":"87120","LotSizeUnits":"Acres","ListingId":"NST6817770","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","OtherStructures":"Pole Building","ParcelNumber":"018201153000","GarageSpaces":"3","NST_PatioPorchType":"Porch","PhotosCount":"3","PostalCity":"Roberts","PostalCode":"54023","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Beautiful large rambler on 2 acres with incredible extras.\nThis property features a versatile 36 x 48 pole building with concrete floors, 12 ft side walls, a 10 x 16 ft overhead door, rough-in for a bathroom, bar area, rough-in for in-floor heat, and full utilities including sewer, water, and newly added natural gas to both the pole shed and the home.\n\nInside the home, enjoy newly refinished Appalachian Eastern Red Oak hardwood floors in the kitchen and dining area. Recent updates include a new dishwasher, new water heater, and new roof. The lower level is framed for an office, bedroom, family room, and a rough-in bath. Sheetrock is included and will stay for the next owner to finish as desired.\n\nThe property offers beautiful mature pines that create natural privacy, along with fiber optic internet options from 3 providers.\nFantastic location with room to spread out and endless potential. Do not miss this one.","PublicSurveyRange":"17W","PublicSurveySection":"30","PublicSurveyTownship":"29N","NST_RentalLicenseYN":"No","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less,Asphalt","RoomType":"Living Room,Kitchen,Dining Room,Bedroom 1,Bedroom 2,Bedroom 3,Other Room","NST_AboveGradeSqFtTotal":"1850.0000","NST_BelowGradeSqFtTotal":"1850.0000","NST_MainLevelFinishedArea":"1850.0000","BuildingAreaTotal":"3700","HighSchoolDistrict":"Saint Croix Central","NST_SchoolDistrictNumber":"2422","NST_SchoolDistrictPhone":"715-796-2256","Sewer":"Private Sewer","NST_SpecialSearch":"3 BR on One Level,All Living Facilities on One Level,Main Floor Laundry","AboveGradeFinishedArea":"1850","BelowGradeFinishedArea":"0","StateOrProvince":"WI","StandardStatus":"Active","Levels":"One","StreetName":"154th","StreetNumber":"787","StreetNumberNumeric":"787","StreetSuffix":"Street","PropertySubType":"Single Family Residence","SubdivisionName":"Emerald Acres Add 01","NST_TaxWithAssessments":"5210.0000","TaxYear":"2025","TaxAnnualAmount":"5210","WaterSource":"Well","YearBuilt":"2005","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-11-15T11:23:07.143Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7827370\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Photos Coming 11/17\",\"ImageWidth\":1200,\"ImageHeight\":900,\"ImageSizeDescription\":\"1200x900\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7827370/cd68a685-8f6b-48b9-b137-e96bc38f8643.png\",\"MediaModificationTimestamp\":\"2025-11-14T22:34:14.718Z\",\"MediaKey\":\"6917ae6655b3fc34ef4632ce\"},{\"ResourceRecordKey\":\"NST7827370\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":1200,\"ImageHeight\":900,\"ImageSizeDescription\":\"1200x900\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7827370/81f0e449-176a-4217-beea-743c5afb0279.png\",\"MediaModificationTimestamp\":\"2025-11-14T22:34:14.639Z\",\"MediaKey\":\"6917ae6655b3fc34ef4632cf\"},{\"ResourceRecordKey\":\"NST7827370\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":1200,\"ImageHeight\":900,\"ImageSizeDescription\":\"1200x900\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7827370/70b836f0-b627-4709-bd6c-bf85b06d1c06.png\",\"MediaModificationTimestamp\":\"2025-11-14T22:34:14.663Z\",\"MediaKey\":\"6917ae6655b3fc34ef4632d0\"}]","PhotosChangeTimestamp":"2025-11-14T22:35:04.849Z","Rooms":"[{\"RoomKey\":\"NST115776480\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"17x14\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115776481\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x11\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115776482\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x11\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115776483\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x15\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115776484\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x12\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115776485\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x12\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115778791\",\"RoomType\":\"Other Room\",\"RoomDimensions\":\"36x48\",\"NST_RoomSortOrder\":\"7\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Photos Coming 11/17\"}]","PhotoOrder":"1,2,3","CustomVTourURL":""}