{"Id":633472,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7171676","MLSAGENTID":"NST506013840","MLSCOAGENTID":"NST506021019","MLSOFFICEID":"NST8237","ADDRESS":"668 Callahan Place","ACRES":0.384,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished,Full,Storage Space,Tile Shower,Walkout","BATHSTOTAL":4.0,"BEDROOMS":5.0,"CITY":"Mendota Heights","CONTINGENCY":"None","COUNTY":"Dakota","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Block,Concrete,Steel Siding,Stone","FORECLOSURE":"No","LASTPRICE":2500000.0,"LASTPRICEDATE":"2026-11-13T03:49:06.517","LATITUDE":44.889181,"LENDEROWNED":"No","LISTDATE":"2026-11-11T06:00:00","LISTPRICE":2500000.0,"LIVINGAREA":5497.0,"LONGITUDE":-93.117525,"LOTDESCRIPTION":"Irregular Lot,Sod Included in Price,Tree Coverage - Medium","MODIFICATIONTIMESTAMP":"2026-11-13T03:49:06.516","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":8,"POSTALCODE":"55118","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to this stunning custom-built luxury home in the heart of Mendota Heights, where modern architecture, exceptional craftsmanship, and thoughtfully selected finishes come together. Designed for both everyday comfort and entertaining, this one-of-a-kind residence offers spacious living areas, beautiful natural light, and attention to detail throughout. Step inside to an impressive great room featuring soaring 20-foot ceilings, expansive Andersen windows that fill the home with natural light, and beautiful hardwood flooring throughout the entire main level. The open-concept layout flows into a gorgeous chef's kitchen featuring custom cabinetry, premium finishes, an impressive 15-foot island, and a spacious butler's pantry. Just off the kitchen, a bright sunroom connects to a large outdoor deck, creating the perfect space for indoor-outdoor entertaining.\n\nThe luxurious primary suite offers a private retreat with a spa-inspired bathroom featuring a freestanding soaking tub, spacious walk-in shower, and beautiful tile finishes. Every bathroom features tile flooring and thoughtfully selected finishes, adding a consistent level of quality throughout the home. Additional bedrooms include a convenient Jack-and-Jill full bathroom, providing both comfort and functionality.\n\nThe finished lower level offers additional living and entertaining space, including a versatile bedroom staged as a private fitness room that can easily serve as guest accommodations or a home gym. An attached three-car garage provides generous space for vehicles and storage. From the dramatic ceiling heights and expansive windows to the custom cabinetry, hardwood floors, beautifully tiled bathrooms, and carefully selected architectural details, every space reflects a commitment to quality craftsmanship and timeless design. Conveniently located near parks, shopping, dining, MSP International Airport, and both downtowns.Built by Lighthouse Development Group with interiors professionally designed by GDS Interiors, this exceptional residence offers a rare opportunity to own a truly distinctive luxury home in one of Mendota Heights' most desirable locations.Please note that this home is currently under construction, with final finishes and features still being completed.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Flat","SCHOOLDISTRICTNUMBER":"197-West St. Paul-Mendota Hts.-Eagan","SCHOOLDISTRICTPHONE":"6514037002","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-11-13T03:49:06.517","LASTSTATUS":"Active","STREETNAME":"Callahan","STREETNUMBER":"668","STREETSUFFIX":"Place","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2026,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-11-13T03:49:06.516","PHOTOORDER":"1,2,3,4,5,6,7,8","SOURCE":"MG_NST"}
{"ListingKey":"NST7997213","NST_AboveGradeSqFtTotal":"3936","AboveGradeFinishedArea":"3936","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Deck,Exercise Room,Hardwood Floors,Kitchen Center Island,Kitchen Window,Primary Bedroom Walk-In Closet,Sun Room,Tile Floors,Vaulted Ceiling(s),Washer/Dryer Hookup,Walk-In Closet","Appliances":"Dishwasher,Dryer,Exhaust Fan,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","AttributionContact":"6515004038","NST_AttributionName":"Julian Scott","Basement":"Finished,Full,Storage Space,Tile Shower,Walkout","BasementYN":"True","NST_BathDesc":"3/4 Basement,Full Jack & Jill,Private Primary,Main Floor 1/2 Bath,Separate Tub & Shower,Steam Shower,Upper Level Full Bath,Walk-In Shower Stall","BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"4","BedroomsTotal":"5","NST_BelowGradeSqFtTotal":"1561","BelowGradeFinishedArea":"1561","CumulativeDaysOnMarket":"1","City":"Mendota Heights","NST_CompletionDate":"2026-12-21","ConstructionMaterials":"Block,Concrete,Steel Siding,Stone","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Dakota","NST_DiningRoomDescription":"Living/Dining Room","Directions":"Just east of Dodd Road and south of Marie Avenue","DocumentsCount":"0","DaysOnMarket":"1","NST_DomIncrementTimestamp":"2026-11-12","NST_DomIncrementYN":"true","Electric":"Circuit Breakers","ExteriorFeatures":"Stone,Cement Board","Fencing":"Partial","FireplaceFeatures":"Electric,Living Room","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"1561","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"775","GarageSpaces":"3","Heating":"Forced Air","HighSchoolDistrict":"West St. Paul-Mendota Hts.-Eagan","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.889181","LaundryFeatures":"Upper Level","NST_LenderOwned":"No","Levels":"Two","ListPrice":"2500000","ListingContractDate":"2026-11-11T06:00:00Z","ListingId":"NST7171676","LivingArea":"5497","LockBoxType":"None","Longitude":"-93.117525","LotFeatures":"Irregular Lot,Sod Included in Price,Tree Coverage - Medium","LotSizeArea":"0.384","LotSizeDimensions":"125 x 134 x 125 x 134","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"2098","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-11-12T21:47:28Z","ParcelNumber":"270250026030","ParkingFeatures":"Attached Garage,Concrete","NST_PatioPorchType":"Deck","PhotosCount":"8","PhotosChangeTimestamp":"2026-11-13T03:49:06.516Z","PostalCity":"Mendota Heights","PostalCode":"55118","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Welcome to this stunning custom-built luxury home in the heart of Mendota Heights, where modern architecture, exceptional craftsmanship, and thoughtfully selected finishes come together. Designed for both everyday comfort and entertaining, this one-of-a-kind residence offers spacious living areas, beautiful natural light, and attention to detail throughout. Step inside to an impressive great room featuring soaring 20-foot ceilings, expansive Andersen windows that fill the home with natural light, and beautiful hardwood flooring throughout the entire main level. The open-concept layout flows into a gorgeous chef's kitchen featuring custom cabinetry, premium finishes, an impressive 15-foot island, and a spacious butler's pantry. Just off the kitchen, a bright sunroom connects to a large outdoor deck, creating the perfect space for indoor-outdoor entertaining.\n\nThe luxurious primary suite offers a private retreat with a spa-inspired bathroom featuring a freestanding soaking tub, spacious walk-in shower, and beautiful tile finishes. Every bathroom features tile flooring and thoughtfully selected finishes, adding a consistent level of quality throughout the home. Additional bedrooms include a convenient Jack-and-Jill full bathroom, providing both comfort and functionality.\n\nThe finished lower level offers additional living and entertaining space, including a versatile bedroom staged as a private fitness room that can easily serve as guest accommodations or a home gym. An attached three-car garage provides generous space for vehicles and storage. From the dramatic ceiling heights and expansive windows to the custom cabinetry, hardwood floors, beautifully tiled bathrooms, and carefully selected architectural details, every space reflects a commitment to quality craftsmanship and timeless design. Conveniently located near parks, shopping, dining, MSP International Airport, and both downtowns.Built by Lighthouse Development Group with interiors professionally designed by GDS Interiors, this exceptional residence offers a rare opportunity to own a truly distinctive luxury home in one of Mendota Heights' most desirable locations.Please note that this home is currently under construction, with final finishes and features still being completed.","PublicSurveyRange":"23","PublicSurveySection":"25","PublicSurveyTownship":"28","RoadFrontageType":"City Street","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less,Flat","NST_SchoolDistrictFullName":"197 - West St. Paul-Mendota Hts.-Eagan","NST_SchoolDistrictNumber":"197","NST_SchoolDistrictPhone":"6514037002","Sewer":"City Sewer/Connected","NST_SpecialSearch":"2nd Floor Laundry,3 BR on One Level,Primary Bdr Suite","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Callahan","StreetNumber":"668","StreetNumberNumeric":"668","StreetSuffix":"Place","TaxAnnualAmount":"4676","NST_TaxWithAssessments":"4676","TaxYear":"2026","NST_TotalArea":"5497","BuildingAreaTotal":"5497","Township":"Mendota Heights","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"2026","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST520588","CoListAgentMlsId":"NST506021019","CoListOfficeMlsId":"NST8237","CoListOfficeName":"Coldwell Banker Realty","CoListOfficeKey":"NST16731","ListAgentKey":"NST106535","ListAgentMlsId":"NST506013840","ListOfficeMlsId":"NST8237","ListOfficeName":"Coldwell Banker Realty","ListOfficeKey":"NST16731","ModificationTimestamp":"2026-11-13T03:49:06.516Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7997213\",\"MediaURL\":\"https://media.mlsgrid.com/token=wnYfttlR3lxO2iyH-Xe0w7wnzz4Wp-O60e2YYDLOuOA&expires=1794545583&id=5d6fc86794c5224544394849/images/NST7997213/59b641b4-ea96-4103-89ea-97854d4cad50.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":2080,\"ImageSizeDescription\":\"2080x2080\",\"MediaModificationTimestamp\":\"2026-11-13T03:48:11.012Z\",\"MediaKey\":\"NST125837519\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7997213\",\"MediaURL\":\"https://media.mlsgrid.com/token=wnYfttlR3lxO2iyH-Xe0w7wnzz4Wp-O60e2YYDLOuOA&expires=1794545583&id=5d6fc86794c5224544394849/images/NST7997213/b08e5e36-4971-4e4b-8a78-5cf7afbfcb3c.jpeg\",\"ImageWidth\":2000,\"ImageHeight\":2000,\"ImageSizeDescription\":\"2000x2000\",\"MediaModificationTimestamp\":\"2026-11-13T03:48:11.038Z\",\"MediaKey\":\"NST125837521\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7997213\",\"MediaURL\":\"https://media.mlsgrid.com/token=wnYfttlR3lxO2iyH-Xe0w7wnzz4Wp-O60e2YYDLOuOA&expires=1794545583&id=5d6fc86794c5224544394849/images/NST7997213/8d2afe8c-6386-4ba5-b0ec-6985645c4e3c.jpeg\",\"ImageWidth\":2000,\"ImageHeight\":2000,\"ImageSizeDescription\":\"2000x2000\",\"MediaModificationTimestamp\":\"2026-11-13T03:48:11.028Z\",\"MediaKey\":\"NST125837523\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7997213\",\"MediaURL\":\"https://media.mlsgrid.com/token=wnYfttlR3lxO2iyH-Xe0w7wnzz4Wp-O60e2YYDLOuOA&expires=1794545583&id=5d6fc86794c5224544394849/images/NST7997213/8e321174-1344-4f1b-8bc0-a0dc94414f1f.jpeg\",\"ImageWidth\":2000,\"ImageHeight\":2000,\"ImageSizeDescription\":\"2000x2000\",\"MediaModificationTimestamp\":\"2026-11-13T03:48:11.134Z\",\"MediaKey\":\"NST125837522\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7997213\",\"MediaURL\":\"https://media.mlsgrid.com/token=wnYfttlR3lxO2iyH-Xe0w7wnzz4Wp-O60e2YYDLOuOA&expires=1794545583&id=5d6fc86794c5224544394849/images/NST7997213/4686ef3e-e186-4f65-9806-4a499df70f52.jpeg\",\"ImageWidth\":2000,\"ImageHeight\":2000,\"ImageSizeDescription\":\"2000x2000\",\"MediaModificationTimestamp\":\"2026-11-13T03:48:11.103Z\",\"MediaKey\":\"NST125837524\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7997213\",\"MediaURL\":\"https://media.mlsgrid.com/token=wnYfttlR3lxO2iyH-Xe0w7wnzz4Wp-O60e2YYDLOuOA&expires=1794545583&id=5d6fc86794c5224544394849/images/NST7997213/46362409-f711-4bf4-8646-c1190833b954.jpeg\",\"ImageWidth\":2000,\"ImageHeight\":2000,\"ImageSizeDescription\":\"2000x2000\",\"MediaModificationTimestamp\":\"2026-11-13T03:48:11.181Z\",\"MediaKey\":\"NST125837525\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7997213\",\"MediaURL\":\"https://media.mlsgrid.com/token=wnYfttlR3lxO2iyH-Xe0w7wnzz4Wp-O60e2YYDLOuOA&expires=1794545583&id=5d6fc86794c5224544394849/images/NST7997213/d7b9cd18-8b8f-4625-9e24-e61c7759a640.jpeg\",\"ImageWidth\":2000,\"ImageHeight\":2000,\"ImageSizeDescription\":\"2000x2000\",\"MediaModificationTimestamp\":\"2026-11-13T03:48:11.084Z\",\"MediaKey\":\"NST125837526\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7997213\",\"MediaURL\":\"https://media.mlsgrid.com/token=wnYfttlR3lxO2iyH-Xe0w7wnzz4Wp-O60e2YYDLOuOA&expires=1794545583&id=5d6fc86794c5224544394849/images/NST7997213/9e6d43cf-8f51-498e-b30d-3b28926b5680.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":1024,\"ImageSizeDescription\":\"1536x1024\",\"MediaModificationTimestamp\":\"2026-11-13T03:48:11.125Z\",\"MediaKey\":\"NST125837520\"}]","Media__Order":"2","Media__MediaObjectID":"NST2","Media__ResourceRecordKey":"NST7997213","Media__MediaURL":"https://media.mlsgrid.com/token=wnYfttlR3lxO2iyH-Xe0w7wnzz4Wp-O60e2YYDLOuOA&expires=1794545583&id=5d6fc86794c5224544394849/images/NST7997213/59b641b4-ea96-4103-89ea-97854d4cad50.jpeg","Media__ImageWidth":"2080","Media__ImageHeight":"2080","Media__ImageSizeDescription":"2080x2080","Media__MediaModificationTimestamp":"11/13/2026 3:48:11 AM","Media__MediaKey":"NST125837519","DocumentsChangeTimestamp":"2026-11-13T03:48:07.996Z","Rooms":"[{\"RoomDimensions\":\"20x15\",\"NST_RoomSortOrder\":19,\"RoomKey\":\"NST116828848\",\"RoomLevel\":\"Main\",\"RoomType\":\"Deck\"},{\"RoomDimensions\":\"14x14\",\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116827282\",\"RoomLevel\":\"Main\",\"RoomType\":\"Dining Room\"},{\"RoomDimensions\":\"32x22\",\"NST_RoomSortOrder\":13,\"RoomKey\":\"NST116828842\",\"RoomLevel\":\"Lower\",\"RoomType\":\"Family Room\"},{\"RoomDimensions\":\"13x12\",\"NST_RoomSortOrder\":12,\"RoomKey\":\"NST116828841\",\"RoomLevel\":\"Lower\",\"RoomType\":\"Bedroom 5\"},{\"RoomDimensions\":\"16x16\",\"NST_RoomSortOrder\":8,\"RoomKey\":\"NST116827288\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom\"},{\"RoomDimensions\":\"13x10\",\"NST_RoomSortOrder\":11,\"RoomKey\":\"NST116828840\",\"RoomLevel\":\"Lower\",\"RoomType\":\"Bedroom 4\"},{\"RoomDimensions\":\"18x15\",\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116827283\",\"RoomLevel\":\"Main\",\"RoomType\":\"Kitchen\"},{\"RoomDimensions\":\"11x8\",\"NST_RoomSortOrder\":15,\"RoomKey\":\"NST116828844\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Laundry\"},{\"RoomDimensions\":\"26x15\",\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116827281\",\"RoomLevel\":\"Main\",\"RoomType\":\"Living Room\"},{\"RoomDimensions\":\"15x11\",\"NST_RoomSortOrder\":17,\"RoomKey\":\"NST116828846\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Primary Bathroom\"},{\"RoomDimensions\":\"15x13\",\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116827286\",\"RoomLevel\":\"Main\",\"RoomType\":\"Office\"},{\"RoomDimensions\":\"12x8\",\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116827284\",\"RoomLevel\":\"Main\",\"RoomType\":\"Pantry (Walk-In)\"},{\"RoomDimensions\":\"14x13\",\"NST_RoomSortOrder\":9,\"RoomKey\":\"NST116827289\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom 2\"},{\"RoomDimensions\":\"13x15\",\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116827285\",\"RoomLevel\":\"Main\",\"RoomType\":\"Sitting Room\"},{\"RoomDimensions\":\"5x7\",\"NST_RoomSortOrder\":18,\"RoomKey\":\"NST116828847\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Steam Room/Shower\"},{\"RoomDimensions\":\"15x13\",\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116827287\",\"RoomLevel\":\"Main\",\"RoomType\":\"Sun Room\"},{\"RoomDimensions\":\"14x13\",\"NST_RoomSortOrder\":10,\"RoomKey\":\"NST116827290\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom 3\"},{\"RoomDimensions\":\"10x11\",\"NST_RoomSortOrder\":16,\"RoomKey\":\"NST116828845\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Walk-In Closet\"}]","Rooms__RoomDimensions":"20x15","Rooms__NST_RoomSortOrder":"19","Rooms__RoomKey":"NST116828848","Rooms__RoomLevel":"Main","Rooms__RoomType":"Deck","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8","CustomVTourURL":""}