Listing provided courtesy of RE/MAX FirstMLS# 50207788MLS Provider
  • 46 days on site
  • 1 views

BEST LOCATION, FUNCTION & VALUE! Private COURT setting with one of the largest lots deep in the subdivision — NO HOA! Massive fenced 1/3RD ACRE LOT featuring sprinklers, storage shed, oversized heated/insulated 3.5-car side-loading garage w./insulated doors, pull-down attic storage, 75K BTU nat gas furnace, four 8' light fixtures, 2 openers & 3 remotes. Huge 8-car driveway — your own car show! Fully loaded contemporary split-level colonial: dramatic 16' two-story foyer with marble flooring, transom & side windows, bridge overlook, open great room design, soaring stone gas fireplace, recessed lighting, formal dining room, French doors, 2 skylights with retractable blinds, FFL with sink/special faucet, newer interior doors, & solid oak/wood features throughout. Hotel-sized primary ensuite with 18' vaulted ceiling, walk-in closet w./organizers, whirlpool tub, and separate shower w./seat & 3-stage faucet. Massive eat-in kitchen with abundant oak cabinetry, huge pantry closet, Jenn-Air range with downdraft/updraft venting, bayed door wall, easy access to laundry & half bath. Enjoy bug-free/shaded entertaining in THREE SEASON/FLORIDA room w./electric outlets & exterior awnings on the front and sides of the home. Large partially finished basement includes wet bar, office/flex room, storage, glass block windows, high-efficiency furnace, 2 upgraded water heaters, new sump pump with backup pump & wireless subscription alarm. Half bath prep already includes toilet and plumbing. Upper bedroom features walk-in closet and private access to adjacent bedrooms/full bath. Intercom, working radio system, whole-house alarm w./keypads & siren. Conveniently located minutes from I-94 & M-59 w./ quick access to shopping, dining, entertainment, downtown Detroit, Rochester & Port Huron. Expect significant activity. ATTENTION AGENTS: See MLS Agent Remarks for more details and offer instructions. BUYERS & AGENTS: LOOK, BUT DO NOT TOUCH THE CARS. Children must remain with an adult at all times.

Source: Great Lakes Repository, MLS#: 50207788

Love this property?
Create a profile so you can receive updates on this property as soon as they happen!
  • Property Type
    Residential
  • Lot
    0.29 acres

Get in Contact

Would you like to know more about this property? We're here to help! Let's connect and find what you're looking for.

Steve Mann

Create a profile so you can receive updates on this property as soon as they happen!

Owning this Home

$
$ %
%
* All calculations are estimates and provided by Reliance Network, for informational purposes only. Actual amounts may vary. ** Assumes 6.50% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information. Any mortgage broker or insurance agent that may appear is independent and is not affiliated with, endorsed by, or provided by the MLS.

Life at 47799 Farmbrook Court


Schools


School data courtesy of LiveBy, Inc.
Ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating. The schools displayed on this website are for informational purposes only and may not represent a complete or up-to-date list. School assignments are subject to change and should be verified directly with the local school district. Please contact the appropriate school district to confirm school zoning and enrollment eligibility for this property.

History

Date Event Value Agent
6/9/2026Source: Great Lakes Repository Status Change
Pending
6/9/2026Source: Great Lakes Repository Status Change
Pending
5/22/2026Source: Great Lakes Repository Status Change
Accepting Backup Offers
5/22/2026Source: Great Lakes Repository Status Change
Accepting Backup Offers
5/20/2026Source: Great Lakes Repository Added to Database
May 20, 2026
5/15/2026Source: Great Lakes Repository Added to Database
May 15, 2026