{"Id":542391,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7054513","MLSAGENTID":"NST506011917","MLSOFFICEID":"NST12127","ADDRESS":"651 Ivy Avenue E","ACRES":0.14,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full,Unfinished","BATHSTOTAL":2.0,"BEDROOMS":6.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":339900.0,"LASTPRICEDATE":"2026-04-15T20:42:08.06","LATITUDE":44.98130324,"LENDEROWNED":"Yes","LISTDATE":"2026-04-15T05:00:00","LISTPRICE":339900.0,"LIVINGAREA":2814.0,"LONGITUDE":-93.07312808,"MODIFICATIONTIMESTAMP":"2026-04-16T10:06:11.237","NEIGHBORHOOD":"98","OFFICE_OFFICENAME":"RES Realty","PHOTOCOUNT":9,"POSTALCODE":"55106","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Great cash-flow opportunity! Up/down duplex near downtown St. Paul featuring a 3BR/1BA unit and a 4BR/2BA unit, each with separate kitchen and bath. Fully occupied with immediate rental income. Large fenced backyard and oversized one-car garage. Convenient location near shopping, dining, transit, and easy access to I-94 & I-35E. Excellent addition to any investment portfolio","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Other","SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-04-15T20:42:08.06","LASTSTATUS":"Active","STREETDIRSUFFIX":"E","STREETNAME":"Ivy","STREETNUMBER":"651","STREETSUFFIX":"Avenue","STYLE":"Duplex Up and Down","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1915,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-04-15T21:02:06.509","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"e3773543-9547-475e-a21e-00397d8966b4.JPG\"},{\"Order\":2,\"Remarks\":\"4c593828-c0cb-4860-86db-59a1dcf1f7b4.JPG\"},{\"Order\":3,\"Remarks\":\"28dff535-1736-4edf-bf94-a1c4ef28cc8d.JPG\"},{\"Order\":4,\"Remarks\":\"5854f1e1-8ea8-44cc-a9a5-63c870b9224d.JPG\"},{\"Order\":5,\"Remarks\":\"1980b983-e0dd-4070-8df1-d85d938f6c7c.JPG\"},{\"Order\":6,\"Remarks\":\"00d1b74f-2ce0-4b4c-a703-98ba0930e3a7.JPG\"},{\"Order\":7,\"Remarks\":\"994c5f08-b6bd-4c45-bfe5-4ab3f196a583.JPG\"},{\"Order\":8,\"Remarks\":\"46145414-414e-42a5-b70e-73aeb3fc2bee.JPG\"},{\"Order\":9,\"Remarks\":\"d89a4771-a9f1-46c8-a081-2e5aab6815e4.JPG\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9","SOURCE":"MG_NST"}
{"ListingKey":"NST7884586","NST_AboveGradeSqFtTotal":"2814","AboveGradeFinishedArea":"2814","AccessibilityFeatures":"Doors 36\"+","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AssessmentPending":"No","Basement":"Full,Unfinished","BasementYN":"True","BathroomsTotalInteger":"2","BedroomsTotal":"6","NST_BelowGradeSqFtTotal":"1222","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"Take I-94 E to Maryland Ave E in Saint Paul. Take exit 109 from I-35E N Continue on Maryland Ave E. Drive to Ivy Ave E.","DocumentsCount":"0","DaysOnMarket":"0","ElectricExpense":"0","Fencing":"Wood","FoundationArea":"1222","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","FuelExpense":"0","NST_GarageSquareFeet":"200","GarageSpaces":"1","GrossIncome":"0","Heating":"Baseboard,Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InsuranceExpense":"0","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.9813032364","NST_LenderOwned":"Yes","Levels":"Two","ListPrice":"339900","ListingContractDate":"2026-04-15T05:00:00Z","ListingId":"NST7054513","LivingArea":"2814","Longitude":"-93.0731280804","LotSizeArea":"0.14","LotSizeDimensions":"55x110","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1222","MaintenanceExpense":"0","ManagerExpense":"0","NST_RefrigeratorNum":"Two","NST_NeighborhoodNumber":"98","NumberOfUnitsTotal":"2","OperatingExpense":"0","OriginalEntryTimestamp":"2026-04-15T15:41:08Z","OtherExpense":"0","NST_OwnerOccupied":"No","ParcelNumber":"202922420218","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Detached Garage","PhotosCount":"9","PhotosChangeTimestamp":"2026-04-15T21:02:06.509Z","PostalCity":"Saint Paul","PostalCode":"55106","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PropertySubType":"Duplex Up and Down","PropertyType":"Residential Income","PublicRemarks":"Great cash-flow opportunity! Up/down duplex near downtown St. Paul featuring a 3BR/1BA unit and a 4BR/2BA unit, each with separate kitchen and bath. Fully occupied with immediate rental income. Large fenced backyard and oversized one-car garage. Convenient location near shopping, dining, transit, and easy access to I-94 & I-35E. Excellent addition to any investment portfolio","Roof":"Other","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"E","StreetName":"Ivy","StreetNumber":"651","StreetNumberNumeric":"651","StreetSuffix":"Avenue","TaxAnnualAmount":"13397","NST_TaxWithAssessments":"13397","TaxYear":"2026","BuildingAreaTotal":"4036","Township":"Saint Paul","TrashExpense":"0","VideosCount":"0","WaterSewerExpense":"0","WaterSource":"City Water/Connected","YearBuilt":"1915","ZoningDescription":"Residential-Multi-Family","ListAgentKey":"NST102459","ListAgentMlsId":"NST506011917","ListOfficeMlsId":"NST12127","ListOfficeName":"RES Realty","ListOfficeKey":"NST17084","ModificationTimestamp":"2026-04-16T10:06:11.237Z","OriginatingSystemName":"northstar","Media":"[{\"LongDescription\":\"d89a4771-a9f1-46c8-a081-2e5aab6815e4.JPG\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7884586\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7884586/91a05233-dafb-455b-ae55-e452ef5027ed.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-04-15T21:01:26.918Z\",\"MediaKey\":\"NST121551151\"},{\"LongDescription\":\"00d1b74f-2ce0-4b4c-a703-98ba0930e3a7.JPG\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7884586\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7884586/4744f581-b149-4f2b-85e5-208f94a396e6.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-04-15T21:01:26.923Z\",\"MediaKey\":\"NST121551158\"},{\"LongDescription\":\"994c5f08-b6bd-4c45-bfe5-4ab3f196a583.JPG\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7884586\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7884586/93f5a5f7-f3b5-49ea-bf42-f3377419ad61.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-04-15T21:01:26.886Z\",\"MediaKey\":\"NST121551155\"},{\"LongDescription\":\"46145414-414e-42a5-b70e-73aeb3fc2bee.JPG\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7884586\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7884586/e4bf59b2-1249-44cc-bd55-214d188f535d.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-04-15T21:01:26.895Z\",\"MediaKey\":\"NST121551152\"},{\"LongDescription\":\"e3773543-9547-475e-a21e-00397d8966b4.JPG\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7884586\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7884586/016304b7-a0b3-4390-9a2c-7e28eda4da04.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-04-15T21:01:26.872Z\",\"MediaKey\":\"NST121551150\"},{\"LongDescription\":\"5854f1e1-8ea8-44cc-a9a5-63c870b9224d.JPG\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7884586\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7884586/958c73f4-7f21-4857-93c0-de9fd5a1a713.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-04-15T21:01:27.001Z\",\"MediaKey\":\"NST121551153\"},{\"LongDescription\":\"28dff535-1736-4edf-bf94-a1c4ef28cc8d.JPG\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7884586\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7884586/716949c2-1360-4b3f-9e8c-59d1dceacaf5.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-04-15T21:01:26.901Z\",\"MediaKey\":\"NST121551156\"},{\"LongDescription\":\"1980b983-e0dd-4070-8df1-d85d938f6c7c.JPG\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7884586\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7884586/1d81ad67-df0c-42c8-a31c-12796efa2fba.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-04-15T21:01:26.952Z\",\"MediaKey\":\"NST121551154\"},{\"LongDescription\":\"4c593828-c0cb-4860-86db-59a1dcf1f7b4.JPG\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7884586\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7884586/ce37b95e-568b-473c-aec7-7aa59db603ea.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-04-15T21:01:26.91Z\",\"MediaKey\":\"NST121551157\"}]","Media__LongDescription":"d89a4771-a9f1-46c8-a081-2e5aab6815e4.JPG","Media__Order":"9","Media__MediaObjectID":"NST9","Media__ResourceRecordKey":"NST7884586","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7884586/91a05233-dafb-455b-ae55-e452ef5027ed.jpeg","Media__ImageWidth":"1560","Media__ImageHeight":"2080","Media__ImageSizeDescription":"1560x2080","Media__MediaModificationTimestamp":"4/15/2026 9:01:26 PM","Media__MediaKey":"NST121551151","DocumentsChangeTimestamp":"2026-04-15T20:42:08.06Z","UnitTypes":"[{\"UnitTypeKey\":\"NST159242\",\"UnitTypeUnitsTotal\":1,\"NST_UnitIsLeased\":\"Y\",\"NST_UnitID\":1,\"UnitTypeBedsTotal\":3,\"UnitTypeTotalRent\":1600,\"NST_UnitRoomsTotal\":7,\"UnitTypeBathsTotal\":1,\"NST_UnitBathFull\":1},{\"UnitTypeKey\":\"NST159243\",\"UnitTypeUnitsTotal\":1,\"NST_UnitIsLeased\":\"N\",\"NST_UnitID\":2,\"UnitTypeBedsTotal\":3,\"UnitTypeTotalRent\":0,\"NST_UnitRoomsTotal\":5,\"UnitTypeBathsTotal\":1,\"NST_UnitLevel\":\"Main Level\",\"NST_UnitBathFull\":1}]","UnitTypes__UnitTypeKey":"NST159242","UnitTypes__UnitTypeUnitsTotal":"1","UnitTypes__NST_UnitIsLeased":"Y","UnitTypes__NST_UnitID":"1","UnitTypes__UnitTypeBedsTotal":"3","UnitTypes__UnitTypeTotalRent":"1600","UnitTypes__NST_UnitRoomsTotal":"7","UnitTypes__UnitTypeBathsTotal":"1","UnitTypes__NST_UnitBathFull":"1","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"e3773543-9547-475e-a21e-00397d8966b4.JPG\"},{\"Order\":2,\"Remarks\":\"4c593828-c0cb-4860-86db-59a1dcf1f7b4.JPG\"},{\"Order\":3,\"Remarks\":\"28dff535-1736-4edf-bf94-a1c4ef28cc8d.JPG\"},{\"Order\":4,\"Remarks\":\"5854f1e1-8ea8-44cc-a9a5-63c870b9224d.JPG\"},{\"Order\":5,\"Remarks\":\"1980b983-e0dd-4070-8df1-d85d938f6c7c.JPG\"},{\"Order\":6,\"Remarks\":\"00d1b74f-2ce0-4b4c-a703-98ba0930e3a7.JPG\"},{\"Order\":7,\"Remarks\":\"994c5f08-b6bd-4c45-bfe5-4ab3f196a583.JPG\"},{\"Order\":8,\"Remarks\":\"46145414-414e-42a5-b70e-73aeb3fc2bee.JPG\"},{\"Order\":9,\"Remarks\":\"d89a4771-a9f1-46c8-a081-2e5aab6815e4.JPG\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9","CustomVTourURL":""}