SELECT * FROM ((SELECT '' acreage, comAddress address1, comAgent agentName, comArea area, '' bathroom1, '' bathroom2, '' bathroomCount, '' bedroom1, '' bedroom1_floor, '' bedroom1_level, '' bedroom1_size, '' bedroom2, '' bedroom2_floor, '' bedroom2_level, '' bedroom2_size, '' bedroom3, '' bedroom3_floor, '' bedroom3_level, '' bedroom3_size, '' bedroom4, '' bedroom4_floor, '' bedroom4_level, '' bedroom4_size, '' bedroom5, '' bedroomCount, comCity city, isForeclosed comIsForeclosed, isShortSale comIsShortSale, CONCAT("|",comComType,"|",comComType2,"|",comComType3,"|",comComType4,"|") comType, comCounty county, '' diningArea, '' diningArea_floor, '' diningArea_level, '' diningArea_size, '' diningRoom, '' diningRoom_floor, '' diningRoom_level, '' diningRoom_size, '' familyRoom, '' familyRoom_floor, '' familyRoom_level, '' familyRoom_size, '' farmType, '' frmIsForeclosed, '' frmIsShortSale, '' garageSize, '' garageType, comHasWaterfront hasWaterfront, comType houseType, '' includes, '' isCondo, '' isManu, '' kitchen, '' kitchen_floor, '' kitchen_level, '' kitchen_size, '' lakeRiver, STR_TO_DATE(comLastModified,'%m/%d/%Y') lastUpdate, '' laundaryRoom_floor, '' laundaryRoom_level, '' laundaryRoom_size, '' laundryRoom, comListingOffice listingOffice, '' livingRoom, '' livingRoom_floor, '' livingRoom_level, '' livingRoom_size, '' lndIsForeclosed, '' lndIsShortSale, CONCAT(comLot_DimL1,'x',comLot_DimW1) lotSize, comMLSNum mlsNum, '' mulIsForeclosed, '' mulIsShortSale, '' netAddress, '' newConstruction, '' numUnits, '' office, '' office_floor, '' office_level, '' office_size, '' openHouse_date, '' openHouse_time, '' otherRoom, '' otherRoom_floor, '' otherRoom_level, '' otherRoom_size, comListPrice price, '' propertyStyle, comComType propType, '' resIsForeclosed, '' resIsShortSale, comSchoolDist schoolDist, CONCAT('Above: ', comAboveGrade, ' Below: ', comBelowGrade) squareFootage, comState state, '' style, comRemarks summary, comTaxYear taxYear, comVirtualTourURL virtualTour, comLakeName waterfront, comYearBuilt yearBuilt, comTaxAmount yearlyTax, comZip zip, comZoning zoning, 'Commercial' propertyType, 'Eau_Claire' mlsSystem FROM tblListingCommercial WHERE comHasWaterfront LIKE 'Y' ) UNION ALL (SELECT frmTotalAcres acreage, frmAddress address1, frmAgent agentName, frmArea area, '' bathroom1, '' bathroom2, '' bathroomCount, '' bedroom1, '' bedroom1_floor, '' bedroom1_level, '' bedroom1_size, '' bedroom2, '' bedroom2_floor, '' bedroom2_level, '' bedroom2_size, '' bedroom3, '' bedroom3_floor, '' bedroom3_level, '' bedroom3_size, '' bedroom4, '' bedroom4_floor, '' bedroom4_level, '' bedroom4_size, '' bedroom5, '' bedroomCount, frmCity city, '' comIsForeclosed, '' comIsShortSale, '' comType, frmCounty county, '' diningArea, '' diningArea_floor, '' diningArea_level, '' diningArea_size, '' diningRoom, '' diningRoom_floor, '' diningRoom_level, '' diningRoom_size, '' familyRoom, '' familyRoom_floor, '' familyRoom_level, '' familyRoom_size, CONCAT("|",frmFrmType,"|",frmFrmType2,"|",frmFrmType3,"|") farmType, isForeclosed frmIsForeclosed, isShortSale frmIsShortSale, '' garageSize, '' garageType, frmHasWaterfront hasWaterfront, frmType houseType, '' includes, '' isCondo, '' isManu, '' kitchen, '' kitchen_floor, '' kitchen_level, '' kitchen_size, '' lakeRiver, STR_TO_DATE(frmLastModified,'%m/%d/%Y') lastUpdate, '' laundaryRoom_floor, '' laundaryRoom_level, '' laundaryRoom_size, '' laundryRoom, frmListingOffice listingOffice, '' livingRoom, '' livingRoom_floor, '' livingRoom_level, '' livingRoom_size, '' lndIsForeclosed, '' lndIsShortSale, CONCAT(frmLotDim1_L,'x',frmLotDim1_W) lotSize, frmMLSNum mlsNum, '' mulIsForeclosed, '' mulIsShortSale, '' netAddress, '' newConstruction, '' numUnits, '' office, '' office_floor, '' office_level, '' office_size, '' openHouse_date, '' openHouse_time, '' otherRoom, '' otherRoom_floor, '' otherRoom_level, '' otherRoom_size, frmListPrice price, '' propertyStyle, frmFrmType propType, '' resIsForeclosed, '' resIsShortSale, frmSchoolDist schoolDist, CONCAT('Above: ', frmAboveGrade, ' Below: ', frmBelowGrade) squareFootage, frmState state, '' style, frmRemarks summary, frmTaxYear taxYear, frmVirtualTourURL virtualTour, frmLakeName waterfront, frmYearBuilt yearBuilt, frmTaxAmount yearlyTax, frmZip zip, frmZoning zoning, 'Farm' propertyType, 'Eau_Claire' mlsSystem FROM tblListingFarm WHERE frmHasWaterfront LIKE 'Y' ) UNION ALL (SELECT lndAcres acreage, lndAddress address1, lndAgent agentName, lndArea area, '' bathroom1, '' bathroom2, '' bathroomCount, '' bedroom1, '' bedroom1_floor, '' bedroom1_level, '' bedroom1_size, '' bedroom2, '' bedroom2_floor, '' bedroom2_level, '' bedroom2_size, '' bedroom3, '' bedroom3_floor, '' bedroom3_level, '' bedroom3_size, '' bedroom4, '' bedroom4_floor, '' bedroom4_level, '' bedroom4_size, '' bedroom5, '' bedroomCount, lndCity city, '' comIsForeclosed, '' comIsShortSale, '' comType, lndCounty county, '' diningArea, '' diningArea_floor, '' diningArea_level, '' diningArea_size, '' diningRoom, '' diningRoom_floor, '' diningRoom_level, '' diningRoom_size, '' familyRoom, '' familyRoom_floor, '' familyRoom_level, '' familyRoom_size, '' farmType, '' frmIsForeclosed, '' frmIsShortSale, '' garageSize, '' garageType, lndHasWaterfront hasWaterfront, lndType houseType, '' includes, '' isCondo, '' isManu, '' kitchen, '' kitchen_floor, '' kitchen_level, '' kitchen_size, lndLakeName lakeRiver, STR_TO_DATE(lndLastUpdate,'%m/%d/%Y') lastUpdate, '' laundaryRoom_floor, '' laundaryRoom_level, '' laundaryRoom_size, '' laundryRoom, lndListingOffice listingOffice, '' livingRoom, '' livingRoom_floor, '' livingRoom_level, '' livingRoom_size, isForeclosed lndIsForeclosed, isShortSale lndIsShortSale, CONCAT(lndLotDim_L1,'x',lndLotDim_W1) lotSize, lndMLSNum mlsNum, '' mulIsForeclosed, '' mulIsShortSale, '' netAddress, '' newConstruction, '' numUnits, '' office, '' office_floor, '' office_level, '' office_size, '' openHouse_date, '' openHouse_time, '' otherRoom, '' otherRoom_floor, '' otherRoom_level, '' otherRoom_size, lndListPrice price, '' propertyStyle, lndLndType propType, '' resIsForeclosed, '' resIsShortSale, lndSchoolDist schoolDist, CONCAT(lndLotDim_L1,'x',lndLotDim_W1) squareFootage, lndState state, '' style, lndRemarks summary, lndTaxYear taxYear, lndVirtualTourURL virtualTour, lndLakeName waterfront, '' yearBuilt, lndTaxAmount yearlyTax, lndZip zip, '' zoning, 'Land' propertyType, 'Eau_Claire' mlsSystem FROM tblListingLand WHERE lndHasWaterfront LIKE 'Y' ) UNION ALL (SELECT '' acreage, mulAddress address1, mulAgent agentName, mulArea area, '' bathroom1, '' bathroom2, '' bathroomCount, '' bedroom1, '' bedroom1_floor, '' bedroom1_level, '' bedroom1_size, '' bedroom2, '' bedroom2_floor, '' bedroom2_level, '' bedroom2_size, '' bedroom3, '' bedroom3_floor, '' bedroom3_level, '' bedroom3_size, '' bedroom4, '' bedroom4_floor, '' bedroom4_level, '' bedroom4_size, '' bedroom5, '' bedroomCount, mulCity city, '' comIsForeclosed, '' comIsShortSale, '' comType, mulCounty county, '' diningArea, '' diningArea_floor, '' diningArea_level, '' diningArea_size, '' diningRoom, '' diningRoom_floor, '' diningRoom_level, '' diningRoom_size, '' familyRoom, '' familyRoom_floor, '' familyRoom_level, '' familyRoom_size, '' farmType, '' frmIsForeclosed, '' frmIsShortSale, '' garageSize, '' garageType, mulHasWaterfront hasWaterfront, mulType houseType, '' includes, '' isCondo, '' isManu, '' kitchen, '' kitchen_floor, '' kitchen_level, '' kitchen_size, '' lakeRiver, STR_TO_DATE(mulLastUpdate,'%m/%d/%Y') lastUpdate, '' laundaryRoom_floor, '' laundaryRoom_level, '' laundaryRoom_size, '' laundryRoom, mulListingOffice listingOffice, '' livingRoom, '' livingRoom_floor, '' livingRoom_level, '' livingRoom_size, '' lndIsForeclosed, '' lndIsShortSale, CONCAT(mulLotDim_L1,'x',mulLotDim_W1) lotSize, mulMLSNum mlsNum, isForeclosed mulIsForeclosed, isShortSale mulIsShortSale, '' netAddress, '' newConstruction, mulNumUnits numUnits, '' office, '' office_floor, '' office_level, '' office_size, '' openHouse_date, '' openHouse_time, '' otherRoom, '' otherRoom_floor, '' otherRoom_level, '' otherRoom_size, mulListPrice price, '' propertyStyle, mulMulType propType, '' resIsForeclosed, '' resIsShortSale, mulSchoolDist schoolDist, CONCAT(mulBldgDim_L1,'x',mulBldgDim_W1) squareFootage, mulState state, '' style, mulRemarks summary, mulTaxYear taxYear, mulVirtualTourURL virtualTour, mulLakeName waterfront, mulYearBuilt yearBuilt, mulTaxAmount yearlyTax, mulZip zip, '' zoning, 'Multi-Family' propertyType, 'Eau_Claire' mlsSystem FROM tblListingMultiFamily WHERE mulHasWaterfront LIKE 'Y' ) UNION ALL (SELECT resAcres acreage, IF(`netAddressDispY/N` = 'Y',resAddress,'') address1, resAgent agentName, resArea area, CONCAT(resBTH1_DimL,'x',resBTH1_DimW, ' Level: ', resBTH1Level) bathroom1, CONCAT(resBTH2_DimL,'x',resBTH2_DimW, ' Level: ', resBTH2Level) bathroom2, resFullBathQty bathroomCount, CONCAT(resBD1_DimL,'x',resBD1_DimW, ' Level: ', resBD1Level) bedroom1, resBD1Flooring bedroom1_floor, resBD1Level bedroom1_level, CONCAT(resBD1_DimL,' x ',resBD1_DimW) bedroom1_size, CONCAT(resBD2_DimL,'x',resBD2_DimW, ' Level: ', resBD2Level) bedroom2, resBD2Flooring bedroom2_floor, resBD2Level bedroom2_level, CONCAT(resBD2_DimL,' x ',resBD2_DimW) bedroom2_size, CONCAT(resBD3_DimL,'x',resBD3_DimW, ' Level: ', resBD3Level) bedroom3, resBD3Flooring bedroom3_floor, resBD3Level bedroom3_level, CONCAT(resBD3_DimL,' x ',resBD3_DimW) bedroom3_size, CONCAT(resBD4_DimL,'x',resBD4_DimW, ' Level: ', resBD4Level) bedroom4, resBD4Flooring bedroom4_floor, resBD4Level bedroom4_level, CONCAT(resBD4_DimL,' x ',resBD4_DimW) bedroom4_size, '' bedroom5, resBedroomQty bedroomCount, resCity city, '' comIsForeclosed, '' comIsShortSale, '' comType, resCounty county, CONCAT(resDA_DimL,'x',resDA_DimW, ' Level: ', resDALevel) diningArea, resDAFlooring diningArea_floor, resDALevel diningArea_level, CONCAT(resDA_DimL,' x ',resDA_DimW) diningArea_size, CONCAT(resDR_DimL,'x',resDR_DimW, ' Level: ', resDRLevel) diningRoom, resDRFlooring diningRoom_floor, resDRLevel diningRoom_level, CONCAT(resDR_DimL,' x ',resDR_DimW) diningRoom_size, CONCAT(resFR_DimL,'x',resFR_DimW, ' Level: ', resFRLevel) familyRoom, resFRFlooring familyRoom_floor, resFRLevel familyRoom_level, CONCAT(resFR_DimL,' x ',resFR_DimW) familyRoom_size, '' farmType, '' frmIsForeclosed, '' frmIsShortSale, CONCAT(resGarageSize, ' Car ', resGarageType) garageSize, resGarageType garageType, resHasWaterfront hasWaterfront, resType houseType, resIncludes includes, `condoY/N` isCondo, `manufacturedY/N` isManu, CONCAT(resKT_DimL,'x',resKT_DimW, ' Level: ', resKTLevel) kitchen, resKTFlooring kitchen_floor, resKTLevel kitchen_level, CONCAT(resKT_DimL,' x ',resKT_DimW) kitchen_size, resLakeName lakeRiver, STR_TO_DATE(resLastUpdate,'%m/%d/%Y') lastUpdate, resLaundryFlooring laundaryRoom_floor, resLaundryLevel laundaryRoom_level, CONCAT(resLaundry_DimL,' x ',resLaundry_DimW) laundaryRoom_size, CONCAT(resLaundry_DimL,'x',resLaundry_DimW, ' Level: ', resLaundryLevel) laundryRoom, resListingOffice listingOffice, CONCAT(resLR_DimL,'x',resLR_DimW, ' Level: ', resLRLevel) livingRoom, resLRFlooring livingRoom_floor, resLRLevel livingRoom_level, CONCAT(resLR_DimL,' x ',resLR_DimW) livingRoom_size, '' lndIsForeclosed, '' lndIsShortSale, CONCAT(resLotSize_L1,'x',resLotSize_W1) lotSize, resMLSNum mlsNum, '' mulIsForeclosed, '' mulIsShortSale, `netAddressDispY/N` netAddress, resNewConst newConstruction, '' numUnits, CONCAT(resOffice_DimL,'x',resOffice_DimW, ' Level: ', resOfficeLevel) office, resOfficeFlooring office_floor, resOfficeLevel office_level, CONCAT(resOffice_DimL,' x ',resOffice_DimW) office_size, STR_TO_DATE(openHouseDate,'%m/%d/%Y') openHouse_date, openHouseTime openHouse_time, CONCAT(resOther_DimL,'x',resOther_DimW,' Level: ', resOtherLevel) otherRoom, resOtherFlooring otherRoom_floor, resOtherLevel otherRoom_level, CONCAT(resOther_DimL,' x ',resOther_DimW) otherRoom_size, resListPrice price, resstyle propertyStyle, resResType propType, isForeclosed resIsForeclosed, isShortSale resIsShortSale, resSchoolDist schoolDist, CONCAT('Above: ', resAboveGrade, ' Below: ', resBelowGrade) squareFootage, resState state, resStyle style, CONCAT(resRemarks,resRemarks2) summary, resTaxYear taxYear, resVirtualTourURL virtualTour, resLakeName waterfront, resYearBuilt yearBuilt, resTaxAmount yearlyTax, resZip zip, '' zoning, 'Single-Family' propertyType, 'Eau_Claire' mlsSystem FROM (tblListingResidential LEFT JOIN openHouses ON resMLSNum=mlsNum) WHERE resHasWaterfront LIKE 'Y' ) ) MasterList ORDER BY price DESC
Property Search - Water Front
Back to search Sort By:
Narrow Your Search:   Price:             Type:         City:
White Arrow DBL Icon White Arrow Icon Next 5 4 3 2 1 Prev Right White Arrow Icon Right DBL White Arrow Icon Page 1 of 353    Results 1-10 of 3522

