{"Id":525634,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7031866","MLSAGENTID":"NST506009471","MLSOFFICEID":"NST10432","ADDRESS":"1542 Ivy Avenue E","ACRES":0.234,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Full","BATHSTOTAL":1.0,"BEDROOMS":3.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Block","FORECLOSURE":"No","LASTPRICE":199000.0,"LASTPRICEDATE":"2026-03-06T14:51:06.237","LATITUDE":44.980844,"LENDEROWNED":"No","LISTDATE":"2026-03-05T06:00:00","LISTPRICE":199000.0,"LIVINGAREA":864.0,"LONGITUDE":-93.035196,"MODIFICATIONTIMESTAMP":"2026-03-06T17:28:07.221","NEIGHBORHOOD":"92","OFFICE_OFFICENAME":"Keller Williams Premier Realty","PHOTOCOUNT":2,"POSTALCODE":"55106","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"On an oversized corner lot just blocks from Lake Phalen, this 3-bedroom home offers a great opportunity to build equity with your own personal updates. Hardwood floors, a newer roof and siding, and a solid layout provide a strong foundation to work with. The unfinished lower level offers additional potential for future living space. You’ll find a three-car garage with one being an extra-deep stall, perfect for storage or a workshop. A great option for buyers looking to customize a home or investors seeking their next project while enjoying nearby parks, trails, and lake access.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-03-06T14:51:06.237","LASTSTATUS":"Active","STREETDIRSUFFIX":"E","STREETNAME":"Ivy","STREETNUMBER":"1542","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1928,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-03-06T14:51:06.235","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front of home\"},{\"Order\":2,\"Remarks\":\"Back of home\"}]","PHOTOORDER":"1,2","SOURCE":"MG_NST"}
{"ListingKey":"NST7864390","NST_AboveGradeSqFtTotal":"864","AboveGradeFinishedArea":"864","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Hardwood Floors","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Block,Full","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"1566","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"1","City":"Saint Paul","ConstructionMaterials":"Block","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Ramsey","Directions":"N., on Prosperity Ave, about 2 blocks to W., on Ivy Ave, about 1/2 block to home on Left.","DocumentsCount":"3","DocumentsChangeTimestamp":"2026-03-06T16:56:06.015Z","DaysOnMarket":"1","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"1566","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"702","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.980844","NST_LenderOwned":"No","Levels":"One","ListPrice":"199000","ListingContractDate":"2026-03-05T06:00:00Z","ListingId":"NST7031866","LivingArea":"864","Longitude":"-93.035196","LotSizeArea":"0.234","LotSizeDimensions":"68x150","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"864","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"92","OriginalEntryTimestamp":"2026-03-06T08:49:19Z","ParcelNumber":"222922430035","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Attached Garage,Tandem Garage","PhotosCount":"2","PhotosChangeTimestamp":"2026-03-06T14:51:06.235Z","PostalCity":"Saint Paul","PostalCode":"55106","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","PublicRemarks":"On an oversized corner lot just blocks from Lake Phalen, this 3-bedroom home offers a great opportunity to build equity with your own personal updates. Hardwood floors, a newer roof and siding, and a solid layout provide a strong foundation to work with. The unfinished lower level offers additional potential for future living space. You’ll find a three-car garage with one being an extra-deep stall, perfect for storage or a workshop. A great option for buyers looking to customize a home or investors seeking their next project while enjoying nearby parks, trails, and lake access.","PublicSurveyRange":"22","PublicSurveySection":"22","PublicSurveyTownship":"29","Roof":"Age 8 Years or Less","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"E","StreetName":"Ivy","StreetNumber":"1542","StreetNumberNumeric":"1542","StreetSuffix":"Avenue","SubdivisionName":"Section 22 Town 29 Range 22","TaxAnnualAmount":"3772","NST_TaxWithAssessments":"3772","TaxYear":"2025","BuildingAreaTotal":"2430","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1928","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST99593","ListAgentMlsId":"NST506009471","ListOfficeMlsId":"NST10432","ListOfficeName":"Keller Williams Premier Realty","ListOfficeKey":"NST17166","ModificationTimestamp":"2026-03-06T17:28:07.221Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7864390/ebb019bf-dc03-4f14-a442-55014ece7f29.jpeg\",\"LongDescription\":\"Front of home\",\"ResourceRecordKey\":\"NST7864390\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":1732,\"ImageHeight\":1154,\"ImageSizeDescription\":\"1732x1154\",\"MediaModificationTimestamp\":\"2026-03-06T14:50:10.15Z\",\"MediaKey\":\"NST120801128\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7864390/ec12f97d-088f-4141-9233-792a2b112650.jpeg\",\"LongDescription\":\"Back of home\",\"ResourceRecordKey\":\"NST7864390\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":1734,\"ImageHeight\":1294,\"ImageSizeDescription\":\"1734x1294\",\"MediaModificationTimestamp\":\"2026-03-06T14:50:10.205Z\",\"MediaKey\":\"NST120801127\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7864390/ebb019bf-dc03-4f14-a442-55014ece7f29.jpeg","Media__LongDescription":"Front of home","Media__ResourceRecordKey":"NST7864390","Media__Order":"1","Media__MediaObjectID":"NST1","Media__ImageWidth":"1732","Media__ImageHeight":"1154","Media__ImageSizeDescription":"1732x1154","Media__MediaModificationTimestamp":"3/6/2026 2:50:10 PM","Media__MediaKey":"NST120801128","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front of home\"},{\"Order\":2,\"Remarks\":\"Back of home\"}]","PhotoOrder":"1,2","CustomVTourURL":""}