{"Id":1395968,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6772768","MLSAGENTID":"NST505010274","MLSOFFICEID":"NST40672","ADDRESS":"195x Glenhill Road","ACRES":2.92,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Egress Window(s),Finished,Walkout","BATHSTOTAL":5.0,"BEDROOMS":5,"CITY":"Mendota Heights","CONTINGENCY":"None","COUNTY":"Dakota","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Fiber Cement,Metal Siding,Shake Siding","FORECLOSURE":"No","LASTPRICE":1899000.0,"LASTPRICEDATE":"2025-08-14T20:26:04.46","LATITUDE":44.88435707,"LENDEROWNED":"No","LISTDATE":"2025-08-14T05:00:00","LISTPRICE":1899000.0,"LIVINGAREA":3911.0,"LONGITUDE":-93.15547147,"LOTDESCRIPTION":"Many Trees","MODIFICATIONTIMESTAMP":"2025-08-14T20:26:04.46","OFFICE_OFFICENAME":"Recreate Real Estate LLC","PHOTOCOUNT":13,"POSTALCODE":"55118","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Amazing opportunity to build on an acreage bluff lot in Mendota Heights with Homes by Tradition. This gorgeous transitional coastal architecture will appeal to both active adults and down-sizers. The main floor boasts 9-foot ceilings, a primary bedroom suite with 4-piece bath and laundry, great room, mud room, kitchen, dining and foyer. Walk right out to a large patio and screened in porch. Upper floor has three beds, two full baths, 2nd laundry and loft. House can be designed with a walk-out or look-out basement with 9-foot ceilings, and features a family room, media center, and workout room. Possible bluff views depending on home design style. Build to suit your needs. Call today for a guided tour of the lot to discuss your dream home. This is an established luxury neighborhood in Mendota Heights and near shopping and amazing schools including Visitation and Saint Thomas Academy.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt","SCHOOLDISTRICTNUMBER":"197-West St. Paul-Mendota Hts.-Eagan","SCHOOLDISTRICTPHONE":"651-403-7002","SEWER":"City Sewer - In Street","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-14T20:26:04.46","LASTSTATUS":"Active","STREETNAME":"Glenhill","STREETNUMBER":"195x","STREETSUFFIX":"Road","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water - In Street","WATERFRONTPRESENT":false,"YEARBUILT":2025,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-08-14T20:26:04.46","PHOTOREMARKS":"[{\"Order\":13,\"Remarks\":\"Glenhill Lot in yellow\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13","SOURCE":"MG_NST"}
{"ListingKey":"NST7788502","LotSizeArea":"2.92","NST_AgeOfProperty":"0","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AssessmentPending":"Yes","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Egress Window(s),Finished,Walkout","BasementYN":"True","NST_BathDesc":"3/4 Basement,Full Primary,Private Primary,Main Floor 1/2 Bath,Main Floor Full Bath,Separate Tub & Shower,Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"3","BathroomsHalf":"1","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"5","BedroomsTotal":"5","NST_BuilderLicense":"556362","BuilderName":"HOMES BY TRADITION LLC","City":"Mendota Heights","PropertyType":"Residential","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Dakota","NST_DiningRoomDescription":"Separate/Formal Dining Room","Directions":"62 to Lexington west on Victoria Curve to Glenhill","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Brick/Stone,Fiber Cement,Metal Siding,Shake Siding","FireplaceFeatures":"Family Room","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","FoundationArea":"1942","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage","NST_GarageDimensions":"33x25","NST_GarageSquareFeet":"825","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-08-14T20:18:16Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-08-14","Latitude":"44.8843570666","NST_LenderOwned":"No","ListAgentKey":"NST82193","ListAgentMlsId":"NST505010274","ListingContractDate":"2025-08-14T05:00:00Z","ListOfficeKey":"NST19525","ListOfficeName":"Recreate Real Estate LLC","ListOfficeMlsId":"NST40672","ListPrice":"1899000","LivingArea":"3911","Longitude":"-93.1554714704","LotFeatures":"Many Trees","NST_LotPrice":"550000.000","LotSizeDimensions":"325x495","LotSizeSquareFeet":"127195.2","LotSizeUnits":"Acres","ListingId":"NST6772768","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"278125100013","GarageSpaces":"3","NST_PatioPorchType":"Front Porch,Patio,Screened","PhotosCount":"13","PostalCity":"Saint Paul","PostalCode":"55118","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","NST_PropertySubTypeDesc":"Acreage","PublicRemarks":"Amazing opportunity to build on an acreage bluff lot in Mendota Heights with Homes by Tradition. This gorgeous transitional coastal architecture will appeal to both active adults and down-sizers. The main floor boasts 9-foot ceilings, a primary bedroom suite with 4-piece bath and laundry, great room, mud room, kitchen, dining and foyer. Walk right out to a large patio and screened in porch. Upper floor has three beds, two full baths, 2nd laundry and loft. House can be designed with a walk-out or look-out basement with 9-foot ceilings, and features a family room, media center, and workout room. Possible bluff views depending on home design style. Build to suit your needs. Call today for a guided tour of the lot to discuss your dream home. This is an established luxury neighborhood in Mendota Heights and near shopping and amazing schools including Visitation and Saint Thomas Academy.","NST_RentalLicenseYN":"No","RoadResponsibility":"Public Maintained Road","Roof":"Asphalt","RoomType":"Great Room,Bedroom 1,Kitchen,Dining Room,Mud Room,Foyer,Office,Laundry,Pantry (Walk-In),Screened Porch,Bedroom 2,Bedroom 3,Bedroom 4,Loft,Family Room,Exercise Room,Bedroom 5","NST_AboveGradeSqFtTotal":"3031.0000","NST_BelowGradeSqFtTotal":"880.0000","NST_MainLevelFinishedArea":"1942.0000","BuildingAreaTotal":"3911","HighSchoolDistrict":"West St. Paul-Mendota Hts.-Eagan","NST_SchoolDistrictNumber":"197","NST_SchoolDistrictPhone":"651-403-7002","Sewer":"City Sewer - In Street","NST_SpecialSearch":"3 BR on One Level,Main Floor Primary,Main Floor Bedroom,Main Floor Laundry","AboveGradeFinishedArea":"3031","BelowGradeFinishedArea":"880","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Glenhill","StreetNumber":"195x","StreetNumberNumeric":"195","StreetSuffix":"Road","PropertySubType":"Single Family Residence","NST_TaxWithAssessments":"7160.0000","TaxYear":"2025","TaxAnnualAmount":"6220","WaterSource":"City Water - In Street","YearBuilt":"2025","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-08-14T20:26:04.46Z","PhotosChangeTimestamp":"2025-08-14T20:26:04.46Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7788502\",\"Order\":1,\"MediaObjectID\":\"1\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788502/ef63638f-8a5b-47ed-a775-bef345a6acf5.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T20:22:32.08Z\",\"MediaKey\":\"689e45883394df76a9519f5f\"},{\"ResourceRecordKey\":\"NST7788502\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788502/acec7913-0c0b-4ad5-968f-dbc0feb49bcc.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T20:22:31.959Z\",\"MediaKey\":\"689e45883394df76a9519f60\"},{\"ResourceRecordKey\":\"NST7788502\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788502/ead50bdc-01b8-48cc-be6f-0e4ce0c91790.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T20:22:32.041Z\",\"MediaKey\":\"689e45883394df76a9519f61\"},{\"ResourceRecordKey\":\"NST7788502\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":1386,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1386x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788502/85369c79-c651-40e5-8545-7a0364199efe.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T20:22:31.944Z\",\"MediaKey\":\"689e45883394df76a9519f62\"},{\"ResourceRecordKey\":\"NST7788502\",\"Order\":5,\"MediaObjectID\":\"5\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788502/37cd8d90-6790-40f9-b444-7c28fa29f198.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T20:22:31.969Z\",\"MediaKey\":\"689e45883394df76a9519f63\"},{\"ResourceRecordKey\":\"NST7788502\",\"Order\":6,\"MediaObjectID\":\"6\",\"ImageWidth\":1920,\"ImageHeight\":1439,\"ImageSizeDescription\":\"1920x1439\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788502/4d9d5057-1b68-4f86-a690-03187e330d41.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T20:25:33.071Z\",\"MediaKey\":\"689e463de96d1473f975cdd4\"},{\"ResourceRecordKey\":\"NST7788502\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":1920,\"ImageHeight\":1439,\"ImageSizeDescription\":\"1920x1439\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788502/97ca1fed-1975-4498-b136-d223731eaec1.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T20:25:33.069Z\",\"MediaKey\":\"689e463de96d1473f975cdd5\"},{\"ResourceRecordKey\":\"NST7788502\",\"Order\":8,\"MediaObjectID\":\"8\",\"ImageWidth\":1920,\"ImageHeight\":1439,\"ImageSizeDescription\":\"1920x1439\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788502/14eb48f9-928e-43ac-978e-8e970ddedc5e.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T20:25:33.066Z\",\"MediaKey\":\"689e463de96d1473f975cdd6\"},{\"ResourceRecordKey\":\"NST7788502\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":1920,\"ImageHeight\":1078,\"ImageSizeDescription\":\"1920x1078\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788502/15314360-b748-40d1-b19f-561779032057.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T20:25:33.07Z\",\"MediaKey\":\"689e463de96d1473f975cdd7\"},{\"ResourceRecordKey\":\"NST7788502\",\"Order\":10,\"MediaObjectID\":\"10\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788502/f6ade5e6-5e95-461b-8142-e9112cca00ea.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T20:25:33.163Z\",\"MediaKey\":\"689e463de96d1473f975cdd8\"},{\"ResourceRecordKey\":\"NST7788502\",\"Order\":11,\"MediaObjectID\":\"11\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788502/0a72b6a8-d693-4ade-b189-e8dc6f5f9aa0.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T20:25:33.108Z\",\"MediaKey\":\"689e463de96d1473f975cdd9\"},{\"ResourceRecordKey\":\"NST7788502\",\"Order\":12,\"MediaObjectID\":\"12\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788502/8dfb1c49-985b-403e-a49a-fd59a649e27f.jpeg\",\"MediaModificationTimestamp\":\"2025-08-14T20:25:33.051Z\",\"MediaKey\":\"689e463de96d1473f975cdda\"},{\"ResourceRecordKey\":\"NST7788502\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"Glenhill Lot in yellow\",\"ImageWidth\":1475,\"ImageHeight\":1315,\"ImageSizeDescription\":\"1475x1315\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788502/d447baf0-9188-4f5a-b0de-ac5c56ec40ab.png\",\"MediaModificationTimestamp\":\"2025-08-14T20:25:33.14Z\",\"MediaKey\":\"689e463de96d1473f975cddb\"}]","Rooms":"[{\"RoomKey\":\"NST115520352\",\"RoomType\":\"Great Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115520353\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115520354\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115520355\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115520356\",\"RoomType\":\"Mud Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115520357\",\"RoomType\":\"Foyer\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115520358\",\"RoomType\":\"Office\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115520359\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115520360\",\"RoomType\":\"Pantry (Walk-In)\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115520361\",\"RoomType\":\"Screened Porch\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"10\"},{\"RoomKey\":\"NST115520362\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":\"11\"},{\"RoomKey\":\"NST115520363\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":\"12\"},{\"RoomKey\":\"NST115520364\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":\"13\"},{\"RoomKey\":\"NST115520365\",\"RoomType\":\"Loft\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":\"14\"},{\"RoomKey\":\"NST115520366\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":\"15\"},{\"RoomKey\":\"NST115520367\",\"RoomType\":\"Exercise Room\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":\"16\"},{\"RoomKey\":\"NST115520368\",\"RoomType\":\"Bedroom 5\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":\"17\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":13,\"Remarks\":\"Glenhill Lot in yellow\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13","CustomVTourURL":""}