• Active/Pending
  • Clearwater - Recently Sold
  • Clearwater Lake Lots
  • Search MLS #
  • Search other lakes
  • Sign up for automated updates
  • Mortgage calculator
  • Favorites
  • Contact Us
  • MENU

    MLS# 7037604 - 3847 Queen Avenue N Minneapolis, MN 55412

    Neighborhoods

    Piche & Associates Real Estate 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. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.

    {"Id":530780,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7037604","MLSAGENTID":"NST506092102","MLSOFFICEID":"NST80541","ADDRESS":"3847 Queen Avenue N","ACRES":0.12,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Drain Tiled,Partially Finished,Sump Pump","BATHSTOTAL":2.0,"BEDROOMS":2.0,"CITY":"Minneapolis","CONTINGENCY":"None","COUNTY":"Hennepin","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Block,Frame","FORECLOSURE":"No","LASTPRICE":250000.0,"LASTPRICEDATE":"2026-03-19T22:48:05.67","LATITUDE":45.025419,"LENDEROWNED":"No","LISTDATE":"2026-03-19T05:00:00","LISTPRICE":250000.0,"LIVINGAREA":1856.0,"LONGITUDE":-93.310005,"LOTDESCRIPTION":"Public Transit (w/in 6 blks)","MODIFICATIONTIMESTAMP":"2026-03-20T05:05:17.804","NEIGHBORHOOD":"79","OFFICE_OFFICENAME":"Piche & Associates Real Estate","PHOTOCOUNT":28,"POSTALCODE":"55412","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"First time on the market in six decades! Lovingly maintained by same owner, it's time for this home's next chapter. Solid stucco bungalow with 1920's charm (hardwood floors on main & upper levels, natural woodwork, enclosed front porch, built-in buffet) and plenty of big-ticket updates (roof, Andersen windows, mechanicals, plumbing, electrical). This cutie is located in the desirable Victory neighborhood of Minneapolis, close to shopping, dining, parks, and easy access to the freeway system & downtown. Bigger than it looks from the outside, there is plenty of finished space and tons of potential with some cosmetic upgrades. The finished upper-level has two non-conforming bedrooms (due to size.) Other highlights include a 2-car garage, deck, fenced yard, built-in outdoor grill, and drain tile/sump pump in basement. Check out the photos, captions & floor plans for more details!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Architectural Shingle,Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"558-Minneapolis","SCHOOLDISTRICTPHONE":"6126680000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-03-20T05:05:17.803","LASTSTATUS":"Coming Soon","STREETDIRSUFFIX":"N","STREETNAME":"Queen","STREETNUMBER":"3847","STREETSUFFIX":"Avenue","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1922,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-03-20T00:20:05.746","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Welcome to 3847 Queen Ave N!\"},{\"Order\":2,\"Remarks\":\"Inviting Front Porch\"},{\"Order\":3,\"Remarks\":\"Living Room features original natural woodwork in excellent condition\"},{\"Order\":4,\"Remarks\":\"Virtually-staged Living Room\"},{\"Order\":5,\"Remarks\":\"Formal Dining Room with built-in buffet\"},{\"Order\":6,\"Remarks\":\"Kitchen is ready for your ideas for a makeover\"},{\"Order\":7,\"Remarks\":\"Main Floor Bedroom One\"},{\"Order\":8,\"Remarks\":\"Virtually-staged Bedroom One\"},{\"Order\":9,\"Remarks\":\"Main Floor 3/4 Bath (shower could be easily added with access from Bedroom One closet)\"},{\"Order\":10,\"Remarks\":\"Main Floor Bedroom Two\"},{\"Order\":11,\"Remarks\":\"Virtually-staged Bedroom Two\"},{\"Order\":12,\"Remarks\":\"Upper Level\"},{\"Order\":13,\"Remarks\":\"Non-conforming Bedroom in Upper Level\"},{\"Order\":14,\"Remarks\":\"2nd non-conforming Bedroom in Upper Level\"},{\"Order\":15,\"Remarks\":\"Basement Family Room\"},{\"Order\":16,\"Remarks\":\"Virtually-staged Family Room\"},{\"Order\":17,\"Remarks\":\"Basement 3/4 Bath\"},{\"Order\":18,\"Remarks\":\"Basement Office/Den\"},{\"Order\":19,\"Remarks\":\"Handy Workshop in Basement\"},{\"Order\":20,\"Remarks\":\"Glimpse of hardwood floors under carpet in Living Room\"},{\"Order\":21,\"Remarks\":\"Queen-Ave-N-2-002_websize.jpg\"},{\"Order\":22,\"Remarks\":\"2-Stall Garage with extra big apron for easy access to and from alley!\"},{\"Order\":23,\"Remarks\":\"Inside the 2-car Garage\"},{\"Order\":24,\"Remarks\":\"Spacious Deck right out the back door\"},{\"Order\":25,\"Remarks\":\"View of Back Yard\"},{\"Order\":26,\"Remarks\":\"Floor Plan - Main Level\"},{\"Order\":27,\"Remarks\":\"Floor Plan - Upper Level\"},{\"Order\":28,\"Remarks\":\"Floor Plan - Basement\"}]","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","SOURCE":"MG_NST"}
    {"ListingKey":"NST7869176","NST_AboveGradeSqFtTotal":"1238","AboveGradeFinishedArea":"1238","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Ceiling Fan(s),Deck,Hardwood Floors,Kitchen Window,Natural Woodwork,Paneled Doors,Porch,Washer/Dryer Hookup","Appliances":"Dryer,Freezer,Gas Water Heater,Range,Refrigerator,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Block,Drain Tiled,Partially Finished,Sump Pump","BasementYN":"True","NST_BathDesc":"3/4 Basement,Main Floor Full Bath","BathroomsFull":"0","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"2","BathroomsTotalInteger":"2","BedroomsTotal":"2","NST_BelowGradeSqFtTotal":"952","BelowGradeFinishedArea":"618","CumulativeDaysOnMarket":"0","City":"Minneapolis","ConstructionMaterials":"Block,Frame","NewConstructionYN":"False","Contingency":"None","Cooling":"Window Unit(s)","CountyOrParish":"Hennepin","NST_DiningRoomDescription":"Separate/Formal Dining Room","Directions":"Use your favorite GPS app. Or 1/2 block North of Dowling Ave & 1 block West of Penn Ave.","DocumentsCount":"5","DocumentsChangeTimestamp":"2026-03-19T22:47:06.36Z","DaysOnMarket":"0","Electric":"Circuit Breakers,100 Amp Service","NST_ExpectedMarketDate":"2026-03-20","Fencing":"Chain Link,Full","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"952","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"528","GarageSpaces":"2","Heating":"Boiler,Hot Water","HighSchoolDistrict":"Minneapolis","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.025419","LaundryFeatures":"In Basement,Gas Dryer Hookup,Laundry Room,Washer Hookup","NST_LenderOwned":"No","Levels":"One and One Half","ListPrice":"250000","ListingContractDate":"2026-03-19T05:00:00Z","ListingId":"NST7037604","LivingArea":"1856","LockBoxType":"Supra","Longitude":"-93.310005","LotFeatures":"Public Transit (w/in 6 blks)","LotSizeArea":"0.12","LotSizeDimensions":"40 x 127","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"952","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"79","OriginalEntryTimestamp":"2026-03-20T00:00:36Z","ParcelNumber":"0502924410166","NST_SchoolDistrictNumber":"558","ParkingFeatures":"Detached Garage,Garage Door Opener","NST_PatioPorchType":"Deck,Enclosed,Front Porch","PhotosCount":"28","PhotosChangeTimestamp":"2026-03-20T00:20:05.746Z","PoolFeatures":"None","PostalCity":"Minneapolis","PostalCode":"55412","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertyType":"Residential","PublicRemarks":"First time on the market in six decades! Lovingly maintained by same owner, it's time for this home's next chapter. Solid stucco bungalow with 1920's charm (hardwood floors on main & upper levels, natural woodwork, enclosed front porch, built-in buffet) and plenty of big-ticket updates (roof, Andersen windows, mechanicals, plumbing, electrical). This cutie is located in the desirable Victory neighborhood of Minneapolis, close to shopping, dining, parks, and easy access to the freeway system & downtown. Bigger than it looks from the outside, there is plenty of finished space and tons of potential with some cosmetic upgrades. The finished upper-level has two non-conforming bedrooms (due to size.) Other highlights include a 2-car garage, deck, fenced yard, built-in outdoor grill, and drain tile/sump pump in basement. Check out the photos, captions & floor plans for more details!","PublicSurveyRange":"24","PublicSurveySection":"05","PublicSurveyTownship":"29","RoadFrontageType":"City Street","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less,Architectural Shingle,Asphalt,Pitched","NST_SchoolDistrictPhone":"6126680000","Sewer":"City Sewer/Connected","NST_SpecialSearch":"Main Floor Bedroom","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Queen","StreetNumber":"3847","StreetNumberNumeric":"3847","StreetSuffix":"Avenue","SubdivisionName":"Thorpe Bros William Penn Add","TaxAnnualAmount":"4093","NST_TaxWithAssessments":"4093","TaxYear":"2026","BuildingAreaTotal":"2190","Township":"Minneapolis","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1922","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST52010","ListAgentMlsId":"NST506092102","ListOfficeMlsId":"NST80541","ListOfficeName":"Piche & Associates Real Estate","ListOfficeKey":"NST21171","ModificationTimestamp":"2026-03-20T05:05:17.804Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":28,\"MediaObjectID\":\"NST28\",\"LongDescription\":\"Floor Plan - Basement\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/af3fc092-3d8b-4496-adb0-c4d768814b37.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1600x1200\",\"MediaModificationTimestamp\":\"2026-03-20T00:20:04.362Z\",\"MediaKey\":\"NST121031922\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"Virtually-staged Bedroom One\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/c5cfb686-5b7f-44de-b2d5-69c015b89bb2.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.677Z\",\"MediaKey\":\"NST121029763\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"LongDescription\":\"Basement 3/4 Bath\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/569941b0-b289-4484-9e67-5df6086c6f3e.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.7Z\",\"MediaKey\":\"NST121029665\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"Main Floor Bedroom Two\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/b2e0290f-5925-48bc-a195-607ad6fe1563.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.699Z\",\"MediaKey\":\"NST121029671\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"Virtually-staged Bedroom Two\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/82a0a93b-5468-4a4d-a32e-192f64fbebf1.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.723Z\",\"MediaKey\":\"NST121029854\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"Main Floor 3/4 Bath (shower could be easily added with access from Bedroom One closet)\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/8bffca97-88bf-4d31-85b6-58ea7c7db994.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.677Z\",\"MediaKey\":\"NST121029672\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"LongDescription\":\"Virtually-staged Family Room\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/55fa742a-b1bb-4fb2-b40d-a307579483de.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.734Z\",\"MediaKey\":\"NST121029887\"},{\"Order\":20,\"MediaObjectID\":\"NST20\",\"LongDescription\":\"Glimpse of hardwood floors under carpet in Living Room\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/aac047a5-632f-4859-90ca-40ceebb483c5.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.696Z\",\"MediaKey\":\"NST121029652\"},{\"Order\":26,\"MediaObjectID\":\"NST26\",\"LongDescription\":\"Floor Plan - Main Level\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/84b6c8a6-060b-4a0f-a6c7-bb48617fd680.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1600x1200\",\"MediaModificationTimestamp\":\"2026-03-20T00:20:04.372Z\",\"MediaKey\":\"NST121031921\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"LongDescription\":\"Non-conforming Bedroom in Upper Level\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/b70c3e4b-7348-45a3-a1e3-966013a07e4c.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.696Z\",\"MediaKey\":\"NST121029681\"},{\"Order\":18,\"MediaObjectID\":\"NST18\",\"LongDescription\":\"Basement Office/Den\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/5f30839b-c249-4261-898a-e86962d06831.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.69Z\",\"MediaKey\":\"NST121029663\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"Kitchen is ready for your ideas for a makeover\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/4db26e21-a4f8-4fd9-a006-be293dfb2f02.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.785Z\",\"MediaKey\":\"NST121029659\"},{\"Order\":24,\"MediaObjectID\":\"NST24\",\"LongDescription\":\"Spacious Deck right out the back door\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/1a6961fb-d9cc-4e36-bce7-6d26db266e4c.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1201,\"ImageSizeDescription\":\"1600x1201\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.99Z\",\"MediaKey\":\"NST121030845\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"Formal Dining Room with built-in buffet\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/73b3381f-d9a5-4819-aa2e-55033af3525d.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.679Z\",\"MediaKey\":\"NST121029657\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"Virtually-staged Living Room\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/7721b705-8a1e-4650-8a6c-d22dc7521435.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-19T22:47:07.06Z\",\"MediaKey\":\"NST121029890\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"Living Room features original natural woodwork in excellent condition\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/ee73b2a8-8ea9-42cb-9096-9522fddcdbba.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-19T22:47:07.052Z\",\"MediaKey\":\"NST121029654\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"Upper Level\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/306a2269-ed7c-496b-97d6-da1df5f9d99f.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.676Z\",\"MediaKey\":\"NST121029683\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"LongDescription\":\"2nd non-conforming Bedroom in Upper Level\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/f6b86435-2d97-4767-9f86-42c530318210.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.723Z\",\"MediaKey\":\"NST121029679\"},{\"Order\":22,\"MediaObjectID\":\"NST22\",\"LongDescription\":\"2-Stall Garage with extra big apron for easy access to and from alley!\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/0f1913f8-dd3b-41de-868f-f401908252ba.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1201,\"ImageSizeDescription\":\"1600x1201\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.691Z\",\"MediaKey\":\"NST121030843\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"LongDescription\":\"Basement Family Room\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/764ea934-9949-4091-8968-5f28c16d3a06.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.731Z\",\"MediaKey\":\"NST121029669\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"Main Floor Bedroom One\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/214d6ee0-fbc9-494b-9084-f2c18639c2bf.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.696Z\",\"MediaKey\":\"NST121029675\"},{\"Order\":23,\"MediaObjectID\":\"NST23\",\"LongDescription\":\"Inside the 2-car Garage\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/b71a66d0-ce8e-4710-a011-622fa1772068.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.737Z\",\"MediaKey\":\"NST121029650\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"Welcome to 3847 Queen Ave N!\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/aa946b46-4352-4b64-9863-6a6624709904.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1201,\"ImageSizeDescription\":\"1600x1201\",\"MediaModificationTimestamp\":\"2026-03-19T22:47:07.105Z\",\"MediaKey\":\"NST121030841\"},{\"Order\":27,\"MediaObjectID\":\"NST27\",\"LongDescription\":\"Floor Plan - Upper Level\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/b2cedcf0-f21b-4289-b774-117dc93c865f.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1600x1200\",\"MediaModificationTimestamp\":\"2026-03-20T00:20:04.358Z\",\"MediaKey\":\"NST121031920\"},{\"Order\":21,\"MediaObjectID\":\"NST21\",\"LongDescription\":\"Queen-Ave-N-2-002_websize.jpg\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/19243703-b8e1-4349-a9ad-3f0cc778608c.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1201,\"ImageSizeDescription\":\"1600x1201\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.682Z\",\"MediaKey\":\"NST121030844\"},{\"Order\":25,\"MediaObjectID\":\"NST25\",\"LongDescription\":\"View of Back Yard\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/c8c1b655-1a02-4ad3-b0bb-779111aa2e8b.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1201,\"ImageSizeDescription\":\"1600x1201\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.763Z\",\"MediaKey\":\"NST121030842\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"Inviting Front Porch\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/918c7879-7bbc-4bbe-9c4f-a0be2790888e.jpeg\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaModificationTimestamp\":\"2026-03-19T22:47:07.07Z\",\"MediaKey\":\"NST121029653\"},{\"Order\":19,\"MediaObjectID\":\"NST19\",\"LongDescription\":\"Handy Workshop in Basement\",\"ResourceRecordKey\":\"NST7869176\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869176/02d66002-b359-4a59-8003-803468a9e407.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-20T00:19:04.78Z\",\"MediaKey\":\"NST121030364\"}]","Media__Order":"28","Media__MediaObjectID":"NST28","Media__LongDescription":"Floor Plan - Basement","Media__ResourceRecordKey":"NST7869176","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7869176/af3fc092-3d8b-4496-adb0-c4d768814b37.jpeg","Media__ImageWidth":"1600","Media__ImageHeight":"1200","Media__ImageSizeDescription":"1600x1200","Media__MediaModificationTimestamp":"3/20/2026 12:20:04 AM","Media__MediaKey":"NST121031922","Rooms":"[{\"RoomType\":\"Bonus Room\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"21 x 10\",\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116032564\"},{\"RoomType\":\"Deck\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16 x 13\",\"NST_RoomSortOrder\":11,\"RoomKey\":\"NST116032569\"},{\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14 x 10\",\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116032560\"},{\"RoomType\":\"Family Room\",\"RoomLevel\":\"Basement\",\"RoomDimensions\":\"25 x 17\",\"NST_RoomSortOrder\":9,\"RoomKey\":\"NST116032567\"},{\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12 x 11\",\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116032562\"},{\"RoomType\":\"Flex Room\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12 x 11\",\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116032565\"},{\"RoomType\":\"Flex Room\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"10 x 8\",\"NST_RoomSortOrder\":8,\"RoomKey\":\"NST116032566\"},{\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12 x 10\",\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116032561\"},{\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14 x 11\",\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116032559\"},{\"RoomType\":\"Office\",\"RoomLevel\":\"Basement\",\"RoomDimensions\":\"8 x 8\",\"NST_RoomSortOrder\":10,\"RoomKey\":\"NST116032568\"},{\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12 x 11\",\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116032563\"}]","Rooms__RoomType":"Bonus Room","Rooms__RoomLevel":"Upper","Rooms__RoomDimensions":"21 x 10","Rooms__NST_RoomSortOrder":"6","Rooms__RoomKey":"NST116032564","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Welcome to 3847 Queen Ave N!\"},{\"Order\":2,\"Remarks\":\"Inviting Front Porch\"},{\"Order\":3,\"Remarks\":\"Living Room features original natural woodwork in excellent condition\"},{\"Order\":4,\"Remarks\":\"Virtually-staged Living Room\"},{\"Order\":5,\"Remarks\":\"Formal Dining Room with built-in buffet\"},{\"Order\":6,\"Remarks\":\"Kitchen is ready for your ideas for a makeover\"},{\"Order\":7,\"Remarks\":\"Main Floor Bedroom One\"},{\"Order\":8,\"Remarks\":\"Virtually-staged Bedroom One\"},{\"Order\":9,\"Remarks\":\"Main Floor 3/4 Bath (shower could be easily added with access from Bedroom One closet)\"},{\"Order\":10,\"Remarks\":\"Main Floor Bedroom Two\"},{\"Order\":11,\"Remarks\":\"Virtually-staged Bedroom Two\"},{\"Order\":12,\"Remarks\":\"Upper Level\"},{\"Order\":13,\"Remarks\":\"Non-conforming Bedroom in Upper Level\"},{\"Order\":14,\"Remarks\":\"2nd non-conforming Bedroom in Upper Level\"},{\"Order\":15,\"Remarks\":\"Basement Family Room\"},{\"Order\":16,\"Remarks\":\"Virtually-staged Family Room\"},{\"Order\":17,\"Remarks\":\"Basement 3/4 Bath\"},{\"Order\":18,\"Remarks\":\"Basement Office/Den\"},{\"Order\":19,\"Remarks\":\"Handy Workshop in Basement\"},{\"Order\":20,\"Remarks\":\"Glimpse of hardwood floors under carpet in Living Room\"},{\"Order\":21,\"Remarks\":\"Queen-Ave-N-2-002_websize.jpg\"},{\"Order\":22,\"Remarks\":\"2-Stall Garage with extra big apron for easy access to and from alley!\"},{\"Order\":23,\"Remarks\":\"Inside the 2-car Garage\"},{\"Order\":24,\"Remarks\":\"Spacious Deck right out the back door\"},{\"Order\":25,\"Remarks\":\"View of Back Yard\"},{\"Order\":26,\"Remarks\":\"Floor Plan - Main Level\"},{\"Order\":27,\"Remarks\":\"Floor Plan - Upper Level\"},{\"Order\":28,\"Remarks\":\"Floor Plan - Basement\"}]","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","CustomVTourURL":""}
    ©2026, All rights reserved. Created with REC by AfterNorth.