Advanced Search

Owner is an Agent?: No

Auction?: No

Status: Active

Contingency: None

Current Price: $1,695,000

Original List Price: 1695000

ListPrice: 1695000

List Date: 2026-07-21

Association: SPAAR

Assoc Mgmt Co. Phone #: 612-986-4715

Association Fee Frequency: Annually

Association Mgmt Co. Name: Hillary Farm Association

Common Wall: No

Lot Measurement: Acres

Manufactured Home?: No

Multiple PIDs?: No

New Development: No

Number of Fireplaces: 2

Road Btwn WF & Home?: No

Waterfront Frontage: 370

Waterfront YN: Yes

Year Built: 2008

Yearly/Seasonal: Yearly

Zoning: Residential-Single Family

Lot Dimensions: 151x736x505x420

Acres: 6.47

Bath Three Quarters: 3

Bath Half: 1

Lake/Waterfront Name: Gem

Bath Quarter: 0

Main Floor Total SqFt: 2367

Above Grd Total SqFt: 4754

Below Grd Total SqFt: 2089

Total SqFt: 6843

Total Finished Sqft: 6736.00

FireplaceYN: Yes

Foundation Size: 2098

Style: (SF) Single Family

Garage Stalls: 4

Association Fee: 2500

Assessment Pending: Unknown

Bedrooms: 6

Baths Total: 5

Bath Full: 1

AssocFeeYN: Yes

Legal Description: HILLARY FARM ADD LOT 5 BLK 1

Map Page: 94

Municipality: Gem Lake

School District: White Bear Lake

School District Phone: 651-407-7500

DNR Lake ID#: 62003700

DNR Lake Classification: Natural Environment

Zip Plus 4: 5934

Property ID Number: 273022310011

Tax Year: 2026

Tax Amount: 29633.22

In Foreclosure?: No

Potential Short Sale?: No

Lender Owned?: No

Public Remarks: 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.

Directions: US 61 N, left county rd F E, right to Hoffman, Left to Scheuneman Rd, Rt Hillary Farm Lane.

None: 1

Central Air: 1

Deck: 1

Hardwood Floors: 1

In-Ground Sprinkler: 1

Kitchen Center Island: 1

Main Floor Primary Bedroom: 1

Vaulted Ceiling(s): 1

Walk-In Closet: 1

Wet Bar: 1

Dishwasher: 1

Dryer: 1

Microwave: 1

Range: 1

Refrigerator: 1

Washer: 1

Assessment Balance: 0

Assessment Installment: 42.78

Tax With Assessments: 29676

Other: 1

Full: 1

Main Floor 1/2 Bath: 1

Upper Level 3/4 Bath: 1

Full Primary: 1

Private Primary: 1

3/4 Basement: 1

Separate Tub & Shower: 1

Walk-In Shower Stall: 1

Finished SqFt Above Ground: 4754

Finished SqFt Below Ground: 1982

Previously Owned: 1

Kitchen/Dining Room: 1

Cement Board: 1

2 or More: 1

Family Room: 1

Great Room: 1

Lower Level: 1

Main Level: 1

Living Room: 1

Other: 1

Natural Gas: 1

Forced Air: 1

Insurance Fee: 0

Lake Acres: 20

Lake Depth: 0

Laundry Room: 1

Lower Level: 1

Land Leased: Not Applicable

Irregular Lot: 1

Tree Coverage - Medium: 1

Homestead: No

Fractional Ownership: No

Garage Square Feet: 1452

Deck: 1

Front Porch: 1

Below Ground: 1

Heated: 1

Range#: 22

Section#: 27

Township#: 30

Paved Streets: 1

Association Maintained Road: 1

Age 8 Years or Less: 1

Cash: 1

Conventional: 1

City Sewer/Connected: 1

3 BR on One Level: 1

4 BR on One Level: 1

All Living Facilities on One Level: 1

Main Floor Primary: 1

Primary Bdr Suite: 1

Two: 1

Private: 1

Lake Front: 1

House Number: 9

Street Name: Hillary Farm

Street Suffix: Lane

Postal City: Saint Paul

County: Ramsey

State: MN

Zip Code: 55110

Complex/Dev/Subdivision: Hillary Farm Add