Title Page Background
HFQUERY 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 = 3462 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 3462 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 3462 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

1117 Royal Avenue
Royal Oak, MI 48073

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $975,000
Beds: 4
Baths: 4
Status: Active
SqFt: 3254
Agency: Fowler Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2022
Notes: STUNNING NEW CUSTOM BUILT CRAFTSMAN STYLE home in sought-after VINSETTA Royal Oak neighborhood! Hand-selected builder finishes are of the highest quality materials and craftsmanship combined with thoughtful and functional design. Modern floor plan allows for open concept social living on first floor with private study. Perfection is what you will find in this four bedroom, 3 1/2 bath, 3105 square-foot home. This new construction house boasts a three car garage, maintenance free exterior, Marvin windows, 9 foot basement and 9 foot ceilings on the first floor. 2nd floor laundry with additional option of downstairs laundry as well. Basement is prepped for future bar and bathroom. Built to have a smaller carbon footprint, and energy efficiency in mind, also see builder's attached addendum of additional features Huge attached garage has room for 3 cars, adjacent mudroom off garage with built-in lockers/benches plus large coat closet. Large front foyer with built-in coat storage. Kitchen features a large island, solid wood cabinetry with quartzite counters, KITCHEN AID appliances and walk-in pantry, LED lighting throughout. Great room with gas fireplace and Private master bedroom boasts 9’ ceilings, dual walk-in closets & amp; attached bath with slate floors, large trough sink, walk-in shower with dual shower heads, and linen closet. Hallway with lots of storage leads to two additional bedrooms with spacious closets and a jack and jill bath. A second full bath with granite counters, graphic tile floor, and shower surround. Convenient 2nd floor laundry with Frigidaire front-load washer/dryer, and overhead storage. Hardwood floors throughout, solid wood trim, 9’ceilings with 8’ solid core doors
MlsNumber: 20240017580


Listing Provided By: Fowler Real Estate, original listing
Name: Fowler Real Estate
Phone: (248) 589-2100
Office Name: Fowler Real Estate
Office Phone: (248) 589-2100
Agent Name: Calvert S Fowler
Disclaimer: Copyright © 2024 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