A

Wisconsin water front property

is a great way to enjoy nature at its best. View Century 21 of Eau Claires beautiful

water front properties

listed below.

Chippewa Valley Homes
MLS # 832403

Price: 6,500,000.00
Type: Single-Family
Beds: 5
Baths: 2
Garage: 2 Car Attached
361 175th Ave, Turtle Lake, Wisconsin 54889

7,080 Square feet. Five bedroom, 4 bath home on 986 surveyed acres with shop, machine shed, fabulous horse barn, chicken coop and 2 lakes. ...
View Full Information

Chippewa Valley Homes
MLS # 812641

Price: 6,123,600.00
Type: Land
Beds:
Baths:
Garage:
25000 Channey Rd, Augusta, Wisconsin 54722

...
View Full Information

Chippewa Valley Homes
MLS # 830502

Price: 3,249,000.00
Type: Commercial
Beds:
Baths:
Garage:
2738 27 1/2 Ave, Mikana, Wisconsin 54857

One of a kind lakeshore property known as The Gathering Place! With 73+ acres and 950 ft of frontage, the property is currently operated as a high end resort, but could be your family compound, a corporate retreat, meeting center, or continued as a r...
Eau Claire Properties Virtual ToursClick Here for Virtual Tour
View Full Information

Chippewa Valley Homes
MLS # 830495

