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, (closingDate="" AND closingPrice=0) listProperty, '' 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, comPublicComments publicComments, '' resIsForeclosed, '' resIsShortSale, comSchoolDist schoolDist, CONCAT('Above: ', comAboveGrade, ' Below: ', comBelowGrade) squareFootage, comState state, '' status, '' 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 comListingOffice LIKE 'C21 Metro%' ) 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, (closingDate="" AND closingPrice=0) listProperty, '' 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, frmPublicComments publicComments, '' resIsForeclosed, '' resIsShortSale, frmSchoolDist schoolDist, CONCAT('Above: ', frmAboveGrade, ' Below: ', frmBelowGrade) squareFootage, frmState state, '' status, '' 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 frmListingOffice LIKE 'C21 Metro%' ) 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, (closingDate="" AND closingPrice=0) listProperty, '' 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, lndPublicComments publicComments, '' resIsForeclosed, '' resIsShortSale, lndSchoolDist schoolDist, CONCAT(lndLotDim_L1,'x',lndLotDim_W1) squareFootage, lndState state, '' status, '' style, lndRemarks summary, lndTaxYear taxYear, lndVirtualTourURL virtualTour, lndLakeName waterfront, '' yearBuilt, lndTaxAmount yearlyTax, lndZip zip, '' zoning, 'Land' propertyType, 'Eau_Claire' mlsSystem FROM tblListingLand WHERE lndListingOffice LIKE 'C21 Metro%' ) 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, (closingDate="" AND closingPrice=0) listProperty, '' 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, mulPublicComments publicComments, '' resIsForeclosed, '' resIsShortSale, mulSchoolDist schoolDist, CONCAT(mulBldgDim_L1,'x',mulBldgDim_W1) squareFootage, mulState state, '' status, '' 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 mulListingOffice LIKE 'C21 Metro%' ) 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, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM (resFullBathQty + resHalfBathQty/2))) 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, (closingDate="" AND closingPrice=0) listProperty, 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, resPublicComments publicComments, isForeclosed resIsForeclosed, isShortSale resIsShortSale, resSchoolDist schoolDist, CONCAT('Above: ', resAboveGrade, ' Below: ', resBelowGrade) squareFootage, resState state, resStatus status, 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 resListingOffice LIKE 'C21 Metro%' ) ) MasterList WHERE listProperty=1 ORDER BY price DESC
Property Search - C21® Listings
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 43    Results 1-10 of 422

View all of Century 21s

Eau Claire foreclosures

and real estate. Below you will find beautiful

Chippewa Valley homes for sale

, including foreclosures, commercial properties, and even water front properties. Century 21 of Eau Claire wants to help you find your next home.

Chippewa Valley Homes
MLS # 848632

Price: 3,199,900.00
Type: Multi-Family
Beds:
Baths:
Garage:
13161-3 43rd Ave, Chippewa Falls, Wisconsin 54729

Professionally managed Chippewa County Real Estate Portfolio. Attractive buildings & unit mix, ranging from duplex to 11-unit buildings (45 units in all) Chippewa Falls; (8) Duplexes, (2) 4 units, (1) 8 unit, (1) 11 unit & 1 vacant lot. Cadott; (1) d...
View Full Information

Chippewa Valley Homes
MLS # 849674

Price: 2,250,000.00
Type: Commercial
Beds:
Baths:
Garage:
350 E Birch Ave, Barron, Wisconsin 54812

River Park Place, is an attractive Apartment Complex consisting of 3 Buildings & garages over 5 acres along the Yellow River in the County Seat, 82 units total: Studio-to-3 BR units, offering ample parking, 40 garages, & Mgr office. Currently has ons...
View Full Information

Chippewa Valley Homes
MLS # 849676

Price: 2,250,000.00
Type: Multi-Family
Beds:
Baths:
Garage:
350 E Birch Ave, Barron, Wisconsin 54812

