Error at 2023-11-29 09:27:24:

Query: SELECT l.StreetAddress, l.City, l.StateOrProvince, l.PostalCode, l.ListPrice, l.MLSNumber, l.PhotoCount, l.Style, l.PropertySubType, l.FarmPropertyType, l.PropertyType, l.YearBuilt, l.ApxFinAboveGrade, l.ApxFinBelowGrade, l.BathsFull, l.BathsHalf, l.BedsTotal, l.GarageCapacity, l.LotSizeArea, l.GarageType, l.Status, l.ListAgentFullName, l.ListOfficeName, l.VirtualTourURLUnbranded, oh.StartTime as OpenHouseStartTime, oh.EndTime as OpenHouseEndTime, COALESCE(g.lat, 0) AS lat, COALESCE(g.lng, 0) AS lng FROM mls_ranww_listings as l LEFT JOIN mls_ranww_open_houses as oh ON l.Matrix_Unique_ID = oh.Listing_MUI AND oh.StartTime = (SELECT oh.StartTime from mls_ranww_open_houses oh WHERE l.Matrix_Unique_ID = oh.Listing_MUI AND oh.EndTime > "2023-11-29 09:27" ORDER BY oh.StartTime ASC LIMIT 1) AND oh.EndTime = (SELECT oh.EndTime from mls_ranww_open_houses oh WHERE l.Matrix_Unique_ID = oh.Listing_MUI AND oh.EndTime > "2023-11-29 09:27" ORDER BY oh.StartTime ASC LIMIT 1) LEFT JOIN mls_ranww_geolocation as g ON l.MLSNumber = g.mls WHERE MLSNumber != "" AND (CountyOrParish = "Barron" OR CountyOrParish = "Chippewa" OR CountyOrParish = "Rusk" ) AND (WaterfrontYN = Y ) ORDER BY l.ListPrice ASC, l.MLSNumber DESC
Error: Unknown column 'Y' in 'where clause'

Wisconsin Real Estate Property Search

Waterfront Properties for Sale

  to  

No Results Found

It looks like there aren't currently any properties that match your search parameters.

Try modifying your search to find more properties.

Start a New Search

Data relating to real estate for sale on this website comes in part from the IDX program of the NW WI MLS. Information provided by NW WI MLS is compiled from third-party sources. The information is deemed reliable, but cannot be guaranteed. Neither NW WI MLS, the listing broker, or its agents or subagents are responsible for its accuracy.

DISCLAIMER: This information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. This data is updated on a regular basis. However, some properties which appear for sale on this site may subsequently have been sold and may no longer be available. This data is current as of November 29th, 2023 at 9:25 AM.