{"Id":614832,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7146919","MLSAGENTID":"NST502053623","MLSOFFICEID":"NST7125","ADDRESS":"1027 White Bear Avenue N","ACRES":0.119,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":2.0,"BEDROOMS":5.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":321000.0,"LASTPRICEDATE":"2026-09-18T19:41:10.447","LATITUDE":44.972337,"LENDEROWNED":"No","LISTDATE":"2026-09-18T05:00:00","LISTPRICE":321000.0,"LIVINGAREA":2578.0,"LONGITUDE":-93.025681,"MODIFICATIONTIMESTAMP":"2026-09-19T18:08:07.76","NEIGHBORHOOD":"92","OFFICE_OFFICENAME":"Bridge Realty, LLC","PHOTOCOUNT":14,"POSTALCODE":"55106","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"This 5-bedroom, 2 full bath home built in 2003 offers plenty of space with several recent updates already\ncompleted. Motivated sellers and a quick close is possible! The city-owned lot next door has been\nmaintained by the sellers and provides additional open space. Conveniently located near shopping,\nrestaurants, parks, schools, and major roadways. If you're looking for a move-in-ready home with lots of room at a great value, this one is a must-see!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-09-19T05:02:12.977","LASTSTATUS":"Coming Soon","STREETDIRSUFFIX":"N","STREETNAME":"White Bear","STREETNUMBER":"1027","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2005,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-09-19T18:08:07.76","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"FRONT OF HOUSE, BUILT IN EARLY 2000s\"},{\"Order\":2,\"Remarks\":\"ATTACHED 3 CAR GARAGE\"},{\"Order\":3,\"Remarks\":\"SPACIOUS OPEN FLOOR PLAN\"},{\"Order\":4,\"Remarks\":\"KITCHEN\"},{\"Order\":5,\"Remarks\":\"DINING ROOM\"},{\"Order\":6,\"Remarks\":\"VAULTED CEILINGS\"},{\"Order\":7,\"Remarks\":\"BEDROOM\"},{\"Order\":8,\"Remarks\":\"1027 White Bear Ave-13.jpg\"},{\"Order\":9,\"Remarks\":\"LARGE OPEN, LOWER LEVEL FAMILY ROOM\"},{\"Order\":10,\"Remarks\":\"LAUNDRY ROOM\"},{\"Order\":11,\"Remarks\":\"ATTACHED 3 CAR GARAGE\"},{\"Order\":12,\"Remarks\":\"SPACIOUS FRONT YARD\"},{\"Order\":13,\"Remarks\":\"LOT NEXT DOOR, MAINTAINED BY SELLER, THAT CANNOT BE BUILT ON\"},{\"Order\":14,\"Remarks\":\"LOT NEXT DOOR, MAINTAINED BY SELLER, THAT CANNOT BE BUILT ON\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14","SOURCE":"MG_NST"}
{"ListingKey":"NST7971908","NST_AboveGradeSqFtTotal":"1344","AboveGradeFinishedArea":"1344","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Vaulted Ceiling(s)","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"None","BasementYN":"False","BathroomsFull":"2","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"5","NST_BelowGradeSqFtTotal":"1234","BelowGradeFinishedArea":"1234","CumulativeDaysOnMarket":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"White Bear Ave S of Larpentur N of Minnehaha W on Ames off of Winebar to alley R of home","DocumentsCount":"2","DocumentsChangeTimestamp":"2026-09-18T23:17:08.35Z","DaysOnMarket":"0","NST_ExpectedMarketDate":"2026-09-19","ExteriorFeatures":"Vinyl","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"2878","FoundationDetails":"None","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"768","GarageSpaces":"3","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.972337","NST_LenderOwned":"No","Levels":"Split Entry (Bi-Level)","ListPrice":"321000","ListingContractDate":"2026-09-18T05:00:00Z","ListingId":"NST7146919","LivingArea":"2578","Longitude":"-93.025681","LotSizeArea":"0.119","LotSizeDimensions":"40x119","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"0","NST_ManufacturedHome":"N","NST_NeighborhoodName":"Greater East Side","NST_NeighborhoodNumber":"92","OriginalEntryTimestamp":"2026-09-19T00:00:09Z","ParcelNumber":"272922140049","ParkingFeatures":"Attached Garage","PhotosCount":"14","PhotosChangeTimestamp":"2026-09-19T18:08:07.76Z","PostalCity":"Saint Paul","PostalCode":"55106","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"This 5-bedroom, 2 full bath home built in 2003 offers plenty of space with several recent updates already\ncompleted. Motivated sellers and a quick close is possible! The city-owned lot next door has been\nmaintained by the sellers and provides additional open space. Conveniently located near shopping,\nrestaurants, parks, schools, and major roadways. If you're looking for a move-in-ready home with lots of room at a great value, this one is a must-see!","PublicSurveyRange":"22","PublicSurveySection":"27","PublicSurveyTownship":"29","NST_SchoolDistrictFullName":"625 - St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"White Bear","StreetNumber":"1027","StreetNumberNumeric":"1027","StreetSuffix":"Avenue","SubdivisionName":"Hazel Park","TaxAnnualAmount":"5672","NST_TaxWithAssessments":"5672","TaxYear":"2025","NST_TotalArea":"2578","BuildingAreaTotal":"2578","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"2005","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST516065","ListAgentMlsId":"NST502053623","ListOfficeMlsId":"NST7125","ListOfficeName":"Bridge Realty, LLC","ListOfficeKey":"NST10402","ModificationTimestamp":"2026-09-19T18:08:07.76Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7971908\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://media.mlsgrid.com/token=H5zR00cR_E8dcgg9vVudyY9w-Zif1nfte4ZMt4z3ofo&expires=1789847133&id=5d6fc86794c5224544394849/images/NST7971908/f0022244-8625-47f0-bdab-53c6a708e3fb.jpeg\",\"LongDescription\":\"DINING ROOM\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-09-19T18:08:05.796Z\",\"MediaKey\":\"NST124975148\"},{\"ResourceRecordKey\":\"NST7971908\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://media.mlsgrid.com/token=H5zR00cR_E8dcgg9vVudyY9w-Zif1nfte4ZMt4z3ofo&expires=1789847133&id=5d6fc86794c5224544394849/images/NST7971908/d20a9c2c-01b2-471f-83a9-7499945abd1e.jpeg\",\"LongDescription\":\"BEDROOM\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-09-19T18:08:05.796Z\",\"MediaKey\":\"NST124975157\"},{\"ResourceRecordKey\":\"NST7971908\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://media.mlsgrid.com/token=H5zR00cR_E8dcgg9vVudyY9w-Zif1nfte4ZMt4z3ofo&expires=1789847133&id=5d6fc86794c5224544394849/images/NST7971908/4fe67c4b-6922-4166-ad45-90accf3d8c42.jpeg\",\"LongDescription\":\"1027 White Bear Ave-13.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-09-19T18:08:05.765Z\",\"MediaKey\":\"NST124975283\"},{\"ResourceRecordKey\":\"NST7971908\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://media.mlsgrid.com/token=H5zR00cR_E8dcgg9vVudyY9w-Zif1nfte4ZMt4z3ofo&expires=1789847133&id=5d6fc86794c5224544394849/images/NST7971908/75cccf79-7a88-4368-aeaa-dcd80d0a8e45.jpeg\",\"LongDescription\":\"SPACIOUS OPEN FLOOR PLAN\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-09-19T18:08:05.765Z\",\"MediaKey\":\"NST124975080\"},{\"ResourceRecordKey\":\"NST7971908\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://media.mlsgrid.com/token=H5zR00cR_E8dcgg9vVudyY9w-Zif1nfte4ZMt4z3ofo&expires=1789847133&id=5d6fc86794c5224544394849/images/NST7971908/a04e1330-aa97-4742-b6a0-cd455cd82013.jpeg\",\"LongDescription\":\"ATTACHED 3 CAR GARAGE\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-09-19T18:08:05.788Z\",\"MediaKey\":\"NST124975077\"},{\"ResourceRecordKey\":\"NST7971908\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://media.mlsgrid.com/token=H5zR00cR_E8dcgg9vVudyY9w-Zif1nfte4ZMt4z3ofo&expires=1789847133&id=5d6fc86794c5224544394849/images/NST7971908/c412ec2c-df89-498d-b699-9df7cd22e848.jpeg\",\"LongDescription\":\"VAULTED CEILINGS\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-09-19T18:08:05.796Z\",\"MediaKey\":\"NST124975150\"},{\"ResourceRecordKey\":\"NST7971908\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"MediaURL\":\"https://media.mlsgrid.com/token=H5zR00cR_E8dcgg9vVudyY9w-Zif1nfte4ZMt4z3ofo&expires=1789847133&id=5d6fc86794c5224544394849/images/NST7971908/3d4ada14-da6f-4b7b-9d4e-c0e3e25f7c97.jpeg\",\"LongDescription\":\"LARGE OPEN, LOWER LEVEL FAMILY ROOM\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-09-19T18:08:05.763Z\",\"MediaKey\":\"NST124975196\"},{\"ResourceRecordKey\":\"NST7971908\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"MediaURL\":\"https://media.mlsgrid.com/token=H5zR00cR_E8dcgg9vVudyY9w-Zif1nfte4ZMt4z3ofo&expires=1789847133&id=5d6fc86794c5224544394849/images/NST7971908/15e2d230-a564-402e-9a82-e610caeb196d.jpeg\",\"LongDescription\":\"LOT NEXT DOOR, MAINTAINED BY SELLER, THAT CANNOT BE BUILT ON\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-09-19T18:08:05.788Z\",\"MediaKey\":\"NST124975289\"},{\"ResourceRecordKey\":\"NST7971908\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://media.mlsgrid.com/token=H5zR00cR_E8dcgg9vVudyY9w-Zif1nfte4ZMt4z3ofo&expires=1789847133&id=5d6fc86794c5224544394849/images/NST7971908/1f8aedcc-7876-4582-be46-2572928634ef.jpeg\",\"LongDescription\":\"KITCHEN\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-09-19T18:08:05.766Z\",\"MediaKey\":\"NST124975112\"},{\"ResourceRecordKey\":\"NST7971908\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://media.mlsgrid.com/token=H5zR00cR_E8dcgg9vVudyY9w-Zif1nfte4ZMt4z3ofo&expires=1789847133&id=5d6fc86794c5224544394849/images/NST7971908/660f02c7-214c-497e-b586-7518912431ac.jpeg\",\"LongDescription\":\"LAUNDRY ROOM\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-09-19T18:08:05.796Z\",\"MediaKey\":\"NST124975284\"},{\"ResourceRecordKey\":\"NST7971908\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"MediaURL\":\"https://media.mlsgrid.com/token=H5zR00cR_E8dcgg9vVudyY9w-Zif1nfte4ZMt4z3ofo&expires=1789847133&id=5d6fc86794c5224544394849/images/NST7971908/747fc4e6-b72e-4a5a-bb88-49775c032809.jpeg\",\"LongDescription\":\"ATTACHED 3 CAR GARAGE\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-09-19T18:08:05.796Z\",\"MediaKey\":\"NST124975285\"},{\"ResourceRecordKey\":\"NST7971908\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"MediaURL\":\"https://media.mlsgrid.com/token=H5zR00cR_E8dcgg9vVudyY9w-Zif1nfte4ZMt4z3ofo&expires=1789847133&id=5d6fc86794c5224544394849/images/NST7971908/369ea88b-3a1a-4e17-af32-eaa8022eae38.jpeg\",\"LongDescription\":\"SPACIOUS FRONT YARD\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-09-19T18:08:05.796Z\",\"MediaKey\":\"NST124975287\"},{\"ResourceRecordKey\":\"NST7971908\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"MediaURL\":\"https://media.mlsgrid.com/token=H5zR00cR_E8dcgg9vVudyY9w-Zif1nfte4ZMt4z3ofo&expires=1789847133&id=5d6fc86794c5224544394849/images/NST7971908/e7aa43c8-87eb-4c96-9778-c5c1a0f98ea1.jpeg\",\"LongDescription\":\"LOT NEXT DOOR, MAINTAINED BY SELLER, THAT CANNOT BE BUILT ON\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-09-19T18:08:05.821Z\",\"MediaKey\":\"NST124975288\"},{\"ResourceRecordKey\":\"NST7971908\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://media.mlsgrid.com/token=H5zR00cR_E8dcgg9vVudyY9w-Zif1nfte4ZMt4z3ofo&expires=1789847133&id=5d6fc86794c5224544394849/images/NST7971908/38acbc30-3863-4b6e-a9e6-eb83279c1189.jpeg\",\"LongDescription\":\"FRONT OF HOUSE, BUILT IN EARLY 2000s\",\"ImageWidth\":1448,\"ImageHeight\":1086,\"ImageSizeDescription\":\"1448x1086\",\"MediaModificationTimestamp\":\"2026-09-19T18:08:05.859Z\",\"MediaKey\":\"NST124968164\"}]","Media__ResourceRecordKey":"NST7971908","Media__Order":"5","Media__MediaObjectID":"NST5","Media__MediaURL":"https://media.mlsgrid.com/token=H5zR00cR_E8dcgg9vVudyY9w-Zif1nfte4ZMt4z3ofo&expires=1789847133&id=5d6fc86794c5224544394849/images/NST7971908/f0022244-8625-47f0-bdab-53c6a708e3fb.jpeg","Media__LongDescription":"DINING ROOM","Media__ImageWidth":"2080","Media__ImageHeight":"1386","Media__ImageSizeDescription":"2080x1386","Media__MediaModificationTimestamp":"9/19/2026 6:08:05 PM","Media__MediaKey":"NST124975148","Rooms":"[{\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116686309\",\"RoomDimensions\":\"15x8\",\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":9},{\"RoomLevel\":\"Lower\",\"RoomKey\":\"NST116686308\",\"RoomDimensions\":\"28x14\",\"RoomType\":\"Family Room\",\"NST_RoomSortOrder\":8},{\"RoomLevel\":\"Lower\",\"RoomKey\":\"NST116686305\",\"RoomDimensions\":\"12x14\",\"RoomType\":\"Bedroom 5\",\"NST_RoomSortOrder\":5},{\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116686301\",\"RoomDimensions\":\"17x11\",\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":1},{\"RoomLevel\":\"Lower\",\"RoomKey\":\"NST116686304\",\"RoomDimensions\":\"15x9\",\"RoomType\":\"Bedroom 4\",\"NST_RoomSortOrder\":4},{\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116686306\",\"RoomDimensions\":\"13x10\",\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":6},{\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116686307\",\"RoomDimensions\":\"14x11\",\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":7},{\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116686302\",\"RoomDimensions\":\"13x11\",\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":2},{\"RoomLevel\":\"Lower\",\"RoomKey\":\"NST116686303\",\"RoomDimensions\":\"13x11\",\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":3}]","Rooms__RoomLevel":"Upper","Rooms__RoomKey":"NST116686309","Rooms__RoomDimensions":"15x8","Rooms__RoomType":"Dining Room","Rooms__NST_RoomSortOrder":"9","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"FRONT OF HOUSE, BUILT IN EARLY 2000s\"},{\"Order\":2,\"Remarks\":\"ATTACHED 3 CAR GARAGE\"},{\"Order\":3,\"Remarks\":\"SPACIOUS OPEN FLOOR PLAN\"},{\"Order\":4,\"Remarks\":\"KITCHEN\"},{\"Order\":5,\"Remarks\":\"DINING ROOM\"},{\"Order\":6,\"Remarks\":\"VAULTED CEILINGS\"},{\"Order\":7,\"Remarks\":\"BEDROOM\"},{\"Order\":8,\"Remarks\":\"1027 White Bear Ave-13.jpg\"},{\"Order\":9,\"Remarks\":\"LARGE OPEN, LOWER LEVEL FAMILY ROOM\"},{\"Order\":10,\"Remarks\":\"LAUNDRY ROOM\"},{\"Order\":11,\"Remarks\":\"ATTACHED 3 CAR GARAGE\"},{\"Order\":12,\"Remarks\":\"SPACIOUS FRONT YARD\"},{\"Order\":13,\"Remarks\":\"LOT NEXT DOOR, MAINTAINED BY SELLER, THAT CANNOT BE BUILT ON\"},{\"Order\":14,\"Remarks\":\"LOT NEXT DOOR, MAINTAINED BY SELLER, THAT CANNOT BE BUILT ON\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14","CustomVTourURL":""}