Property type: Residential
Address: Contact Gem Realty here for the address
City: Bloomfield Hills
Price: $2,250,000
Beds: 6
Baths: 7.5
Garage: 5
Sqft Above Ground: 6,732
Sqft Basement: 2,953
Acres: 2.04
Other Features:
In the Spirit of a Country Estate, this spectacular Bloomfield Hills executive retreat is perfectly situated on a gorgeous, private 2.04-acre parcel overlooking Stonycroft Hills Country Club. Accessed by a winding white picket fence, the main and upper levels feature 6,785 square feet of living space showcasing newer, site-finished oak hardwood flooring throughout, abundant windows, and generous rooms offering exceptional flow. Some highlights include three fireplaces, character ceilings, and abundant natural light. The gourmet eat-in kitchen is a chef's dream with granite countertops, large center island, stainless steel appliances, and butler's pantry with prep area, all adjacent to the impressive formal dining room. The expansive great room captivates with floor-to-ceiling windows and stunning stone fireplace, while the library provides ideal work-from-home space with additional fireplace and vaulted ceiling. The bonus, second great room is an exceptional space complete with mini kitchen and expansive island, ideal for family gatherings, featuring a full bath with direct access to private yard and convenient to the upper level in-law suite with its own private full bath. The luxurious, updated first-floor primary suite is a true sanctuary featuring a fireplace and two separate walk-in closets. One of the home's most remarkable features is the stunning indoor lap pool with adjacent exercise room, offering resort-style living without ever leaving home. The second level showcases three princess suites, each with their own recently remodeled ensuite baths, plus an additional bedroom with hallway bath. The recently finished 2,953 square foot lower level is an entertainer's paradise complete with home theatre, media room, children's play area, gaming area with ping pong, billiards space, and full remodeled bath. This one-of-a-kind property includes a five-car garage (3 heated). Bloomfield Hills Schools.
Property type: Single family
Address: Contact Gem Realty here for the address
City: Commerce Twp
Price: $6,500,000.00
Beds: 5
Baths: 7.2
Garage: 9 car attached
Sqft Above Ground: 8,700
Sqft Basement: 3,500
Acres: 2.05
Other Features: lake front -sandy bottom no seaweed and beach area. Sttached garage is two sections, one with open ceiling and set up to accommodate three car lifts (Six indoor parking spots) plus additional three car garage with workshop storage space.
Property type: Condo
Address: Contact Gem Realty here for the address
City: Northville Twp
Price: $700,000.00
Beds: 2
Baths: 3
Garage: 3 car attached
Sqft Above Ground: 1,834
Sqft Basement: 100
Other Features: Beautiful Northville Township condo offering 2 bedrooms, 3 bathrooms, and 1,834 sq. ft. of stylish living space. Features include a 3-car attached garage, modern exterior, spacious layout, and low-maintenance condo living in a desirable community.
Property type: Single Family
Address: Contact Gem Realty here for the address
City: Northville
Price: $1,995,000.00
Beds: 5
Baths: 4.1
Garage: 3 car attached
Sqft Above Ground: 4,152
Sqft Basement: 2,428
Acres: 0.2
Other Features:
Custom-built Cape Cod in Northville, crafted in 2017 by Vistal Homes. Offering over 6,200 square feet of refined living just minutes from downtown Northville. Rich hardwood floors, sun-filled living spaces, and soaring ceilings in the great room and foyer create a seamless, open layout. The striking kitchen features stainless steel appliances, Quartz countertops, a large central island, double ovens, a pot filler over the cooktop, and timeless finishes. A butler’s pantry with beverage fridge conveniently leads to the spacious dining room. The two-story great room is anchored by a grand stacked-stone gas fireplace. The first-floor primary suite offers a true retreat with a spa-inspired bath, including a standalone soaking tub, a huge seamless-glass shower, and heated tile floors. A main-level office with coffered ceilings and hardwood floors provides a perfect workspace. Thoughtful details continue with a heated 3-car garage featuring its own utility/pet shower. Upstairs, you’ll find three large guest bedrooms with generous closets, one private suite, and a Jack-and-Jill bath. A huge bonus room is ideal for a kids’ play area or media room. Additional highlights include two newer hot water heaters with a hot water accelerator, gutter guards, and integrated Control4 technology with outdoor speakers. The finished walkout lower level extends the living space beautifully with a large kitchenette, spacious family room, wine cellar, workout room, and an additional bedroom with a full bath. Northville Schools district.
Property type: Single Family
Address: Contact Gem Realty here for the address
City: Commerce Twp
Price: $779,000.00
Beds: 2
Baths: 1.1
Garage: 2 car attached
Sqft Above Ground: 1,728
Sqft Basement: split level
Acres: 0.22
Other Features: Lakefront right on Union Lake, tenant occupied, split level
Other Features: Seize this exceptional chance to call beautiful Union Lake home! This residence features an open floor plan with stunning sunrise views that stretch across the entire lake. Completely move-in ready with 2021 renovations, the property boasts brand new flooring, a fully remodeled kitchen with custom cabinetry, granite countertops, and stainless steel appliances. Both bathrooms have been modernized. The upper level contains two bedrooms, while the lower level has space for a third bedroom (requires wall installation). The finished basement walkout provides direct access to 50 feet of pristine sandy beach frontage. A two-car attached garage and extra-wide driveway offer ample parking space. Located in the highly-rated Walled Lake School District.
Property type: Commercial
Address: Contact Gem Realty here for the address
City: Plymouth
Price: $944,000.00
Beds: 1 / 1 / 3
Baths: 1 / 1 / 2
Garage: 0
Sqft Above Ground: 2,550
Sqft Basement: see Notes
Acres: 0.4
Other Features:
2 Buildings on the parcel, 1 commercial and 1 duplex with parking lot. Downtown Plymouth location. ***CAN BE USED AS AN OFFICE OR RETAIL. 2 buildings- ONE IS A 1,581 SQ FT BLDG THAT'S READY FOR IMMEDIATE OCCUPANCY. THE 2ND "CARRIAGE" BUILDING HOUSES TWO 1 BR APTS
Why Pocket Listings
Understanding off-market real estate
A pocket listing — also called an off-market or exclusive listing — is a property that is for sale but never appears on the open Multiple Listing Service (MLS) or major public real estate portals. Instead, the listing is shared privately, or "kept in the pocket," by the listing agent and offered only to a select network of buyers and cooperating agents. Sellers choose this route for a variety of reasons: to protect their privacy, to test a price quietly before going public, to avoid the disruption of open houses and frequent showings, or simply because they value discretion during a life transition such as a divorce, relocation, or estate sale.
For buyers, pocket listings open the door to opportunities that never surface in a standard search. Because these homes aren't competing in the crowded public marketplace, there's typically less bidding pressure, more room for direct negotiation, and a more personal, unhurried process from first tour to closing. Working with a brokerage that maintains an active network of off-market relationships, like Gem Realty, means gaining access to inventory that other buyers simply never see — sometimes homes that are never publicly listed at all.
Off-market real estate isn't for every buyer or every seller, but for those who value privacy, exclusivity, and a more curated search, it remains one of the most effective ways to buy and sell property outside the noise of the open market. If you'd like to be considered for our current or upcoming pocket listings, reach out below and a Gem Realty agent will follow up directly.

Get in touch
Ready to see more?
Send us a note and a Gem Realty agent will follow up with full details, including the address, on any property you're interested in.









































































































































































































































































