Browse All WAYNE COUNTY CONDO PLAN NO 1178 CITY MODERN HISTORIC HOMES Properties for Sale

3 Beds ⋅ 3 Baths ⋅ 20240064092 MLS

Step into the historic charm of Detroit's coveted Brush Park with all the modern amenities! Unit A is a masterfully crafted luxury duplex more commonly known as one of "The Mansard Twins." Meticulously restored inside and out the open floorplan offers 2000 square feet of finished living space, with 3 spacious bedrooms and 2.1 baths. Dramatic ceilings, bold custom moldings, and a fusion of rich hardwoods with contemporary accents create an atmosphere of timeless elegance. A fire-lit, sun-soaked living space off the main entrance flows into the ample dining room creating the perfect space for quiet nights at home or intimate gatherings. The second floor hosts the primary bedroom suite, with spacious walk-in closet and laundry adjacent to the dual-sink primary bathroom with shower and soaking tub. The third floor features two additional bedrooms, one with a large rooftop deck, and another full bath. Enjoy a seamless blend of functionality and flow to meet the demands of modern living, offering ample storage space on every floor. Included is a one-car detached garage for added convenience, with additional parking available. Nestled in an enviable location, you'll find yourself mere minutes away from Comerica Park, Little Caesars Arena, Ford Field, DMC, and Henry Ford Hospital. 24-hour private neighborhood security. Enjoy the coveted NEZ-Rehab tax abatement that freezes the taxable value through 2037 and is investor friendly meaning you do not need to homestead in order to qualify for the abatement. Move right in and embrace the opportunity to relish the rich history and modern comforts that this remarkable residence has to offer! Don't miss this one, set up your private showing today!

295 Alfred St Unit A, Detroit

Courtesy of Max Broock, REALTORS®-Detroit 3133248430

Selling Office: The Agency Hall & Hunter.

$1,050,000

3 Beds ⋅ 3 Baths ⋅ 20230077125 MLS

Discover a true gem amidst the historic charm of Detroit's coveted Brush Park! Welcome to Unit B in a masterfully crafted luxury duplex more commonly known as one of "The Mansard Twins". It was recently meticulously restored both inside and out to offer a harmonious blend of old-world grandeur and modern living. With nearly 2800 square feet of exquisitely finished living space, there are 3 generously proportioned bedrooms and 2.1 baths. Step into a world of timeless elegance, where dramatic ceilings, bold custom moldings, and a fusion of rich hardwoods with contemporary accents create a captivating atmosphere. The dining room, with its ample space and abundant natural light, is perfect for hosting gatherings of your choice. Enjoy a seamless blend of functionality and flow to meet the demands of modern living, offering ample storage space on every floor. Included is a one-car detached garage for added convenience with additional parking available. Nestled in an enviable location, you'll find yourself mere minutes away from Comerica Park, Little Caesars Arena, Ford Field, DMC, and Henry Ford Hospital. 24-hour private neighborhood security. Enjoy the coveted NEZ-Rehab tax abatement that freezes the taxable value through 2037 and is investor friendly meaning you do not need to homestead in order to qualify for the abatement. Move right in and embrace the opportunity to relish the rich history and modern comforts that this remarkable residence has to offer! Don't miss this one, set up your private showing today!

295 Alfred St Unit B, Detroit

Courtesy of Max Broock, REALTORS®-Detroit 3133248430

Selling Office: @propertiesChristie's Int'l RE.

$655,000

3 Beds ⋅ 4 Baths ⋅ 20230077029 MLS

Here it is! Discover pure opulence within Unit B of "The Campbell House" - a remarkable luxury duplex gracefully situated in the Brush Park neighborhood within downtown Detroit. As you step into this exclusive residence, you'll be greeted by a world of first-class living and modern sophistication. Originally constructed in the 1800s, this architectural masterpiece underwent an extensive renovation like no other - and no details were spared! Enjoy nearly 2200 square feet of finished living space throughout with 3 bedroom suites and 3.1 baths. Included is a one-car detached garage for added convenience with additional parking available. Nestled in a prestigious neighborhood, Unit B offers easy access to upscale shopping, fine dining, cultural attractions, and everything the city has to offer. 24-hour private neighborhood security. Enjoy the coveted NEZ-Rehab tax abatement that freezes the taxable value through 2035 and is investor-friendly - you do not need to homestead the property in order to qualify for the abatement creating an exceptional investment opportunity. This residence is a true showpiece, suitable for intimate gatherings or grand galas, and represents a unique opportunity that may not present itself again!

261 Alfred St Unit B, Detroit

Courtesy of Max Broock, REALTORS®-Detroit 3133248430

Selling Office: Max Broock, REALTORS®-Detroit.

$945,000

4 Beds ⋅ 4 Baths ⋅ 20230071024 MLS

Welcome to the historic Campbell House - gracefully situated in the Brush Park neighborhood within downtown Detroit. Originally constructed in the 1800s, this architectural masterpiece underwent an extensive renovation like no other - and the details were not spared. This super special property boasts 4 generously proportioned bedrooms and 2.5 baths, offering 2600 square feet of finished living space throughout with an unfinished basement ready to be done to your liking. RARE- The are two primary bedroom suites - the first exudes a regal ambiance on the 3rd floor with its soaring ceilings and sitting area, complemented by an attached bathroom featuring a clawfoot tub, walk-in shower, and dual sinks. The other. primary bedroom suite is located on the 2nd floor with an adjacent bath and oversized closet. The kitchen and firelit dining room are perfect for entertaining and serve as a focal point, showcasing custom-crafted cabinets with granite countertops. Stainless steel appliances and a sleek hood fan provide modern functionality while preserving the home's timeless charm. Included is a one-car detached garage for added convenience with additional parking available. Nestled in an enviable location, you'll find yourself mere minutes away from Comerica Park, Little Caesars Arena, Ford Field, DMC, and Henry Ford Hospital. 24-hour private neighborhood security. Enjoy the coveted NEZ-Rehab tax abatement that freezes the taxable value through 2035 and is investor friendly meaning you do not need to homestead in order to qualify for the abatement. This residence is a true showpiece, suitable for intimate gatherings or grand galas, and represents a unique opportunity that may not present itself again!

261 Alfred St Unit A, Detroit

Courtesy of Max Broock, REALTORS®-Detroit 3133248430

Selling Office: Max Broock, REALTORS®-Detroit.

Start Your Search

IDX provided courtesy of Realcomp II Ltd., via Real Estate Company. Copyright 2026 Realcomp II Ltd. Shareholders. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing and that the data is deemed reliable but not guaranteed accurate by the MLS.

WAYNE COUNTY CONDO PLAN NO 1178 CITY MODERN HISTORIC HOMES Real Estate & Homes

Our website features the best real estate search for homes, condos, land and foreclosure properties available in WAYNE COUNTY CONDO PLAN NO 1178 CITY MODERN HISTORIC HOMES, Detroit MI. It is the only site you will ever need! It is easy-to-use and updated by the official Realtor®’s database every 15 minutes.

You can save searches, and get daily email alerts of new listings, price changes, sold data, and market reports. Our Interactive Map Search allows you to view properties on a map or refine your search by drawing the boundaries around the area you desire.

Curious about what’s happening in your neighborhood? You can create a custom market report to see what’s active, under contract, and sold in your neighborhood!

Considering selling or refinancing your home? Get an INSTANT property valuation now!