{"Id":575432,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7094098","MLSAGENTID":"NST502028288","MLSCOAGENTID":"NST506019121","MLSOFFICEID":"NST253197","ADDRESS":"1875 Garden Way","ACRES":0.05,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Egress Window(s),Finished,Full","BATHSTOTAL":3.0,"BEDROOMS":3.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":305000.0,"LASTPRICEDATE":"2026-06-20T00:00:08.047","LATITUDE":44.95347399,"LENDEROWNED":"No","LISTDATE":"2026-06-19T05:00:00","LISTPRICE":305000.0,"LIVINGAREA":1675.0,"LONGITUDE":-93.02093784,"MODIFICATIONTIMESTAMP":"2026-06-20T12:10:06.255","NEIGHBORHOOD":"88","OFFICE_OFFICENAME":"The Mission Team Realty, LLC","PHOTOCOUNT":11,"POSTALCODE":"55119","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to this beautifully maintained 3-bedroom, 3-bathroom townhome, ideally located with easy freeway access and conveniently close to shopping, dining, parks,and everyday amenities. The open-concept design offers comfortable living and entertaining spaces throughout. Upstairs, you'll find a spacious primary suite, a second bedroom, and a versatile loft overlooking the main level. The main floor features a bright and inviting living room, dining area, and a thoughtfully designed kitchen. The lower level includes a third bedroom and a large family room, providing additional space for guests, recreation, or a home office.\n\nRecent updates include fresh paint throughout, new carpeting, and newer stainless-steel appliances. The roof was replaced just two years ago, offering added peace of mind. Step outside and enjoy the semi-private backyard, perfect for relaxing or entertaining. This move-in-ready home combines comfort, convenience, and an excellent location.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Architectural Shingle","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-06-20T00:00:08.047","LASTSTATUS":"Active","STREETNAME":"Garden","STREETNUMBER":"1875","STREETSUFFIX":"Way","STYLE":"(TH) Quad/4 Corners","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2006,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-06-20T12:10:06.255","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"10504.jpg\"},{\"Order\":2,\"Remarks\":\"image3.jpg\"},{\"Order\":3,\"Remarks\":\"image2.jpg\"},{\"Order\":4,\"Remarks\":\"10498.jpg\"},{\"Order\":5,\"Remarks\":\"10499.jpg\"},{\"Order\":6,\"Remarks\":\"image6.jpg\"},{\"Order\":7,\"Remarks\":\"image5.jpg\"},{\"Order\":8,\"Remarks\":\"10554.jpg\"},{\"Order\":9,\"Remarks\":\"10555.jpg\"},{\"Order\":10,\"Remarks\":\"10556.jpg\"},{\"Order\":11,\"Remarks\":\"10557.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11","SOURCE":"MG_NST"}
{"ListingKey":"NST7920141","NST_AboveGradeSqFtTotal":"1225","AboveGradeFinishedArea":"1225","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","Appliances":"Cooktop,Dishwasher,Dryer,Microwave,Range,Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"True","AssociationFee":"535","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Hazard Insurance,Lawn Care,Snow Removal","AssociationName":"Ideal Property Investments","AssociationPhone":"6125051561","Basement":"Block,Egress Window(s),Finished,Full","BasementYN":"True","NST_BathDesc":"3/4 Basement,Private Primary,Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"2","BathroomsTotalInteger":"3","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"450","BelowGradeFinishedArea":"450","CumulativeDaysOnMarket":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Informal Dining Room","Directions":"94 to White Bear Ave, N to Old Hudson RD, E to Hazel, north to Garden Way.","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-06-19T23:59:06.849Z","DaysOnMarket":"0","Electric":"150 Amp Service","ExteriorFeatures":"Block,Cement Board","Fencing":"Chain Link","FireplacesTotal":"0","FoundationArea":"710","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"400","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.9534739851","LaundryFeatures":"In Basement","NST_LenderOwned":"No","Levels":"Two","ListPrice":"305000","ListingContractDate":"2026-06-19T05:00:00Z","ListingId":"NST7094098","LivingArea":"1675","LockBoxType":"Supra","Longitude":"-93.0209378364","LotSizeArea":"0.05","LotSizeDimensions":"00x00","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"584","NST_ManufacturedHome":"N","NST_NeighborhoodName":"Battle Creek-Highwood","NST_NeighborhoodNumber":"88","OriginalEntryTimestamp":"2026-06-19T18:58:19Z","ParcelNumber":"352922320078","ParkingFeatures":"Attached Garage","PhotosCount":"11","PhotosChangeTimestamp":"2026-06-20T12:10:06.255Z","PostalCity":"Saint Paul","PostalCode":"55119","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(TH) Quad/4 Corners","PropertyType":"Residential","PublicRemarks":"Welcome to this beautifully maintained 3-bedroom, 3-bathroom townhome, ideally located with easy freeway access and conveniently close to shopping, dining, parks,and everyday amenities. The open-concept design offers comfortable living and entertaining spaces throughout. Upstairs, you'll find a spacious primary suite, a second bedroom, and a versatile loft overlooking the main level. The main floor features a bright and inviting living room, dining area, and a thoughtfully designed kitchen. The lower level includes a third bedroom and a large family room, providing additional space for guests, recreation, or a home office.\n\nRecent updates include fresh paint throughout, new carpeting, and newer stainless-steel appliances. The roof was replaced just two years ago, offering added peace of mind. Step outside and enjoy the semi-private backyard, perfect for relaxing or entertaining. This move-in-ready home combines comfort, convenience, and an excellent location.","RoadFrontageType":"City Street,Private Road","Roof":"Age 8 Years or Less,Architectural Shingle","NST_SchoolDistrictFullName":"625 - St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","NST_SingleFamilyTownhouseType":"Not Applicable","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Garden","StreetNumber":"1875","StreetNumberNumeric":"1875","StreetSuffix":"Way","SubdivisionName":"Hazel Gardens","TaxAnnualAmount":"3904","NST_TaxWithAssessments":"3904","TaxYear":"2026","NST_TotalArea":"1675","BuildingAreaTotal":"1675","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"2006","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST505959","CoListAgentMlsId":"NST506019121","CoListOfficeName":"The Mission Team Realty, LLC","ListAgentKey":"NST82376","ListAgentMlsId":"NST502028288","ListOfficeMlsId":"NST253197","ListOfficeName":"The Mission Team Realty, LLC","ListOfficeKey":"NST1001940","ModificationTimestamp":"2026-06-20T12:10:06.255Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"image5.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7920141/fff21fb3-fe1d-4aeb-9bd2-35bebd5102ba.jpeg\",\"ResourceRecordKey\":\"NST7920141\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2026-06-20T12:09:05.873Z\",\"MediaKey\":\"NST123098045\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"image6.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7920141/d8498052-8ffd-40b8-89a1-1216f2c73594.jpeg\",\"ResourceRecordKey\":\"NST7920141\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2026-06-19T23:59:11.429Z\",\"MediaKey\":\"NST123098044\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"10554.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7920141/fbf165c1-7bb0-4257-a3ef-44872a6ac0a1.jpeg\",\"ResourceRecordKey\":\"NST7920141\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-20T12:09:05.906Z\",\"MediaKey\":\"NST123100760\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"image2.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7920141/b77226d7-da3d-439b-abf1-7de1f7318bb6.jpeg\",\"ResourceRecordKey\":\"NST7920141\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2026-06-20T12:10:05.91Z\",\"MediaKey\":\"NST123098047\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"10555.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7920141/35b9b857-5e99-4dec-b7dd-103a07a35eff.jpeg\",\"ResourceRecordKey\":\"NST7920141\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-20T12:09:05.947Z\",\"MediaKey\":\"NST123100759\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"image3.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7920141/b47efdb1-0cd4-46ac-8f56-e06f5cb8bd98.jpeg\",\"ResourceRecordKey\":\"NST7920141\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2026-06-20T12:09:05.878Z\",\"MediaKey\":\"NST123098046\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"10557.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7920141/fdcc3f95-1569-4f52-a599-6965eb4f1239.jpeg\",\"ResourceRecordKey\":\"NST7920141\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-20T12:09:05.878Z\",\"MediaKey\":\"NST123100757\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"10498.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7920141/70a71ccf-2499-40ab-a985-99462ba9313e.jpeg\",\"ResourceRecordKey\":\"NST7920141\",\"ImageWidth\":2080,\"ImageHeight\":960,\"ImageSizeDescription\":\"2080x960\",\"MediaModificationTimestamp\":\"2026-06-19T23:59:11.457Z\",\"MediaKey\":\"NST123098051\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"10499.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7920141/00898b98-18bd-4f42-a72f-64558cb60566.jpeg\",\"ResourceRecordKey\":\"NST7920141\",\"ImageWidth\":2080,\"ImageHeight\":960,\"ImageSizeDescription\":\"2080x960\",\"MediaModificationTimestamp\":\"2026-06-19T23:59:11.503Z\",\"MediaKey\":\"NST123098050\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"10504.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7920141/c38115f2-4b00-4f8a-80fb-433a5fe2cff2.jpeg\",\"ResourceRecordKey\":\"NST7920141\",\"ImageWidth\":1327,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1327x2080\",\"MediaModificationTimestamp\":\"2026-06-20T12:09:05.897Z\",\"MediaKey\":\"NST123097917\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"10556.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7920141/2e28d625-8043-4c58-8dc5-a75155b608ce.jpeg\",\"ResourceRecordKey\":\"NST7920141\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-06-20T12:10:05.943Z\",\"MediaKey\":\"NST123100758\"}]","Media__Order":"7","Media__MediaObjectID":"NST7","Media__LongDescription":"image5.jpg","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7920141/fff21fb3-fe1d-4aeb-9bd2-35bebd5102ba.jpeg","Media__ResourceRecordKey":"NST7920141","Media__ImageWidth":"1024","Media__ImageHeight":"768","Media__ImageSizeDescription":"1024x768","Media__MediaModificationTimestamp":"6/20/2026 12:09:05 PM","Media__MediaKey":"NST123098045","Rooms":"[{\"RoomKey\":\"NST116361183\",\"RoomDimensions\":\"10x10\",\"NST_RoomSortOrder\":2,\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116361190\",\"RoomDimensions\":\"18x12\",\"NST_RoomSortOrder\":9,\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\"},{\"RoomKey\":\"NST116361185\",\"RoomDimensions\":\"14x13\",\"NST_RoomSortOrder\":4,\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Upper\"},{\"RoomKey\":\"NST116361189\",\"RoomDimensions\":\"15x4\",\"NST_RoomSortOrder\":8,\"RoomType\":\"Foyer\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116361184\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":3,\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116361191\",\"RoomDimensions\":\"12x7\",\"NST_RoomSortOrder\":10,\"RoomType\":\"Laundry\",\"RoomLevel\":\"Lower\"},{\"RoomKey\":\"NST116361182\",\"RoomDimensions\":\"18x14\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116361188\",\"RoomDimensions\":\"10x8\",\"NST_RoomSortOrder\":7,\"RoomType\":\"Loft\",\"RoomLevel\":\"Upper\"},{\"RoomKey\":\"NST116361192\",\"RoomDimensions\":\"12x4\",\"NST_RoomSortOrder\":11,\"RoomType\":\"Patio\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116361186\",\"RoomDimensions\":\"12x10\",\"NST_RoomSortOrder\":5,\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\"},{\"RoomKey\":\"NST116361187\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Lower\"}]","Rooms__RoomKey":"NST116361183","Rooms__RoomDimensions":"10x10","Rooms__NST_RoomSortOrder":"2","Rooms__RoomType":"Dining Room","Rooms__RoomLevel":"Main","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"10504.jpg\"},{\"Order\":2,\"Remarks\":\"image3.jpg\"},{\"Order\":3,\"Remarks\":\"image2.jpg\"},{\"Order\":4,\"Remarks\":\"10498.jpg\"},{\"Order\":5,\"Remarks\":\"10499.jpg\"},{\"Order\":6,\"Remarks\":\"image6.jpg\"},{\"Order\":7,\"Remarks\":\"image5.jpg\"},{\"Order\":8,\"Remarks\":\"10554.jpg\"},{\"Order\":9,\"Remarks\":\"10555.jpg\"},{\"Order\":10,\"Remarks\":\"10556.jpg\"},{\"Order\":11,\"Remarks\":\"10557.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11","CustomVTourURL":""}