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 Featured Listings
Listing 1 out of 21
$400,000 Pending

202 Tartan Drive
Rochester Hills, MI 48309

4 beds, 3 baths | Single Family Home
2,653 sq ft; lot: 0.66 acres - MLS# 218096561
Property Photo


Rare find, Waterfront 4 bedroom ranch with walkout basement in Rochester Hills... look out at your own island parcel! Stunning views, abundant wildlife and within minutes of Downtown Rochester, trails, Oakland University and Crittenton Hospital. Walkout with full bar, TV and poolroom perfect for entertaining. Slate entry, granite kitchen, over-sized garage with workshop area, private circular drive for additional parking, 2 natural fireplaces are just a few of the homes characteristics, sold in as-is condition. Pool Table included in sale. Owner is a Licensed MI agent. Only pre-qualified buyers by appointment only.


  • Association Fee Frequency: Annually
  • Basement: Partially Finished, Walkout Access
  • Baths: 3
  • Bedrooms: 4
  • Construction Materials: Brick, Wood
  • Cooling: Attic Fan, Ceiling Fan, Central Air, Energy Star® Qualified Ceiling Fan(S)
  • County/Area: Oakland County
  • Exterior Features: Energy Star® Qualified Skylights
  • Fireplace: Basement,Living Room
  • Fireplace Fuel: Natural
  • Foundation Details: Basement, Michigan Basement
  • Foundation Materials: Poured
  • Frontage Feet: 127
  • Full Baths: 3
  • Garage: 2 Car
  • Garage Dimensions: 30x25
  • Garage Features: Attached, Door Opener, Electricity, Side Entrance, Workshop
  • Heating: Energy Star® Qualified Furnace Equipment, Forced Air
  • Heating Fuel: Natural Gas
  • Interior Features: Cable Available, High Spd Internet Avail, Humidifier, Wet Bar
  • Kitchen Appliances: Bar Fridge, Dishwasher, Disposal, Dryer, Energy Star® Qualified Dishwasher, Energy Star® Qualified
  • Listing Financing: Cash, Conventional
  • Listing Status: Pending
  • Lot Dimensions: 127X100
  • Lot Features: Lake View
  • Lot Size: 0.6600
  • Originating MLS: Realcomp Ii Ltd
  • Ownership Status: Private Owned, Short Sale - No
  • Porch Type: Balcony, Deck, Patio
  • Property Type: Single Family Home
  • Road Frontage Type: Paved
  • Roof Material: Asphalt
  • School District: Rochester
  • Sewer: Sewer-Sanitary
  • Sq.Ft.: 2653
  • Sqft Combined: 4009
  • Sqft Lower Floor: 1356
  • Sqft Source: Prd
  • Sqft Total Bsmt: 2273
  • Stories: 1 Story
  • Style: Ranch
  • Sub Type: Residential
  • Subdivision: Lochmoor Hills No 1
  • Subdivision/Neighborhood: Lochmoor Hills No 1
  • Total Rooms: 18
  • Water Heater Fuel: Natural Gas
  • Water Source: Municipal Water, Well-Existing
  • Year Built: 1964
  • Zip Code: 48309
  • Waterfront: Creek, Pond, Sargent Creek/Lochmoor Lake

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