Bay Lake Realty
Bruce Johnson
Broker/Owner
Bay Lake Realty is Licensed in the State of Minnesota
15929 Wakeman Rd.
Deerwood, MN 56444
Cell Phone: 218-838-1111
E-mail: bruce@baylakerealty.com
{"Id":1434142,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6820951","MLSAGENTID":"NST798549702","MLSCOAGENTID":"NST90099065","MLSOFFICEID":"NST26320","ADDRESS":"3806 Hampshire Avenue N","ACRES":0.19,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished","BATHSTOTAL":2.0,"BEDROOMS":4,"CITY":"Crystal","CONTINGENCY":"None","COUNTY":"Hennepin","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Other,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":318000.0,"LASTPRICEDATE":"2025-11-22T00:17:03.923","LATITUDE":45.024909,"LENDEROWNED":"No","LISTDATE":"2025-11-21T06:00:00","LISTPRICE":318000.0,"LIVINGAREA":1724.0,"LONGITUDE":-93.364756,"MODIFICATIONTIMESTAMP":"2025-11-22T11:05:04.84","OFFICE_OFFICENAME":"Opendoor Brokerage, LLC","PHOTOCOUNT":21,"POSTALCODE":"55427","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to this charming property that is sure to impress. The home boasts a neutral color paint scheme, providing a calming and inviting atmosphere. The partial flooring replacement adds a touch of modernity, enhancing the overall aesthetic of the property. This home is a perfect canvas for your personal touch. Don't miss out on this opportunity to own a home that combines elegance and comfort in one package. This home has been virtually staged to illustrate its potential.. Included 100-Day Home Warranty with buyer activation","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"281-Robbinsdale","SCHOOLDISTRICTPHONE":"763-504-8000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-11-22T00:17:03.923","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Hampshire","STREETNUMBER":"3806","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1959,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2025-11-22T00:16:03.96","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"listing_0.jpg\"},{\"Order\":2,\"Remarks\":\"VIRTUALLY STAGED\"},{\"Order\":3,\"Remarks\":\"listing_2.jpg\"},{\"Order\":4,\"Remarks\":\"VIRTUALLY STAGED\"},{\"Order\":5,\"Remarks\":\"listing_4.jpg\"},{\"Order\":6,\"Remarks\":\"listing_5.jpg\"},{\"Order\":7,\"Remarks\":\"listing_6.jpg\"},{\"Order\":8,\"Remarks\":\"listing_7.jpg\"},{\"Order\":9,\"Remarks\":\"listing_8.jpg\"},{\"Order\":10,\"Remarks\":\"listing_9.jpg\"},{\"Order\":11,\"Remarks\":\"listing_10.jpg\"},{\"Order\":12,\"Remarks\":\"listing_11.jpg\"},{\"Order\":13,\"Remarks\":\"listing_12.jpg\"},{\"Order\":14,\"Remarks\":\"listing_13.jpg\"},{\"Order\":15,\"Remarks\":\"listing_14.jpg\"},{\"Order\":16,\"Remarks\":\"listing_15.jpg\"},{\"Order\":17,\"Remarks\":\"listing_16.jpg\"},{\"Order\":18,\"Remarks\":\"listing_17.jpg\"},{\"Order\":19,\"Remarks\":\"listing_18.jpg\"},{\"Order\":20,\"Remarks\":\"listing_19.jpg\"},{\"Order\":21,\"Remarks\":\"listing_20.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21","SOURCE":"MG_NST"}
{"ListingKey":"NST7830150","LotSizeArea":"0.19","NST_AgeOfProperty":"66","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Finished","BasementYN":"True","BathroomsOneQuarter":"0","BathroomsFull":"2","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"4","CarportSpaces":"0","City":"Crystal","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Hennepin","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","Directions":"Head northwest on 36th Ave N toward Welcome Ave N\nTurn right onto Douglas Dr N\nTurn left onto 38th Ave N\nTurn right onto Hampshire Ave N","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Other,Vinyl Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"912","NST_FractionalOwnershipYN":"No","NST_Fuel":"Electric","ParkingFeatures":"None","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-11-22T00:13:04Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-11-22","Latitude":"45.024909","NST_LenderOwned":"No","ListAgentKey":"NST225984","ListAgentMlsId":"NST798549702","CoListAgentKey":"NST86971","CoListAgentMlsId":"NST90099065","ListingContractDate":"2025-11-21T06:00:00Z","ListOfficeKey":"NST26320","ListOfficeName":"Opendoor Brokerage, LLC","ListOfficeMlsId":"NST26320","ListPrice":"318000","LivingArea":"1724","Longitude":"-93.364756","LotSizeDimensions":"61*133","LotSizeSquareFeet":"8276.4","LotSizeUnits":"Acres","ListingId":"NST6820951","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"1711821440030","GarageSpaces":"0","PhotosCount":"21","PostalCity":"Minneapolis","PostalCode":"55427","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Welcome to this charming property that is sure to impress. The home boasts a neutral color paint scheme, providing a calming and inviting atmosphere. The partial flooring replacement adds a touch of modernity, enhancing the overall aesthetic of the property. This home is a perfect canvas for your personal touch. Don't miss out on this opportunity to own a home that combines elegance and comfort in one package. This home has been virtually staged to illustrate its potential.. Included 100-Day Home Warranty with buyer activation","PublicSurveyRange":"21","PublicSurveySection":"17","PublicSurveyTownship":"118","NST_RentalLicenseYN":"No","NST_AboveGradeSqFtTotal":"1037.0000","NST_BelowGradeSqFtTotal":"1037.0000","NST_MainLevelFinishedArea":"1037.0000","BuildingAreaTotal":"2074","HighSchoolDistrict":"Robbinsdale","NST_SchoolDistrictNumber":"281","NST_SchoolDistrictPhone":"763-504-8000","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1037","BelowGradeFinishedArea":"687","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"N","StreetName":"Hampshire","StreetNumber":"3806","StreetNumberNumeric":"3806","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Colonial Acres","NST_TaxWithAssessments":"4227.0000","TaxYear":"2025","TaxAnnualAmount":"4071","WaterSource":"City Water/Connected","YearBuilt":"1959","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-11-22T11:05:04.84Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7830150\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"listing_0.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/1aa01a6e-b27a-4011-a2ed-8d8b9aae43e0.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:57.01Z\",\"MediaKey\":\"692100bd21e86757482ddcc2\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"VIRTUALLY STAGED\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/74afc948-7a3e-4531-bcf5-99192b5972ba.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:57.106Z\",\"MediaKey\":\"692100bd21e86757482ddcc3\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"listing_2.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/ad2aadc9-5bf1-4606-bc6f-df92c3391cfc.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:56.99Z\",\"MediaKey\":\"692100bd21e86757482ddcc4\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"VIRTUALLY STAGED\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/1262d7ed-3695-430b-b6fb-44c248fa4112.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:56.984Z\",\"MediaKey\":\"692100bd21e86757482ddcc5\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"listing_4.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/2c90d0f6-ff2d-4576-9220-a976ce7dcfa1.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:57.002Z\",\"MediaKey\":\"692100bd21e86757482ddcc6\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"listing_5.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/b0ef8887-0a21-4bf3-832c-b23e5ad93813.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:56.992Z\",\"MediaKey\":\"692100bd21e86757482ddcc7\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"listing_6.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/f1f54ca6-a974-4a7f-aa09-6e2e5c58dfe5.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:56.996Z\",\"MediaKey\":\"692100bd21e86757482ddcc8\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"listing_7.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/c5fdba41-82c4-421b-849a-166398ffdf51.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:56.987Z\",\"MediaKey\":\"692100bd21e86757482ddcc9\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"listing_8.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/17766617-dc69-491b-ad94-697a7fd07628.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:56.984Z\",\"MediaKey\":\"692100bd21e86757482ddcca\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"listing_9.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/fe6dd5d0-f052-40e1-86f1-cf0260a4a1e2.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:57.019Z\",\"MediaKey\":\"692100bd21e86757482ddccb\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"listing_10.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/c7b19352-4ac1-4ec0-9d9b-38f4e3ff7c97.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:56.984Z\",\"MediaKey\":\"692100bd21e86757482ddccc\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"listing_11.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/8ec53102-be82-4ee0-8fe0-7a7eee80e136.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:57.006Z\",\"MediaKey\":\"692100bd21e86757482ddccd\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"listing_12.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/e8f7917c-7aa4-4178-8488-36b05f075dea.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:56.984Z\",\"MediaKey\":\"692100bd21e86757482ddcce\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"listing_13.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/6556ad30-8775-46c4-b28b-9a78003b7519.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:56.984Z\",\"MediaKey\":\"692100bd21e86757482ddccf\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"listing_14.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/b33c9592-2d2a-47ec-aa51-b8a6bbda3577.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:56.986Z\",\"MediaKey\":\"692100bd21e86757482ddcd0\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"listing_15.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1563,\"ImageSizeDescription\":\"2080x1563\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/fcfeb6cf-58be-4d1d-a5d8-dc3ba40afbbb.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:56.993Z\",\"MediaKey\":\"692100bd21e86757482ddcd1\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"listing_16.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/071fb571-c569-489f-bcbc-cd7fef19a196.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:56.984Z\",\"MediaKey\":\"692100bd21e86757482ddcd2\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":18,\"MediaObjectID\":\"18\",\"LongDescription\":\"listing_17.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/32184c57-f0e3-4f2e-8c78-afbd575d6f01.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:56.984Z\",\"MediaKey\":\"692100bd21e86757482ddcd3\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":19,\"MediaObjectID\":\"19\",\"LongDescription\":\"listing_18.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1555,\"ImageSizeDescription\":\"2080x1555\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/72b6a412-4498-447f-9e21-5b3c4cc7f955.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:57.025Z\",\"MediaKey\":\"692100bd21e86757482ddcd4\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":20,\"MediaObjectID\":\"20\",\"LongDescription\":\"listing_19.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/ea32b1f5-a6c5-4b4a-bf51-886d7993dd4a.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:57.014Z\",\"MediaKey\":\"692100bd21e86757482ddcd5\"},{\"ResourceRecordKey\":\"NST7830150\",\"Order\":21,\"MediaObjectID\":\"21\",\"LongDescription\":\"listing_20.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830150/2899966a-925f-4339-92d4-c63add85eafd.jpeg\",\"MediaModificationTimestamp\":\"2025-11-22T00:15:57.059Z\",\"MediaKey\":\"692100bd21e86757482ddcd6\"}]","PhotosChangeTimestamp":"2025-11-22T00:16:03.96Z","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"listing_0.jpg\"},{\"Order\":2,\"Remarks\":\"VIRTUALLY STAGED\"},{\"Order\":3,\"Remarks\":\"listing_2.jpg\"},{\"Order\":4,\"Remarks\":\"VIRTUALLY STAGED\"},{\"Order\":5,\"Remarks\":\"listing_4.jpg\"},{\"Order\":6,\"Remarks\":\"listing_5.jpg\"},{\"Order\":7,\"Remarks\":\"listing_6.jpg\"},{\"Order\":8,\"Remarks\":\"listing_7.jpg\"},{\"Order\":9,\"Remarks\":\"listing_8.jpg\"},{\"Order\":10,\"Remarks\":\"listing_9.jpg\"},{\"Order\":11,\"Remarks\":\"listing_10.jpg\"},{\"Order\":12,\"Remarks\":\"listing_11.jpg\"},{\"Order\":13,\"Remarks\":\"listing_12.jpg\"},{\"Order\":14,\"Remarks\":\"listing_13.jpg\"},{\"Order\":15,\"Remarks\":\"listing_14.jpg\"},{\"Order\":16,\"Remarks\":\"listing_15.jpg\"},{\"Order\":17,\"Remarks\":\"listing_16.jpg\"},{\"Order\":18,\"Remarks\":\"listing_17.jpg\"},{\"Order\":19,\"Remarks\":\"listing_18.jpg\"},{\"Order\":20,\"Remarks\":\"listing_19.jpg\"},{\"Order\":21,\"Remarks\":\"listing_20.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21","CustomVTourURL":""}