Share

  • Price: $70,000

  • 28268 QUEENS Court
    Warren, MI 48093

  • MLS #: 215086973

Property Details

Super Clean 3 Bedroom, 1.5 Bath Townhouse on a Basement with a Carport. ALL appliances included. BIG master bedroom. 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 »

3 Bedrooms

2.00 Bathrooms

1240 Square Feet

Brandon Schmidt

Real Estate Agent 6501311989
  • 43599 Schoenherr Rd
    Sterling Heights, MI 48313
  • 586-262-5124
  • 586-883-4459
Schedule a Showing Visit My Website

Biography

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!

Loading Agent Listings

Find out your monthly payments for this listing

Mortgage Calculator

How Much Can I Borrow?

How Much Can I Afford?

Loading Brochures

Select a school from the list below to view its contact information and statistics.

Type of school

Carter Middle School (Grades: 6 - 8)
Cousino Senior High School (Grades: 9 - 12)
Cromie Elementary School (Grades: PK - 5)
Crothers Elementary School (Grades: KG - 5)
Frontier International Academy Elementary (Grades: KG - 5)
Michigan Mathematics and Science Academy Elementary (Grades: KG - 5)
Rockwell Middle School (Grades: 6 - 8)
Westwood Elementary School (Grades: KG - 5)
Wilkerson Elementary School (Grades: PK - 5)
Briarwood Elementary School (Grades: KG - 5)
Pinewood Elementary School (Grades: KG - 5)
Warren Woods Enterprise HS (Grades: 9 - 12)
Warren Woods Middle School (Grades: 6 - 8)
Warren Woods Tower High School (Grades: 9 - 12)
Wilde Elementary School (Grades: PK - 5)
Beer Middle School (Grades: 6 - 8)
Conner Creek Academy East Michigan Collegiate (Grades: 7 - 12)
Green Acres Elementary School (Grades: PK - 5)
Lean Elementary School (Grades: PK - 5)
Macomb Math Science Technology Center (Grades: 9 - 12)
Middle School Mathematics Science Technology Center (Grades: 6 - 8)
Warren Mott High School (Grades: 9 - 12)
Academy 21 (Grades: 6 - 12)
Center Line High School (Grades: 9 - 12)
Rising Stars Academy (Grades: 12)
Wolfe Middle School (Grades: 6 - 8)
Black Elementary School (Grades: PK - 5)
Bozymowski Center (Grades: PK - 12)
Bruce Collins Elementary School (Grades: PK - 6)
Career Preparation Center (Grades: 10 - 12)
Carleton Middle School (Grades: 6 - 8)
Davis Junior High School (Grades: 7 - 9)
Heritage Junior High School (Grades: 7 - 9)
Huron Academy Grades K2 (Grades: PK - 12)
Maple Lane School (Grades: KG - 5)
Messmore Elementary School (Grades: PK - 6)
Oakbrook Elementary School (Grades: PK - 6)
Sterling Heights Senior HS (Grades: 9 - 12)
Willow Woods Elementary School (Grades: PK - 5)
Arts Academy in the Woods (Grades: 9 - 12)
Eisenhower Elementary School (Grades: PK - 6)
Fraser High School (Grades: 9 - 12)
Ralph Waldo Emerson Elem School (Grades: KG - 6)
Richards Middle School (Grades: 7 - 8)
Thomas A Edison Elem School (Grades: KG - 6)
Academy of Warren (Grades: KG - 8)
Keith Bovenschen School (Grades: PK - 12)
KENNEDY EARLY CHILDHOOD CENTER (Grades: PK)
LINCOLN ELEMENTARY SCHOOL (Grades: KG - 5)
Lincoln High School (Grades: 9 - 12)
Lincoln Middle School (Grades: 6 - 8)
Macomb Montessori Academy (Grades: PK - 8)
Marjorie Carlson Elementary School (Grades: PK - 5)
May V Peck Elementary School (Grades: KG - 5)
McKinley Elementary School (Grades: KG - 5)
School Age Child Care (Grades: PK)
Success Academy (Grades: 6 - 12)
Warren Woods Adult Education (Grades: 10 - 12)
Warren Woods Early Childhood Center (Grades: PK)
Warren Woods Education Center (Grades: 9 - 12)
Achievement High School (Grades: 10 - 12)
Conner Creek Academy East Elementary (Grades: PK - 6)
Dooley Center (Grades: PK - KG)
Dort Elementary School (Grades: PK - 5)
Eastland Middle School (Grades: 6 - 8)
Fountain Elementary School (Grades: KG - 5)
Global Preparatory Academy (Grades: PK - 6)
Huron Park Elementary School (Grades: PK - 5)
John R Kment Elementary School (Grades: KG - 5)
Joseph G Steenland Elementary School (Grades: KG - 5)
Kaiser Elementary School (Grades: PK - 5)
Lucile S Patton Elem School (Grades: KG - 5)
Mark Twain Elementary School (Grades: PK - 6)
Reach Charter Academy (Grades: KG - 8)
Roseville High School (Grades: 9 - 12)
Roseville Middle School (Grades: 6 - 8)
WAY Academy Roseville Site (Grades: M)
CL Home School Partnership (Grades: KG - 12)
Creative Learning Center Warren (Grades: 9 - 12)
Early Childhood Center (Grades: PK - KG)
Fitzgerald Early Childhood (Grades: PK)
Fitzgerald Senior High School (Grades: 9 - 12)
Fitzgerald Virtual Academy (Grades: 9 - 12)
Great Oaks Academy (Grades: KG - 8)
Mark C Roose Elementary School (Grades: KG - 5)
Mound Park Elementary School (Grades: KG - 5)
PD Chatterton Middle School (Grades: 6 - 8)
Schofield Elementary School (Grades: KG)
Siersma Elementary School (Grades: PK - 6)
Westview Elementary School (Grades: KG - 5)
Bellview Elementary School (Grades: 3 - 5)
Crescentwood Elementary School (Grades: PK - 2)
Eastpointe Alternative Center (Grades: 9 - 12)
Eastpointe Early Learning Center (Grades: PK)
Eastpointe High School (Grades: 9 - 12)
Eastpointe Middle School (Grades: 6 - 8)
Eastpointe Virtual Academy (Grades: 6 - 12)
Eaton Academy (Grades: KG - 8)
Forest Park Elementary School (Grades: KG - 2)
Koepsell Elementary School (Grades: PK - 5)
Pleasantview Elementary School (Grades: 3 - 5)
Angus Elementary School (Grades: KG - 5)
Frank Jeannette Jr High School (Grades: 7 - 9)
Grissom Middle School (Grades: 6 - 8)
Harwood Elementary School (Grades: PK - 5)
Holden Elementary School (Grades: PK - 6)
Jefferson Elementary School (Grades: PK - 5)
Noor International Academy (Grades: PK - 6)
Schuchard Elementary School (Grades: PK - 6)
Warren Consolidated Community High School (Grades: 6 - 12)
Warren Consolidated Early Childhood Program (Grades: PK - KG)
Information