River Park Place is an attractive apt complex consisting of 3 buildings & garages over 5 acres along the Yellow River in the City of Barron. 82 units total: Studio-to-3 Bedroom units, ample parking, 40 garages, and managers office. Current has an ons...
View Full Information

Chippewa Valley Homes
MLS # 836301

Price: 1,320,000.00
Type: Commercial
Beds:
Baths:
Garage:
E6266 866th Ave, Colfax, Wisconsin 54730

One of the most prestigious properties in the Chippewa Valley! This ultimate Lakefront Estate features a majestic brick mansion on a very private peninsula site with a 180 degree view of Tainter Lake. Stunning architecture & artisan details, from the...
View Full Information

Chippewa Valley Homes
MLS # 835331

Price: 1,320,000.00
Type: Single-Family
Beds: 8
Baths: 7
Garage: 4 Car Attached
E6266 866th Ave, Colfax, Wisconsin 54730

One of the most prestigious properties in the Chippewa Valley! This ultimate lakefront Estate features a majestic brick mansion on a very private peninsula site w/a 180 degree view of Tainter Lake. Meticulous in design, home has stunning architecture& artisan details, from the 2000 sf open 2 story studio to the intimate courtyard to the professional state of the art recording studio. Complete ...
View Full Information

Chippewa Valley Homes
MLS # 852431

Price: 1,100,000.00
Type: Single-Family
Beds: 6
Baths: 5.5
Garage: 3 Car Detached
N736 Scenic Ln, Pepin, Wisconsin 54755

Panoramic view of Lake Pepin plus your own 200' of sandy beach water frontage. Family Estate includes 2 properties separated by an inground heated pool. Excellent corporate retreat! Currently owners do rent out by the weekend or weeks at a time. Repeat guests each year. Extra income. Property was totally remodeled in 2003. Pool liner was new in 2010. 4 fireplaces. Both homes offer quality througho...
View Full Information

Chippewa Valley Homes
MLS # 848633

Price: 1,099,400.00
Type: Multi-Family
Beds:
Baths:
Garage:
13161-3 43rd Ave, Chippewa Falls, Wisconsin 54729

6 duplexes all with 2 BR's 1.5 bath, 2-car attached garage, maintenance free exteriors, some with fireplaces, mostly all long-term tenants. Professionally managed. More properties available if desired -- call for details....
View Full Information

Chippewa Valley Homes
MLS # 841085

Price: 975,000.00
Type: Land
Beds:
Baths:
Garage:
Lot 1 Truax Ln, Eau Claire, Wisconsin 54703

5.74 Acres at the intersection of Hwy 312 and I-94. Perfect location for restaurant, auto, truck or strip mall. Lot has been filled to increase visibility and accessability. Easily seen from 360 degrees. Billboard sign on property for additional...
View Full Information

Chippewa Valley Homes
MLS # 852894

Price: 952,000.00
Type: Single-Family
Beds: 2
Baths: 1.5
Garage: 2 Car Attached
2509 Damon St, Eau Claire, Wisconsin 54701

8 units on Damon & Sterling - 2509-2510-2512-2518-2524-2526 Damon & 3925-3927 Sterling...
View Full Information
Condo Eau Claire Property Type

Chippewa Valley Homes
MLS # 851177

Price: 889,000.00
Type: Single-Family
Beds: 4
Baths: 3
Garage: 3 Car Attached
22404 20th Ave, Cadott, Wisconsin 54727

Executive home w/a 3&4 season sunporch, in-flr heat,extensive landscaping w/3-tier waterfall, steel seamless siding,comfortline fiberglass windows, 17' aerated pond w/ windmill. Lower level has a kitchenette & built-in bar for entertaining.Currentlyset up for beef cattle with approx 50 wooded 50 open acres, 40X50 heated shop, 40X80 machine shed w/ 14' side walls, 40X133 building consists o...
View Full Information



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

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.