Dylan Tent

5280 Brookdale Road, Bloomfield Twp Sq. Footage:   3659 Bedrooms:   6      Baths - Full:   3     Half:   School District:   Birmingham Located in one of Bloomfield Hills' most coveted neighborhoods, this 6-bedroom, 3-bathroom ranch is a masterpiece of mid-century design by the renowned on… More...

Listed at:  $ 2,650,000 MLS#:   20240078660 Additional Details

116 4 Avenue, Ann Arbor Sq. Footage:   5363 Bedrooms:   3      Baths - Full:   5     Half:   School District:   Ann Arbor Extraordinary Opportunity to Own and Occupy a Prestigious Mixed-Use Gem in the Heart of Downtown Ann Arbor! Step into a world of sophistication with this… More...

Listed at:  $ 2,599,900 MLS#:   20240079963 Additional Details

4143 Longview Drive, Elba Twp Sq. Footage:   6582 Bedrooms:   4      Baths - Full:   5     Half:   School District:   Lapeer Magnificent All Sports Lakefront estate in the Lake Nepessing Bluffs on 7+ landscaped acres. Exclusive gated community offers the best of the best in Upon… More...

Listed at:  $ 2,499,900 MLS#:   20240055912 Additional Details

3885 Lake Front Street, Waterford Twp Sq. Footage:   2000 Bedrooms:   3      Baths - Full:   2     Half:  1 School District:   Waterford **Luxurious Lakefront Living on Cass Lake - 3885 Lake Front St** Discover an unparalleled lifestyle at 3885 Lake Front St, an exquisitely updated 52 feet… More...

Listed at:  $ 1,799,900 MLS#:   20240078335 Additional Details

15165 Main Street, Buchanan Sq. Footage:   6400 Bedrooms:   1      Baths - Full:   1     Half:   School District:   Buchanan Welcome to your own private paradise! Nestled on over 10 acres of picturesque riverfront land, this stunning property offers the ultimate retreat from the… More...

Listed at:  $ 1,499,000 MLS#:   20240075706 Additional Details

1825 A Dell Rose Drive, Bloomfield Twp Sq. Footage:    Bedrooms:         Baths - Full:        Half:   School District:   Pontiac Welcome to an extraordinary opportunity to own a prime lakefront lot on the coveted All Sports Square Lake in Bloomfield Township, MI. This expansive **80… More...

Listed at:  $ 799,900 MLS#:   20240094373 Additional Details

1825 Dell Rose Drive, Bloomfield Twp Sq. Footage:   1436 Bedrooms:   3      Baths - Full:   1     Half:  1 School District:   Pontiac Welcome to an extraordinary opportunity to own a prime lakefront lot on the coveted All Sports Square Lake in Bloomfield Township, MI. This expansive **80… More...

Listed at:  $ 799,900 MLS#:   20240094378 Additional Details

233 Barden Road, Bloomfield Hills Sq. Footage:   1864 Bedrooms:   3      Baths - Full:   2     Half:   School District:   Bloomfield Hills Discover this beautifully updated, spacious ranch-style condo, ideally located in the heart of Bloomfield Hills, just a short walk from Cranbrook Middle a… More...

Listed at:  $ 449,000 MLS#:   20240093019 Additional Details

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240078660'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240079963'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240055912'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240078335'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240075706'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240094373'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240094378'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230096824'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210046328'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210046336'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240079810'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240093019'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240086949'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240094134'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240090706'

Array