Homes by Email

Be the first to see new listings as soon as they hit the market!

Quick Search

view all



No Min.

No Max.

David Elya
Broker Owner
Brookview Realty
623 North Main Street

Rochester, MI 48307

Email Us
Our Testimonials

Contact Us

* fields are required
Back to Saved Search
Listing 2 out of 250
$317,999 For Sale

3900 Waterview
Shelby Twp, MI 48316

4 beds, 2 full, 1 partial baths | Single Family Home
2,565 sq ft; lot: 18295 sq ft - MLS# 58031368677
Property Photo


Impeccably maintained, 4 bedroom Colonial, located in the heart of Shelby Twp, in the award winning Utica Community School District. Enter the spacious foyer, to be greeted by french doors leading to the open concept living & dining room, featuring 2 sets of large windows, they flood the room w/ natural light! Proceeding to the GORGEOUS eat in kitchen & family room, you will find, granite countertops, endless amounts of cabinetry, built-in SS appliances, breakfast nook, real wood burning f/p, along w/ dual entry to the HUGE backyard w/ covered patio & pool w/ deck, perfect for entertaining in the warmer months! Finishing off the main level, is the convenient laundry room w/ direct access to the 2 car attached garage & half bath. Upstairs you will find the large master suite w/ his & hers closets, stand up shower, soaker tub & vanity, along w/ 3 generously sized bedrooms & full bath w/ dual sinks and granite countertops! Finished basement providing addt'l living space & storage!


  • Property Type: Single Family Home
  • Sub Type: Residential
  • Listing Status: Active
  • County/Area: Macomb County
  • Zip Code: 48316
  • Year Built: 1975
  • Subdivision/Neighborhood: Twin Lakes
  • School District: Utica
  • Sq.Ft.: 2,565 sq ft
  • Style: Colonial
  • Stories: 2 Story
  • Bedrooms: 4
  • Full Baths: 2
  • Half Baths: 1
  • Basement: Finished
  • Garage: 2 Car
  • Lot Size: 18295 sq ft
  • Baths: 3
  • Construction Materials: Brick, Vinyl
  • Cooling: Central Air
  • Exterior Features: Sprinkler(S)
  • Fireplace Fuel: Natural
  • Foundation Details: Basement
  • Frontage Feet: 120
  • Garage Features: Attached, Door Opener, Electricity
  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Kitchen Appliances: Dishwasher, Disposal, Microwave, Refrigerator, Stove
  • Lease Type: Single Family House
  • Listing Financing: Cash, Conventional
  • Lot Dimensions: 120x159
  • Originating MLS: Mirealsource
  • Porch Type: Deck, Patio, Porch
  • Road Frontage Type: Paved
  • Sewer: Septic-Existing
  • Sqft Combined: 3465
  • Sqft Lower Floor: 900
  • Sqft Total Bsmt: 1000
  • Water Heater Fuel: Natural Gas
  • Water Source: Municipal Water
Courtesy of Exp Realty Llc Rochester

Brookview Realty | 248-652-7000 | Contact Us
623 N. Main Street - Rochester, MI 48307
Copyright © , All Rights Reserved

Real Estate Websites by iHOUSEweb iconiHOUSEweb | Admin Menu