Crystal Marsh

My Featured Listings

41614 Hamlet Lane, Novi
Sq. Footage:   1132
Bedrooms:   2      Baths - Full:   2     Half:
School District:   Novi
You won't want to MISS this beautifully renovated Gateway Village of Novi Condominium! This tastefully designed home offers a neutral luxury wood floor, a… More...

Listed at: $ 297,000
MLS#: 20261011607
Additional Details

29329 Rose Street, Madison Heights
Sq. Footage:   1057
Bedrooms:   3      Baths - Full:   1     Half:
School District:   Lamphere
This adorable ranch home is available for immediate occupancy. Large windows throughout. The updated kitchen is open to the living and dining areas and 3… More...

Listed at: $ 1,900
MLS#: 20261022594
Additional Details

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

Branch Listings
MLS #	Address	City	Type	Price
20240087018	16134 Tindall Road	Groveland Twp	Vacant Land	$15,000,000
20261001237	999 Pleasant Avenue	Birmingham	Residential	$8,999,000
20261023865	9842 Misery Bay	Alpena	Residential	$8,100,000
20261022182	1398 Chesterfield Avenue	Birmingham	Residential	$7,999,000
20261017613	2475 W Lake Angelus Road	Lake Angelus	Residential	$6,499,000
20240086826	Lot 1 Tindall Road	Groveland Twp	Vacant Land	$6,300,000
20261000725	395 Greenwood Street	Birmingham	Residential	$4,650,000
20261011714	625 Fairbrook Street	Northville Twp	Residential	$4,500,000
20261020241	2759 Turtle Ridge Drive	Bloomfield Twp	Residential	$3,995,000
20261000726	1120 Lyonhurst Street	Birmingham	Residential	$3,895,000
20261015419	1094 Lincoln Court	Birmingham	Residential	$3,799,000
20261014418	7357 Lindenmere Drive	Bloomfield Twp	Residential	$3,750,000
20261022894	1295 Lakeside Drive	Birmingham	Residential	$3,699,000
20240087102	Lot 6 Tindall Road	Groveland Twp	Vacant Land	$3,200,000
20251049382	10624 Jefferson Avenue	Detroit	Commercial	$3,000,000
20251057273	16385/16475 17 1/2 Mile Road	Marshall	Residential	$2,750,000
20230098765	453 Martin Luther King Jr Boulevard	Detroit	Commercial	$2,500,000
20261020947	5001 Forest Valley	Independence Twp	Residential	$2,499,900
20240087016	Lot 2 Tindall Road	Groveland Twp	Vacant Land	$2,400,000
20251054593	16385 17 1/2 Mile Road	Marshall	Residential	$2,365,000
20240087026	Lot 3 Tindall Road	Groveland Twp	Vacant Land	$2,200,000
20261023266	3225 Legacy Court	West Bloomfield Twp	Residential	$1,990,000
20261022087	4650 Lahser Road	Bloomfield Hills	Residential	$1,750,000
20261001201	4294 East Torch Lake Drive	Central Lake Twp	Residential	$1,659,000
20261022356	4650 Lahser Road	Bloomfield Hills	Residential	$1,650,000
20240091887	6 Mccandlish Road	Grand Blanc Twp	Vacant Land	$1,575,000
20261020069	2532 Cedar Brook Court	Rochester Hills	Residential	$1,550,000
20261003901	608 Purdy Street	Birmingham	Residential	$1,299,900
20250021788	7699 Minnick Road	Rubicon Twp	Residential	$1,299,000
20261023448	7455 Groveland Road	Groveland Twp	Residential	$1,139,800
20240087028	Lot 4 Tindall Road	Groveland Twp	Vacant Land	$1,100,000
20261011716	1216 Combermere Drive	Troy	Commercial	$999,000
20251038757	8650 Stone Road	Maybee Vlg	Residential	$949,500
20251040440	000 8 Mile Road	Salem Twp	Vacant Land	$895,000
20261024175	9393 Boncrest Street	Commerce Twp	Residential	$848,999
20261011715	54085 Deadwood Lane	Shelby Twp	Residential	$809,999
20251041237	11436 NE Lakeview Road	Kalkaska Twp	Residential	$799,900
20261023168	38383 Saddle Lane	Clinton Twp	Residential	$799,000
20261015912	2497 Walton Boulevard	Waterford Twp	Residential	$798,000
20261017853	2509 Liberty Street	Ann Arbor	Residential	$645,000
20261019780	411 Old Woodward Avenue	Birmingham	Condominium	$599,000
20261019472	13850 Grand River Avenue	Detroit	Commercial	$535,500
20261023982	24122 Bingham Pointe Drive	Bingham Farms Vlg	Condominium	$529,000
20261014785	19005 Silver Parkway	Fenton Twp	Commercial	$499,000
20261023430	21890 Hampton Street	Beverly Hills Vlg	Residential	$485,000
20261021673	281 Quartz Way	White Lake Twp	Residential	$479,999
20251061915	VL Lahser Road Lot 76	Bloomfield Hills	Vacant Land	$450,000
20251018627	8735 Lyndon Street	Detroit	Commercial	$410,000
20251054659	16475 17 1/2 Mile Road	Marshall	Residential	$409,000
20261020142	6460 Marble Lane	Flint Twp	Residential	$400,000
20240087029	Lot 5 Tindall Road	Groveland Twp	Vacant Land	$400,000
20261018798	1115 Old Woodward Avenue	Birmingham	Condominium	$399,900
20261014469	237 Marlborough Drive	Bloomfield Twp	Residential	$399,900
20251049487	3050 Outer Drive	Detroit	Vacant Land	$399,900
20251051857	1991 Calvert Street	Detroit	Residential	$380,000
20261022038	229 Forest Trail	Rose Lake Twp	Residential	$297,800
20261011607	41614 Hamlet Lane	Novi	Condominium	$297,000
20251017494	15801 Schaefer Highway	Detroit	Commercial	$265,000
20261022112	4650 Lahser Road	Bloomfield Hills	Vacant Land	$250,000
20261020369	36702 Park Place Drive	Sterling Heights	Condominium	$210,000
20261009283	1155 Derby Road	Birmingham	Condominium	$190,000
20251028341	1389 Cass Lake Road	Waterford Twp	Vacant Land	$175,000
20251047628	75 Mathews Street	Pontiac	Residential	$165,000
20251059717	689 Fox Hills Drive	Bloomfield Hills	Condominium	$164,900
20261009222	2983 Dashwood Drive	Troy	Vacant Land	$159,900
20261011458	12519 Riad Street	Detroit	Residential	$105,000
20251045454	11375 Grandmont Avenue	Detroit	Residential	$100,000
20261011949	31831 Grand River Avenue	Farmington	Condominium	$95,000
20251004063	VAC Massena Drive	Commerce Twp	Vacant Land	$19,900
20251057377	16615 Walcliff Drive	Clinton Twp	Residential	$6,500
20251057340	2002 Ridgemont Road	Grosse Pointe Woods	Residential	$6,500
20261013933	6710 Westpointe Drive	Troy	Residential	$4,500
20261018679	4576 Wagon Wheel Drive	Bloomfield Twp	Residential	$4,400
20261021635	5130 Provincial Drive	Bloomfield Twp	Residential	$4,000
20261014031	2194 Dorchester Road	Birmingham	Residential	$3,500
20250021391	5058 Leafdale Boulevard	Royal Oak	Commercial	$3,500
20261022594	29329 Rose Street	Madison Heights	Residential	$1,900
20261023685	30773 Hidden Pines	Roseville	Condominium	$1,575
20261011284	689 Fox Hills Drive	Bloomfield Hills	Condominium	$1,525

Search All On-Market Properties

Market Area	Realcomp	Property Type

Preferred City

Price Range	to

Preferences	Bedrooms Bathrooms

Search by Keyword Enter street name or zip

Realcomp

Or, Search Directly by MLS#: Realcomp

Signature Sotheby's International Realty is a member of Realcomp, the consolidated multiple listings service Throughout Southeast Michigan. Let me and my associates help you find the home of your dreams. Signature Sotheby's International Realty also specializes in worldwide relocation. Contact me for all of your Real Estate needs.

Sotheby's International Realty® is a registered trademark licensed to Sotheby's International Realty Affiliates, Inc.
Each Office is Independently Owned and Operated. Equal Housing Opportunity.

Listings with the IDX logo are provided through Realcomp exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Contact agent for more information and most current market data. Copyright 2012 Realcomp.

© 2012 Signature Sotheby's International Realty LLC, Inc. All rights reserved worldwide.