$SCONTENT$
$LABEL$
$SCONTENT$
MLS# 7131695 - 515 Farrell Street N Maplewood, MN 55119
First Impressions Home Group 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. Edge of the Wilderness Lakes & Homes Realty - Alexandra Bloch is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Edge of the Wilderness Lakes & Homes Realty - Alexandra Bloch, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
{"Id":603513,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7131695","MLSAGENTID":"NST502040529","MLSOFFICEID":"NST26241","ADDRESS":"515 Farrell Street N","ACRES":0.41,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Drain Tiled,Finished,Full,Storage Space","BATHSTOTAL":3.0,"BEDROOMS":6.0,"CITY":"Maplewood","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Block","FORECLOSURE":"No","LASTPRICE":539900.0,"LASTPRICEDATE":"2026-08-22T00:47:06.557","LATITUDE":44.956919,"LENDEROWNED":"No","LISTDATE":"2026-08-21T05:00:00","LISTPRICE":539900.0,"LIVINGAREA":2480.0,"LONGITUDE":-92.987934,"LOTDESCRIPTION":"Sod Included in Price","MODIFICATIONTIMESTAMP":"2026-08-22T10:22:07.918","OFFICE_OFFICENAME":"First Impressions Home Group","PHOTOCOUNT":19,"POSTALCODE":"55119","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Enjoy the quality, comfort, and peace of mind that only brand-new construction can provide! Beautifully situated on a desirable infill lot in sought-after Maplewood, this all-new home offers nearly 2,500 finished square feet and an incredibly flexible layout with up to 6 bedrooms—or configure the space to best fit your lifestyle, including options for a home office, playroom, exercise room, or additional flex space or 5 bedrooms with expanded living areas.\n\nStep inside to an all-new floor plan designed with both style and function in mind. The home features modern finishes throughout and a thoughtful layout that maximizes livability.\n\nKey features include:\nStylish LVP flooring throughout main living areas\nNewly released designer lighting package\nStainless steel kitchen appliances\nFresh, modern interior finishes\nOpen, functional design ideal for everyday living and entertaining\nEnjoy the added confidence that comes with new construction, including:\n\nNew materials and systems throughout\nModern energy efficiency\nQuality craftsmanship\nBuilder warranty protection\nMinimal maintenance compared to older homes\nEstimated completion: November.\n\nDriveway access is shared for approximately the first 40 feet about 7\\.5 feet of width before splitting into a private driveway serving the new home","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"622-North St Paul-Maplewood","SCHOOLDISTRICTPHONE":"6517487410","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-08-22T00:47:06.557","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Farrell","STREETNUMBER":"515","STREETSUFFIX":"Street","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2026,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-08-22T00:47:06.558","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Progress as of 8/21! Please call for plans and specs\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","SOURCE":"MG_NST"}
{"ListingKey":"NST7955811","NST_AboveGradeSqFtTotal":"1377","AboveGradeFinishedArea":"1377","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"Yes","NST_AmenitiesUnit":"Ceiling Fan(s),Deck,Kitchen Center Island,Primary Bedroom Walk-In Closet,Natural Woodwork,Paneled Doors,In-Ground Sprinkler,Vaulted Ceiling(s),Washer/Dryer Hookup,Walk-In Closet","Appliances":"Air-To-Air Exchanger,Dishwasher,Disposal,Microwave,Range,Refrigerator,Stainless Steel Appliances","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Daylight/Lookout Windows,Drain Tiled,Finished,Full,Storage Space","BasementYN":"True","NST_BathDesc":"3/4 Basement,3/4 Primary,Double Sink,Private Primary,Upper Level 3/4 Bath,Upper Level Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"2","BathroomsTotalInteger":"3","BedroomsTotal":"6","NST_BelowGradeSqFtTotal":"1377","BelowGradeFinishedArea":"1103","NST_BuilderAssociationID":"Builders Association of the Twin Cities","NST_BuilderLicense":"763908","BuilderName":"NOBERG HOMES INC","CumulativeDaysOnMarket":"0","City":"Maplewood","NST_CompletionDate":"2026-11-15","ConstructionMaterials":"Block","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Breakfast Bar,Informal Dining Room,Kitchen/Dining Room,Living/Dining Room","Directions":"Century Ave, West on Freemont South on Farrell","DocumentsCount":"5","DocumentsChangeTimestamp":"2026-08-22T00:45:06.542Z","DaysOnMarket":"0","Electric":"Circuit Breakers,200+ Amp Service","ExteriorFeatures":"Stone,Vinyl","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"1377","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"572","NST_GarageDimensions":"26x22","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"North St Paul-Maplewood","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.956919","LaundryFeatures":"Lower Level,Sink,Washer Hookup","NST_LenderOwned":"No","Levels":"Split Entry (Bi-Level)","ListPrice":"539900","ListingContractDate":"2026-08-21T05:00:00Z","ListingId":"NST7131695","LivingArea":"2480","LockBoxType":"Combo","Longitude":"-92.987934","LotFeatures":"Sod Included in Price","LotSizeArea":"0.41","LotSizeDimensions":"55x295x56x295","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1377","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-08-21T19:44:20Z","ParcelNumber":"362922140046","ParkingFeatures":"Attached Garage,Asphalt,Garage Door Opener","NST_PatioPorchType":"Deck","PhotosCount":"19","PhotosChangeTimestamp":"2026-08-22T00:47:06.558Z","PoolFeatures":"None","PostalCity":"Maplewood","PostalCode":"55119","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Enjoy the quality, comfort, and peace of mind that only brand-new construction can provide! Beautifully situated on a desirable infill lot in sought-after Maplewood, this all-new home offers nearly 2,500 finished square feet and an incredibly flexible layout with up to 6 bedrooms—or configure the space to best fit your lifestyle, including options for a home office, playroom, exercise room, or additional flex space or 5 bedrooms with expanded living areas.\n\nStep inside to an all-new floor plan designed with both style and function in mind. The home features modern finishes throughout and a thoughtful layout that maximizes livability.\n\nKey features include:\nStylish LVP flooring throughout main living areas\nNewly released designer lighting package\nStainless steel kitchen appliances\nFresh, modern interior finishes\nOpen, functional design ideal for everyday living and entertaining\nEnjoy the added confidence that comes with new construction, including:\n\nNew materials and systems throughout\nModern energy efficiency\nQuality craftsmanship\nBuilder warranty protection\nMinimal maintenance compared to older homes\nEstimated completion: November.\n\nDriveway access is shared for approximately the first 40 feet about 7\\.5 feet of width before splitting into a private driveway serving the new home","PublicSurveyRange":"22","PublicSurveySection":"36","PublicSurveyTownship":"29","RoadFrontageType":"City Street,Paved Streets","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less,Asphalt,Pitched","NST_SchoolDistrictFullName":"622 - North St Paul-Maplewood","NST_SchoolDistrictNumber":"622","NST_SchoolDistrictPhone":"6517487410","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level,Primary Bdr Suite","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Farrell","StreetNumber":"515","StreetNumberNumeric":"515","StreetSuffix":"Street","SubdivisionName":"Farrells Add","TaxAnnualAmount":"1438","NST_TaxWithAssessments":"1438","TaxYear":"2026","NST_TotalArea":"2754","BuildingAreaTotal":"2754","Township":"Maplewood","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"2026","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST95424","ListAgentMlsId":"NST502040529","ListOfficeMlsId":"NST26241","ListOfficeName":"First Impressions Home Group","ListOfficeKey":"NST26241","ModificationTimestamp":"2026-08-22T10:22:07.918Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/1200368d-681f-4513-b0b8-5b8439a4f9f9.jpeg\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2026-08-22T00:45:05.972Z\",\"MediaKey\":\"NST124419276\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/842b7bec-92f4-4ea9-a095-f7e18c5b6c44.jpeg\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":800,\"ImageHeight\":600,\"ImageSizeDescription\":\"800x600\",\"MediaModificationTimestamp\":\"2026-08-22T00:47:06.515Z\",\"MediaKey\":\"NST124419281\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/fcd8dee4-15a7-4d6c-aa15-ec3674f6dd72.jpeg\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-08-22T00:45:05.965Z\",\"MediaKey\":\"NST124419286\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/580e7b89-818f-42cc-9246-1649287a6a8f.jpeg\",\"LongDescription\":\"Progress as of 8/21! Please call for plans and specs\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":800,\"ImageHeight\":600,\"ImageSizeDescription\":\"800x600\",\"MediaModificationTimestamp\":\"2026-08-22T00:45:05.974Z\",\"MediaKey\":\"NST124419275\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/adc747ce-cb05-4436-b350-23035b206658.jpeg\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":853,\"ImageHeight\":1280,\"ImageSizeDescription\":\"853x1280\",\"MediaModificationTimestamp\":\"2026-08-22T00:45:05.971Z\",\"MediaKey\":\"NST124419292\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/ed2d7326-cf5b-4e13-a249-925ed8326fe9.jpeg\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-08-22T00:45:06.005Z\",\"MediaKey\":\"NST124419295\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/5a228153-a6d1-46ce-925e-cae6508949a9.jpeg\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-08-22T00:45:06.018Z\",\"MediaKey\":\"NST124419282\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/abbaeae5-96a6-4017-85a5-5bd3004732f0.jpeg\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-08-22T00:45:05.992Z\",\"MediaKey\":\"NST124419291\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/9d83c057-ee52-4447-9214-fb7fb22d8f03.jpeg\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-08-22T00:45:05.955Z\",\"MediaKey\":\"NST124419297\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/f58fdac1-5690-49bd-b500-31158b71da3f.jpeg\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-08-22T00:45:05.971Z\",\"MediaKey\":\"NST124419293\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/499a6bab-1a8e-44a1-8ad0-a246ee8302a9.jpeg\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-08-22T00:45:05.98Z\",\"MediaKey\":\"NST124419296\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/104deb23-8ae3-4c2c-be03-f602fc47c7cd.jpeg\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":1919,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1919x1280\",\"MediaModificationTimestamp\":\"2026-08-22T00:45:05.994Z\",\"MediaKey\":\"NST124419288\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/f6673521-5518-4483-bb59-bc82ed7060c4.jpeg\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-08-22T00:45:05.963Z\",\"MediaKey\":\"NST124419294\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/e495b3fc-19cf-4583-8005-7ca52b1858d0.jpeg\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-08-22T00:45:05.98Z\",\"MediaKey\":\"NST124419287\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/d20c9cd9-0aab-46a4-8edf-7c0cec9b2889.jpeg\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-08-22T00:45:05.954Z\",\"MediaKey\":\"NST124419289\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/721adb17-b04a-4349-8e9f-c3c1359693a1.jpeg\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":1915,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1915x1280\",\"MediaModificationTimestamp\":\"2026-08-22T00:45:05.991Z\",\"MediaKey\":\"NST124419285\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/4ff48472-efa0-4ed0-8946-1a2f3fff4b2a.jpeg\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"ImageWidth\":1917,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1917x1280\",\"MediaModificationTimestamp\":\"2026-08-22T00:45:05.968Z\",\"MediaKey\":\"NST124419299\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/01a310d6-4fca-43f6-99f7-f83a0d60818b.jpeg\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":1919,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1919x1280\",\"MediaModificationTimestamp\":\"2026-08-22T00:45:06.018Z\",\"MediaKey\":\"NST124419284\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955811/79a2d1e8-2191-4dd8-8ba7-7035d04f3c98.jpeg\",\"ResourceRecordKey\":\"NST7955811\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":1915,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1915x1280\",\"MediaModificationTimestamp\":\"2026-08-22T00:45:06.05Z\",\"MediaKey\":\"NST124419283\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7955811/1200368d-681f-4513-b0b8-5b8439a4f9f9.jpeg","Media__ResourceRecordKey":"NST7955811","Media__Order":"2","Media__MediaObjectID":"NST2","Media__ImageWidth":"1024","Media__ImageHeight":"768","Media__ImageSizeDescription":"1024x768","Media__MediaModificationTimestamp":"8/22/2026 12:45:05 AM","Media__MediaKey":"NST124419276","Rooms":"[{\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"14x10\",\"RoomKey\":\"NST116595162\"},{\"RoomType\":\"Bedroom 5\",\"NST_RoomSortOrder\":8,\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"12x14\",\"RoomKey\":\"NST116595167\"},{\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"14'8x13\",\"RoomKey\":\"NST116595163\"},{\"RoomType\":\"Bedroom 4\",\"NST_RoomSortOrder\":7,\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"12x14\",\"RoomKey\":\"NST116595166\"},{\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"10x10\",\"RoomKey\":\"NST116595160\"},{\"RoomType\":\"Laundry\",\"NST_RoomSortOrder\":10,\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"14x10'6\",\"RoomKey\":\"NST116595169\"},{\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"20x12\",\"RoomKey\":\"NST116595161\"},{\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11x12'6\",\"RoomKey\":\"NST116595164\"},{\"RoomType\":\"Bedroom 6\",\"NST_RoomSortOrder\":9,\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"14x10\",\"RoomKey\":\"NST116595168\"},{\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":6,\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13x11\",\"RoomKey\":\"NST116595165\"}]","Rooms__RoomType":"Dining Room","Rooms__NST_RoomSortOrder":"3","Rooms__RoomLevel":"Upper","Rooms__RoomDimensions":"14x10","Rooms__RoomKey":"NST116595162","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Progress as of 8/21! Please call for plans and specs\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","CustomVTourURL":""}