$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Opendoor Brokerage, LLC 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. LongvilleLakes.com is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of LongvilleLakes.com, 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. LongvilleLakes.com is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of LongvilleLakes.com, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"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-22T00:17:03.922","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","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-21","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-22T00:17:03.922Z","PhotosChangeTimestamp":"2025-11-22T00:16:03.96Z","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\"}]","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":""}