Perry Gatliff

1414 Joliet Place, Detroit Sq. Footage:   1400 Bedrooms:   3      Baths - Full:   1     Half:  1 School District:   Detroit Experience a unique gem of iconic mid-century modern living in the heart of Lafayette Park, a master-planned community conceived by legendary architect in… More...

Listed at:  $ 389,000 MLS#:   20261012543 Additional Details

3031 Trowbridge Street, Hamtramck Sq. Footage:   858 Bedrooms:   2      Baths - Full:   1     Half:   School District:   Hamtramck This bungalow is located a short walk from Hamtramck's nicest restaurants, shopping, and Groceries. Home sits on 45 feet of frontage, a prior home was at… More...

Listed at:  $ 140,000 MLS#:   20251058719 Additional Details

20870 Wildwood, Harper Woods Sq. Footage:   1000 Bedrooms:   2      Baths - Full:   1     Half:   School District:   Harper Woods This Bright and Cozy two-bedroom Harper Woods Coop with brand new carpeting and neutral paint is a great value. Two spacious bedrooms with generous closet… More...

Listed at:  $ 47,500 MLS#:   20261005448 Additional Details

1029 Maryland Street, Grosse Pointe Park Sq. Footage:   1300 Bedrooms:   3      Baths - Full:   1     Half:   School District:   Grosse Pointe Great location and space. Upper flat with Newer Kitchen, refinished hardwood floors front and rear balconies, separated basements, separate electric and 2… More...

Listed at:  $ 1,500 MLS#:   20261001648 Additional Details

1031 Maryland Street, Grosse Pointe Park Sq. Footage:   1300 Bedrooms:   3      Baths - Full:   1     Half:   School District:   Grosse Pointe Great location and space. Lower flat with new kitchen and bath, refinished hardwood floors, porch, separate electric and furnaces. 2 car per unit parking… More...

Listed at:  $ 1,500 MLS#:   20261002258 Additional Details

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

Array

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

Array

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

Array

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

Array

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

Array