Price: 3,249,000.00
Type: Single-Family
Beds: 23
Baths: 16
Garage: 4 Car Detached
2738 27 1/2 Ave, Mikana, Wisconsin 54857

One of a kind lakeshore property known as The Gathering Place! With 73+ acres and 950 ft of frontage, the property is currently operated as a high end resort, but could be your family compound, a corporate retreat, meeting center, or continued as a resort. Property includes 6 lakeshore cabins, a 1,600 SF lodge ideal for receptions/common meeting space, and a 5,000 SF residence. The property is on ...
Eau Claire Properties Virtual ToursClick Here for Virtual Tour
View Full Information

Chippewa Valley Homes
MLS # 811649

Price: 3,200,000.00
Type: Commercial
Beds:
Baths:
Garage:
N1035 Riviera Ave, Neillsville, Wisconsin 54456

Thriving resort on beautiful Lake Arbutus. Completely rebuilt in last 5 years. Log built 5886 SF sports bar & grill with full kitchen, several cabins and cottages, seven Biscayne park models, 17 full service camp sites, mini-golf, bait shop, game r...
View Full Information

Chippewa Valley Homes
MLS # 827249

Price: 2,950,000.00
Type: Single-Family
Beds: 4
Baths: 4
Garage: 2 Car Attached
49080 S River Rd, Gordon, Wisconsin 54838

