




9 Hillary Farm Ln, Gem Lake, MN, 55110
About This Home
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.
Getting Around
Schools
Construction
Condition
- Year built: 2008
Materials
- Roof: Age 8 Years or Less
Type & Style
- Home type: SingleFamily
- Property subType: Single Family
Interior
Appliances
- Appliances included: Dishwasher,Dryer,Microwave,Range,Refrigerator,Washer
- Laundry features: Lower Level,Laundry Room
Basement
- Has basement: Yes
- Basement: Finished,Full,Walk-Out Access
Bedroom
- Level: Main
- Area: 252
- Dimensions: 18x14
Bedroom2
- Level: Upper
- Area: 216
- Dimensions: 18x12
Bedroom3
- Level: Upper
- Area: 182
- Dimensions: 14x13
Bedroom4
- Level: Upper
- Area: 187
- Dimensions: 17x11
Bedroom5
- Level: Upper
- Area: 169
- Dimensions: 13x13
Bedroom6
- Level: Lower
- Area: 168
- Dimensions: 12x14
Bedrooms & Bathrooms
- Bedrooms: 6
- Bathrooms: 5
- Full bathrooms: 1
- 3/4 bathrooms: 3
- 1/2 bathrooms: 1
Bonus Room
- Level: Upper
- Area: 504
- Dimensions: 21x24
Dining Room
- Level: Main
- Area: 247
- Dimensions: 19x13
Exercise Room
- Level: Lower
- Area: 252
- Dimensions: 18x14
Family Room
- Level: Main
- Area: 304
- Dimensions: 19x16
Features
- Number of fireplaces: 2
- Fireplace features: Living Room
- Fireplace: Yes
- Finished area below ground: 1,982
- Finished area above ground: 4,754
Heating & Cooling
- Heating features: Forced Air,Fireplace(s)
- Cooling features: Central Air
Interior Area
- Total structure area: 6,843
- Total interior livable area: 6,843 sqft
Kitchen
- Level: Main
- Area: 228
- Dimensions: 19x12
Living Room
- Level: Main
- Area: 399
- Dimensions: 19x21
Recreation Room
- Level: Lower
- Area: 925
- Dimensions: 37x25
Study
- Level: Upper
- Area: 108
- Dimensions: 9x12
Property
Accessibility
- Accessibility features: None
Details
- Parcel number: 273022310011
- Zoning description: Residential-Single Family
- Foundation area: 2098
Features
- Levels: Two
- Stories: 2
- Private pool: Yes
- Pool features: In Ground,Heated
- Patio & porch: Deck,Front Porch
- On waterfront: Yes
- Waterfront features: Lake Front
- Frontage length: Water Frontage: 370
Lot
- Lot size: 6.48 Acres
- Features: Irregular Lot,Tree Coverage - Medium
- Lot size dimensions: 151 x 736 x 505 x 420
Parking
- Total spaces: 4
- Parking features: Attached
- Has garage: Yes
- Attached garage spaces: 4
- Covered spaces: 4
Climate Risk is Financial Risk
Every home has a financial story beyond the listing price. Below, you’ll see the climate risks that could affect this property — and in Bills & Affordability, how those risks may influence repairs, insurance, utilities, and long-term value.
Biggest Threats for This Home
- Cold Wave
- Hail
- Heat Wave
- Landslide
- Tornado
- Winter Weather
How This Home’s Risks Compare
FEMA Declared Disasters in Ramsey County and Minnesota
Understanding the Costs
Financial advisors generally recommend spending no more than 30% of your gross household income on housing costs. In practice, many households stretch to 35% or beyond — especially in high-cost markets.
Estimated Costs Today
| Monthly | Annual | |
|---|---|---|
| Mortgage | $8,570 | $102,840 |
| Home Insurance * | $1,140 | $13,680 |
| Property Taxes | $2,257 | $27,084 |
| Electricity | $577 | $6,925 |
| Total | $12,544 | $150,528 |
Income You'd Need if You Spent...
Minnesota FAIR Plan Programs
How Costs Could Change Over Time
Climate risk is quickly impacting all of the major home ownership costs. Adjust the growth rates and percentage of income spent on housing below to see how your housing costs could change over the next 10 years — and what income you'd need to keep up.
Comparing Against the Market
Price Per Sq Ft
vs Other Active Listings
Avg $/sqft
vs Homes Sold Last Month
Median $/sqft
Current Market Trends
Median Price Per Square Foot
The median price per square foot of homes sold in this area each month. Compare this to this listing's price per square foot to gauge whether the home is priced in line with recent sales.
Historicals for This Listing
Zestimate History ($/sqft)
Price History
| Date | Event | Price |
|---|---|---|
| 2026-04-10 | Listed for sale | $1,950,000 |
| 2008-09-03 | Sold | $530,000 |
For Sale by Agent
