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$
Keller Williams Integrity Realty 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":532675,"ORGTABLE":"RAW_Property","MLSCLASS":"RNT","MLSNUMBER":"NST6810504","MLSAGENTID":"NST506094338","MLSOFFICEID":"NST10071","ADDRESS":"610 Fairview Ave Avenue N","ACRES":0.112,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Partial,Walkout","BATHSTOTAL":1.0,"BEDROOMS":4.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":2550.0,"LASTPRICEDATE":"2026-03-25T14:35:06.067","LATITUDE":44.959526,"LENDEROWNED":"No","LISTDATE":"2025-10-27T05:00:00","LISTPRICE":2550.0,"LIVINGAREA":1567.0,"LONGITUDE":-93.176856,"LOTDESCRIPTION":"Public Transit (w/in 6 blks)","MODIFICATIONTIMESTAMP":"2026-03-25T14:35:06.067","NEIGHBORHOOD":"93","OFFICE_OFFICENAME":"Keller Williams Integrity Realty","PHOTOCOUNT":29,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Spacious and updated, this charming home offers comfort and convenience in a prime location. The main level features beautiful hardwood floors, while the upstairs has brand-new carpeting. Enjoy cooking and entertaining in the large kitchen, complete with new stainless steel appliances. A versatile main-level bedroom is perfect for a home office. The enclosed front porch provides additional living space, ideal for relaxing or hosting. All windows have been replaced, and the home includes brand-new gutters for peace of mind. The concrete driveway offers off-street parking, and a backyard shed adds valuable extra storage. Located just minutes from the light rail, Newell Park, and the State Fairgrounds—this home combines modern updates with unbeatable convenience. Tenant pays utilities and is responsible for lawn and snow.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt","SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-03-25T14:35:06.067","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Fairview Ave","STREETNUMBER":"610","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Rent","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1883,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-01-19T19:52:06.197","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Exterior Front.jpg\"},{\"Order\":2,\"Remarks\":\"Balcony.jpg\"},{\"Order\":3,\"Remarks\":\"Front Porch.jpg\"},{\"Order\":4,\"Remarks\":\"Front Porch.jpg\"},{\"Order\":5,\"Remarks\":\"Living Room.jpg\"},{\"Order\":6,\"Remarks\":\"Living Room.jpg\"},{\"Order\":7,\"Remarks\":\"Living Room.jpg\"},{\"Order\":8,\"Remarks\":\"Living Room.jpg\"},{\"Order\":9,\"Remarks\":\"Dining Room.jpg\"},{\"Order\":10,\"Remarks\":\"Dining Room.jpg\"},{\"Order\":11,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":12,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":13,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":14,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":15,\"Remarks\":\"2nd Floor Primary Bedroom.jpg\"},{\"Order\":16,\"Remarks\":\"2nd Floor Primary Bedroom.jpg\"},{\"Order\":17,\"Remarks\":\"2nd Floor Primary Bedroom.jpg\"},{\"Order\":18,\"Remarks\":\"Bathroom.jpg\"},{\"Order\":19,\"Remarks\":\"2nd Floor Primary Bathroom.jpg\"},{\"Order\":20,\"Remarks\":\"2nd Floor Primary Bathroom.jpg\"},{\"Order\":21,\"Remarks\":\"2nd Floor Primary Bathroom.jpg\"},{\"Order\":22,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":23,\"Remarks\":\"2nd Floor Bedroom.jpg\"},{\"Order\":24,\"Remarks\":\"2nd Floor Bedroom.jpg\"},{\"Order\":25,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":26,\"Remarks\":\"2nd Floor Bedroom.jpg\"},{\"Order\":27,\"Remarks\":\"2nd Floor Bedroom.jpg\"},{\"Order\":28,\"Remarks\":\"Lower Level Laundry Room.jpg\"},{\"Order\":29,\"Remarks\":\"Exterior Rear.jpg\"}]","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","SOURCE":"MG_NST"}
{"ListingKey":"NST7821202","Appliances":"Dishwasher,Dryer,Microwave,Range,Refrigerator,Washer","AssociationYN":"False","AssociationFee":"0","Basement":"Partial,Walkout","City":"Saint Paul","Contingency":"None","Directions":"Minnehaha to Fairview, south to home.","FireplaceYN":"False","NST_Fuel":"Natural Gas","Furnished":"Unfurnished","Latitude":"44.959526","LivingArea":"1567","Longitude":"-93.176856","LotSizeDimensions":"41x118x41x117","LotSizeUnits":"Acres","OwnerPays":"Insurance,Taxes","ParcelNumber":"TBD","PostalCity":"Saint Paul","PostalCode":"55104","PublicRemarks":"Spacious and updated, this charming home offers comfort and convenience in a prime location. The main level features beautiful hardwood floors, while the upstairs has brand-new carpeting. Enjoy cooking and entertaining in the large kitchen, complete with new stainless steel appliances. A versatile main-level bedroom is perfect for a home office. The enclosed front porch provides additional living space, ideal for relaxing or hosting. All windows have been replaced, and the home includes brand-new gutters for peace of mind. The concrete driveway offers off-street parking, and a backyard shed adds valuable extra storage. Located just minutes from the light rail, Newell Park, and the State Fairgrounds—this home combines modern updates with unbeatable convenience. Tenant pays utilities and is responsible for lawn and snow.","PublicSurveyRange":"23","PublicSurveySection":"33","PublicSurveyTownship":"29","NST_RentSpreeYN":"N","NST_RentalLicenseType":"Standard","NST_RentalLicenseYN":"Y","Roof":"Asphalt","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Fairview Ave","StreetNumber":"610","StreetNumberNumeric":"610","StreetSuffix":"Avenue","TenantPays":"All Utilities,Grounds Care,Lawn Care,Snow Removal","YearBuilt":"1883","NST_AboveGradeSqFtTotal":"1567","AboveGradeFinishedArea":"1567","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Hardwood Floors,Kitchen Window,Porch","NST_ApplicationFee":"45","LivingAreaUnits":"Square Feet","AvailabilityDate":"2025-10-27T05:00:00Z","NST_BackgroundCheckReq":"Y","BasementYN":"True","NST_BathDesc":"Upper Level Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"450","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"147","NewConstructionYN":"False","Cooling":"None","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Eat In Kitchen,Separate/Formal Dining Room","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-01-12T15:42:05.835Z","DaysOnMarket":"147","Fencing":"Partial","FireplacesTotal":"0","NST_ForSaleMLNumber":"6782291","FoundationArea":"900","NST_FractionalOwnershipYN":"No","GarageSpaces":"0","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","LaundryFeatures":"None","NST_LeasePrice":"2550","NST_LenderOwned":"No","Levels":"Two","ListingContractDate":"2025-10-27T05:00:00Z","ListingId":"NST6810504","LotFeatures":"Public Transit (w/in 6 blks)","LotSizeArea":"0.112","NST_MainLevelFinishedArea":"900","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"93","OriginalEntryTimestamp":"2025-10-28T18:26:07Z","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Concrete","NST_PatioPorchType":"Enclosed,Front Porch","PhotosCount":"29","PhotosChangeTimestamp":"2026-01-19T19:52:06.197Z","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential Lease","RoadFrontageType":"City Street","NST_SecurityDeposit":"2699","NST_SmokingPermitted":"N","NST_SpecialSearch":"3 BR on One Level","StandardStatus":"Active","SubdivisionName":"Maywood, & Add To, The C","BuildingAreaTotal":"2017","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST53356","ListAgentMlsId":"NST506094338","ListOfficeMlsId":"NST10071","ListOfficeName":"Keller Williams Integrity Realty","ListOfficeKey":"NST16710","ModificationTimestamp":"2026-03-25T14:35:06.067Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Living Room.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/6b9720c1-70ff-445f-8043-f36d2aa849bc.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":999,\"ImageSizeDescription\":\"1500x999\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.221Z\",\"MediaKey\":\"NST119427156\"},{\"Order\":28,\"MediaObjectID\":\"NST28\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Lower Level Laundry Room.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/a561a123-651b-44c9-9393-c0ba84a6410e.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.236Z\",\"MediaKey\":\"NST119427138\"},{\"Order\":25,\"MediaObjectID\":\"NST25\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Bedroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/dcb3d78d-b9c1-485b-834f-28e7ab337742.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.21Z\",\"MediaKey\":\"NST120141909\"},{\"Order\":29,\"MediaObjectID\":\"NST29\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Exterior Rear.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/6f840a83-211e-4c00-8cb3-03a4a3d173d4.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.249Z\",\"MediaKey\":\"NST120141985\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Balcony.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/d722cdc0-49c3-4bae-8b32-064a67faad49.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-14T17:16:10.36Z\",\"MediaKey\":\"NST120141799\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Front Porch.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/15b80eb0-2106-428d-9669-70c738e06ccc.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-14T17:16:10.325Z\",\"MediaKey\":\"NST119427159\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Dining Room.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/d7ed0152-540b-462a-bccf-0436ae5917c1.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.217Z\",\"MediaKey\":\"NST119427155\"},{\"Order\":21,\"MediaObjectID\":\"NST21\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"2nd Floor Primary Bathroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/564ee764-f9e2-4183-8f02-fd09bc93f68d.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.234Z\",\"MediaKey\":\"NST119427143\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Front Porch.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/28dff20f-d822-40d3-acb0-059ef1784316.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-14T17:16:10.331Z\",\"MediaKey\":\"NST119427160\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Living Room.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/26940d36-93eb-497a-b77c-4bd7c463fb09.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-14T17:16:10.33Z\",\"MediaKey\":\"NST119427158\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Kitchen.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/f87415c3-db63-4d06-9bb3-8902e81d9db4.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.244Z\",\"MediaKey\":\"NST120141800\"},{\"Order\":23,\"MediaObjectID\":\"NST23\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"2nd Floor Bedroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/047c0148-d565-41c3-bcb0-1280ec221412.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.257Z\",\"MediaKey\":\"NST119427142\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Bedroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/44145828-1eca-4c11-a475-5f1adfcd1424.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.218Z\",\"MediaKey\":\"NST120141798\"},{\"Order\":19,\"MediaObjectID\":\"NST19\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"2nd Floor Primary Bathroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/2db500fb-9ccd-4f2c-b6ec-f2edb8074b1f.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.189Z\",\"MediaKey\":\"NST119427145\"},{\"Order\":20,\"MediaObjectID\":\"NST20\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"2nd Floor Primary Bathroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/ccdf62a4-ab40-49b9-9e03-6384485ff404.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":999,\"ImageSizeDescription\":\"1500x999\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.254Z\",\"MediaKey\":\"NST119427144\"},{\"Order\":26,\"MediaObjectID\":\"NST26\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"2nd Floor Bedroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/0c847365-9d52-4595-80c5-463241dd21ec.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.234Z\",\"MediaKey\":\"NST119427140\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Bedroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/0c543826-2023-40a1-aa5a-f7ab43067afb.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":999,\"ImageSizeDescription\":\"1500x999\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.217Z\",\"MediaKey\":\"NST119427150\"},{\"Order\":24,\"MediaObjectID\":\"NST24\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"2nd Floor Bedroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/13b825bc-290d-4f5b-911a-409a7f7282f7.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.279Z\",\"MediaKey\":\"NST119427141\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"2nd Floor Primary Bedroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/23bc0f14-1713-4a2f-ab8a-23149c76e565.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.217Z\",\"MediaKey\":\"NST119427146\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Dining Room.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/78945def-986f-43c5-83a1-5e96727ddb91.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.211Z\",\"MediaKey\":\"NST119427154\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Bedroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/8453d7ba-40df-4cae-ad71-768a29fe07cd.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":999,\"ImageSizeDescription\":\"1500x999\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.239Z\",\"MediaKey\":\"NST119427149\"},{\"Order\":18,\"MediaObjectID\":\"NST18\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Bathroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/59c31d70-01ad-4880-a2bd-d59d7e4f5883.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.235Z\",\"MediaKey\":\"NST120141986\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Living Room.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/bd8b27e1-c5d6-47bc-a9a9-241579de12a1.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-14T17:16:10.328Z\",\"MediaKey\":\"NST120141772\"},{\"Order\":27,\"MediaObjectID\":\"NST27\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"2nd Floor Bedroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/3b8a2d37-0e9e-41ee-99d3-cf09e6940c9d.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.247Z\",\"MediaKey\":\"NST119427139\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Living Room.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/44485015-8ac4-4948-a5df-7a0ff66edad3.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-14T17:16:10.39Z\",\"MediaKey\":\"NST120141771\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"2nd Floor Primary Bedroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/d830d4fd-2a33-4828-a431-950871dce7c9.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.218Z\",\"MediaKey\":\"NST119427147\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Exterior Front.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/adbdc890-46df-4191-82b8-5ded90a7e33c.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-14T17:11:53.04Z\",\"MediaKey\":\"NST120141773\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"2nd Floor Primary Bedroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/1a2af74e-a88a-4878-9dd2-a6e42e72f335.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.261Z\",\"MediaKey\":\"NST120141908\"},{\"Order\":22,\"MediaObjectID\":\"NST22\",\"ResourceRecordKey\":\"NST7821202\",\"LongDescription\":\"Bedroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7821202/92441b97-446f-48c3-b325-99fc191a2c06.jpeg\",\"ImageWidth\":1500,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1500x1000\",\"MediaModificationTimestamp\":\"2026-01-19T19:51:09.225Z\",\"MediaKey\":\"NST120141907\"}]","Media__Order":"8","Media__MediaObjectID":"NST8","Media__ResourceRecordKey":"NST7821202","Media__LongDescription":"Living Room.jpg","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7821202/6b9720c1-70ff-445f-8043-f36d2aa849bc.jpeg","Media__ImageWidth":"1500","Media__ImageHeight":"999","Media__ImageSizeDescription":"1500x999","Media__MediaModificationTimestamp":"1/19/2026 7:51:09 PM","Media__MediaKey":"NST119427156","Rooms":"[{\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x12\",\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST115737392\"},{\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"15x12\",\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST115737394\"},{\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST115737397\"},{\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x15\",\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST115737393\"},{\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x12\",\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST115737377\"},{\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST115737395\"},{\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST115737396\"}]","Rooms__RoomType":"Dining Room","Rooms__RoomLevel":"Main","Rooms__RoomDimensions":"12x12","Rooms__NST_RoomSortOrder":"2","Rooms__RoomKey":"NST115737392","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Exterior Front.jpg\"},{\"Order\":2,\"Remarks\":\"Balcony.jpg\"},{\"Order\":3,\"Remarks\":\"Front Porch.jpg\"},{\"Order\":4,\"Remarks\":\"Front Porch.jpg\"},{\"Order\":5,\"Remarks\":\"Living Room.jpg\"},{\"Order\":6,\"Remarks\":\"Living Room.jpg\"},{\"Order\":7,\"Remarks\":\"Living Room.jpg\"},{\"Order\":8,\"Remarks\":\"Living Room.jpg\"},{\"Order\":9,\"Remarks\":\"Dining Room.jpg\"},{\"Order\":10,\"Remarks\":\"Dining Room.jpg\"},{\"Order\":11,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":12,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":13,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":14,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":15,\"Remarks\":\"2nd Floor Primary Bedroom.jpg\"},{\"Order\":16,\"Remarks\":\"2nd Floor Primary Bedroom.jpg\"},{\"Order\":17,\"Remarks\":\"2nd Floor Primary Bedroom.jpg\"},{\"Order\":18,\"Remarks\":\"Bathroom.jpg\"},{\"Order\":19,\"Remarks\":\"2nd Floor Primary Bathroom.jpg\"},{\"Order\":20,\"Remarks\":\"2nd Floor Primary Bathroom.jpg\"},{\"Order\":21,\"Remarks\":\"2nd Floor Primary Bathroom.jpg\"},{\"Order\":22,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":23,\"Remarks\":\"2nd Floor Bedroom.jpg\"},{\"Order\":24,\"Remarks\":\"2nd Floor Bedroom.jpg\"},{\"Order\":25,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":26,\"Remarks\":\"2nd Floor Bedroom.jpg\"},{\"Order\":27,\"Remarks\":\"2nd Floor Bedroom.jpg\"},{\"Order\":28,\"Remarks\":\"Lower Level Laundry Room.jpg\"},{\"Order\":29,\"Remarks\":\"Exterior Rear.jpg\"}]","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","CustomVTourURL":""}
$MLSDESCRIPTION$
610 Fairview Ave Avenue N Saint Paul, MN 55104
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
610 Fairview Ave Avenue N Saint Paul, MN 55104
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$