This is the ultimate lake property! Sixteen acres of beautiful pine forest and over a quarter mile of crystal clear sandy lakeshore offering total privacy! Now picture a perfectly designed 5400+ sq ft lake home with a stunning lakeside master suite, private library with its own fireplace, breathtaking sunroom, massive two story real river rock woodburning fireplace in the greatroom, plus an in-flo...
Eau Claire Properties Virtual ToursClick Here for Virtual Tour
View Full Information

Chippewa Valley Homes
MLS # 828568

Price: 2,945,000.00
Type: Land
Beds:
Baths:
Garage:
7751 S Hwy S, Lake Nebagamon, Wisconsin 54849

Long time established "YMCA" Camp on Lake Nebagamon with 1,303 feet of sandy beach frontage. There are 10 buildings on the property. Main cabin is 40 x 50; Directors cabin is 24x34; Red cabin is 24x16;Craft cabin is 34x20; two cabins are 20x20 and an...
View Full Information

Chippewa Valley Homes
MLS # 822294

Price: 2,800,000.00
Type: Single-Family
Beds: 3
Baths: 2
Garage: 2 Car Detached
13608 S Hwy Y, Gordon, Wisconsin 54838

A nostalgic masterpiece offered here. Estate featuring large rooms with beautiful parlor and fieldstone fireplace, private master bedroom up with bath, lakeside views and privacy, privacy privacy to remind you of days gone by. The apx 996 feet of sandy shoreline along the clear pristine waters of this exceptional lake and 38.89 wooded acres to ensure your privacy here. A boathouse with modern gues...
View Full Information

