$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Edina 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. Edge of the Wilderness Lakes & Homes Realty is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Edge of the Wilderness Lakes & Homes Realty, 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. Edge of the Wilderness Lakes & Homes Realty is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Edge of the Wilderness Lakes & Homes Realty, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":601741,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7128350","MLSAGENTID":"NST502002100","MLSOFFICEID":"NST8113","ADDRESS":"789 Fairview Avenue N","ACRES":0.114,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Full,Unfinished","BATHSTOTAL":1.0,"BEDROOMS":3.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Frame","FORECLOSURE":"No","LASTPRICE":300000.0,"LASTPRICEDATE":"2026-09-16T15:23:06.577","LATITUDE":44.965016,"LENDEROWNED":"No","LISTDATE":"2026-08-16T05:00:00","LISTPRICE":275000.0,"LIVINGAREA":1287.0,"LONGITUDE":-93.177566,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2026-09-16T15:23:06.575","NEIGHBORHOOD":"93","OFFICE_OFFICENAME":"Edina Realty, Inc.","PHOTOCOUNT":37,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Classic 1922 built Craftsman with the Brick Fireplace framed by built in bookcases. Hardwood floors and Natural Woodwork on main floor. Front porch to greet guests. Sun room for plants or morning coffee. Large dining room for gatherings with friends and family. Updated kitchen. Fenced yard. Sweet single garage with one extra parking space beside it. The second floor has three bedrooms. One bedroom is small and would need a wardrobe. Full hall bath. Basement is for laundry and storage. At one time there was a toilet by staircase. Easy access to light rail, both downtowns, U of M, and Newell Park with its majestic oak trees. This home backs up to another park. Close to coffee shops and restaurants. Don't miss this one!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-08-19T15:44:08.347","LASTSTATUS":"Coming Soon","STREETDIRSUFFIX":"N","STREETNAME":"Fairview","STREETNUMBER":"789","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1922,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-08-19T15:39:07.075","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Classic 1922 home w/Natural Woodwork\"},{\"Order\":2,\"Remarks\":\"Walk to Newell Park plus backs up to small park\"},{\"Order\":3,\"Remarks\":\"Greet guests at your front door\"},{\"Order\":4,\"Remarks\":\"Front 3 season porch\"},{\"Order\":5,\"Remarks\":\"Greet guests in your front porch\"},{\"Order\":6,\"Remarks\":\"Hardwood Floors\"},{\"Order\":7,\"Remarks\":\"Original Brick Fireplace framed by book cases\"},{\"Order\":8,\"Remarks\":\"Open floor plan with archways\"},{\"Order\":9,\"Remarks\":\"Sun Room with Hardwood floors\"},{\"Order\":10,\"Remarks\":\"Open staircase\"},{\"Order\":11,\"Remarks\":\"Large formal dining room for gathering with friends and family\"},{\"Order\":12,\"Remarks\":\"Updated kitchen with Stainless steel farm style sink\"},{\"Order\":13,\"Remarks\":\"Stainless steel gas range\"},{\"Order\":14,\"Remarks\":\"Good counter space\"},{\"Order\":15,\"Remarks\":\"Easy access to dining room\"},{\"Order\":16,\"Remarks\":\"Large window to enjoy yard views\"},{\"Order\":17,\"Remarks\":\"Main Floor\"},{\"Order\":18,\"Remarks\":\"Full Basement\"},{\"Order\":19,\"Remarks\":\"Open basement\"},{\"Order\":20,\"Remarks\":\"Laundry\"},{\"Order\":21,\"Remarks\":\"Room to expand\"},{\"Order\":22,\"Remarks\":\"Great storage\"},{\"Order\":23,\"Remarks\":\"Upper Level\"},{\"Order\":24,\"Remarks\":\"Large front bedroom with walk in closets\"},{\"Order\":25,\"Remarks\":\"Harwood floors under carpet\"},{\"Order\":26,\"Remarks\":\"Smaller bedroom or office\"},{\"Order\":27,\"Remarks\":\"Full bath with shower\"},{\"Order\":28,\"Remarks\":\"Hardwood under carpet in second bedroom\"},{\"Order\":29,\"Remarks\":\"Deep closet\"},{\"Order\":30,\"Remarks\":\"Private back yard with patio\"},{\"Order\":31,\"Remarks\":\"Winding path from house to garage\"},{\"Order\":32,\"Remarks\":\"Privacy fence\"},{\"Order\":33,\"Remarks\":\"Single garage room for small car or work shop\"},{\"Order\":34,\"Remarks\":\"Good tree coverage\"},{\"Order\":35,\"Remarks\":\"Conveniently located near universities and colleges\"},{\"Order\":36,\"Remarks\":\"All levels\"},{\"Order\":37,\"Remarks\":\"Walk to parks, coffee shops & restaurants\"}]","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,27,28,29,30,31,32,33,34,35,36,37","SOURCE":"MG_NST"}
{"ListingKey":"NST7951953","NST_AboveGradeSqFtTotal":"1287","AboveGradeFinishedArea":"1287","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Hardwood Floors,Kitchen Window,Natural Woodwork","Appliances":"Dryer,Range,Refrigerator,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Block,Full,Unfinished","BasementYN":"True","NST_BathDesc":"Upper Level Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"767","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Saint Paul","ConstructionMaterials":"Frame","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Separate/Formal Dining Room","Directions":"Snelling Ave to Thomas. West to Fairview, north to home.","DocumentsCount":"3","DocumentsChangeTimestamp":"2026-09-11T15:35:11.018Z","DaysOnMarket":"0","Electric":"Circuit Breakers,100 Amp Service","NST_ExpectedMarketDate":"2026-08-19","ExteriorFeatures":"Vinyl","Fencing":"Full,Privacy","FireplaceFeatures":"Brick,Wood Burning","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"767","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"240","GarageSpaces":"1","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.965016","LaundryFeatures":"In Basement,Gas Dryer Hookup","NST_LenderOwned":"No","Levels":"Two","ListPrice":"275000","ListingContractDate":"2026-08-16T05:00:00Z","ListingId":"NST7128350","LivingArea":"1287","LockBoxType":"Supra","Longitude":"-93.177566","LotFeatures":"Public Transit (w/in 6 blks),Tree Coverage - Light","LotSizeArea":"0.114","LotSizeDimensions":"40x125","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"767","NST_ManufacturedHome":"N","NST_NeighborhoodName":"Hamline-Midway","NST_NeighborhoodNumber":"93","OriginalEntryTimestamp":"2026-08-19T00:00:09Z","ParcelNumber":"282923340018","ParkingFeatures":"Detached Garage,Gravel","NST_PatioPorchType":"Front Porch,Glass Enclosed","PhotosCount":"37","PhotosChangeTimestamp":"2026-08-19T15:39:07.075Z","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55104","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Classic 1922 built Craftsman with the Brick Fireplace framed by built in bookcases. Hardwood floors and Natural Woodwork on main floor. Front porch to greet guests. Sun room for plants or morning coffee. Large dining room for gatherings with friends and family. Updated kitchen. Fenced yard. Sweet single garage with one extra parking space beside it. The second floor has three bedrooms. One bedroom is small and would need a wardrobe. Full hall bath. Basement is for laundry and storage. At one time there was a toilet by staircase. Easy access to light rail, both downtowns, U of M, and Newell Park with its majestic oak trees. This home backs up to another park. Close to coffee shops and restaurants. Don't miss this one!","PublicSurveyRange":"23","PublicSurveySection":"28","PublicSurveyTownship":"29","RoadFrontageType":"City Street,Curbs,Paved Streets,Sidewalks","RoadResponsibility":"Public Maintained Road","Roof":"Age Over 8 Years","NST_SchoolDistrictFullName":"625 - St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Fairview","StreetNumber":"789","StreetNumberNumeric":"789","StreetSuffix":"Avenue","SubdivisionName":"Midway Heights","TaxAnnualAmount":"4450","NST_TaxWithAssessments":"4450","TaxYear":"2025","NST_TotalArea":"2054","BuildingAreaTotal":"2054","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1922","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST88063","ListAgentMlsId":"NST502002100","ListOfficeMlsId":"NST8113","ListOfficeName":"Edina Realty, Inc.","ListOfficeKey":"NST16445","ModificationTimestamp":"2026-09-16T15:23:06.575Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/459c629a-60e7-48e6-a700-d13e675f7e5a.jpeg\",\"LongDescription\":\"All levels\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":36,\"MediaObjectID\":\"NST36\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.532Z\",\"MediaKey\":\"NST124347722\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/71dcdb1b-575a-4158-b619-8f00833b41af.jpeg\",\"LongDescription\":\"Full Basement\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.574Z\",\"MediaKey\":\"NST124347725\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/b4f74faa-4989-476b-b59a-deda90b1cbd5.jpeg\",\"LongDescription\":\"Upper Level\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":23,\"MediaObjectID\":\"NST23\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.544Z\",\"MediaKey\":\"NST124347723\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/ac5d8413-7013-42be-842e-6abddaafd691.jpeg\",\"LongDescription\":\"Large front bedroom with walk in closets\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":24,\"MediaObjectID\":\"NST24\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.58Z\",\"MediaKey\":\"NST124347826\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/9e18d234-775b-4ba6-ac97-ca5cf41fb9cd.jpeg\",\"LongDescription\":\"Original Brick Fireplace framed by book cases\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.61Z\",\"MediaKey\":\"NST124347840\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/8e408150-2737-4e1c-a2e5-1017be6615f1.jpeg\",\"LongDescription\":\"Greet guests in your front porch\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.656Z\",\"MediaKey\":\"NST124347842\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/35e2ddfa-079d-422c-927d-115e10882e9c.jpeg\",\"LongDescription\":\"Stainless steel gas range\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.559Z\",\"MediaKey\":\"NST124347833\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/93549c70-79e8-4939-85d3-9ee30f2c07ff.jpeg\",\"LongDescription\":\"Easy access to dining room\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.588Z\",\"MediaKey\":\"NST124347832\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/e5713e53-ccf5-426d-acf1-ea37e0fca0bb.jpeg\",\"LongDescription\":\"Large formal dining room for gathering with friends and family\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.565Z\",\"MediaKey\":\"NST124347836\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/bc04fede-e369-41fd-bb49-66aace1bcb9a.jpeg\",\"LongDescription\":\"Good counter space\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.617Z\",\"MediaKey\":\"NST124347834\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/1e3ac0ea-78d6-4094-9cf9-a38fb8f33903.jpeg\",\"LongDescription\":\"Open floor plan with archways\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.596Z\",\"MediaKey\":\"NST124347839\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/9d7f3729-9b07-4106-b804-5eab1c4b6ae2.jpeg\",\"LongDescription\":\"Open staircase\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.571Z\",\"MediaKey\":\"NST124347837\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/b7686308-fac2-48cc-8da7-a249132e2d75.jpeg\",\"LongDescription\":\"Large window to enjoy yard views\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.644Z\",\"MediaKey\":\"NST124347831\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/f8ed7ad1-a1f7-451c-b2a4-f2c8c51ebcce.jpeg\",\"LongDescription\":\"Room to expand\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":21,\"MediaObjectID\":\"NST21\",\"ImageWidth\":2080,\"ImageHeight\":1385,\"ImageSizeDescription\":\"2080x1385\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.619Z\",\"MediaKey\":\"NST124347828\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/f4889b2d-08ef-4f6c-b31c-524e777593a5.jpeg\",\"LongDescription\":\"Laundry\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":20,\"MediaObjectID\":\"NST20\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.618Z\",\"MediaKey\":\"NST124347829\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/d0106ba8-0eca-49e9-8904-0cff81a5cfcd.jpeg\",\"LongDescription\":\"Sun Room with Hardwood floors\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.567Z\",\"MediaKey\":\"NST124347838\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/3a3d1043-f6cd-485f-9fe2-70c4282f64bc.jpeg\",\"LongDescription\":\"Smaller bedroom or office\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":26,\"MediaObjectID\":\"NST26\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.541Z\",\"MediaKey\":\"NST124347824\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/ea61ee97-01cf-4b0b-b82e-e68b47ce12d0.jpeg\",\"LongDescription\":\"Main Floor\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.577Z\",\"MediaKey\":\"NST124347724\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/21614807-7614-4233-8a16-7909bb9f4189.jpeg\",\"LongDescription\":\"Updated kitchen with Stainless steel farm style sink\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.567Z\",\"MediaKey\":\"NST124347835\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/f1503ad8-60be-42c9-8c1b-b2e12b369caf.jpeg\",\"LongDescription\":\"Great storage\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":22,\"MediaObjectID\":\"NST22\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.592Z\",\"MediaKey\":\"NST124347827\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/f5649340-b752-4791-a0f5-b3e036488559.jpeg\",\"LongDescription\":\"Front 3 season porch\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.653Z\",\"MediaKey\":\"NST124347843\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/4c2bd992-c385-42dd-bd83-c3dc4a26e3a1.jpeg\",\"LongDescription\":\"Harwood floors under carpet\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":25,\"MediaObjectID\":\"NST25\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.532Z\",\"MediaKey\":\"NST124347825\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/ae02806a-2e6d-4dd7-83dd-aeaab31748a5.jpeg\",\"LongDescription\":\"Hardwood Floors\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.532Z\",\"MediaKey\":\"NST124347841\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/9922f7c1-cb42-4b00-8021-8cc0d33be268.jpeg\",\"LongDescription\":\"Open basement\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.569Z\",\"MediaKey\":\"NST124347830\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/4946a507-452d-4148-aab1-6b9c83aa3caf.jpeg\",\"LongDescription\":\"Hardwood under carpet in second bedroom\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":28,\"MediaObjectID\":\"NST28\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.555Z\",\"MediaKey\":\"NST124348315\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/378a81c5-a564-40ed-b01e-8899c5e6e325.jpeg\",\"LongDescription\":\"Full bath with shower\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":27,\"MediaObjectID\":\"NST27\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.591Z\",\"MediaKey\":\"NST124348316\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/82f89e8f-5ac7-4f54-bef5-88e7e1cd6b3a.jpeg\",\"LongDescription\":\"Privacy fence\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":32,\"MediaObjectID\":\"NST32\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.569Z\",\"MediaKey\":\"NST124348311\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/d21c07aa-2708-4bfc-b20d-5a99860b87a2.jpeg\",\"LongDescription\":\"Private back yard with patio\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":30,\"MediaObjectID\":\"NST30\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.607Z\",\"MediaKey\":\"NST124348313\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/ecbb58ea-3b8c-4699-a7bf-c1d76e929221.jpeg\",\"LongDescription\":\"Winding path from house to garage\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":31,\"MediaObjectID\":\"NST31\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.611Z\",\"MediaKey\":\"NST124348312\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/79844069-060d-47b7-9964-167ac299c1bf.jpeg\",\"LongDescription\":\"Greet guests at your front door\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.544Z\",\"MediaKey\":\"NST124347844\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/51aaffad-60a4-49dd-a50f-ea3402c4fe8b.jpeg\",\"LongDescription\":\"Conveniently located near universities and colleges\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":35,\"MediaObjectID\":\"NST35\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.546Z\",\"MediaKey\":\"NST124348308\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/15b320c6-05c7-42ae-aa45-cc73b6c1e806.jpeg\",\"LongDescription\":\"Classic 1922 home w/Natural Woodwork\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:07:20.924Z\",\"MediaKey\":\"NST124347846\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/86a7f759-1f14-4dbd-a1ed-e0782604ed3d.jpeg\",\"LongDescription\":\"Walk to Newell Park plus backs up to small park\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.623Z\",\"MediaKey\":\"NST124347845\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/733d65f3-7502-4035-89a6-076cafc9612c.jpeg\",\"LongDescription\":\"Deep closet\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":29,\"MediaObjectID\":\"NST29\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.544Z\",\"MediaKey\":\"NST124348314\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/4fa7ad1c-94bb-4b44-a7cc-9ef6c3fe6cd4.jpeg\",\"LongDescription\":\"Good tree coverage\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":34,\"MediaObjectID\":\"NST34\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.549Z\",\"MediaKey\":\"NST124348309\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/ae03fbf5-cd48-48f1-b62a-08a94c8a60ee.jpeg\",\"LongDescription\":\"Walk to parks, coffee shops & restaurants\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":37,\"MediaObjectID\":\"NST37\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.595Z\",\"MediaKey\":\"NST124348307\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/e14f53e0-dc68-44eb-a94f-edbf470ae14e.jpeg\",\"LongDescription\":\"Single garage room for small car or work shop\",\"ResourceRecordKey\":\"NST7951953\",\"Order\":33,\"MediaObjectID\":\"NST33\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-19T15:38:10.593Z\",\"MediaKey\":\"NST124348310\"}]","Media__MediaURL":"https://media.mlsgrid.com/token=22wynF0sdTHndMLiCPJRXq_08AZbqV-YVSUoHGRMPyc&expires=1789576897&id=5d6fc86794c5224544394849/images/NST7951953/459c629a-60e7-48e6-a700-d13e675f7e5a.jpeg","Media__LongDescription":"All levels","Media__ResourceRecordKey":"NST7951953","Media__Order":"36","Media__MediaObjectID":"NST36","Media__ImageWidth":"2080","Media__ImageHeight":"1560","Media__ImageSizeDescription":"2080x1560","Media__MediaModificationTimestamp":"8/19/2026 3:38:10 PM","Media__MediaKey":"NST124347722","Rooms":"[{\"RoomDimensions\":\"12.5x10.8\",\"RoomType\":\"Dining Room\",\"RoomKey\":\"NST116574820\",\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"15.5x12.5\",\"RoomType\":\"Bedroom\",\"RoomKey\":\"NST116574822\",\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Upper\"},{\"RoomDimensions\":\"12x9.5\",\"RoomType\":\"Kitchen\",\"RoomKey\":\"NST116574821\",\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"23x12.5\",\"RoomType\":\"Living Room\",\"RoomKey\":\"NST116574819\",\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"10.5x7.5\",\"RoomType\":\"Porch\",\"RoomKey\":\"NST116574818\",\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"12.5x9\",\"RoomType\":\"Bedroom 2\",\"RoomKey\":\"NST116574823\",\"NST_RoomSortOrder\":6,\"RoomLevel\":\"Upper\"},{\"RoomDimensions\":\"12x7.5\",\"RoomType\":\"Sun Room\",\"RoomKey\":\"NST116574825\",\"NST_RoomSortOrder\":8,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"9x8.5\",\"RoomType\":\"Bedroom 3\",\"RoomKey\":\"NST116574824\",\"NST_RoomSortOrder\":7,\"RoomLevel\":\"Upper\"}]","Rooms__RoomDimensions":"12.5x10.8","Rooms__RoomType":"Dining Room","Rooms__RoomKey":"NST116574820","Rooms__NST_RoomSortOrder":"3","Rooms__RoomLevel":"Main","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Classic 1922 home w/Natural Woodwork\"},{\"Order\":2,\"Remarks\":\"Walk to Newell Park plus backs up to small park\"},{\"Order\":3,\"Remarks\":\"Greet guests at your front door\"},{\"Order\":4,\"Remarks\":\"Front 3 season porch\"},{\"Order\":5,\"Remarks\":\"Greet guests in your front porch\"},{\"Order\":6,\"Remarks\":\"Hardwood Floors\"},{\"Order\":7,\"Remarks\":\"Original Brick Fireplace framed by book cases\"},{\"Order\":8,\"Remarks\":\"Open floor plan with archways\"},{\"Order\":9,\"Remarks\":\"Sun Room with Hardwood floors\"},{\"Order\":10,\"Remarks\":\"Open staircase\"},{\"Order\":11,\"Remarks\":\"Large formal dining room for gathering with friends and family\"},{\"Order\":12,\"Remarks\":\"Updated kitchen with Stainless steel farm style sink\"},{\"Order\":13,\"Remarks\":\"Stainless steel gas range\"},{\"Order\":14,\"Remarks\":\"Good counter space\"},{\"Order\":15,\"Remarks\":\"Easy access to dining room\"},{\"Order\":16,\"Remarks\":\"Large window to enjoy yard views\"},{\"Order\":17,\"Remarks\":\"Main Floor\"},{\"Order\":18,\"Remarks\":\"Full Basement\"},{\"Order\":19,\"Remarks\":\"Open basement\"},{\"Order\":20,\"Remarks\":\"Laundry\"},{\"Order\":21,\"Remarks\":\"Room to expand\"},{\"Order\":22,\"Remarks\":\"Great storage\"},{\"Order\":23,\"Remarks\":\"Upper Level\"},{\"Order\":24,\"Remarks\":\"Large front bedroom with walk in closets\"},{\"Order\":25,\"Remarks\":\"Harwood floors under carpet\"},{\"Order\":26,\"Remarks\":\"Smaller bedroom or office\"},{\"Order\":27,\"Remarks\":\"Full bath with shower\"},{\"Order\":28,\"Remarks\":\"Hardwood under carpet in second bedroom\"},{\"Order\":29,\"Remarks\":\"Deep closet\"},{\"Order\":30,\"Remarks\":\"Private back yard with patio\"},{\"Order\":31,\"Remarks\":\"Winding path from house to garage\"},{\"Order\":32,\"Remarks\":\"Privacy fence\"},{\"Order\":33,\"Remarks\":\"Single garage room for small car or work shop\"},{\"Order\":34,\"Remarks\":\"Good tree coverage\"},{\"Order\":35,\"Remarks\":\"Conveniently located near universities and colleges\"},{\"Order\":36,\"Remarks\":\"All levels\"},{\"Order\":37,\"Remarks\":\"Walk to parks, coffee shops & restaurants\"}]","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,27,28,29,30,31,32,33,34,35,36,37","CustomVTourURL":""}
$MLSDESCRIPTION$
789 Fairview Avenue N Saint Paul, MN 55104
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
789 Fairview Avenue N Saint Paul, MN 55104
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
789 Fairview Avenue N Saint Paul, MN 55104
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
789 Fairview Avenue N Saint Paul, MN 55104
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$