Institution Name:

Phone:
Type:
NCES District ID:

Mailing Address:

District:
County:
NCES School ID: 263519007106

Student/Teacher Ratio
Student/Teacher Ratio
Characteristics
Locale :
Charter :
Total Teachers (FTE) :
Total Students :
Student/Teacher Ratio :
Enrollment by Grade

Students:

Grade Students

School Data Provided By NCES
This information is provided by a third party provider and may or may not reflect all schools in this area.
  • 90-100
  • 70-89
  • 50-69
  • 25-49
  • 0-24
  • Rider's Paradise World-class public transportation
  • Excellent Transit Transit is convenient for most trips
  • Good Transit Many nearby transportation options
  • Some Transit A few nearby transportation options
  • Minimal Transit It is possible to get on a bus
  • 90-100
  • 70-89
  • 50-69
  • 25-49
  • 0-24
  • Walker's Paradise Daily errands do not require a car
  • Very Walkable Most errands can be accomplished by foot
  • Good Transit Some errands can be accomplished by foot
  • Car-Dependent Most errands require car
  • Car-Dependent Almost all errands require car
  • 90-100
  • 70-89
  • 50-69
  • 0-49
  • Biker's Paradise Daily errands can be accomplished on a bike
  • Very Bikeable Biking is convenient for most trips
  • Bikeable Some bike infrastructure
  • Somewhat Bikeable Minimal bike infrastructure

Want to visit this property? Use this information to plan your trip. Check out local weather data.

High

:

Low

:

Precipitation

:

Humidity

:

Wind

:

Pressure

:

Warren, MI 48093

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)

By registering, you agree to our terms of use and that real estate professionals and lenders may call/text you about your inquiry, which may involve the use of automated means and prerecorded/artificial voices. You don't need to consent as a condition of buying any property, goods, or services. Message/data rates may apply.
28268 QUEENS Court Warren, MI 48093
Loading Footer