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$
Capital and Business Opportuni 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":1416901,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6785615","MLSAGENTID":"NST506009396","MLSOFFICEID":"NST49004","ADDRESS":"2701 Gerald Avenue","ACRES":0.22,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block","BATHSTOTAL":2.0,"BEDROOMS":4,"CITY":"North Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Stucco","FORECLOSURE":"No","LASTPRICE":380000.0,"LASTPRICEDATE":"2025-10-02T18:56:03.957","LATITUDE":45.02274,"LENDEROWNED":"No","LISTDATE":"2025-09-09T05:00:00","LISTPRICE":380000.0,"LIVINGAREA":1733.0,"LONGITUDE":-93.006505,"LOTDESCRIPTION":"Many Trees","MODIFICATIONTIMESTAMP":"2025-10-02T19:33:03.669","OFFICE_OFFICENAME":"Capital and Business Opportuni","OUTBUILDINGS":"Storage Shed","PHOTOCOUNT":26,"POSTALCODE":"55109","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Step into this beautifully updated home featuring a large, high-ceiling living room filled with natural light and warmth from hardwood floors throughout. The remodeled kitchen boasts all-new appliances and stylish finishes, while the remodeled bathrooms offer modern comfort and design. Enjoy peace of mind with new windows and plenty of space to relax or entertain in the expansive yard—perfect for gatherings, gardening, or play.\n\nPlease note: there is ongoing road construction, but access is still open. If the street is temporarily blocked, you can park on Mohawk and take a short walk over.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"622-North St Paul-Maplewood","SCHOOLDISTRICTPHONE":"651-748-7410","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-10-02T18:56:03.957","LASTSTATUS":"Active","STREETNAME":"Gerald","STREETNUMBER":"2701","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1957,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-10T13:14:04.893","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"DSC01207.jpeg\"},{\"Order\":2,\"Remarks\":\"DSC01216.jpeg\"},{\"Order\":3,\"Remarks\":\"DSC01215.jpeg\"},{\"Order\":4,\"Remarks\":\"DSC01214.jpeg\"},{\"Order\":5,\"Remarks\":\"DSC01213.jpeg\"},{\"Order\":6,\"Remarks\":\"DSC01212.jpeg\"},{\"Order\":7,\"Remarks\":\"DSC01211.jpeg\"},{\"Order\":8,\"Remarks\":\"DSC01248.jpeg\"},{\"Order\":9,\"Remarks\":\"DSC01247.jpeg\"},{\"Order\":10,\"Remarks\":\"DSC01246.jpeg\"},{\"Order\":11,\"Remarks\":\"DSC01243.jpeg\"},{\"Order\":12,\"Remarks\":\"DSC01237.jpeg\"},{\"Order\":13,\"Remarks\":\"DSC01249.jpeg\"},{\"Order\":14,\"Remarks\":\"DSC01250.jpeg\"},{\"Order\":15,\"Remarks\":\"DSC01241.jpeg\"},{\"Order\":16,\"Remarks\":\"DSC01238.jpeg\"},{\"Order\":17,\"Remarks\":\"DSC01218.jpeg\"},{\"Order\":18,\"Remarks\":\"DSC01229.jpeg\"},{\"Order\":19,\"Remarks\":\"DSC01227.jpeg\"},{\"Order\":20,\"Remarks\":\"DSC01226.jpeg\"},{\"Order\":21,\"Remarks\":\"DSC01225.jpeg\"},{\"Order\":22,\"Remarks\":\"DSC01224.jpeg\"},{\"Order\":23,\"Remarks\":\"DSC01221.jpeg\"},{\"Order\":24,\"Remarks\":\"DSC01219.jpeg\"},{\"Order\":25,\"Remarks\":\"DSC01218.jpeg\"},{\"Order\":26,\"Remarks\":\"DSC01217.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":"NST7799704","LotSizeArea":"0.22","NST_AgeOfProperty":"68","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Hardwood Floors,Kitchen Window,Local Area Network,Natural Woodwork,Other,Patio,Vaulted Ceiling(s),Washer/Dryer Hookup","Appliances":"Cooktop,Dishwasher,Dryer,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer","NST_AssessmentPending":"No","AssociationFeeFrequency":"N/A","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Block","BasementYN":"True","NST_BathDesc":"Main Floor 3/4 Bath,Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"4","City":"North Saint Paul","PropertyType":"Residential","NST_ConstructionMaterialsDesc":"Block,Stone","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"20","CumulativeDaysOnMarket":"20","NST_DiningRoomDescription":"Breakfast Area,Eat In Kitchen,Informal Dining Room,Kitchen/Dining Room,Separate/Formal Dining Room","Directions":"McKnight & 17th Ave","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","NST_ExpectedMarketDate":"2025-09-12","ConstructionMaterials":"Brick/Stone,Stucco","Fencing":"Chain Link,Full","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","FoundationArea":"1056","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage","NST_GarageSquareFeet":"200","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-09-12T05:00:05Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-10-02","Latitude":"45.02274","NST_LenderOwned":"No","ListAgentKey":"NST99451","ListAgentMlsId":"NST506009396","ListingContractDate":"2025-09-09T05:00:00Z","ListOfficeKey":"NST49004","ListOfficeName":"Capital and Business Opportuni","ListOfficeMlsId":"NST49004","ListPrice":"380000","LivingArea":"1733","NST_LockBoxSource":"SPAAR","LockBoxType":"Combo","Longitude":"-93.006505","LotFeatures":"Many Trees","LotSizeDimensions":"76X122X77X121","LotSizeSquareFeet":"9583.2","LotSizeUnits":"Acres","ListingId":"NST6785615","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","OtherStructures":"Storage Shed","ParcelNumber":"022922440045","GarageSpaces":"2","NST_PatioPorchType":"Rear Porch","PhotosCount":"26","PostalCity":"Saint Paul","PostalCode":"55109","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Step into this beautifully updated home featuring a large, high-ceiling living room filled with natural light and warmth from hardwood floors throughout. The remodeled kitchen boasts all-new appliances and stylish finishes, while the remodeled bathrooms offer modern comfort and design. Enjoy peace of mind with new windows and plenty of space to relax or entertain in the expansive yard—perfect for gatherings, gardening, or play.\n\nPlease note: there is ongoing road construction, but access is still open. If the street is temporarily blocked, you can park on Mohawk and take a short walk over.","PublicSurveyRange":"22","PublicSurveySection":"02","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","Roof":"Age 8 Years or Less","RoomType":"Living Room,Dining Room,Kitchen,Bathroom,Bedroom 4,Bedroom 1,Bedroom 2,Bedroom 3,Laundry,Porch","NST_AboveGradeSqFtTotal":"1039.0000","NST_BelowGradeSqFtTotal":"694.0000","NST_MainLevelFinishedArea":"0.0000","BuildingAreaTotal":"1733","HighSchoolDistrict":"North St Paul-Maplewood","NST_SchoolDistrictNumber":"622","NST_SchoolDistrictPhone":"651-748-7410","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1039","BelowGradeFinishedArea":"694","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Four or More Level Split","StreetName":"Gerald","StreetNumber":"2701","StreetNumberNumeric":"2701","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Gudims Highland Hills, Plat 2","NST_TaxWithAssessments":"4356.0000","TaxYear":"2025","TaxAnnualAmount":"4356","WaterSource":"City Water/Connected","YearBuilt":"1957","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-10-02T19:33:03.669Z","PhotosChangeTimestamp":"2025-09-10T13:14:04.893Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7799704\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"DSC01207.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/73faa1af-21d4-4cf7-952c-1412222b793c.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.109Z\",\"MediaKey\":\"68c1797a15bfa838faa3c50a\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"DSC01216.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":684,\"ImageSizeDescription\":\"1024x684\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/c40bf546-4121-426a-9b97-3d0ad09532f5.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.038Z\",\"MediaKey\":\"68c1797a15bfa838faa3c50b\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"DSC01215.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/a20f8abd-3216-475a-9c42-0b501c401f26.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.038Z\",\"MediaKey\":\"68c1797a15bfa838faa3c50c\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"DSC01214.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":684,\"ImageSizeDescription\":\"1024x684\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/623e2760-ae89-41eb-88c7-39ff428b763d.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.038Z\",\"MediaKey\":\"68c1797a15bfa838faa3c50d\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"DSC01213.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":684,\"ImageSizeDescription\":\"1024x684\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/28387bf2-c5a7-48e2-ba06-644d1d21bcbd.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.038Z\",\"MediaKey\":\"68c1797a15bfa838faa3c50e\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"DSC01212.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":684,\"ImageSizeDescription\":\"1024x684\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/8c8bc01f-eb7e-4992-aa0b-0f94617413a6.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.039Z\",\"MediaKey\":\"68c1797a15bfa838faa3c50f\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"DSC01211.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/87436f3f-833b-4763-a20d-669aa3f77abc.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.038Z\",\"MediaKey\":\"68c1797a15bfa838faa3c510\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"DSC01248.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/a468b9c7-8de1-42d7-a22c-c62fcfed14d7.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.075Z\",\"MediaKey\":\"68c1797a15bfa838faa3c511\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"DSC01247.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/cfcf26e3-ceff-41ec-8843-86280367d751.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.038Z\",\"MediaKey\":\"68c1797a15bfa838faa3c512\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"DSC01246.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/951a47d7-6e99-43aa-9e86-bef3f94e1432.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.038Z\",\"MediaKey\":\"68c1797a15bfa838faa3c513\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"DSC01243.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/c554325c-c1ea-4d7f-a8d3-6aeef7817991.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.038Z\",\"MediaKey\":\"68c1797a15bfa838faa3c514\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"DSC01237.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/05b3dcfd-d186-4d40-95bb-843ec9899540.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.038Z\",\"MediaKey\":\"68c1797a15bfa838faa3c515\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"DSC01249.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/c4b2d876-e507-4199-9379-661a2e0f9c98.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.08Z\",\"MediaKey\":\"68c1797a15bfa838faa3c516\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"DSC01250.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/ccc86600-9c16-45c0-a5ba-7c9aa5bd4f2b.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.026Z\",\"MediaKey\":\"68c1797a15bfa838faa3c517\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"DSC01241.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/df01ff1f-3ec8-4101-8a65-9660e8965280.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.038Z\",\"MediaKey\":\"68c1797a15bfa838faa3c518\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"DSC01238.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/780298db-5584-4955-804a-d8a5c055089c.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:29.968Z\",\"MediaKey\":\"68c1797a15bfa838faa3c519\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"DSC01218.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/ce256886-1967-4910-ab3f-00eaf6a2e3e6.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.038Z\",\"MediaKey\":\"68c1797a15bfa838faa3c51a\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":18,\"MediaObjectID\":\"18\",\"LongDescription\":\"DSC01229.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/c456cd06-0040-4bb7-a25d-bd102c83c056.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.026Z\",\"MediaKey\":\"68c1797a15bfa838faa3c51b\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":19,\"MediaObjectID\":\"19\",\"LongDescription\":\"DSC01227.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/e41a76cd-a6a0-4ebd-9434-c5dc0a441f29.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.038Z\",\"MediaKey\":\"68c1797a15bfa838faa3c51c\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":20,\"MediaObjectID\":\"20\",\"LongDescription\":\"DSC01226.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/d0e31c64-5a87-42aa-9665-18f3563a5f8e.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.026Z\",\"MediaKey\":\"68c1797a15bfa838faa3c51d\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":21,\"MediaObjectID\":\"21\",\"LongDescription\":\"DSC01225.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/19ac9a10-b8f9-4ba3-9c57-6875c4d6bc5e.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.087Z\",\"MediaKey\":\"68c1797a15bfa838faa3c51e\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":22,\"MediaObjectID\":\"22\",\"LongDescription\":\"DSC01224.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/503e171d-3fac-422e-9c68-00c2b650a3d7.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.038Z\",\"MediaKey\":\"68c1797a15bfa838faa3c51f\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":23,\"MediaObjectID\":\"23\",\"LongDescription\":\"DSC01221.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/35d4c902-865f-42b7-b240-e28d71f6ce6b.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.038Z\",\"MediaKey\":\"68c1797a15bfa838faa3c520\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":24,\"MediaObjectID\":\"24\",\"LongDescription\":\"DSC01219.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/4bee0a9e-b304-4feb-959f-60c69f29f0ab.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.038Z\",\"MediaKey\":\"68c1797a15bfa838faa3c521\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":25,\"MediaObjectID\":\"25\",\"LongDescription\":\"DSC01218.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/43ada04c-4aac-4906-b8de-025225a3216e.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.124Z\",\"MediaKey\":\"68c1797a15bfa838faa3c522\"},{\"ResourceRecordKey\":\"NST7799704\",\"Order\":26,\"MediaObjectID\":\"26\",\"LongDescription\":\"DSC01217.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799704/798f6f78-a4c7-4f99-b264-5393fa4d1b2e.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T13:13:30.038Z\",\"MediaKey\":\"68c1797a15bfa838faa3c523\"}]","Rooms":"[{\"RoomKey\":\"NST115594726\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15X23\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115594727\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"11X13\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115594728\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"8X17\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115594729\",\"RoomType\":\"Bathroom\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115594730\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"12X12\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115594731\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12X14\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115594732\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11X12\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115594733\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"9X11\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115594734\",\"RoomType\":\"Bathroom\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115594735\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Basement\",\"NST_RoomSortOrder\":\"10\"},{\"RoomKey\":\"NST115594736\",\"RoomType\":\"Porch\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"8X16\",\"NST_RoomSortOrder\":\"11\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"DSC01207.jpeg\"},{\"Order\":2,\"Remarks\":\"DSC01216.jpeg\"},{\"Order\":3,\"Remarks\":\"DSC01215.jpeg\"},{\"Order\":4,\"Remarks\":\"DSC01214.jpeg\"},{\"Order\":5,\"Remarks\":\"DSC01213.jpeg\"},{\"Order\":6,\"Remarks\":\"DSC01212.jpeg\"},{\"Order\":7,\"Remarks\":\"DSC01211.jpeg\"},{\"Order\":8,\"Remarks\":\"DSC01248.jpeg\"},{\"Order\":9,\"Remarks\":\"DSC01247.jpeg\"},{\"Order\":10,\"Remarks\":\"DSC01246.jpeg\"},{\"Order\":11,\"Remarks\":\"DSC01243.jpeg\"},{\"Order\":12,\"Remarks\":\"DSC01237.jpeg\"},{\"Order\":13,\"Remarks\":\"DSC01249.jpeg\"},{\"Order\":14,\"Remarks\":\"DSC01250.jpeg\"},{\"Order\":15,\"Remarks\":\"DSC01241.jpeg\"},{\"Order\":16,\"Remarks\":\"DSC01238.jpeg\"},{\"Order\":17,\"Remarks\":\"DSC01218.jpeg\"},{\"Order\":18,\"Remarks\":\"DSC01229.jpeg\"},{\"Order\":19,\"Remarks\":\"DSC01227.jpeg\"},{\"Order\":20,\"Remarks\":\"DSC01226.jpeg\"},{\"Order\":21,\"Remarks\":\"DSC01225.jpeg\"},{\"Order\":22,\"Remarks\":\"DSC01224.jpeg\"},{\"Order\":23,\"Remarks\":\"DSC01221.jpeg\"},{\"Order\":24,\"Remarks\":\"DSC01219.jpeg\"},{\"Order\":25,\"Remarks\":\"DSC01218.jpeg\"},{\"Order\":26,\"Remarks\":\"DSC01217.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$
2701 Gerald Avenue North Saint Paul, MN 55109
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
2701 Gerald Avenue North Saint Paul, MN 55109
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$