SELECT * FROM ((SELECT `resMLSNum`, `resListPrice`, `resType`, `resResType`, `resArea`, `resAddress`, `resCity`, `resState`, `resZip`, `resStatus`, `resCounty`, `resAgent`, `resListingOffice`, `resAboveGrade`, `resBelowGrade`, `resHomeDim_L1`, `resHomeDim_W1`, `resHomeDim_L2`, `resHomeDim_W2`, `resYearBuilt`, `resLotSize_L1`, `resLotSize_W1`, `resLotSize_L2`, `resLotSize_W2`, `resWaterService`, `resWaterService2`, `resWaterService3`, `resWaterService4`, `resSewerService`, `resSewerService2`, `resSewerService3`, `resSewerService4`, `resZoning`, `resZoning2`, `resZoning3`, `resLegalDesc`, `resRestCovenant`, `resSchoolDist`, `resTaxAmount`, `resTaxYear`, `resRemarks`, `resRemarks2`, `resDirections`, `resStyle`, `resBedroomQty`, `resFullBathQty`, `resHalfBathQty`, `resGarageSize`, `resGarageType`, `resAcres`, `resLRLevel`, `resLR_DimL`, `resLR_DimW`, `resLRFlooring`, `resDRLevel`, `resDR_DimL`, `resDR_DimW`, `resDRFlooring`, `resKTLevel`, `resKT_DimL`, `resKT_DimW`, `resKTFlooring`, `resDALevel`, `resDA_DimL`, `resDA_DimW`, `resDAFlooring`, `resBD1Level`, `resBD1_DimL`, `resBD1_DimW`, `resBD1Flooring`, `resBD2Level`, `resBD2_DimL`, `resBD2_DimW`, `resBD2Flooring`, `resBD3Level`, `resBD3_DimL`, `resBD3_DimW`, `resBD3Flooring`, `resBD4Level`, `resBD4_DimL`, `resBD4_DimW`, `resBD4Flooring`, `resBTH1Level`, `resBTH1_DimL`, `resBTH1_DimW`, `resBTH1Flooring`, `resBTH2Level`, `resBTH2_DimL`, `resBTH2_DimW`, `resBTH2Flooring`, `resFRLevel`, `resFR_DimL`, `resFR_DimW`, `resFRFlooring`, `resOtherLevel`, `resOther_DimL`, `resOther_DimW`, `resOtherFlooring`, `resLaundryLevel`, `resLaundry_DimL`, `resLaundry_DimW`, `resLaundryFlooring`, `resOfficeLevel`, `resOffice_DimL`, `resOffice_DimW`, `resOfficeFlooring`, `resIncludes`, `resIncludes2`, `resIncludes3`, `resIncludes4`, `resIncludes5`, `resIncludes6`, `resIncludes7`, `resIncludes8`, `resIncludes9`, `resIncludes10`, `resIncludes11`, `resIncludes12`, `resExcludes`, `resExcludes2`, `resExcludes3`, `resExcludes4`, `resExcludes5`, `resExcludes6`, `resExcludes7`, `resExcludes8`, `resExcludes9`, `resExcludes10`, `resExcludes11`, `resExcludes12`, `resHasWaterfront`, `resWaterfrontDesc`, `resWaterfrontDesc2`, `resWaterfrontDesc3`, `resWaterfrontDesc4`, `resWaterfrontType`, `resWaterFrontage`, `resWaterSeasons`, `resOwnsFrontage`, `resSharedFrontage`, `resLakeSize`, `resLakeName`, `resLakeDepth`, `resDeededAccess`, `resEasements`, `resBasement`, `resBasement2`, `resBasement3`, `resCooling`, `resCooling2`, `resCooling3`, `resDriveway`, `resDriveway2`, `resDriveway3`, `resElectric`, `resElectric2`, `resElectric3`, `resExterior`, `resExterior2`, `resExterior3`, `resExterior4`, `resFireplace`, `resFireplace2`, `resFireplace3`, `resFoundation`, `resFoundation2`, `resFoundation3`, `resFuelSource`, `resFuelSource2`, `resFuelSource3`, `resFuelSource4`, `resHeating`, `resHeating2`, `resHeating3`, `resNewConst`, `resNewConst2`, `resNewConst3`, `resNewConst4`, `resOccupancy`, `resOccupancy2`, `resOccupancy3`, `resOccupancy4`, `resOutBuildings`, `resOutBuildings2`, `resOutBuildings3`, `resOutBuildings4`, `resPatioDeck`, `resPatioDeck2`, `resPatioDeck3`, `resPatioDeck4`, `resWaterHeater`, `resWaterHeater2`, `resWaterHeater3`, `resWaterHeater4`, `resVirtualTourURL`, `resLastUpdate`, `idx_y/n`, `brokerCode`, `newField`, `condoY/N`, `manufacturedY/N`, `netAddressDispY/N`, `isForeclosed`, `isShortSale`, `closingDate`, `closingPrice`, `extra1`, `resTotalFootage`, `resPublicComments`, `resAssociation`, `daysOnMarket`, 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, 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, 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,'%Y-%m-%d') 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, CONCAT(resLotSize_L1,'x',resLotSize_W1) lotSize, resMLSNum mlsNum, `netAddressDispY/N` netAddress, resNewConst newConstruction, 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, 'Single-Family' propertyType, 'Eau_Claire' mlsSystem FROM (tblListingResidential LEFT JOIN openHouses ON resMLSNum=mlsNum) WHERE 1 LIMIT 3000) ) MasterList WHERE listProperty=1 ORDER BY price DESC
Virtual Tours of Eau Claire Homes for Sale - CENTURY 21 Metro Realty, Inc
SELECT * FROM ((SELECT `resMLSNum`, `resListPrice`, `resType`, `resResType`, `resArea`, `resAddress`, `resCity`, `resState`, `resZip`, `resStatus`, `resCounty`, `resAgent`, `resListingOffice`, `resAboveGrade`, `resBelowGrade`, `resHomeDim_L1`, `resHomeDim_W1`, `resHomeDim_L2`, `resHomeDim_W2`, `resYearBuilt`, `resLotSize_L1`, `resLotSize_W1`, `resLotSize_L2`, `resLotSize_W2`, `resWaterService`, `resWaterService2`, `resWaterService3`, `resWaterService4`, `resSewerService`, `resSewerService2`, `resSewerService3`, `resSewerService4`, `resZoning`, `resZoning2`, `resZoning3`, `resLegalDesc`, `resRestCovenant`, `resSchoolDist`, `resTaxAmount`, `resTaxYear`, `resRemarks`, `resRemarks2`, `resDirections`, `resStyle`, `resBedroomQty`, `resFullBathQty`, `resHalfBathQty`, `resGarageSize`, `resGarageType`, `resAcres`, `resLRLevel`, `resLR_DimL`, `resLR_DimW`, `resLRFlooring`, `resDRLevel`, `resDR_DimL`, `resDR_DimW`, `resDRFlooring`, `resKTLevel`, `resKT_DimL`, `resKT_DimW`, `resKTFlooring`, `resDALevel`, `resDA_DimL`, `resDA_DimW`, `resDAFlooring`, `resBD1Level`, `resBD1_DimL`, `resBD1_DimW`, `resBD1Flooring`, `resBD2Level`, `resBD2_DimL`, `resBD2_DimW`, `resBD2Flooring`, `resBD3Level`, `resBD3_DimL`, `resBD3_DimW`, `resBD3Flooring`, `resBD4Level`, `resBD4_DimL`, `resBD4_DimW`, `resBD4Flooring`, `resBTH1Level`, `resBTH1_DimL`, `resBTH1_DimW`, `resBTH1Flooring`, `resBTH2Level`, `resBTH2_DimL`, `resBTH2_DimW`, `resBTH2Flooring`, `resFRLevel`, `resFR_DimL`, `resFR_DimW`, `resFRFlooring`, `resOtherLevel`, `resOther_DimL`, `resOther_DimW`, `resOtherFlooring`, `resLaundryLevel`, `resLaundry_DimL`, `resLaundry_DimW`, `resLaundryFlooring`, `resOfficeLevel`, `resOffice_DimL`, `resOffice_DimW`, `resOfficeFlooring`, `resIncludes`, `resIncludes2`, `resIncludes3`, `resIncludes4`, `resIncludes5`, `resIncludes6`, `resIncludes7`, `resIncludes8`, `resIncludes9`, `resIncludes10`, `resIncludes11`, `resIncludes12`, `resExcludes`, `resExcludes2`, `resExcludes3`, `resExcludes4`, `resExcludes5`, `resExcludes6`, `resExcludes7`, `resExcludes8`, `resExcludes9`, `resExcludes10`, `resExcludes11`, `resExcludes12`, `resHasWaterfront`, `resWaterfrontDesc`, `resWaterfrontDesc2`, `resWaterfrontDesc3`, `resWaterfrontDesc4`, `resWaterfrontType`, `resWaterFrontage`, `resWaterSeasons`, `resOwnsFrontage`, `resSharedFrontage`, `resLakeSize`, `resLakeName`, `resLakeDepth`, `resDeededAccess`, `resEasements`, `resBasement`, `resBasement2`, `resBasement3`, `resCooling`, `resCooling2`, `resCooling3`, `resDriveway`, `resDriveway2`, `resDriveway3`, `resElectric`, `resElectric2`, `resElectric3`, `resExterior`, `resExterior2`, `resExterior3`, `resExterior4`, `resFireplace`, `resFireplace2`, `resFireplace3`, `resFoundation`, `resFoundation2`, `resFoundation3`, `resFuelSource`, `resFuelSource2`, `resFuelSource3`, `resFuelSource4`, `resHeating`, `resHeating2`, `resHeating3`, `resNewConst`, `resNewConst2`, `resNewConst3`, `resNewConst4`, `resOccupancy`, `resOccupancy2`, `resOccupancy3`, `resOccupancy4`, `resOutBuildings`, `resOutBuildings2`, `resOutBuildings3`, `resOutBuildings4`, `resPatioDeck`, `resPatioDeck2`, `resPatioDeck3`, `resPatioDeck4`, `resWaterHeater`, `resWaterHeater2`, `resWaterHeater3`, `resWaterHeater4`, `resVirtualTourURL`, `resLastUpdate`, `idx_y/n`, `brokerCode`, `newField`, `condoY/N`, `manufacturedY/N`, `netAddressDispY/N`, `isForeclosed`, `isShortSale`, `closingDate`, `closingPrice`, `extra1`, `resTotalFootage`, `resPublicComments`, `resAssociation`, `daysOnMarket`, 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, 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, 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,'%Y-%m-%d') 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, CONCAT(resLotSize_L1,'x',resLotSize_W1) lotSize, resMLSNum mlsNum, `netAddressDispY/N` netAddress, resNewConst newConstruction, 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, 'Single-Family' propertyType, 'Eau_Claire' mlsSystem FROM (tblListingResidential LEFT JOIN openHouses ON resMLSNum=mlsNum) WHERE 1 LIMIT 3000) ) MasterList WHERE listProperty=1 ORDER BY price DESC
Property Search - Listings
Back to search Sort By:
Narrow Your Search:   Price:             Type:         City:
White Arrow DBL Icon White Arrow Icon Next 0 -1 -2 -3 Prev Right White Arrow Icon Right DBL White Arrow Icon Page 1 of 7    Results 311-66 of 66


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

CENTURY 21 Metro Realty, Inc.

CENTURY 21® is a registered
trademark owned by 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.