Advanced Search

Owner is an Agent?: No

Auction?: No

Status: Coming Soon

Contingency: None

Current Price: $568,000

Original List Price: 568000

ListPrice: 568000

List Date: 2026-08-24

Association: MAAR

Common Wall: No

Lot Measurement: Acres

Manufactured Home?: No

Multiple PIDs?: No

New Development: No

Number of Fireplaces: 1

Waterfront Frontage: 100

Waterfront YN: Yes

Year Built: 1961

Yearly/Seasonal: Yearly

Zoning: Residential-Single Family

Lot Dimensions: 100 x 200

Acres: 0.44

Bath Three Quarters: 1

Bath Half: 0

Lake/Waterfront Name: Mississippi River

Bath Quarter: 0

Main Floor Total SqFt: 1432

Above Grd Total SqFt: 1432

Below Grd Total SqFt: 1340

Total SqFt: 2772

Total Finished Sqft: 2772.00

FireplaceYN: Yes

Foundation Size: 1532

Style: (SF) Single Family

Garage Stalls: 2

Power Company: Xcel Energy

Association Fee: 0

Assessment Pending: No

Bedrooms: 3

Baths Total: 2

Bath Full: 1

AssocFeeYN: No

Legal Description: LOT 17 BLK 2 SANDHURST ADD, SUBJ TO EASE OF REC

Listing City: Fridley

Map Page: 78

Municipality: Fridley

School District: Fridley

School District Phone: 763-502-5001

DNR Lake Classification: Not Applicable

Zip Plus 4: 4112

Property ID Number: 153024120054

Tax Year: 2026

Tax Amount: 7868

In Foreclosure?: No

Potential Short Sale?: No

Lender Owned?: No

Public Remarks: HIDDEN GEM... peaceful and quiet retreat with breathtaking views and Mississippi River access! High quality craftsmanship, close to parks and trails. Beautifully updated walkout rambler with stunning river views through big windows in every room. Only the second owners, the sellers have invested 20 years into making this their dream home... now you have the rare opportunity to make it your own. Main floor kitchen and family room were completely remodeled to create an open floor plan with custom maple cabinets, granite counters, stainless steel appliances, big island, gas fireplace, walkout to big composite deck to sit and watch beautiful sunsets. Hardwood floors, Andersen windows, solid core doors throughout. Two bedrooms on main floor and lower level finished with family room, guest room, office/craft room, work shop, drain tile. 30-year roof new in 2013, furnace and A/C new in 2019, attic insulation with R-value of 60, in ground sprinkler system, fire pit, garage floor with polyurethane coating, switchback trail to river so you can launch your kayaks. This home just feels good as soon as you enter and invites you to stay. See supplements for more about this outstanding property. Professional photos coming 8/26

Directions: I-694 to East River Rd, north to Hartman Circle.

None: 1

Central Air: 1

Ceiling Fan(s): 1

Deck: 1

French Doors: 1

Hardwood Floors: 1

In-Ground Sprinkler: 1

Kitchen Center Island: 1

Kitchen Window: 1

Main Floor Primary Bedroom: 1

Natural Woodwork: 1

Paneled Doors: 1

Panoramic View: 1

Patio: 1

Security Lights: 1

Tile Floors: 1

Washer/Dryer Hookup: 1

Dishwasher: 1

Disposal: 1

Dryer: 1

Energy Star Appliances: 1

Microwave: 1

Range: 1

Refrigerator: 1

Washer: 1

Wine Cooler: 1

Assessment Balance: 0

Tax With Assessments: 7868

Not Assumable: 1

Concrete Block: 1

Drain Tiled: 1

Full: 1

Storage Space: 1

Sump Pump: 1

Main Floor Full Bath: 1

3/4 Basement: 1

Finished SqFt Above Ground: 1432

Finished SqFt Below Ground: 1340

Block: 1

Concrete: 1

Previously Owned: 1

Breakfast Bar: 1

Living/Dining Room: 1

Separate/Formal Dining Room: 1

150 Amp Service: 1

Circuit Breakers: 1

Brick/Stone: 1

Stucco: 1

2 or More: 1

Family Room: 1

Lower Level: 1

Main Level: 1

Partial: 1

Privacy: 1

Family Room: 1

Gas Burning: 1

Concrete Block: 1

Natural Gas: 1

Forced Air: 1

Insurance Fee: 0

Lake Depth: 0

In Basement: 1

Laundry Room: 1

Lower Level: 1

Sink: 1

Land Leased: Not Applicable

Accessible Shoreline: 1

Public Transit (w/in 6 blks): 1

Tree Coverage - Medium: 1

Homestead: Yes

Fractional Ownership: No

Garage Square Feet: 452

Composite Decking: 1

Deck: 1

Patio: 1

None: 1

Range#: 24

Section#: 15

Township#: 30

City Street: 1

Curbs: 1

Paved Streets: 1

Storm Sewer: 1

Street Lights: 1

Public Maintained Road: 1

Age Over 8 Years: 1

Architectural Shingle: 1

Pitched: 1

Cash: 1

Conventional: 1

FHA: 1

VA: 1

City Sewer/Connected: 1

Main Floor Bedroom: 1

Main Floor Primary: 1

One: 1

City Water/Connected: 1

River Front: 1

River View: 1

House Number: 165

Street Name: Hartman

Street Suffix: Circle

Street Direction Suffix: NE

Postal City: Fridley

County: Anoka

State: MN

Zip Code: 55432

Complex/Dev/Subdivision: Sandhurst Add