Share

  • Price: $140,000

  • 5304 LYONS Circle S
    Warren, MI 48092

  • MLS #: 215113714

Property Details

Magnificent North Warren Ranch. Designer Granite Kitchen with Rich Cabinetry, Stone Backsplash & Walk-in Pantry. High End Plumbing Fixtures & Custom Tile Work. Contemporary Bathrooms with wainscoting. Custom Trim, Crown Moldings & Columns that will blow you away! Large Living Room with Fireplace & Gleaming Hardwood Floors. Finished Basement with workshop. Completely updated from top to bottom! Large 2.5 Car Garage & a HUGE Fenced Yard with Gorgeous Landscaping and Large Deck. Truly a MUST SEE! Details »

3 Bedrooms

2.00 Bathrooms

1100 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?

To email this brochure, please fill out the appropriate fields below. When done, simply click the "SEND" button.

Email Brochure Form


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.

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

Type of school

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)
Edmonson Elementary School (Grades: PK - 5)
Four Corners Montessori Academy (Grades: PK - 8)
Hiller Elementary School (Grades: KG - 5)
Keys Grace Academy (Grades: KG - 12)
Lamphere Center (Grades: 5 - 12)
Lamphere Early Childhood Center (Grades: PK)
Lamphere High School (Grades: 9 - 12)
Lessenger Elementary School (Grades: PK - 5)
Madison District Early Childhood Education Center (Grades: PK)
Madison Elementary School (Grades: PK - 5)
Madison High School (Grades: 9 - 12)
Madison Preparatory High School (Grades: 9 - 12)
Madison Virtual Academy (Grades: KG - 12)
Page Middle School (Grades: 6 - 8)
Simonds Elementary School (Grades: PK - 5)
Wilkinson Middle School (Grades: 6 - 8)
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)
Academy 21 (Grades: 6 - 12)
Center Line High School (Grades: 9 - 12)
Rising Stars Academy (Grades: 12)
Wolfe Middle School (Grades: 6 - 8)
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)
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)
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)
Advantage Alternative Program (Grades: KG - 12)
Hazel Park ACCESS Alternative School (Grades: 9 - 12)
Hazel Park Adult Education (Grades: 9 - 12)
Hazel Park ESL 9 Mile (Grades: 9 - 12)
Hazel Park High School (Grades: 9 - 12)
Hazel Park Junior High School (Grades: 6 - 8)
Hazel Park Training Facility (Grades: 9 - 12)
Hazel Park Training Facility II (Grades: 9 - 12)
Hoover Elementary School (Grades: PK - 5)
Invest Roosevelt Alternative High School (Grades: 9 - 12)
Michigan Cyber Academy (Grades: 9 - 12)
Momentum Academy (Grades: PK - 9)
SER YouthBuild High School Academy (Grades: 9 - 12)
United Oaks Elementary School (Grades: KG - 5)
Viking Virtual Academy (Grades: 9 - 12)
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)
Keller Elementary (Grades: PK - 5)
Oakland Elementary School (Grades: KG - 5)
Royal Oak Middle School (Grades: 6 - 8)
Baker Middle School (Grades: 6 - 8)
Barnard Elementary School (Grades: KG - 5)
Morse Elementary School (Grades: PK - 5)
Susick Elementary School (Grades: PK - 5)
Troy Center for Transition (Grades: 9 - 12)
Wattles Elementary School (Grades: KG - 5)
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)
Baker School (Grades: PK)
Clawson High School (Grades: 9 - 12)
Clawson Middle School (Grades: 6 - 8)
Kenwood Elementary School (Grades: PK - 5)
Paul A Schalm School (Grades: KG - 5)
Information

Institution Name:
Beer Middle School

Phone: (586)574-3175
Type: Regular school
NCES District ID: 2635190

Mailing Address:
3200 Martin RdWarren, MI 48092

District: Warren Consolidated Schools
County:
NCES School ID: 263519007107

Student/Teacher Ratio
Characteristics
Locale : City, Midsize (12)
Charter : no
Total Teachers (FTE) : 36.60
Total Students : 705
Student/Teacher Ratio : 19.3
Enrollment by Grade

Students: 06 - 08

Grade Students
6th209
7th222
8th274

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 48092

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.
5304 LYONS Circle S Warren, MI 48092
Share this listing with a friend!
English | Español


Powered by CORE ListingMachine 2025