28256 QUEENS Court
Warren, MI 48093
MLS #: 214065741
Super Clean 2 Bedroom, 1.5 Bath Townhouse on a Basement with a Carport. New Hardwood floors & ALL appliances included (new stove, microwave, washer & dryer). BIG master bedroom and 2nd bedroom with balcony. Super quiet complex with gorgeous in-ground pool & well manicured grounds. Private patio. GAS and WATER is included!! Pet friendly & Move in Ready! Convenient location!! Details »
2 Bedrooms
2.00 Bathrooms
1080 Square Feet
Raised in a real estate family in Metro Detroit, Brandon Schmidt attended Oakland Universityâs marketing and communications program. Beginning his career in 2000 at RE/MAX Suburban in Sterling Heights, he served as a buyerâs agent for his father, Russ. Brandon rapidly increased the duos visibility by partnering in the creation of their home renovation company, Gemini Opportunities. Brandon carries on his fatherâs legacy by being one of the top agents in Southeastern Michigan. After his fatherâs retirement, Brandonâs brother, Brett, joined which created the next generation focusing on offering clients a collaborative and personalized service they deserve.
Brandon now leads a full time team of professionals and has been recognized by HOUR Detroit magazine as a âReal Estate All Starâ and has been inducted into the RE/MAX International Hall of Fame, a designation reserved for elite agents.
Brandon serves territories from his hometown of Macomb County through Oakland County, where he currently resides as well as Northern Wayne, Southern Lapeer & Southern St Clair Counties.. Brandon is an enthusiastic member of the community and enjoys, golfing, the outdoors and showing clients the best that Metro Detroit has to offer!
SimpleXMLElement Object
(
[0] => disclaimer
)
SimpleXMLElement Object
(
[0] => contactDisclaimer
)
SimpleXMLElement Object
(
[0] => Terms acceptance requirement notification
)
SimpleXMLElement Object
(
[0] => canadaContactDisclaimerNotice
)
SimpleXMLElement Object
(
[0] => Canadian disclaimer checkbox label
)
SimpleXMLElement Object
(
[0] => canadaDisclaimerLabel
)
SimpleXMLElement Object
(
[0] => Canadian disclaimer
)
SimpleXMLElement Object
(
[0] => canadaContactDisclaimer
)
SimpleXMLElement Object
(
[0] => The prev/next page links on each page
)
SimpleXMLElement Object
(
[0] => prevPage_previous
)
SimpleXMLElement Object
(
[0] => The prev/next page links on each page
)
SimpleXMLElement Object
(
[0] => prevPage_page
)
SimpleXMLElement Object
(
[0] => The prev/next page links on each page
)
SimpleXMLElement Object
(
[0] => nextPage_previous
)
SimpleXMLElement Object
(
[0] => The prev/next page links on each page
)
SimpleXMLElement Object
(
[0] => nextPage_page
)
SimpleXMLElement Object
(
[0] => The title for the agent listings page
)
SimpleXMLElement Object
(
[0] => agentlistings_h1
)
SimpleXMLElement Object
(
[0] => The main intro text for the agent listings page
)
SimpleXMLElement Object
(
[0] => agentlistings_headerText
)
SimpleXMLElement Object
(
[0] => The table columns
)
SimpleXMLElement Object
(
[0] => agentlistings_addressColumn
)
SimpleXMLElement Object
(
[0] => The table columns
)
SimpleXMLElement Object
(
[0] => agentlistings_sizeColumn
)
SimpleXMLElement Object
(
[0] => The table columns
)
SimpleXMLElement Object
(
[0] => agentlistings_priceColumn
)
SimpleXMLElement Object
(
[0] => The table columns
)
SimpleXMLElement Object
(
[0] => agentlistings_photoColumn
)
SimpleXMLElement Object
(
[0] => The details label on the right page
)
SimpleXMLElement Object
(
[0] => agentlistings_addressLabel
)
SimpleXMLElement Object
(
[0] => The details label on the right page
)
SimpleXMLElement Object
(
[0] => agentlistings_sizeLabel
)
SimpleXMLElement Object
(
[0] => The details label on the right page
)
SimpleXMLElement Object
(
[0] => agentlistings_bedsLabel
)
SimpleXMLElement Object
(
[0] => The details label on the right page
)
SimpleXMLElement Object
(
[0] => agentlistings_priceLabel
)
SimpleXMLElement Object
(
[0] => The details label on the right page
)
SimpleXMLElement Object
(
[0] => agentlistings_openTourButton
)
SimpleXMLElement Object
(
[0] => The title for the Property Details page
)
SimpleXMLElement Object
(
[0] => propertydetails
)
SimpleXMLElement Object
(
[0] => See More Listings button text
)
SimpleXMLElement Object
(
[0] => seeMoreListings
)
Browse through the many properties that I am currently representing. Click the property to view the virtual tour of each listing.
| Photo | Address | Size | Price |
|---|---|---|---|
| See More Listings | |||
Mortgage Calculator
How Much Can I Borrow?
How Much Can I Afford?
To email this brochure, please fill out the appropriate fields below. When done, simply click the "SEND" button.
Select a school from the list below to view its contact information and statistics.
Type of school
Institution Name:
Carter Middle School
Phone: (586)825-2620
Type: Regular school
NCES District ID: 2635190
Mailing Address:
12000 Masonic BlvdWarren, MI 48093
District: Warren Consolidated Schools
County:
NCES School ID: 263519007106
| Locale | : | City, Midsize (12) |
| Charter | : | no |
| Total Teachers (FTE) | : | 34.00 |
| Total Students | : | 686 |
| Student/Teacher Ratio | : | 20.2 |
Students: 06 - 08
| Grade | Students |
|---|---|
| 6th | 227 |
| 7th | 231 |
| 8th | 228 |
High |
: |
|
Low |
: |
|
Precipitation |
: |
|
Humidity |
: |
|
Wind |
: |
|
Pressure |
: |
There are two ways to get directions to this property. You can print the directions from your computer or have the address texted to your phone which can then be opened in Google maps.
Please enter Cell Numbers with only 10 digits (ex. 5555555555)
Brandon Schmidt
|
Real Estate Agent
|
586-262-5124
RE/MAX Suburban-MI (Cancelled)
|
586 262 2000
If you would like to be contacted with details about this property and others like it, please fill out the form below.