{"Id":593419,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7119197","MLSAGENTID":"NST506094595","MLSCOAGENTID":"NST496505467","MLSOFFICEID":"NST1865","ADDRESS":"556 Constance Boulevard NW","ACRES":0.99,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Block,Finished,Partially Finished,Unfinished","BATHSTOTAL":2.0,"BEDROOMS":3.0,"CITY":"Andover","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Block","FORECLOSURE":"No","LASTPRICE":289900.0,"LASTPRICEDATE":"2026-07-30T23:08:06.41","LATITUDE":45.261887,"LENDEROWNED":"No","LISTDATE":"2026-07-30T05:00:00","LISTPRICE":289900.0,"LIVINGAREA":1435.0,"LONGITUDE":-93.280061,"LOTDESCRIPTION":"Irregular Lot,Tree Coverage - Medium","MODIFICATIONTIMESTAMP":"2026-07-31T17:18:10.374","OFFICE_OFFICENAME":"Keller Williams Classic Realty","OUTBUILDINGS":"Lean-To","PHOTOCOUNT":4,"POSTALCODE":"55304","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Opportunity awaits with this diamond in the rough! This handman special is the perfect fixer-upper for investors, renovators or buyers looking to build equity. The split-entry home features 3 bedrooms, 2 bathrooms, and offers endless potential to make it your own. while the home is in need of updating throughout, it has a functional layout and a great foundation for your renovation ideas.\nSituated on nearly 1 acre (0.99 acres), the property provides plenty of room to enjoy the outdoors, expand or create your ideal backyard retreat. As an added bonus, the seller will install a new well prior to closing, and the septic system is compliant. \nBring your vision and imagination-this property is full of possibilities and is ready for its next chapter!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years,Asphalt","SCHOOLDISTRICTNUMBER":"11-Anoka-Hennepin","SCHOOLDISTRICTPHONE":"7635061000","SEWER":"Septic System Compliant - Yes","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-07-30T23:08:06.41","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"Constance","STREETNUMBER":"556","STREETSUFFIX":"Boulevard","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"Well","WATERFRONTPRESENT":false,"YEARBUILT":1970,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-07-31T16:44:07.05","PHOTOORDER":"1,2,3,4","SOURCE":"MG_NST"}
{"ListingKey":"NST7944006","NST_AboveGradeSqFtTotal":"1035","AboveGradeFinishedArea":"1035","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"Yes","NST_AmenitiesUnit":"Ceiling Fan(s),Washer/Dryer Hookup","Appliances":"Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Block,Finished,Partially Finished,Unfinished","BasementYN":"True","NST_BathDesc":"3/4 Basement,Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"1035","BelowGradeFinishedArea":"400","CumulativeDaysOnMarket":"0","City":"Andover","ConstructionMaterials":"Block","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Anoka","NST_DPResource":"Yes","NST_DiningRoomDescription":"Eat In Kitchen","Directions":"Hanson Blvd North to 161st Ave NW/Constance Blvd NW to property.","DocumentsCount":"6","DocumentsChangeTimestamp":"2026-07-30T23:07:06.813Z","DaysOnMarket":"0","Electric":"Circuit Breakers,100 Amp Service","ExteriorFeatures":"Vinyl,Wood","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"1035","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"528","NST_GarageDimensions":"25 x 25","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Anoka-Hennepin","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.261887","LaundryFeatures":"In Basement","NST_LenderOwned":"No","Levels":"Split Entry (Bi-Level)","ListPrice":"289900","ListingContractDate":"2026-07-30T05:00:00Z","ListingId":"NST7119197","LivingArea":"1435","Longitude":"-93.280061","LotFeatures":"Irregular Lot,Tree Coverage - Medium","LotSizeArea":"0.99","LotSizeDimensions":"208*171","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1035","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-07-30T18:06:52Z","OtherStructures":"Lean-To","ParcelNumber":"133224310002","ParkingFeatures":"Attached Garage,Concrete","NST_PatioPorchType":"Deck","PhotosCount":"4","PhotosChangeTimestamp":"2026-07-31T16:44:07.05Z","PoolFeatures":"None","PostalCity":"Andover","PostalCode":"55304","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Opportunity awaits with this diamond in the rough! This handman special is the perfect fixer-upper for investors, renovators or buyers looking to build equity. The split-entry home features 3 bedrooms, 2 bathrooms, and offers endless potential to make it your own. while the home is in need of updating throughout, it has a functional layout and a great foundation for your renovation ideas.\nSituated on nearly 1 acre (0.99 acres), the property provides plenty of room to enjoy the outdoors, expand or create your ideal backyard retreat. As an added bonus, the seller will install a new well prior to closing, and the septic system is compliant. \nBring your vision and imagination-this property is full of possibilities and is ready for its next chapter!","PublicSurveyRange":"24","PublicSurveySection":"13","PublicSurveyTownship":"32","RoadFrontageType":"City Street","RoadResponsibility":"Public Maintained Road","Roof":"Age Over 8 Years,Asphalt","NST_SchoolDistrictFullName":"11 - Anoka-Hennepin","NST_SchoolDistrictNumber":"11","NST_SchoolDistrictPhone":"7635061000","Sewer":"Septic System Compliant - Yes","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"NW","StreetName":"Constance","StreetNumber":"556","StreetNumberNumeric":"556","StreetSuffix":"Boulevard","TaxAnnualAmount":"2852","NST_TaxWithAssessments":"2852","TaxYear":"2026","NST_TotalArea":"2070","BuildingAreaTotal":"2070","Township":"Andover","VideosCount":"0","WaterSource":"Well","WaterfrontYN":"False","YearBuilt":"1970","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST66775","CoListAgentMlsId":"NST496505467","CoListOfficeName":"Keller Williams Classic Realty","ListAgentKey":"NST78780","ListAgentMlsId":"NST506094595","ListOfficeMlsId":"NST1865","ListOfficeName":"Keller Williams Classic Realty","ListOfficeKey":"NST14003","ModificationTimestamp":"2026-07-31T17:18:10.374Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7944006\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944006/c7a52a5e-730f-42be-a150-56c3edd6dc24.jpeg\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaModificationTimestamp\":\"2026-07-31T16:43:12.077Z\",\"MediaKey\":\"NST123968408\"},{\"ResourceRecordKey\":\"NST7944006\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944006/19c8f6eb-5bcb-4e88-986b-b4c122f6055b.jpeg\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-07-31T16:43:12.077Z\",\"MediaKey\":\"NST123968409\"},{\"ResourceRecordKey\":\"NST7944006\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944006/58502a62-f660-4d6f-87e7-52965ff0cd3c.jpeg\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":640,\"ImageHeight\":480,\"ImageSizeDescription\":\"640x480\",\"MediaModificationTimestamp\":\"2026-07-31T16:43:12.077Z\",\"MediaKey\":\"NST123968410\"},{\"ResourceRecordKey\":\"NST7944006\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7944006/577c8d9a-8a11-4c05-be77-14b0c20404a2.jpeg\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-31T16:43:12.134Z\",\"MediaKey\":\"NST123953297\"}]","Media__ResourceRecordKey":"NST7944006","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7944006/c7a52a5e-730f-42be-a150-56c3edd6dc24.jpeg","Media__Order":"3","Media__MediaObjectID":"NST3","Media__ImageWidth":"640","Media__ImageHeight":"480","Media__ImageSizeDescription":"640x480","Media__MediaModificationTimestamp":"7/31/2026 4:43:12 PM","Media__MediaKey":"NST123968408","Rooms":"[{\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116518163\",\"NST_RoomSortOrder\":7,\"RoomType\":\"Bathroom\",\"RoomDimensions\":\"8 x 6\"},{\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116518157\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Deck\",\"RoomDimensions\":\"12 x 24\"},{\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116518158\",\"NST_RoomSortOrder\":2,\"RoomType\":\"Dining Room\",\"RoomDimensions\":\"7 x 8\"},{\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116518160\",\"NST_RoomSortOrder\":4,\"RoomType\":\"Family Room\",\"RoomDimensions\":\"13 x 17.5\"},{\"RoomLevel\":\"Lower\",\"RoomKey\":\"NST116518164\",\"NST_RoomSortOrder\":8,\"RoomType\":\"Family Room\",\"RoomDimensions\":\"21 x 13\"},{\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116518161\",\"NST_RoomSortOrder\":5,\"RoomType\":\"Bedroom\",\"RoomDimensions\":\"11 x 11.5\"},{\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116518159\",\"NST_RoomSortOrder\":3,\"RoomType\":\"Kitchen\",\"RoomDimensions\":\"9 x 11\"},{\"RoomLevel\":\"Lower\",\"RoomKey\":\"NST116518166\",\"NST_RoomSortOrder\":10,\"RoomType\":\"Laundry\",\"RoomDimensions\":\"10 x 16\"},{\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116518162\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Bedroom 2\",\"RoomDimensions\":\"13.5 x 11.5\"},{\"RoomLevel\":\"Lower\",\"RoomKey\":\"NST116518165\",\"NST_RoomSortOrder\":9,\"RoomType\":\"Bedroom 3\",\"RoomDimensions\":\"10 x 12\"}]","Rooms__RoomLevel":"Main","Rooms__RoomKey":"NST116518163","Rooms__NST_RoomSortOrder":"7","Rooms__RoomType":"Bathroom","Rooms__RoomDimensions":"8 x 6","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4","CustomVTourURL":""}