Title Page Background
DEBUG FN args: Array ( [0] => 3464 [1] => [2] => [3] => agent ) BEFORE: Site: 3464 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3464 Igate: njhud LocID: 3464 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3464 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3464 [1] => [2] => [3] => lender ) BEFORE: Site: 3464 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3464 Igate: njhud LocID: 3464 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3464 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3464 [1] => [2] => [3] => other ) BEFORE: Site: 3464 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3464 Igate: njhud LocID: 3464 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3464 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

22471 Montebello
Novi, MI 48375
Jamey Kramer with RE/MAX Classic, original listing - (248) 348-3000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,300,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active Under Contract
SqFt: 3049 Square Feet
Agency: RE/MAX Classic
Agency Phone: (248) 348-3000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: STUNNING 5 BEDROOM COLONIAL IN NOVI'S EXCLUSIVE MONTEBELLO ESTATES WITH AWARD WINNING NORTHVILLE SCHOOLS! THIS NEARLY BRAND NEW (2022 BUILD) HOME IS SITUATED ON A SEMI-PRIVATE TREED LOT WITH BEAUTIFUL PROFESSIONAL LANDSCAPING, OUTDOOR FOUNTAIN AND AN ENTRY WITH A COVERED PORCH. UPGRADED 8' DOUBLE GLASS DOORS WELCOME YOU INTO THE 2 STORY FOYER. HARDWOOD FLOORS AND UPGRADED LIGHTING THROUGHOUT MOST OF MAIN LEVEL. IMPECCABLY DECORATED AND FILLED WITH HIGH END FINISHES. 1ST FLOOR LIBRARY PERFECT FOR WORKING FROM HOME. FORMAL LIVING ROOM WITH CROWN MOLDING. GREAT ROOM WITH SOARING CEILING, 2 STORY SHIPLAP AND TRAVERTINE GAS FIREPLACE, ELECTRIC BLINDS AND WALL OF WINDOWS FOR TONS OF NATURAL LIGHT. GOURMET KITCHEN BOASTS QUARTZ COUNTERS, SS APPLIANCES, GAS COOKTOP, UPGRADED RANGE HOOD, SOFT CLOSE CABINETS WITH UNDER CABINET LIGHTING, CENTER ISLAND AND PANTRY. BREAKFAST NOOK WITH DOOR WALL TO DECK. 1ST FLOOR LAUNDRY RM WITH UPGRADED CABINETS/COUNTERTOPS. UPSTAIRS YOU'LL FIND THE SPACIOUS PRIMARY SUITE THAT FEATURES CALIFORNIA CLOSET SYSTEM AND EN SUITE BATH WITH SOAKING TUB, DUAL SINKS AND SEPARATE SHOWER. 3 ADDITIONAL BEDROOMS UPSTAIRS WITH 2 FULL BATHS. CUSTOM BLINDS WITH BLACKOUT SHADES IN ALL BEDROOMS AND UPGRADED RECESSED LIGHTING ON 2ND FLOOR THAT DOUBLE AS NIGHT LIGHTS. GORGEOUS FINISHED LOWER LEVEL IS AN ENTERTAINER'S DREAM OFFERING A WET BAR WITH SEATING, WINE ROOM, REC AREA WITH ELECTRIC FIREPLACE AND BUILT-INS CONCEALING A HIDDEN WORKOUT ROOM (OR PANIC ROOM). LOWER LEVEL ALSO FEATURES AN IN-LAW SUITE WITH AN EGRESS WINDOW AND LUXURIOUS FULL BATH. GENERAC GENERATOR AND RADON MITIGATION SYSTEM. ENJOY THE BEAUTIFUL BACKYARD FROM THE CUSTOM DECK. NEIGHBORHOOD OFFERS TENNIS COURTS, SIDEWALKS AND NATURE TRAIL WITH GAZEBO. GREAT LOCATION CLOSE TO SHOPPING, RESTAURANTS AND EXPRESSWAYS.
MlsNumber: --
ListingId: 20250036595


Listing Provided By: RE/MAX Classic, original listing
Phone: (248) 348-7200
Office Phone: (248) 348-3000
Agent Name: Jamey Kramer
Disclaimer: Copyright © 2025 Realcomp Limited II. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App