• 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# 6770993 - 951 Front Avenue Saint Paul, MN 55103

    Neighborhoods

    VIBE 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. 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":487719,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6770993","MLSAGENTID":"NST506021068","MLSCOAGENTID":"NST502044523","MLSOFFICEID":"NST26321","ADDRESS":"951 Front Avenue","ACRES":0.124,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Finished,Full,Tile Shower","BATHSTOTAL":3.0,"BEDROOMS":3,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Concrete","FORECLOSURE":"No","LASTPRICE":424900.0,"LASTPRICEDATE":"2025-12-23T04:30:05.303","LATITUDE":44.970436,"LENDEROWNED":"No","LISTDATE":"2025-10-15T05:00:00","LISTPRICE":375000.0,"LIVINGAREA":2065.0,"LONGITUDE":-93.140165,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Tree Coverage - Medium","MODIFICATIONTIMESTAMP":"2025-12-23T04:30:05.302","NEIGHBORHOOD":"89","OFFICE_OFFICENAME":"VIBE Realty","OUTBUILDINGS":"Garage(s),Storage Shed","PHOTOCOUNT":37,"POSTALCODE":"55103","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Fully renovated home with updated roof, siding, windows, leaf-blocking gutters, AC, HVAC, tankless water heater, and new sewer line. Electrical has been updated to 200-amp service in the house and 100-amp service in the garage, allowing for potential EV charging. Mini-split systems installed in the upper-level bedrooms provide zoned heating and cooling. \n\nProperty includes a large fenced-in yard and located a few blocks from Lake Como - ideal for dog owners. Nearby amenities include Como Golf Course, Como Zoo, Como Pavilion, Orchard Recreation Center, and McMurray Fields. The home is conveniently located between downtown Minneapolis and St. Paul and sits along the Route 3 bus line. Additional nearby destinations include University Avenue light rail, Target and Allianz Field, Grand Avenue shopping and dining, and Rosedale Center within approximately five miles. Come check it out!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-10-17T05:03:07.6","LASTSTATUS":"Coming Soon","STREETNAME":"Front","STREETNUMBER":"951","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1912,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-12-23T04:30:05.302","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Welcome to 951 Front Ave!\"},{\"Order\":2,\"Remarks\":\"Inviting entry with raised plant boxes\"},{\"Order\":3,\"Remarks\":\"Well-lit walkway introduces the home\"},{\"Order\":4,\"Remarks\":\"Side view highlights newer roof, siding, gutters, and landscaping\"},{\"Order\":5,\"Remarks\":\"Side walkway connects front to back\"},{\"Order\":6,\"Remarks\":\"Front view highlights the home's elevated position atop the lot\"},{\"Order\":7,\"Remarks\":\"Built-in planter boxes let you design your ideal garden\"},{\"Order\":8,\"Remarks\":\"Fully customized kitchen with new appliances and butler's pantry\"},{\"Order\":9,\"Remarks\":\"Handmade concrete island, countertops, and barstools\"},{\"Order\":10,\"Remarks\":\"Copper pendant lighting over the island\"},{\"Order\":11,\"Remarks\":\"Formal dining area with handcrafted table and chairs for eight\"},{\"Order\":12,\"Remarks\":\"Thoughtfully designed copper light fixture and artwork add character\"},{\"Order\":13,\"Remarks\":\"Built-in window benches with hidden storage; hardwood floors throughout\"},{\"Order\":14,\"Remarks\":\"Convenient main-level half bath\"},{\"Order\":15,\"Remarks\":\"Living room featuring custom wainscoting, sconces, and built-in bookshelf\"},{\"Order\":16,\"Remarks\":\"Living room opens to a bright four-season porch\"},{\"Order\":17,\"Remarks\":\"Four-season porch with beadboard ceiling and ceiling fan\"},{\"Order\":18,\"Remarks\":\"Handcrafted copper staircase leads to the upper level\"},{\"Order\":19,\"Remarks\":\"Upper-level bedroom with newer windows and mini-split for year-round comfort\"},{\"Order\":20,\"Remarks\":\"Bright office nook with natural light\"},{\"Order\":21,\"Remarks\":\"Fully customized upper-level bath with industrial design touches\"},{\"Order\":22,\"Remarks\":\"Primary bedroom with handmade bed frame and mini-split\"},{\"Order\":23,\"Remarks\":\"Cleverly designed sliding closets maximize storage\"},{\"Order\":24,\"Remarks\":\"Brand-new flex room - perfect for an office, guest room, or studio\"},{\"Order\":25,\"Remarks\":\"Versatile lower level - ideal for gym or additional living space\"},{\"Order\":26,\"Remarks\":\"Newer washer, dryer, tankless water heater, and 200-Amp electrical service\"},{\"Order\":27,\"Remarks\":\"Custom-built bath with walk-in shower\"},{\"Order\":28,\"Remarks\":\"Lower-level bedroom with exposed wood ceiling beams\"},{\"Order\":29,\"Remarks\":\"Outdoor dining area ideal for hosting or unwinding\"},{\"Order\":30,\"Remarks\":\"Fenced yard with mature trees and a spacious side lawn\"},{\"Order\":31,\"Remarks\":\"Two-car garage with space for additional parking\"},{\"Order\":32,\"Remarks\":\"Back patio is perfect for relaxing or gathering around a fire pit\"},{\"Order\":33,\"Remarks\":\"View of the home from the alley access\"},{\"Order\":34,\"Remarks\":\"Great location just blocks from Lake Como\"},{\"Order\":35,\"Remarks\":\"Close to dining, entertainment, and shopping\"},{\"Order\":36,\"Remarks\":\"Easy access to walking trails and outdoor recreation\"},{\"Order\":37,\"Remarks\":\"Enjoy the peaceful charm of St. Paul living\"}]","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":"NST7786963","Appliances":"Dishwasher,Dryer,Freezer,Microwave,Range,Refrigerator,Stainless Steel Appliances,Tankless Water Heater,Washer","AssociationYN":"False","AssociationFee":"0","AttributionContact":"chris@vibemn.com","NST_AttributionName":"Christopher Yortsos","Basement":"Block,Finished,Full,Tile Shower","CarportSpaces":"0","City":"Saint Paul","Contingency":"None","Directions":"Lexington Parkway North to Front Avenue - East to home","Electric":"200+ Amp Service","FireplaceYN":"False","NST_Fuel":"Natural Gas","NST_GarageDimensions":"18 x 17","NST_GarageDoorHeight":"7","NST_GarageDoorWidth":"16","Latitude":"44.970436","ListPrice":"375000","LivingArea":"2065","LockBoxType":"Supra","Longitude":"-93.140165","LotSizeDimensions":"108 x 50","LotSizeUnits":"Acres","ParcelNumber":"262923240168","PostalCity":"Saint Paul","PostalCode":"55103","PublicRemarks":"Fully renovated home with updated roof, siding, windows, leaf-blocking gutters, AC, HVAC, tankless water heater, and new sewer line. Electrical has been updated to 200-amp service in the house and 100-amp service in the garage, allowing for potential EV charging. Mini-split systems installed in the upper-level bedrooms provide zoned heating and cooling. \n\nProperty includes a large fenced-in yard and located a few blocks from Lake Como - ideal for dog owners. Nearby amenities include Como Golf Course, Como Zoo, Como Pavilion, Orchard Recreation Center, and McMurray Fields. The home is conveniently located between downtown Minneapolis and St. Paul and sits along the Route 3 bus line. Additional nearby destinations include University Avenue light rail, Target and Allianz Field, Grand Avenue shopping and dining, and Rosedale Center within approximately five miles. Come check it out!","PublicSurveyRange":"23","PublicSurveySection":"26","PublicSurveyTownship":"29","Roof":"Age 8 Years or Less","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StateOrProvince":"MN","StreetName":"Front","StreetNumber":"951","StreetNumberNumeric":"951","StreetSuffix":"Avenue","TaxYear":"2025","YearBuilt":"1912","NST_AboveGradeSqFtTotal":"1615","AboveGradeFinishedArea":"1615","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Ceiling Fan(s),Hardwood Floors,Kitchen Center Island,Kitchen Window,Primary Bedroom Walk-In Closet,Porch,Washer/Dryer Hookup","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Yes","BasementYN":"True","NST_BathDesc":"3/4 Basement,Main Floor 1/2 Bath,Upper Level 3/4 Bath","BathroomsFull":"0","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"2","BathroomsTotalInteger":"3","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"450","BelowGradeFinishedArea":"450","CumulativeDaysOnMarket":"0","ConstructionMaterials":"Concrete","NewConstructionYN":"False","Cooling":"Central Air,Ductless Mini-Split","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Breakfast Area,Living/Dining Room,Separate/Formal Dining Room","DocumentsCount":"3","DocumentsChangeTimestamp":"2025-12-23T04:30:05.302Z","DaysOnMarket":"0","NST_ExpectedMarketDate":"2025-10-17","Fencing":"Chain Link,Full","FireplacesTotal":"0","FoundationArea":"932","NST_FractionalOwnershipYN":"No","NST_GarageSquareFeet":"324","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","LaundryFeatures":"In Basement,Laundry Room","NST_LenderOwned":"No","Levels":"One and One Half","ListingContractDate":"2025-10-15T05:00:00Z","ListingId":"NST6770993","LotFeatures":"Public Transit (w/in 6 blks),Tree Coverage - Medium","LotSizeArea":"0.124","NST_MainLevelFinishedArea":"932","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"89","OriginalEntryTimestamp":"2025-10-17T00:00:05Z","OtherStructures":"Garage(s),Storage Shed","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Detached Garage,Asphalt,Garage Door Opener","NST_PatioPorchType":"Enclosed,Front Porch,Patio,Screened","PhotosCount":"37","PhotosChangeTimestamp":"2025-12-23T04:30:05.302Z","PoolFeatures":"None","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","RoadFrontageType":"Paved Streets,Sidewalks","RoadResponsibility":"Public Maintained Road","NST_SpecialSearch":"Renovated","StandardStatus":"Active","SubdivisionName":"Denslows Sub Of, Lots 5","TaxAnnualAmount":"4490","NST_TaxWithAssessments":"4490","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST102779","CoListAgentMlsId":"NST502044523","CoListOfficeName":"VIBE Realty","ListAgentKey":"NST520743","ListAgentMlsId":"NST506021068","ListOfficeMlsId":"NST26321","ListOfficeName":"VIBE Realty","ListOfficeKey":"NST26321","ModificationTimestamp":"2025-12-23T04:30:05.302Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Copper pendant lighting over the island\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/6bdb6ed9-847c-4a46-a1c3-d27b7397acdd.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.153Z\",\"MediaKey\":\"NST119216807\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Great location just blocks from Lake Como\",\"Order\":34,\"MediaObjectID\":\"NST34\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/410d451c-121d-4ec1-b6dd-5e48b9ffadea.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1385,\"ImageSizeDescription\":\"2080x1385\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.168Z\",\"MediaKey\":\"NST119216788\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Front view highlights the home's elevated position atop the lot\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/91518701-bb52-4694-abc4-8405af8e1414.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.175Z\",\"MediaKey\":\"NST119216818\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Lower-level bedroom with exposed wood ceiling beams\",\"Order\":28,\"MediaObjectID\":\"NST28\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/15c44489-688c-42a0-9ed4-35c3d876d813.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.154Z\",\"MediaKey\":\"NST119216797\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Brand-new flex room - perfect for an office, guest room, or studio\",\"Order\":24,\"MediaObjectID\":\"NST24\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/3dd3c108-aeef-4497-9cd7-8523c57fd167.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.166Z\",\"MediaKey\":\"NST119216801\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Well-lit walkway introduces the home\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/052d4c52-c26f-4804-8d9c-16d7547621b2.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.191Z\",\"MediaKey\":\"NST119216824\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Cleverly designed sliding closets maximize storage\",\"Order\":23,\"MediaObjectID\":\"NST23\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/18976b8a-26e1-4a8c-b073-839976a8a4c5.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.154Z\",\"MediaKey\":\"NST119216802\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Formal dining area with handcrafted table and chairs for eight\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/3b203914-5f56-4bfe-b986-e2c210a64505.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.158Z\",\"MediaKey\":\"NST119216812\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Primary bedroom with handmade bed frame and mini-split\",\"Order\":22,\"MediaObjectID\":\"NST22\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/61b2ee45-0f68-49b8-ae52-5465929f6d32.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.131Z\",\"MediaKey\":\"NST119216803\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Thoughtfully designed copper light fixture and artwork add character\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/f09d3186-7074-4687-84b3-0a87882d7370.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.167Z\",\"MediaKey\":\"NST119216813\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Close to dining, entertainment, and shopping\",\"Order\":35,\"MediaObjectID\":\"NST35\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/5c388ab8-ec2c-49d9-8dc4-ea18ee5fc1f0.jpeg\",\"ImageWidth\":1386,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1386x2080\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.178Z\",\"MediaKey\":\"NST119216789\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Bright office nook with natural light\",\"Order\":20,\"MediaObjectID\":\"NST20\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/53af3a8c-2f30-4597-90e4-385d5dc1c5c2.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.15Z\",\"MediaKey\":\"NST119216805\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Back patio is perfect for relaxing or gathering around a fire pit\",\"Order\":32,\"MediaObjectID\":\"NST32\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/00d73749-887b-4e71-94d3-8b365d82b95c.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.15Z\",\"MediaKey\":\"NST119216822\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Versatile lower level - ideal for gym or additional living space\",\"Order\":25,\"MediaObjectID\":\"NST25\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/0d7ab677-7505-4eba-9b1f-dd5c9ec28614.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.181Z\",\"MediaKey\":\"NST119216800\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Fenced yard with mature trees and a spacious side lawn\",\"Order\":30,\"MediaObjectID\":\"NST30\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/34e66ece-9de2-44c1-b973-fb4a962b8c8d.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.157Z\",\"MediaKey\":\"NST119216795\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Enjoy the peaceful charm of St. Paul living\",\"Order\":37,\"MediaObjectID\":\"NST37\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/f2c9a52b-e855-4d7d-94fb-0f95d1e9c7b4.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.182Z\",\"MediaKey\":\"NST119216786\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Two-car garage with space for additional parking\",\"Order\":31,\"MediaObjectID\":\"NST31\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/ce78072e-8bbd-49d5-afeb-269304cb3e5a.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.166Z\",\"MediaKey\":\"NST119216793\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Upper-level bedroom with newer windows and mini-split for year-round comfort\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/dd0eda3e-1bf8-4fd4-b9b3-839df4c25d21.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.151Z\",\"MediaKey\":\"NST119216806\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Living room opens to a bright four-season porch\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/1136a62e-3d92-4b85-b49f-7035d2ad285a.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.152Z\",\"MediaKey\":\"NST119216816\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Side view highlights newer roof, siding, gutters, and landscaping\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/6899469a-e0a0-4b91-bc14-976a8a2c116b.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.157Z\",\"MediaKey\":\"NST119216825\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Fully customized upper-level bath with industrial design touches\",\"Order\":21,\"MediaObjectID\":\"NST21\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/25db98a0-283c-4a84-b1a7-dbc6d8a2d07b.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.164Z\",\"MediaKey\":\"NST119216804\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Convenient main-level half bath\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/fb395a8b-4b22-43ce-83b8-f5125bf9378c.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.195Z\",\"MediaKey\":\"NST119216810\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Built-in window benches with hidden storage; hardwood floors throughout\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/6a56934d-2366-4a22-a41e-d813f32948ba.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.163Z\",\"MediaKey\":\"NST119216811\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Side walkway connects front to back\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/ed82b9ae-891a-4b0d-b4ef-e26fb0ed6808.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.148Z\",\"MediaKey\":\"NST119216823\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"View of the home from the alley access\",\"Order\":33,\"MediaObjectID\":\"NST33\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/eceec7fd-9997-4749-8e03-f2a91eec6d6c.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.148Z\",\"MediaKey\":\"NST119216821\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Newer washer, dryer, tankless water heater, and 200-Amp electrical service\",\"Order\":26,\"MediaObjectID\":\"NST26\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/98529730-f0be-4417-a916-77ee733d6df6.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.165Z\",\"MediaKey\":\"NST119216799\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Living room featuring custom wainscoting, sconces, and built-in bookshelf\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/4b1e5a5f-a343-47ac-8464-9457994571b5.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.158Z\",\"MediaKey\":\"NST119216817\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Four-season porch with beadboard ceiling and ceiling fan\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/b104a745-4303-4385-9d8f-2a3796280806.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.151Z\",\"MediaKey\":\"NST119216814\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Fully customized kitchen with new appliances and butler's pantry\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/2931be3e-bb25-4a03-b1f0-836d0e59ddc9.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.138Z\",\"MediaKey\":\"NST119216809\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Outdoor dining area ideal for hosting or unwinding\",\"Order\":29,\"MediaObjectID\":\"NST29\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/6dc74101-592d-46aa-94ca-1aae43141486.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.186Z\",\"MediaKey\":\"NST119216794\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Handmade concrete island, countertops, and barstools\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/c8e111a4-d2af-4fb8-9a78-73630fdbf96b.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.148Z\",\"MediaKey\":\"NST119216808\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Handcrafted copper staircase leads to the upper level\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/7f9ebb45-c8fd-4b5c-9aea-ae899a754b1b.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.122Z\",\"MediaKey\":\"NST119216815\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Custom-built bath with walk-in shower\",\"Order\":27,\"MediaObjectID\":\"NST27\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/f7d54c66-282f-4b26-8022-3656e3b278d5.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.148Z\",\"MediaKey\":\"NST119216798\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Easy access to walking trails and outdoor recreation\",\"Order\":36,\"MediaObjectID\":\"NST36\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/f1c20e25-a3d9-4909-9879-c9626045e546.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.192Z\",\"MediaKey\":\"NST119216791\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Inviting entry with raised plant boxes\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/ce169e31-acdd-4860-94ce-777fe5599f52.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.154Z\",\"MediaKey\":\"NST119216826\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Welcome to 951 Front Ave!\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/fd5937f7-b9ae-40b7-ab3a-83c52f38bebf.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.216Z\",\"MediaKey\":\"NST119216820\"},{\"ResourceRecordKey\":\"NST7786963\",\"LongDescription\":\"Built-in planter boxes let you design your ideal garden\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7786963/41f5a02b-fed3-422a-b08e-7fd2100862a6.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2025-12-23T04:30:05.207Z\",\"MediaKey\":\"NST119216819\"}]","Media__ResourceRecordKey":"NST7786963","Media__LongDescription":"Copper pendant lighting over the island","Media__Order":"10","Media__MediaObjectID":"NST10","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7786963/6bdb6ed9-847c-4a46-a1c3-d27b7397acdd.jpeg","Media__ImageWidth":"2080","Media__ImageHeight":"1386","Media__ImageSizeDescription":"2080x1386","Media__MediaModificationTimestamp":"12/23/2025 4:30:05 AM","Media__MediaKey":"NST119216807","Rooms":"[{\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST115594204\",\"RoomDimensions\":\"19' x 14'\",\"RoomType\":\"Dining Room\"},{\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST115594206\",\"RoomDimensions\":\"17'1\\\" x 12'4\\\"\",\"RoomType\":\"Bedroom\"},{\"NST_RoomSortOrder\":6,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST115594207\",\"RoomDimensions\":\"13' x 6'8\\\"\",\"RoomType\":\"Flex Room\"},{\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST115594202\",\"RoomDimensions\":\"14'10\\\" x 6'2\\\"\",\"RoomType\":\"Four Season Porch\"},{\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST115594205\",\"RoomDimensions\":\"15' x 13'\",\"RoomType\":\"Kitchen\"},{\"NST_RoomSortOrder\":8,\"RoomLevel\":\"Basement\",\"RoomKey\":\"NST115594209\",\"RoomDimensions\":\"13'8\\\" x 6'\",\"RoomType\":\"Laundry\"},{\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST115594203\",\"RoomDimensions\":\"14'11\\\" x 11'5\\\"\",\"RoomType\":\"Living Room\"},{\"NST_RoomSortOrder\":9,\"RoomLevel\":\"Basement\",\"RoomKey\":\"NST115594210\",\"RoomDimensions\":\"19'4\\\" x 10'7\\\"\",\"RoomType\":\"Non-Egress\"},{\"NST_RoomSortOrder\":7,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST115594208\",\"RoomDimensions\":\"14'11\\\" x 14'\",\"RoomType\":\"Bedroom 2\"},{\"NST_RoomSortOrder\":10,\"RoomLevel\":\"Basement\",\"RoomKey\":\"NST115594211\",\"RoomDimensions\":\"13'4\\\" x 12'3\\\"\",\"RoomType\":\"Bedroom 3\"}]","Rooms__NST_RoomSortOrder":"3","Rooms__RoomLevel":"Main","Rooms__RoomKey":"NST115594204","Rooms__RoomDimensions":"19' x 14'","Rooms__RoomType":"Dining Room","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Welcome to 951 Front Ave!\"},{\"Order\":2,\"Remarks\":\"Inviting entry with raised plant boxes\"},{\"Order\":3,\"Remarks\":\"Well-lit walkway introduces the home\"},{\"Order\":4,\"Remarks\":\"Side view highlights newer roof, siding, gutters, and landscaping\"},{\"Order\":5,\"Remarks\":\"Side walkway connects front to back\"},{\"Order\":6,\"Remarks\":\"Front view highlights the home's elevated position atop the lot\"},{\"Order\":7,\"Remarks\":\"Built-in planter boxes let you design your ideal garden\"},{\"Order\":8,\"Remarks\":\"Fully customized kitchen with new appliances and butler's pantry\"},{\"Order\":9,\"Remarks\":\"Handmade concrete island, countertops, and barstools\"},{\"Order\":10,\"Remarks\":\"Copper pendant lighting over the island\"},{\"Order\":11,\"Remarks\":\"Formal dining area with handcrafted table and chairs for eight\"},{\"Order\":12,\"Remarks\":\"Thoughtfully designed copper light fixture and artwork add character\"},{\"Order\":13,\"Remarks\":\"Built-in window benches with hidden storage; hardwood floors throughout\"},{\"Order\":14,\"Remarks\":\"Convenient main-level half bath\"},{\"Order\":15,\"Remarks\":\"Living room featuring custom wainscoting, sconces, and built-in bookshelf\"},{\"Order\":16,\"Remarks\":\"Living room opens to a bright four-season porch\"},{\"Order\":17,\"Remarks\":\"Four-season porch with beadboard ceiling and ceiling fan\"},{\"Order\":18,\"Remarks\":\"Handcrafted copper staircase leads to the upper level\"},{\"Order\":19,\"Remarks\":\"Upper-level bedroom with newer windows and mini-split for year-round comfort\"},{\"Order\":20,\"Remarks\":\"Bright office nook with natural light\"},{\"Order\":21,\"Remarks\":\"Fully customized upper-level bath with industrial design touches\"},{\"Order\":22,\"Remarks\":\"Primary bedroom with handmade bed frame and mini-split\"},{\"Order\":23,\"Remarks\":\"Cleverly designed sliding closets maximize storage\"},{\"Order\":24,\"Remarks\":\"Brand-new flex room - perfect for an office, guest room, or studio\"},{\"Order\":25,\"Remarks\":\"Versatile lower level - ideal for gym or additional living space\"},{\"Order\":26,\"Remarks\":\"Newer washer, dryer, tankless water heater, and 200-Amp electrical service\"},{\"Order\":27,\"Remarks\":\"Custom-built bath with walk-in shower\"},{\"Order\":28,\"Remarks\":\"Lower-level bedroom with exposed wood ceiling beams\"},{\"Order\":29,\"Remarks\":\"Outdoor dining area ideal for hosting or unwinding\"},{\"Order\":30,\"Remarks\":\"Fenced yard with mature trees and a spacious side lawn\"},{\"Order\":31,\"Remarks\":\"Two-car garage with space for additional parking\"},{\"Order\":32,\"Remarks\":\"Back patio is perfect for relaxing or gathering around a fire pit\"},{\"Order\":33,\"Remarks\":\"View of the home from the alley access\"},{\"Order\":34,\"Remarks\":\"Great location just blocks from Lake Como\"},{\"Order\":35,\"Remarks\":\"Close to dining, entertainment, and shopping\"},{\"Order\":36,\"Remarks\":\"Easy access to walking trails and outdoor recreation\"},{\"Order\":37,\"Remarks\":\"Enjoy the peaceful charm of St. Paul living\"}]","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":""}
    ©2025, All rights reserved. Created with REC by AfterNorth.