$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Coldwell Banker Realty is the brokerage office representing the seller for this listing.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
The data relating to real estate for sale on this site comes in part from the broker reciprocity program of the Regional multiple Listing Service of Minnesota, Inc. real estate listings held by brokerage firms other than are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Heartland Real Estate is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Heartland Real Estate, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
The data relating to real estate for sale on this site comes in part from the broker reciprocity program of the Regional multiple Listing Service of Minnesota, Inc. real estate listings held by brokerage firms other than are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Heartland Real Estate is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Heartland Real Estate, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":532136,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7029942","MLSAGENTID":"NST506097009","MLSOFFICEID":"NST8237","ADDRESS":"2683 Lakeview Court","ACRES":0.335,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished,Full","BATHSTOTAL":3.0,"BEDROOMS":3.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Structurally Insulated Panels","FORECLOSURE":"No","LASTPRICE":1883491.0,"LASTPRICEDATE":"2026-03-24T03:57:05.957","LATITUDE":45.022116,"LENDEROWNED":"No","LISTDATE":"2026-03-23T05:00:00","LISTPRICE":1883491.0,"LIVINGAREA":3749.0,"LONGITUDE":-93.077348,"LOTDESCRIPTION":"Corner Lot,Sod Included in Price,Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2026-03-24T03:57:05.956","OFFICE_OFFICENAME":"Coldwell Banker Realty","OUTBUILDINGS":"Storage Shed","PHOTOCOUNT":4,"POSTALCODE":"55117","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Another amazing pre-sold under construction build by Hampton Companies in the Villas Of Gervais Lake! \n\nLots available for custom design build!\n\nCome visit us at our model for the Parade Of Homes March 13th-April 12th, Friday-Sunday noon-6pm or by appointment.\n\nModel location is 2706 Lakeview Ct, Little Canada MN 55117.\n\nDirections to model home:\n35E to Little Canada Road, East on Little Canada Road to Edgerton St. Take Left and go North on Edgerton about one block, take left on Lakeview Ct to model home on left(first home with for sale sign in yard).","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"2096-Roseville","SCHOOLDISTRICTPHONE":"6516351600","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-03-24T03:57:05.957","LASTSTATUS":"Active","STREETNAME":"Lakeview","STREETNUMBER":"2683","STREETSUFFIX":"Court","STYLE":"Single Family","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2026,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-03-24T03:57:05.956","PHOTOORDER":"1,2,3,4","SOURCE":"MG_NST"}
{"ListingKey":"NST7862827","NST_AboveGradeSqFtTotal":"1858","AboveGradeFinishedArea":"1858","AccessibilityFeatures":"Other","AdditionalParcelsYN":"False","NST_AgentOwner":"No","Appliances":"Dishwasher,Range,Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","AttributionContact":"7632267127","NST_AttributionName":"Mark C. Fearing","Basement":"Finished,Full","BasementYN":"True","BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"1891","BelowGradeFinishedArea":"1891","CumulativeDaysOnMarket":"0","City":"Saint Paul","NST_CommunityName":"Villas of Gervais Lake","NST_CompletionDate":"2026-10-31","ConstructionMaterials":"Structurally Insulated Panels","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_ListPriceHigh":"300000","NST_LotPrice":"285000","Directions":"35E to Little Canada Rd. Little Canada Rd East to Edgerton St. Edgerton St North to Lakeview Ct. Left on Lakeview Ct to property on right.","DocumentsCount":"0","DaysOnMarket":"0","Electric":"Circuit Breakers,200+ Amp Service","FireplaceFeatures":"Electric Log","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"1891","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"510","NST_GarageDimensions":"24 x 21","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Roseville","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.022116","LaundryFeatures":"Laundry Room,Main Level","NST_LenderOwned":"No","Levels":"One","ListPrice":"1883491","ListingContractDate":"2026-03-23T05:00:00Z","ListingId":"NST7029942","LivingArea":"3749","Longitude":"-93.077348","LotFeatures":"Corner Lot,Sod Included in Price,Tree Coverage - Light","LotSizeArea":"0.335","LotSizeDimensions":"122 x 152","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1858","NST_ManufacturedHome":"N","NST_ModelHours":"Friday-Sunday noon-6pm","NST_ModelLocation":"2706 Lakeview Ct Little Canada MN 55117","OriginalEntryTimestamp":"2026-03-23T22:56:28Z","OtherStructures":"Storage Shed","ParcelNumber":"052922340070","NST_SchoolDistrictNumber":"2096","ParkingFeatures":"Attached Garage,Insulated Garage","NST_PatioPorchType":"Front Porch,Patio","PhotosCount":"4","PhotosChangeTimestamp":"2026-03-24T03:57:05.956Z","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55117","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Another amazing pre-sold under construction build by Hampton Companies in the Villas Of Gervais Lake! \n\nLots available for custom design build!\n\nCome visit us at our model for the Parade Of Homes March 13th-April 12th, Friday-Sunday noon-6pm or by appointment.\n\nModel location is 2706 Lakeview Ct, Little Canada MN 55117.\n\nDirections to model home:\n35E to Little Canada Road, East on Little Canada Road to Edgerton St. Take Left and go North on Edgerton about one block, take left on Lakeview Ct to model home on left(first home with for sale sign in yard).","PublicSurveyRange":"22","PublicSurveySection":"05","PublicSurveyTownship":"29","RoadFrontageType":"City Street,Curbs,Paved Streets,Storm Sewer","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less","NST_SchoolDistrictPhone":"6516351600","Sewer":"City Sewer/Connected","NST_SpecialSearch":"All Living Facilities on One Level,Main Floor Primary,Main Floor Laundry,Primary Bdr Suite","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Lakeview","StreetNumber":"2683","StreetNumberNumeric":"2683","StreetSuffix":"Court","SubdivisionName":"Villas Of Gervais Lake","TaxAnnualAmount":"940","NST_TaxWithAssessments":"940","TaxYear":"2025","BuildingAreaTotal":"3749","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"2026","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST67150","ListAgentMlsId":"NST506097009","ListOfficeMlsId":"NST8237","ListOfficeName":"Coldwell Banker Realty","ListOfficeKey":"NST16731","ModificationTimestamp":"2026-03-24T03:57:05.956Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7862827\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7862827/d542dc76-a7e5-4770-982f-cace3fb4fb3b.jpeg\",\"ImageWidth\":640,\"ImageHeight\":481,\"ImageSizeDescription\":\"640x481\",\"MediaModificationTimestamp\":\"2026-03-24T03:57:04.516Z\",\"MediaKey\":\"NST121086282\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7862827\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7862827/6ccbbd30-dad8-4ce6-b4b5-12489fd7bb59.jpeg\",\"ImageWidth\":640,\"ImageHeight\":481,\"ImageSizeDescription\":\"640x481\",\"MediaModificationTimestamp\":\"2026-03-24T03:57:04.52Z\",\"MediaKey\":\"NST121086280\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7862827\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7862827/c4d0cdb9-65d6-4f21-89e1-f5096b912a80.jpeg\",\"ImageWidth\":640,\"ImageHeight\":481,\"ImageSizeDescription\":\"640x481\",\"MediaModificationTimestamp\":\"2026-03-24T03:57:04.514Z\",\"MediaKey\":\"NST121086283\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7862827\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7862827/e8589695-58e8-4332-aaea-a6bb93cdddf3.jpeg\",\"ImageWidth\":640,\"ImageHeight\":481,\"ImageSizeDescription\":\"640x481\",\"MediaModificationTimestamp\":\"2026-03-24T03:57:04.512Z\",\"MediaKey\":\"NST121086281\"}]","Media__Order":"3","Media__MediaObjectID":"NST3","Media__ResourceRecordKey":"NST7862827","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7862827/d542dc76-a7e5-4770-982f-cace3fb4fb3b.jpeg","Media__ImageWidth":"640","Media__ImageHeight":"481","Media__ImageSizeDescription":"640x481","Media__MediaModificationTimestamp":"3/24/2026 3:57:04 AM","Media__MediaKey":"NST121086282","DocumentsChangeTimestamp":"2026-03-24T03:57:05.956Z","Rooms":"[{\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16 x 10\",\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116042334\"},{\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"18 x 18\",\"NST_RoomSortOrder\":10,\"RoomKey\":\"NST116042341\"},{\"RoomType\":\"Foyer\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116042336\"},{\"RoomType\":\"Great Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"18 x 18\",\"NST_RoomSortOrder\":14,\"RoomKey\":\"NST116042359\"},{\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"17 x 16\",\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116042331\"},{\"RoomType\":\"Laundry\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116042337\"},{\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"18 x 14\",\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116042332\"},{\"RoomType\":\"Mud Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116042335\"},{\"RoomType\":\"Porch\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16 x 14\",\"NST_RoomSortOrder\":9,\"RoomKey\":\"NST116042339\"},{\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"13 x 12\",\"NST_RoomSortOrder\":11,\"RoomKey\":\"NST116042342\"},{\"RoomType\":\"Sun Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16 x 14\",\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116042333\"},{\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"13 x 12\",\"NST_RoomSortOrder\":12,\"RoomKey\":\"NST116042343\"},{\"RoomType\":\"Walk-In Closet\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":8,\"RoomKey\":\"NST116042338\"},{\"RoomType\":\"Wine Cellar\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"12 x 10\",\"NST_RoomSortOrder\":13,\"RoomKey\":\"NST116042344\"}]","Rooms__RoomType":"Dining Room","Rooms__RoomLevel":"Main","Rooms__RoomDimensions":"16 x 10","Rooms__NST_RoomSortOrder":"4","Rooms__RoomKey":"NST116042334","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4","CustomVTourURL":""}
Box 152 Pine River, MN 56474
Doug Zaske, Owner/Broker
Office: 218.587.4424
Cell: 218.820.8688