Skip to main content
For Sale

4520 Water Street, Columbiaville, MI 48421

$1,200,000
3 beds5 baths4,678 sqftBuilt 19000.42 acres
4520 Water Street, Columbiaville, MI 48421 — front exterior
1 / 98

Description

Custom waterfront home offering a rare combination of privacy, recreation, and entertaining space in a small-town setting. This iconic Columbiaville building has been converted into a residential home with a large addition, this unique property sits on two city lots with no neighboring homes in lakeview sight and overlooks an excellent walleye fishing area. The home features 3 bedrooms, 3 full baths, and 2 half baths, including both first- and second-floor primary suites. Inside, you’ll find custom kitchens with custom countertops, a chef’s kitchen with oversized pantry with extra fridge & freezer plus an Ice maker, dedicated coffee bar area, upstairs full wet bar, two gas fireplaces, and extensive updates including all new electrical and plumbing, three new furnaces, new windows within the last five years, new appliances, reverse osmosis system, two on-demand water heaters, heated shop floors, and new roofing including a flat roof with a 20-year warranty. The outdoor entertaining areas are equally impressive with a large upper waterfront patio, expansive lower patio, hidden fire pit patio built into the rock wall at the water’s edge, professionally landscaped hardscape, docks, pontoon hoist, and jet ski hoist. Small boats and jet skis can access the big all-sports water while the pontoon can travel far upriver for a private leisurely cruise. Additional features include a heated slab in the new garage, dry basement storage, and included pontoon boat plus two personal watercraft.

Price & Status History

May 20, 2026MLS #20261036678
Listed for sale
$1,200,000

MLS Listing History1 listing

StatusList PriceSale PriceListedSoldBoard
For Sale$1,200,000May 20, 2026RealcompView →

Tax & Assessment

Parcel Number04335100160
Annual Tax$3,382

Property Details

Property TypeResidentialBedrooms3Bathrooms5Living Area4,678 sqftLot Size0.42 acresYear Built1900CityColumbiavilleMunicipalityColumbiaville VlgZip Code48421School DistrictLakevilleTerms AcceptedCash, Conventional, FHA, VA Loan

Listed by Douglas F Ferrell

Realty Executives Main St LLC

