mike@minnesotarealestatesales.com
Phone: 218-821-4775
- About
- Pelican Lake
- Ossawinnamakee Lake
- Horseshoe Lake
- Advanced Search
- Daily Hotsheets
- Buyers
- Sellers
- Estimate Request
- Popular Listings
- Favorite Listings
- Pelican Lakes Association
- Conservation Club
- DNR Lake Information
Contact me here...
$STITLE$
$SCONTENT$
$LABEL$
$SCONTENT$
Counselor Realty, Inc is the brokerage office representing the seller for this listing.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
The data relating to real estate for sale on this site comes in part from the broker reciprocity program of the Regional multiple Listing Service of Minnesota, Inc. real estate listings held by brokerage firms other than are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Mike Stanwood Realtor/GRI is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mike Stanwood Realtor/GRI, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
The data relating to real estate for sale on this site comes in part from the broker reciprocity program of the Regional multiple Listing Service of Minnesota, Inc. real estate listings held by brokerage firms other than are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Mike Stanwood Realtor/GRI is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mike Stanwood Realtor/GRI, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":567092,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7086366","MLSAGENTID":"NST496501908","MLSOFFICEID":"NST9392","ADDRESS":"833 Fremont Avenue","ACRES":0.174,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full,Unfinished","BATHSTOTAL":2.0,"BEDROOMS":5.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Frame","FORECLOSURE":"No","LASTPRICE":225000.0,"LASTPRICEDATE":"2026-06-03T20:58:08.227","LATITUDE":44.957784,"LENDEROWNED":"No","LISTDATE":"2026-06-03T05:00:00","LISTPRICE":225000.0,"LIVINGAREA":1257.0,"LONGITUDE":-93.065198,"LOTDESCRIPTION":"Tree Coverage - Medium","MODIFICATIONTIMESTAMP":"2026-06-03T22:01:06.633","NEIGHBORHOOD":"90","OFFICE_OFFICENAME":"Counselor Realty, Inc","PHOTOCOUNT":26,"POSTALCODE":"55106","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Double lot and move in ready. 5 bedrooms, great kitchen, new furnace, and huge main floor laundry. All the character with lots of updating.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years,Asphalt","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-06-03T20:58:08.227","LASTSTATUS":"Active","STREETNAME":"Fremont","STREETNUMBER":"833","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1879,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-06-03T22:01:06.633","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_9630.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_9629.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_9625.jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_9618.jpeg\"},{\"Order\":5,\"Remarks\":\"IMG_9617.jpeg\"},{\"Order\":6,\"Remarks\":\"IMG_9606.jpeg\"},{\"Order\":7,\"Remarks\":\"IMG_9608.jpeg\"},{\"Order\":8,\"Remarks\":\"IMG_9607.jpeg\"},{\"Order\":9,\"Remarks\":\"IMG_9605.jpeg\"},{\"Order\":10,\"Remarks\":\"IMG_9601.jpeg\"},{\"Order\":11,\"Remarks\":\"IMG_9600.jpeg\"},{\"Order\":12,\"Remarks\":\"IMG_9596.jpeg\"},{\"Order\":13,\"Remarks\":\"IMG_9609.jpeg\"},{\"Order\":14,\"Remarks\":\"IMG_9610.jpeg\"},{\"Order\":15,\"Remarks\":\"IMG_9598.jpeg\"},{\"Order\":16,\"Remarks\":\"IMG_9613.jpeg\"},{\"Order\":17,\"Remarks\":\"IMG_9599.jpeg\"},{\"Order\":18,\"Remarks\":\"IMG_9595.jpeg\"},{\"Order\":19,\"Remarks\":\"IMG_9615.jpeg\"},{\"Order\":20,\"Remarks\":\"IMG_9614.jpeg\"},{\"Order\":21,\"Remarks\":\"IMG_9612.jpeg\"},{\"Order\":22,\"Remarks\":\"IMG_9611.jpeg\"},{\"Order\":23,\"Remarks\":\"IMG_9603.jpeg\"},{\"Order\":24,\"Remarks\":\"IMG_9604.jpeg\"},{\"Order\":25,\"Remarks\":\"IMG_9597.jpeg\"},{\"Order\":26,\"Remarks\":\"IMG_9602.jpeg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26","SOURCE":"MG_NST"}
{"ListingKey":"NST7912411","NST_AboveGradeSqFtTotal":"1251","AboveGradeFinishedArea":"1257","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Kitchen Window,Main Floor Primary Bedroom,Porch","Appliances":"Dryer,Gas Water Heater,Range,Refrigerator,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Yes","AssociationYN":"False","AssociationFee":"0","Basement":"Full,Unfinished","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath,Upper Level 3/4 Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"5","NST_BelowGradeSqFtTotal":"821","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Saint Paul","ConstructionMaterials":"Frame","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Living/Dining Room","Directions":"3rd St to Earl, north to Fremont, west to home","DocumentsCount":"2","DocumentsChangeTimestamp":"2026-06-03T21:29:06.542Z","DaysOnMarket":"0","Electric":"Circuit Breakers,100 Amp Service","ExteriorFeatures":"Stucco","Fencing":"None","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"821","FoundationDetails":"Stone","NST_FoundationDimensions":"1x1","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"0","GarageSpaces":"0","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.957784","LaundryFeatures":"Laundry Room,Main Level","NST_LenderOwned":"No","Levels":"Two","ListPrice":"225000","ListingContractDate":"2026-06-03T05:00:00Z","ListingId":"NST7086366","LivingArea":"1257","LockBoxType":"Combo","Longitude":"-93.065198","LotFeatures":"Tree Coverage - Medium","LotSizeArea":"7581","LotSizeDimensions":"40x30x78x40x53x12x29xx40x98","LotSizeUnits":"Square Feet","NST_MainLevelFinishedArea":"821","NST_ManufacturedHome":"N","NST_NeighborhoodName":"Dayton's Bluff","NST_NeighborhoodNumber":"90","OriginalEntryTimestamp":"2026-06-03T15:57:25Z","ParcelNumber":"332922230174","ParkingFeatures":"Asphalt","NST_PatioPorchType":"Front Porch","PhotosCount":"26","PhotosChangeTimestamp":"2026-06-03T22:01:06.633Z","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55106","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Double lot and move in ready. 5 bedrooms, great kitchen, new furnace, and huge main floor laundry. All the character with lots of updating.","PublicSurveyRange":"22","PublicSurveySection":"33","PublicSurveyTownship":"29","RoadFrontageType":"City Street","RoadResponsibility":"Public Maintained Road","Roof":"Age Over 8 Years,Asphalt","NST_SchoolDistrictFullName":"625 - St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level,Main Floor Bedroom,Main Floor Laundry","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Fremont","StreetNumber":"833","StreetNumberNumeric":"833","StreetSuffix":"Avenue","SubdivisionName":"Ofarrells Sub Of B91 Lyman &","TaxAnnualAmount":"5292","NST_TaxWithAssessments":"5724","TaxYear":"2026","NST_TotalArea":"2072","BuildingAreaTotal":"2072","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1879","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST49180","ListAgentMlsId":"NST496501908","ListOfficeMlsId":"NST9392","ListOfficeName":"Counselor Realty, Inc","ListOfficeKey":"NST16385","ModificationTimestamp":"2026-06-03T22:01:06.633Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"IMG_9596.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/6940c8bc-f771-4bc2-98ca-5f5a6febfd50.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.303Z\",\"MediaKey\":\"NST122700661\"},{\"Order\":26,\"MediaObjectID\":\"NST26\",\"LongDescription\":\"IMG_9602.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/84c5f1a3-968a-49ac-8d93-c862ea4f5fc6.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.285Z\",\"MediaKey\":\"NST122700667\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"LongDescription\":\"IMG_9598.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/aac9b39d-a395-4d17-a953-72eca67f657e.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.295Z\",\"MediaKey\":\"NST122700662\"},{\"Order\":18,\"MediaObjectID\":\"NST18\",\"LongDescription\":\"IMG_9595.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/61a829f9-f77e-4b13-b363-03f3766169d1.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.294Z\",\"MediaKey\":\"NST122700660\"},{\"Order\":25,\"MediaObjectID\":\"NST25\",\"LongDescription\":\"IMG_9597.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/52f26047-26c3-4f26-90cf-0276d0206332.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.293Z\",\"MediaKey\":\"NST122700663\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"LongDescription\":\"IMG_9609.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/56f440c6-7048-4ae6-ad22-5ca79e19f96b.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.283Z\",\"MediaKey\":\"NST122700675\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"IMG_9600.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/bda89037-a77e-417f-8ad7-9e556824ab25.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.318Z\",\"MediaKey\":\"NST122700666\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"LongDescription\":\"IMG_9599.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/9335960a-2626-48c9-b5e8-5bc50a3f3829.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.284Z\",\"MediaKey\":\"NST122700664\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"IMG_9601.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/a5272f60-2ee4-49b3-a591-117d766ab9d3.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.308Z\",\"MediaKey\":\"NST122700665\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"IMG_9607.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/5535f518-4388-400f-b842-a966bdf34794.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.295Z\",\"MediaKey\":\"NST122700671\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"IMG_9608.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/8ada1cfb-8758-48b6-a84e-448aacd85754.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.291Z\",\"MediaKey\":\"NST122700673\"},{\"Order\":23,\"MediaObjectID\":\"NST23\",\"LongDescription\":\"IMG_9603.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/497f27a4-d552-4c5b-910a-b94c3f77a220.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.295Z\",\"MediaKey\":\"NST122700669\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"LongDescription\":\"IMG_9610.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/81db1052-6014-4aaf-9d2f-26e476c2bbb7.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.28Z\",\"MediaKey\":\"NST122700674\"},{\"Order\":24,\"MediaObjectID\":\"NST24\",\"LongDescription\":\"IMG_9604.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/76ab5d29-5e1d-4602-a04d-9ddd37116949.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.329Z\",\"MediaKey\":\"NST122700668\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"IMG_9605.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/0ea98116-8199-40a6-a07d-6912015b72a5.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.346Z\",\"MediaKey\":\"NST122700670\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"IMG_9606.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/7129d2f2-e331-48ee-a10b-2a9e17ea2203.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.308Z\",\"MediaKey\":\"NST122700672\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"IMG_9629.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/84f015c7-a0ba-443c-baf5-ebc6e4a155d0.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T21:25:17.746Z\",\"MediaKey\":\"NST122700685\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"IMG_9630.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/5cad8900-b58d-45c9-9815-cf8f57993c0e.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T21:25:17.811Z\",\"MediaKey\":\"NST122700686\"},{\"Order\":20,\"MediaObjectID\":\"NST20\",\"LongDescription\":\"IMG_9614.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/384040d5-b172-4358-8f73-933642dd0480.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.319Z\",\"MediaKey\":\"NST122700679\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"IMG_9617.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/ed53bf00-7a0e-4f89-854a-267b28a04329.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.292Z\",\"MediaKey\":\"NST122700681\"},{\"Order\":22,\"MediaObjectID\":\"NST22\",\"LongDescription\":\"IMG_9611.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/30044cce-f4b0-4452-abf9-d6f4e35919ac.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.285Z\",\"MediaKey\":\"NST122700676\"},{\"Order\":21,\"MediaObjectID\":\"NST21\",\"LongDescription\":\"IMG_9612.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/580bfcf2-ff1a-4cd5-8aeb-dc255a398e83.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.283Z\",\"MediaKey\":\"NST122700677\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"IMG_9625.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/6bcca536-104b-4d83-a953-0c2ef10bd175.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.325Z\",\"MediaKey\":\"NST122700683\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"LongDescription\":\"IMG_9613.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/9d6ffbda-7c43-4258-b015-35c79bcaf75c.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.308Z\",\"MediaKey\":\"NST122700678\"},{\"Order\":19,\"MediaObjectID\":\"NST19\",\"LongDescription\":\"IMG_9615.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/263aebd9-7bae-43d2-9824-45d2323b0fcd.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.311Z\",\"MediaKey\":\"NST122700680\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"IMG_9618.jpeg\",\"ResourceRecordKey\":\"NST7912411\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7912411/9ded831f-0c5d-4bb7-804e-d04d25164992.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-03T22:00:07.302Z\",\"MediaKey\":\"NST122700682\"}]","Media__Order":"12","Media__MediaObjectID":"NST12","Media__LongDescription":"IMG_9596.jpeg","Media__ResourceRecordKey":"NST7912411","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7912411/6940c8bc-f771-4bc2-98ca-5f5a6febfd50.jpeg","Media__ImageWidth":"2080","Media__ImageHeight":"1560","Media__ImageSizeDescription":"2080x1560","Media__MediaModificationTimestamp":"6/3/2026 10:00:07 PM","Media__MediaKey":"NST122700661","Rooms":"[{\"NST_RoomSortOrder\":8,\"RoomKey\":\"NST116311417\",\"RoomDimensions\":\"7x14\",\"RoomType\":\"Bedroom 5\",\"RoomLevel\":\"Upper\"},{\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116311413\",\"RoomDimensions\":\"11x12\",\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116311416\",\"RoomDimensions\":\"9x9\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Upper\"},{\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116311410\",\"RoomDimensions\":\"8x12\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116311412\",\"RoomDimensions\":\"9x12\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116311411\",\"RoomDimensions\":\"10x14\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116311414\",\"RoomDimensions\":\"8x15\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116311415\",\"RoomDimensions\":\"12x15\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\"}]","Rooms__NST_RoomSortOrder":"8","Rooms__RoomKey":"NST116311417","Rooms__RoomDimensions":"7x14","Rooms__RoomType":"Bedroom 5","Rooms__RoomLevel":"Upper","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"IMG_9630.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_9629.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_9625.jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_9618.jpeg\"},{\"Order\":5,\"Remarks\":\"IMG_9617.jpeg\"},{\"Order\":6,\"Remarks\":\"IMG_9606.jpeg\"},{\"Order\":7,\"Remarks\":\"IMG_9608.jpeg\"},{\"Order\":8,\"Remarks\":\"IMG_9607.jpeg\"},{\"Order\":9,\"Remarks\":\"IMG_9605.jpeg\"},{\"Order\":10,\"Remarks\":\"IMG_9601.jpeg\"},{\"Order\":11,\"Remarks\":\"IMG_9600.jpeg\"},{\"Order\":12,\"Remarks\":\"IMG_9596.jpeg\"},{\"Order\":13,\"Remarks\":\"IMG_9609.jpeg\"},{\"Order\":14,\"Remarks\":\"IMG_9610.jpeg\"},{\"Order\":15,\"Remarks\":\"IMG_9598.jpeg\"},{\"Order\":16,\"Remarks\":\"IMG_9613.jpeg\"},{\"Order\":17,\"Remarks\":\"IMG_9599.jpeg\"},{\"Order\":18,\"Remarks\":\"IMG_9595.jpeg\"},{\"Order\":19,\"Remarks\":\"IMG_9615.jpeg\"},{\"Order\":20,\"Remarks\":\"IMG_9614.jpeg\"},{\"Order\":21,\"Remarks\":\"IMG_9612.jpeg\"},{\"Order\":22,\"Remarks\":\"IMG_9611.jpeg\"},{\"Order\":23,\"Remarks\":\"IMG_9603.jpeg\"},{\"Order\":24,\"Remarks\":\"IMG_9604.jpeg\"},{\"Order\":25,\"Remarks\":\"IMG_9597.jpeg\"},{\"Order\":26,\"Remarks\":\"IMG_9602.jpeg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26","CustomVTourURL":""}
$MLSDESCRIPTION$
833 Fremont Avenue Saint Paul, MN 55106
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
833 Fremont Avenue Saint Paul, MN 55106
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$