Property Attributes
- ID#7113422
- TypeSingle Family
- Listing Status Active
- CountyRAMSEY
- CitySaint Paul
- AreaHillary Farm Add
- NeighborhoodHillary Farm Add
- Zip55110
- StyleSingle Family
- Year Built2008
- Taxes$ 29633
- Price$ 1,695,000
- Bedrooms6
- Full Bathrooms4
- Half Bathrooms1
- Sqr Footage6736
- Lot Size6.476 Acres
Data Source:
Northstar MLS (NSTAR)
Property Description
Welcome to 9 Hillary Farm in Gem Lake, where refined luxury meets effortless indoor–outdoor living. Perfectly situated on Gem Lake, this home offers expansive lake views that enrich every moment. Inside, the main floor showcases an impressive open layout with double-height ceilings, creating a bright and airy atmosphere ideal for both everyday living and elegant entertaining. This stunning 6-bedroom, 5-bath residence features fresh paint, new carpet in select areas, a new roof, and a newer furnace and water heater for added peace of mind. The gourmet kitchen is equipped with premium appliances, including Wolf ovens, making it a dream for home chefs. The main-floor owner’s suite provides a spa-like ensuite retreat, while additional living space above the garage—complete with a private entrance and deck—offers a perfect setup for guests, multigenerational living, or a home office. Step outside to an unbelievable backyard oasis overlooking the lake, featuring an in-ground pool, hot tub, outdoor pizza oven, and grill. A truly exceptional property in one of Gem Lake’s most sought-after settings.
| Price History | |
|---|---|
| 7/22/2026 | Listed $1,695,000 |
General Features
| Living Area | 6736 |
|---|---|
| Sewer | City Sewer/Connected |
| Heating | Forced Air,Fireplace(s) |
| Cooling | Central Air |
| Roof | Age 8 Years or Less |
| Appliances | Dishwasher,Dryer,Microwave,Range,Refrigerator,Washer |
| HOA Fee | 2500 |
| Garage Spaces | 4 |
| Association Fee Includes | Other |
| Pool Features | Below Ground,Heated |
| Year Built | 2008 |
| Levels | Two |
| Property Subtype | Single Family |
| Tax Year | 2026 |
| Waterfront Features | Lake Front |
| Accessibility | None |
| Assoc Fee Paid Per | Annually |
| County | Ramsey |
| New Construction | No |
| Property Type | Residential |
| HOA | Yes |
| Contingency | None |
| Subdivision Name | Hillary Farm Add |
| Full Baths | 1 |
| Directions | US 61 N,left county rd F E,right to Hoffman,Left to Scheuneman Rd,Rt Hillary Farm Lane. |
| City | Gem Lake |
| Association Name | Hillary Farm Association |
| High School District | White Bear Lake |
| Zoning Description | Residential-Single Family |
| Lot Size Units | Acres |
| Property Attached Y/N | No |
| Land Lease Y/N | No |
| Tax Annual Amount | 29633.22 |
| Additional Parcels Y/N | No |
| Standard Status | Active |
| Lender Owned | No |
| Amenities Unit | Deck,Hardwood Floors,Kitchen Center Island,Main Floor Primary Bedroom,In-Ground Sprinkler,Vaulted Ceiling(s),Wet Bar,Walk-In Closet |
| PostalCity | Saint Paul |
Interior Features
| Basement | Finished,Full,Walkout |
|---|---|
| Total Fireplaces | 2 |
| Fireplace Features | Living Room |
| Basement (Y/N) | Yes |
| Fireplace Y/N | Yes |
| Above Grade Finished Area | 4754 |
| Half Baths | 1 |
| 3/4 Baths | 3 |
| Laundry Features | Lower Level,Laundry Room |
| Total Bedrooms | 6 |
| Below Grade Finished Area | 1982 |
| Total Baths | 5 |
| Bath Desc | 3/4 Basement,Full Primary,Private Primary,Main Floor 1/2 Bath,Separate Tub & Shower,Upper Level 3/4 Bath,Walk-In Shower Stall |
| Dining Room Description | Kitchen/Dining Room |
| Fuel | Natural Gas |
| Garage Square Feet | 1452 |
| Waterfront Feet | 370 |
Exterior Features
| Parking Features | Attached Garage |
|---|---|
| Lot Features | Irregular Lot,Tree Coverage - Medium |
| Water Source | Private |
| Lot Size Area | 6.476 |
| Building Area Total | 6843 |
| Lot Dimensions | 151x736x505x420 |
| Waterfront Y/N | Yes |
| Foundation Area | 2098 |
| Road Frontage Type | Paved Streets |
| Road Responsibility | Association Maintained Road |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
The data relating to real estate for sale on this web 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 Coldwell Banker River Valley, REALTORS - Rochester are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo (little black
house) and detailed information about them includes the name of the listing brokers.
Metro MLS - Milwaukee Data provided by Metro MLS. All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. IDX information is provided exclusively for consumers personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of the Multiple Listing Service. Information is supplied by seller and other third parties and has not been verified. Real estate listings held by brokerage firms other than Coldwell Banker River Valley, REALTORS - Rochester may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. Copyright ©2026 - Multiple Listing Service, Inc. - All rights reserved.
Last Updated: September 15, 2026 7:33 AM UTC
© 2026 Realtor Association of Southern Minnesota. All rights reserved. The data relating to real estate for sale on this limited electronic display comes in part from the Broker Reciprocity (sm) Program of the Realtor Association of Southern Minnesota Multiple Listing Service. Real estate listings held by brokerage firms other then Coldwell Banker River Valley, REALTORS - Rochester are marked with the Broker Reciprocity(sm) logo or the Broker Reciprocity(sm) thumbnail logo (a little black house)
SCWMLS - South Central Wisconsin Multiple Listing Corp. All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of the Multiple Listing Service. Real estate listings held by brokerage firms other than Coldwell Banker River Valley, REALTORS - Rochester may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. Copyright 2026 South Central Wisconsin MLS Corporation All rights reserved.
This information, provided by seller, listing broker, and other parties, may not have been verified.
SCWMLS information is provided exclusively for consumers personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Last Updated: September 15, 2026 7:23 AM UTC
Information should be deemed reliable but not guaranteed, all representations are approximate, and individual verification is recommended. Copyright ©2017 All rights reserved.