Browse All Neighborhoods
Browse All Condos
Ann Arbor
Ypsilanti
Allen Park
Belleville
Birmingham
Bloomfield Hills
Brighton
Canton
Chelsea
Clawson
Commerce
Dearborn
Detroit
Dexter
Farmington Hills
Ferndale
Flat Rock
Franklin
Howell
Livonia
Luna Pier
Manchester
Melvindale
Milan
Milford
Monroe
New Boston
New Hudson
Northville
Novi
Plymouth
Rochester Hills
Romulus
Royal Oak
Saline
South Lyon
South Rockwood
Southfield
Sterling Heights
Taylor
Temperance
Trenton
Troy
Utica
Walled Lake
Warren
Waterford
Wayne
Westland
Wixom
Zip_48165
Zip_48315
Browse All Towns & Cities
Ada TwpAddison TwpAdrian TwpAhmeekAkronAlaiedon TwpAlamo TwpAlansonAlbee TwpAlbion TwpAlgoma TwpAlgonacAllegan TwpAllenAllendale TwpAlmaAlmont TwpAlpenaAlpine TwpAnn Arbor TwpApplegateArcadia TwpArgentine TwpArmada TwpAsh TwpAshleyAthens TwpAtlas TwpAttica TwpAu GresAuburnAuburn HillsAugusta TwpAurelius TwpBad AxeBainbridge TwpBaldwinBancroftBangorBaroda TwpBarrytonBattle CreekBay CityBear LakeBeavertonBedford TwpBeldingBellaireBellevueBenton HarborBenton TwpBenzoniaBerkleyBerlin TwpBerrien SpringsBerrien TwpBertrand TwpBessemerBeulahBeverly HillsBig RapidsBingham FarmsBirch Run TwpBlackman TwpBlendon TwpBlissfield TwpBloomfield TwpBloomingdaleBlue Lake TwpBlumfield TwpBowne TwpBoyne CityBoyne FallsBrady TwpBrandon TwpBrant TwpBreckenridgeBreedsvilleBridgeport TwpBridgewater TwpBridgmanBrighton TwpBrittonBrockway TwpBronsonBrooklynBrown CityBrownstown TwpBruce TwpBuchanan TwpBuckleyBuena Vista TwpBunker Hill TwpBurlington TwpBurnside TwpBurr OakBurtchville TwpBurtonByron TwpCadillacCaledonia TwpCalumetCambridge TwpCamdenCannon TwpCanton TwpCapacCarletonCaroCarrollton TwpCarson CityCarsonvilleCascade TwpCasco TwpCasevilleCasnovia TwpCaspianCass CityCassopolisCedar Creek TwpCedar SpringsCement CityCenter LineCentral LakeCentrevilleChapin TwpCharleston TwpCharlevoixCharlotteCheboyganChesaning TwpCheshire TwpChester TwpChesterfield TwpChikaming TwpChina TwpClareClarence TwpClarendon TwpClarksvilleClay TwpClayton TwpClimax TwpClinton TwpClioClyde TwpCohoctah TwpColdwaterColemanColoma TwpColonColumbia TwpColumbiavilleColumbus TwpCommerce TwpComstock TwpConcord TwpConstantineConvis TwpConway TwpCooper TwpCoopersvilleCopemishCorunnaCottrellville TwpCourtland TwpCrockery TwpCroswellCusterDalton TwpDavison TwpDe Tour VillageDearborn HeightsDecaturDeckervilleDeerfield TwpDelhi TwpDewittDexter TwpDimondaleDorr TwpDouglasDover TwpDowagiacDryden TwpDundee TwpDurandEast China TwpEast Grand RapidsEast JordanEast LansingEast TawasEastlakeEastpointeEaton RapidsEau ClaireEckford TwpEcorseEdmoreEdwardsburgEgelston TwpElba TwpElbertaElk RapidsElktonEllsworthElsieEmmett TwpEmpireErie TwpEscanabaEssexvilleEstral BeachEvartExeter TwpFairfield TwpFairgroveFarmingtonFarwellFennvilleFenton TwpFerrysburgFife LakeFillmore TwpFlint TwpFlushing TwpForest TwpForestvilleFort Gratiot TwpFountainFowlerFowlervilleFrankenmuth TwpFrankfortFranklin TwpFraserFredonia TwpFree SoilFreedom TwpFreeportFremont TwpFrenchtown TwpFruitland TwpFruitport TwpGagetownGaines TwpGalesburgGalien TwpGanges TwpGarden CityGaylordGenesee TwpGenoa TwpGeorgetown TwpGibraltarGladwinGoblesGoodland TwpGoodrichGrand BeachGrand Blanc TwpGrand Haven TwpGrand LedgeGrand Rapids TwpGrandvilleGrant TwpGrass Lake TwpGrattan TwpGraylingGreen Oak TwpGreenvilleGreenwood TwpGrosse Ile TwpGrosse PointeGrosse Pointe FarmsGrosse Pointe ParkGrosse Pointe WoodsGroveland TwpGun Plain TwpHadley TwpHagar TwpHamburg TwpHamtramckHandy TwpHanover TwpHarbor BeachHarper WoodsHarriettaHarrison TwpHarrisvilleHartHartfordHartland TwpHastingsHazel ParkHeath TwpHenrietta TwpHerseyHesperiaHighland ParkHighland TwpHillmanHillsdaleHolland TwpHolly TwpHolton TwpHomer TwpHonorHopkins TwpHoughtonHoward CityHowell TwpHubbardstonHudson TwpHudsonvilleHuron TwpIda TwpImlay CityIndependence TwpIngham TwpInksterIoniaIosco TwpIra TwpIron MountainIron RiverIronwoodIshpemingIthacaJacksonJames TwpJamestown TwpJonesfield TwpJonesvilleKalamazoo TwpKalevaKalkaskaKeego HarborKenockee TwpKent CityKentwoodKimball TwpKingsleyKingstonKochville TwpL AnseLa Salle TwpLaingsburgLake AngelusLake AnnLake CityLake IsabellaLake OdessaLake OrionLakefield TwpLaketon TwpLaketown TwpLakeviewLakewood ClubLansing TwpLapeer TwpLathrupLauriumLawrenceLawtonLe RoyLee TwpLeighton TwpLennonLenox TwpLeonardLeoni TwpLeroy TwpLeslie TwpLexingtonLiberty TwpLima TwpLincoln ParkLincoln TwpLindenLitchfieldLocke TwpLodi TwpLondon TwpLowell TwpLudingtonLutherLyndon TwpLynn TwpLyon TwpLyonsMackinac IslandMackinaw CityMacomb TwpMacon TwpMadison HeightsMadison TwpMancelonaManchester TwpManisteeManistiqueManlius TwpMantonMaple Grove TwpMaple RapidsMarathon TwpMarcellusMarengo TwpMarine CityMarion TwpMarletteMarquetteMarshall TwpMartin TwpMarysvilleMasonMattawanMaybeeMayfield TwpMayvilleMcbainMcbrideMecostaMedina TwpMelvinMemphisMendonMeridian TwpMerrillMesickMetamora TwpMichianaMiddlevilleMidlandMilan TwpMilford TwpMillersburgMillingtonMinden CityMonroe TwpMontague TwpMonterey TwpMontgomeryMontrose TwpMoorland TwpMorenciMorleyMorriceMount ClemensMount Morris TwpMount PleasantMuirMullikenMundy TwpMunisingMuskegon HeightsMuskegon TwpMussey TwpNapoleon TwpNashvilleNelson TwpNew BaltimoreNew Buffalo TwpNew EraNew HavenNew LothropNewaygoNewberryNewton TwpNiles TwpNorth AdamsNorth Branch TwpNorth MuskegonNorthfield TwpNorthportNorthville TwpNorton ShoresNorvell TwpNorwayNovi TwpOakfield TwpOakland TwpOakleyOceola TwpOgden TwpOlive TwpOlivetOmerOnawayOnekamaOnondaga TwpOnstedOrchard LakeOregon TwpOrion TwpOronoko TwpOrtonvilleOshtemo TwpOtisvilleOtsego TwpOtter LakeOverisel TwpOvidOwossoOxford TwpPalmyra TwpParchmentPark TwpParma TwpPavilion TwpPaw PawPeckPellstonPennfield TwpPentwaterPerrintonPerryPetersburgPetoskeyPewamoPiersonPigeonPinconningPipestone TwpPlainfield TwpPlainwellPleasant RidgePlymouth TwpPolkton TwpPontiacPort AustinPort HopePort Huron TwpPort SanilacPort Sheldon TwpPortagePortlandPosenPottervillePrairie Ronde TwpPrescottPulaski TwpPutnam TwpQuincyRaisin TwpRaisinville TwpRavenna TwpRay TwpReadingRedford TwpReed CityReeseRich TwpRichfield TwpRichland TwpRichmond TwpRidgeway TwpRiga TwpRiley TwpRiver RougeRiverviewRives TwpRobinson TwpRochesterRockfordRockwoodRogers CityRollin TwpRome TwpRomeoRoosevelt ParkRoscommonRose CityRosebushRosevilleRoss TwpRothburyRoyal Oak TwpRoyalton TwpSaginaw TwpSalem TwpSaline TwpSand LakeSandstone TwpSanduskySanfordSaranacSaugatuck TwpSault Ste MarieSchoolcraft TwpScottvilleSebewaingSeneca TwpSharon TwpShelby TwpShepherdSheridan TwpSherwoodShorehamSodus TwpSolon TwpSouth HavenSouthfield TwpSouthgateSparta TwpSpaulding TwpSpencer TwpSpring Arbor TwpSpring Lake TwpSpringfield TwpSpringport TwpSt Charles TwpSt Clair ShoresSt Clair TwpSt IgnaceSt JohnsSt Joseph TwpSt LouisStandishStantonStanwoodStephensonSterlingStevensvilleStockbridge TwpSturgisSullivan TwpSummerfield TwpSummit TwpSumpter TwpSunfieldSuttons BaySwan Creek TwpSwartz CreekSylvan LakeSylvan TwpTallmadge TwpTawas CityTaymouth TwpTecumseh TwpTekonsha TwpTexas TwpThetford TwpThomas TwpThompsonvilleThree Oaks TwpThree RiversTittabawassee TwpTompkins TwpTraverse CityTrowbridge TwpTurnerTustinTwiningTyrone TwpUblyUnadilla TwpUnion CityUnionvilleValley TwpVan Buren TwpVandaliaVanderbiltVassarVergennes TwpVermontvilleVernonVevay TwpVicksburgVienna TwpVillage Of ClarkstonVillage Of Grosse Pointe ShoresWakefieldWakeshma TwpWaldronWales TwpWalkerWalkervilleWashington TwpWaterford TwpWaterloo TwpWatervliet TwpWatson TwpWayland TwpWebbervilleWebster TwpWeesaw TwpWest Bloomfield TwpWest BranchWestphaliaWheatfield TwpWhite CloudWhite Lake TwpWhite Oak TwpWhite PigeonWhite River TwpWhiteford TwpWhitehall TwpWhitmore LakeWhittemoreWilliamstonWilliamstown TwpWolverineWolverine LakeWoodhavenWoodlandWoodstock TwpWright TwpWyandotteWyomingYaleYork TwpYpsilanti TwpZeeland TwpZilwaukee Twp