{"Id":587792,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7111778","MLSAGENTID":"NST805526593","MLSOFFICEID":"NST252031","ADDRESS":"4044 Gisella Boulevard","ACRES":0.258,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full","BATHSTOTAL":1.0,"BEDROOMS":3.0,"CITY":"White Bear Lake","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":259900.0,"LASTPRICEDATE":"2026-07-17T23:52:06.507","LATITUDE":45.063668,"LENDEROWNED":"No","LISTDATE":"2026-07-17T05:00:00","LISTPRICE":259900.0,"LIVINGAREA":1024.0,"LONGITUDE":-92.998863,"MODIFICATIONTIMESTAMP":"2026-07-18T00:09:08.09","OFFICE_OFFICENAME":"Entera Realty LLC","PHOTOCOUNT":4,"POSTALCODE":"55110","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Secure a highly desirable asset just blocks from the shores of White Bear Lake. This classic three-bedroom, one-bathroom single-story rambler offers an exceptional foundation for building immediate equity or strengthening a rental portfolio.\n\nStep inside to a bright, inviting layout where abundant natural light highlights original hardwood flooring stretching seamlessly across the main level. The functional kitchen comes fully equipped with essential appliances and generous cabinet storage, providing smooth access to the primary living areas and three comfortable bedrooms. Crucial everyday conveniences are already in place, including central cooling and dedicated washer and dryer hookups.\n\nThe ultimate value-add opportunity awaits below. A full, expansive basement provides a massive blank canvas ready for your specific finishing touches, allowing you to easily expand the finished square footage and drive instant equity.\n\nOutside, the private backyard oasis features an outdoor pool, creating a premium outdoor amenity for future occupants to enjoy during hot summer days.\n\nLocation drives lasting value, and this property delivers. Situated in a quiet neighborhood within the top-rated White Bear Lake School District, the home ensures enduring demand. Residents will appreciate immediate access to Sunrise Park Middle School, nearby local parks, public beaches, and major transit routes. Capitalize on this outstanding opportunity and schedule your tour today.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"624-White Bear Lake","SCHOOLDISTRICTPHONE":"6514077500","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-07-17T23:52:06.507","LASTSTATUS":"Active","STREETNAME":"Gisella","STREETNUMBER":"4044","STREETSUFFIX":"Boulevard","STYLE":"Single Family","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1955,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-07-17T23:52:06.508","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_7520 Annie Pearson.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_7571 Annie Pearson.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_7553 Annie Pearson.jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_7542 Annie Pearson.jpeg\"}]","PHOTOORDER":"1,2,3,4","SOURCE":"MG_NST"}
{"ListingKey":"NST7936580","NST_AboveGradeSqFtTotal":"1024","AboveGradeFinishedArea":"1024","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Full","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"1008","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"White Bear Lake","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","Directions":"From I-35E North, take Exit 115 for County Rd E. Head east on County Rd E, turn left (North) onto McKnight Rd N, turn right onto Gisella Blvd, and follow it around. The property will be on your left","DocumentsCount":"3","DocumentsChangeTimestamp":"2026-07-18T00:01:06.742Z","DaysOnMarket":"0","ExteriorFeatures":"Wood","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"1008","FoundationDetails":"Other","NST_FractionalOwnershipYN":"No","NST_Fuel":"Electric","NST_GarageSquareFeet":"528","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"White Bear Lake","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.063668","NST_LenderOwned":"No","Levels":"One","ListPrice":"259900","ListingContractDate":"2026-07-17T05:00:00Z","ListingId":"NST7111778","LivingArea":"1024","LockBoxType":"Combo","Longitude":"-92.998863","LotSizeArea":"0.258","LotSizeDimensions":"75X150","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1024","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-07-17T18:51:21Z","ParcelNumber":"253022210041","ParkingFeatures":"Detached Garage","PhotosCount":"4","PhotosChangeTimestamp":"2026-07-17T23:52:06.508Z","PoolFeatures":"Outdoor","PostalCity":"White Bear Lake","PostalCode":"55110","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Secure a highly desirable asset just blocks from the shores of White Bear Lake. This classic three-bedroom, one-bathroom single-story rambler offers an exceptional foundation for building immediate equity or strengthening a rental portfolio.\n\nStep inside to a bright, inviting layout where abundant natural light highlights original hardwood flooring stretching seamlessly across the main level. The functional kitchen comes fully equipped with essential appliances and generous cabinet storage, providing smooth access to the primary living areas and three comfortable bedrooms. Crucial everyday conveniences are already in place, including central cooling and dedicated washer and dryer hookups.\n\nThe ultimate value-add opportunity awaits below. A full, expansive basement provides a massive blank canvas ready for your specific finishing touches, allowing you to easily expand the finished square footage and drive instant equity.\n\nOutside, the private backyard oasis features an outdoor pool, creating a premium outdoor amenity for future occupants to enjoy during hot summer days.\n\nLocation drives lasting value, and this property delivers. Situated in a quiet neighborhood within the top-rated White Bear Lake School District, the home ensures enduring demand. Residents will appreciate immediate access to Sunrise Park Middle School, nearby local parks, public beaches, and major transit routes. Capitalize on this outstanding opportunity and schedule your tour today.","PublicSurveyRange":"22","PublicSurveySection":"25","PublicSurveyTownship":"30","RoadFrontageType":"Paved Streets","RoadResponsibility":"Public Maintained Road","NST_SchoolDistrictFullName":"624 - White Bear Lake","NST_SchoolDistrictNumber":"624","NST_SchoolDistrictPhone":"6514077500","Sewer":"City Sewer/Connected","NST_SingleFamilySubType":"Ranch-Style Home","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Gisella","StreetNumber":"4044","StreetNumberNumeric":"4044","StreetSuffix":"Boulevard","SubdivisionName":"Normandy Park","TaxAnnualAmount":"4228","NST_TaxWithAssessments":"4228","TaxYear":"2025","NST_TotalArea":"2032","BuildingAreaTotal":"2032","Township":"White Bear Lake","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1955","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST523101","ListAgentMlsId":"NST805526593","ListOfficeMlsId":"NST252031","ListOfficeName":"Entera Realty LLC","ListOfficeKey":"NST1000775","ModificationTimestamp":"2026-07-18T00:09:08.09Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7936580/3aa0a805-15d9-4a27-b192-fce3e2ccd97b.jpeg\",\"ResourceRecordKey\":\"NST7936580\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"IMG_7542 Annie Pearson.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-17T23:52:04.976Z\",\"MediaKey\":\"NST123682640\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7936580/0b5c5dcf-e959-4066-905d-2f0d30d72e93.jpeg\",\"ResourceRecordKey\":\"NST7936580\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"IMG_7571 Annie Pearson.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-07-17T23:52:04.94Z\",\"MediaKey\":\"NST123681689\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7936580/1b66050b-1716-431d-af8d-6718c565e41a.jpeg\",\"ResourceRecordKey\":\"NST7936580\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"IMG_7520 Annie Pearson.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-17T23:52:04.975Z\",\"MediaKey\":\"NST123682639\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7936580/2787140e-2709-423e-8bfe-08f0d0a767af.jpeg\",\"ResourceRecordKey\":\"NST7936580\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"IMG_7553 Annie Pearson.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-07-17T23:52:05.005Z\",\"MediaKey\":\"NST123682641\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7936580/3aa0a805-15d9-4a27-b192-fce3e2ccd97b.jpeg","Media__ResourceRecordKey":"NST7936580","Media__Order":"4","Media__MediaObjectID":"NST4","Media__LongDescription":"IMG_7542 Annie Pearson.jpeg","Media__ImageWidth":"2080","Media__ImageHeight":"1560","Media__ImageSizeDescription":"2080x1560","Media__MediaModificationTimestamp":"7/17/2026 11:52:04 PM","Media__MediaKey":"NST123682640","Rooms":"[{\"RoomKey\":\"NST116472974\",\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3},{\"RoomKey\":\"NST116472973\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2},{\"RoomKey\":\"NST116472972\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1},{\"RoomKey\":\"NST116472975\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4},{\"RoomKey\":\"NST116472976\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":5}]","Rooms__RoomKey":"NST116472974","Rooms__RoomType":"Bedroom","Rooms__RoomLevel":"Main","Rooms__NST_RoomSortOrder":"3","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"IMG_7520 Annie Pearson.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_7571 Annie Pearson.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_7553 Annie Pearson.jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_7542 Annie Pearson.jpeg\"}]","PhotoOrder":"1,2,3,4","CustomVTourURL":""}