{"Id":1416315,"ORGTABLE":"RAW_Property","MLSCLASS":"LND","MLSNUMBER":"NST6797783","MLSAGENTID":"NST502034296","MLSOFFICEID":"NST253015","ADDRESS":"1738 University Avenue W","ACRES":0.46,"AGENTOWNER":false,"AUCTIONYN":false,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":895000.0,"LASTPRICEDATE":"2025-10-01T17:45:04.367","LATITUDE":44.955396,"LENDEROWNED":"No","LISTDATE":"2025-09-30T05:00:00","LISTPRICE":895000.0,"LIVINGAREA":0.0,"LONGITUDE":-93.173924,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Corner Lot","MODIFICATIONTIMESTAMP":"2025-10-01T19:05:04.219","NEIGHBORHOOD":"Merriam Park/Lexington-Hamline","OFFICE_OFFICENAME":"LPT Realty, LLC","PHOTOCOUNT":10,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PUBLICREMARKS":"Unleash Your Vision in St. Paul’s Hottest Redevelopment Hub! Six prime parcels all conjoining (Pid#'s are\n332923420006, 332923420008, 332923420009, 332923420010, 332923420011, 332923420012), spanning 0.46 acres,\nperfectly perched along the vibrant Green Line Light Rail. Zoned T4+ for maximum development flexibility,\nthis is your canvas for innovation! Just a stone’s throw from Allianz Field, Fairview Ave and Penn Ave\nStations, the University of Minnesota Campus, and the bustling Midway district—all within a mile. Seize\nthis electrifying opportunity for transit-oriented brilliance!\nProperty currently consists of 2 mixed use commercial buildings, 1 duplex, 1 single family, and parking\nlot. Monthly rent: $1800 (1744 University Single Family home), $2000 (1738 University Duplex, total for\nboth units), $1150 (471 Herschel lower unit commercial space), $950 (1728 University upper residential\nunit), $1000 (1730 University upper residential unit ), (1 vacancy is lower commercial unit of 1730\nUniversity) = $6,900 per month.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SALEINCLUDES":"Survey,Torrens","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-10-01T17:45:04.367","LASTSTATUS":"Active","STREETDIRSUFFIX":"W","STREETNAME":"University","STREETNUMBER":"1738","STREETSUFFIX":"Avenue","TRANSACTIONTYPE":"For Sale","WATERFRONTPRESENT":false,"ZONING":"Other","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-10-01T17:44:04.003","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Bring your ideas for this redevelopment site off of University Ave W and Herschel Street in St Paul Minnesota!!\"},{\"Order\":2,\"Remarks\":\"1738 University, 6 parcel site, .46 acres or 20,038 sq feet\"},{\"Order\":3,\"Remarks\":\"Within 1 mile of allianz soccer stadium St paul Mn\"},{\"Order\":4,\"Remarks\":\"Minutes from Down Town St Paul and Minneapolis\"},{\"Order\":5,\"Remarks\":\"1738 University, 6 parcel site\"},{\"Order\":6,\"Remarks\":\"1738 University, 6 parcel site\"},{\"Order\":7,\"Remarks\":\"1738 University, 6 parcel site\"},{\"Order\":8,\"Remarks\":\"1738 University, 6 parcel site\"},{\"Order\":9,\"Remarks\":\"1738 light rail Green Line\"},{\"Order\":10,\"Remarks\":\"Survey information\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10","SOURCE":"MG_NST"}
{"ListingKey":"NST7810114","LotSizeArea":"0.46","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","NST_BuilderRestrict":"Open","City":"Saint Paul","PropertyType":"Land","Contingency":"None","CountyOrParish":"Ramsey","DevelopmentStatus":"Other","Directions":"From Snelling Ave, head west on University to N Herschel St, and property consists of 6 lots on southwest\ncorner of N Herschel St and University Ave W. 33-","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","NST_ForeclosureStatus":"No","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Curbs,Other,Paved Streets,Sidewalks","NST_Improvements":"Curbs,Other,Paved Streets,Public Road,Sidewalks","OriginalEntryTimestamp":"2025-10-01T17:40:43Z","LotSizeDimensions":"184x70x44x51x140x121","Inclusions":"Survey,Torrens","LandLeaseYN":"False","NST_LastUpdateDate":"2025-10-01","Latitude":"44.955396","NST_LenderOwned":"No","ListAgentKey":"NST83210","ListAgentMlsId":"NST502034296","ListingContractDate":"2025-09-30T05:00:00Z","ListOfficeKey":"NST1001758","ListOfficeName":"LPT Realty, LLC","ListOfficeMlsId":"NST253015","ListPrice":"895000","Longitude":"-93.173924","LotFeatures":"Public Transit (w/in 6 blks),Corner Lot","LotSizeUnits":"Acres","ListingId":"NST6797783","SourceSystemName":"RMLS","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Merriam Park/Lexington-Hamline","NST_OfficeBoard":"SPAAR","ParcelNumber":"332923420011","PhotosCount":"10","PostalCity":"Saint Paul","PostalCode":"55104","NST_PotentialShortSale":"No","NST_ProgramAcresTotal":"0.0000","NST_PropertySubTypeDesc":"Other","PublicRemarks":"Unleash Your Vision in St. Paul’s Hottest Redevelopment Hub! Six prime parcels all conjoining (Pid#'s are\n332923420006, 332923420008, 332923420009, 332923420010, 332923420011, 332923420012), spanning 0.46 acres,\nperfectly perched along the vibrant Green Line Light Rail. Zoned T4+ for maximum development flexibility,\nthis is your canvas for innovation! Just a stone’s throw from Allianz Field, Fairview Ave and Penn Ave\nStations, the University of Minnesota Campus, and the bustling Midway district—all within a mile. Seize\nthis electrifying opportunity for transit-oriented brilliance!\nProperty currently consists of 2 mixed use commercial buildings, 1 duplex, 1 single family, and parking\nlot. Monthly rent: $1800 (1744 University Single Family home), $2000 (1738 University Duplex, total for\nboth units), $1150 (471 Herschel lower unit commercial space), $950 (1728 University upper residential\nunit), $1000 (1730 University upper residential unit ), (1 vacancy is lower commercial unit of 1730\nUniversity) = $6,900 per month.","PublicSurveyRange":"23","PublicSurveySection":"33","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","NST_Restrictions":"Other","RoadResponsibility":"Public Maintained Road","NST_SaleOptions":"Sell Entirely","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","StateOrProvince":"MN","StandardStatus":"Active","StreetDirSuffix":"W","StreetName":"University","StreetNumber":"1738","StreetNumberNumeric":"1738","StreetSuffix":"Avenue","SubdivisionName":"Howard Park","NST_TaxWithAssessments":"14708.0000","TaxYear":"2025","TaxAnnualAmount":"14708","Topography":"Other","Utilities":"Other Connected,Cable Available,Electricity Available,Natural Gas Available,Sewer Available,Storm Sewer Available,Phone Available,Underground Utilities Available,Water Available","ZoningDescription":"Other","ModificationTimestamp":"2025-10-01T19:05:04.219Z","PhotosChangeTimestamp":"2025-10-01T17:44:04.003Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7810114\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Bring your ideas for this redevelopment site off of University Ave W and Herschel Street in St Paul Minnesota!!\",\"ImageWidth\":1584,\"ImageHeight\":836,\"ImageSizeDescription\":\"1584x836\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7810114/cfd6179b-4c96-478f-a5dc-215e103628b9.png\",\"MediaModificationTimestamp\":\"2025-10-01T17:43:06.657Z\",\"MediaKey\":\"68dd682a9d74a055bcbecbca\"},{\"ResourceRecordKey\":\"NST7810114\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"1738 University, 6 parcel site, .46 acres or 20,038 sq feet\",\"ImageWidth\":1896,\"ImageHeight\":1468,\"ImageSizeDescription\":\"1896x1468\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7810114/94471dc0-ac2e-4104-bacc-de655a225864.png\",\"MediaModificationTimestamp\":\"2025-10-01T17:43:06.669Z\",\"MediaKey\":\"68dd682a9d74a055bcbecbcb\"},{\"ResourceRecordKey\":\"NST7810114\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Within 1 mile of allianz soccer stadium St paul Mn\",\"ImageWidth\":2008,\"ImageHeight\":1330,\"ImageSizeDescription\":\"2008x1330\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7810114/8015c08a-7039-497b-95a4-e9ece2384a88.png\",\"MediaModificationTimestamp\":\"2025-10-01T17:43:06.696Z\",\"MediaKey\":\"68dd682a9d74a055bcbecbcc\"},{\"ResourceRecordKey\":\"NST7810114\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Minutes from Down Town St Paul and Minneapolis\",\"ImageWidth\":1888,\"ImageHeight\":1220,\"ImageSizeDescription\":\"1888x1220\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7810114/3eb7e37d-b2f3-403f-b581-4423f93f83f7.png\",\"MediaModificationTimestamp\":\"2025-10-01T17:43:06.751Z\",\"MediaKey\":\"68dd682a9d74a055bcbecbcd\"},{\"ResourceRecordKey\":\"NST7810114\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"1738 University, 6 parcel site\",\"ImageWidth\":2032,\"ImageHeight\":834,\"ImageSizeDescription\":\"2032x834\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7810114/d0599631-3cae-4e07-adc5-ce329976fd9c.jpeg\",\"MediaModificationTimestamp\":\"2025-10-01T17:43:06.576Z\",\"MediaKey\":\"68dd682a9d74a055bcbecbce\"},{\"ResourceRecordKey\":\"NST7810114\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"1738 University, 6 parcel site\",\"ImageWidth\":2036,\"ImageHeight\":1016,\"ImageSizeDescription\":\"2036x1016\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7810114/84837aa6-1ab8-4f1f-8e50-a8387e571203.jpeg\",\"MediaModificationTimestamp\":\"2025-10-01T17:43:06.677Z\",\"MediaKey\":\"68dd682a9d74a055bcbecbcf\"},{\"ResourceRecordKey\":\"NST7810114\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"1738 University, 6 parcel site\",\"ImageWidth\":936,\"ImageHeight\":578,\"ImageSizeDescription\":\"936x578\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7810114/b270c164-aa77-436d-b847-b6fa447be1fe.jpeg\",\"MediaModificationTimestamp\":\"2025-10-01T17:43:06.569Z\",\"MediaKey\":\"68dd682a9d74a055bcbecbd0\"},{\"ResourceRecordKey\":\"NST7810114\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"1738 University, 6 parcel site\",\"ImageWidth\":2048,\"ImageHeight\":1062,\"ImageSizeDescription\":\"2048x1062\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7810114/4c63156e-5471-4f5a-8822-f49b58e3f3d1.jpeg\",\"MediaModificationTimestamp\":\"2025-10-01T17:43:06.568Z\",\"MediaKey\":\"68dd682a9d74a055bcbecbd1\"},{\"ResourceRecordKey\":\"NST7810114\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"1738 light rail Green Line\",\"ImageWidth\":2034,\"ImageHeight\":1176,\"ImageSizeDescription\":\"2034x1176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7810114/2872cb73-4e01-4a52-8035-256cc733611a.jpeg\",\"MediaModificationTimestamp\":\"2025-10-01T17:43:06.608Z\",\"MediaKey\":\"68dd682a9d74a055bcbecbd2\"},{\"ResourceRecordKey\":\"NST7810114\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"Survey information\",\"ImageWidth\":2034,\"ImageHeight\":1530,\"ImageSizeDescription\":\"2034x1530\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7810114/6d8dba17-8d70-41df-a02f-5aeebc349451.png\",\"MediaModificationTimestamp\":\"2025-10-01T17:43:06.723Z\",\"MediaKey\":\"68dd682a9d74a055bcbecbd3\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Bring your ideas for this redevelopment site off of University Ave W and Herschel Street in St Paul Minnesota!!\"},{\"Order\":2,\"Remarks\":\"1738 University, 6 parcel site, .46 acres or 20,038 sq feet\"},{\"Order\":3,\"Remarks\":\"Within 1 mile of allianz soccer stadium St paul Mn\"},{\"Order\":4,\"Remarks\":\"Minutes from Down Town St Paul and Minneapolis\"},{\"Order\":5,\"Remarks\":\"1738 University, 6 parcel site\"},{\"Order\":6,\"Remarks\":\"1738 University, 6 parcel site\"},{\"Order\":7,\"Remarks\":\"1738 University, 6 parcel site\"},{\"Order\":8,\"Remarks\":\"1738 University, 6 parcel site\"},{\"Order\":9,\"Remarks\":\"1738 light rail Green Line\"},{\"Order\":10,\"Remarks\":\"Survey information\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10","CustomVTourURL":""}