Chippewa Valley Homes
MLS # 826632

Price: 2,695,000.00
Type: Single-Family
Beds: 5
Baths: 5
Garage: 3 Car Detached
47585 Chapinwood Rd, Cable, Wisconsin 54821

Follow a winding lane through a century-old hardwood forest to a place few can dream of a place that almost feels like another time. A place of old-style craftsmanship. A place of trees and lakes even older. A place of stones older still. A place with a feeling of warmth and old comfort, yet with all the conveniences of a modern age. Such a place exists at Chapinwood, a magnificent log esta...
Eau Claire Properties Virtual ToursClick Here for Virtual Tour
View Full Information

Chippewa Valley Homes
MLS # 830431

Price: 2,500,000.00
Type: Single-Family
Beds: 3
Baths: 1
Garage: 5 Car Detached
20985 Dam Rd, Cable, Wisconsin 54821

Custom built log home just mnutes from Cable. Home is located on Lake Namekagon close to the Dam. Very private setting with upper end construction Onyx fireplace, infloor heat, steam shower, heated garage, nice large deck, and more. This property is very private and quiet and would make a nice home or corporate get away.True Value...
View Full Information



Chippewa Valley Homes - Real Estate Icon
Licensed in the State of Wisconsin. Website ©2010 CENTURY 21 Metro Realty Inc.
©2010

Century 21 Real Estate LLC.

CENTURY 21® is a registered
trademark licensed to Century 21 Real Estate LLC. Equal Housing Opportunity.
Each Office is Independently Owned and Operated.
1906 Brackett Avenue Eau Claire, Wisconsin 54701 United States
Website design and hosting by JB Systems, LLC.