Title Page Background
DEBUG FN args: Array ( [0] => 3460 [1] => [2] => [3] => agent ) BEFORE: Site: 3460 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3460 Igate: njhud LocID: 3460 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 = 3460 AND i.igate IN ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3460 [1] => [2] => [3] => lender ) BEFORE: Site: 3460 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3460 Igate: njhud LocID: 3460 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 = 3460 AND i.igate IN ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3460 [1] => [2] => [3] => other ) BEFORE: Site: 3460 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3460 Igate: njhud LocID: 3460 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 = 3460 AND i.igate IN ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

680 Pear Tree
Grosse Pointe Woods, MI 48236

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,175,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4811 Square Feet
Agency: Real Estate One Grosse Pointe
Agency Phone: (313) 886-1000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1959
Notes: Grosse Pointe Woods living at its finest. Completely remodeled in 2014. Updated equipment includes electrical, PEX plumbing, 75 gal hot water heater, 2 HVAC systems, 2 remote internet controlled thermostats, vinyl siding, leaf filter and SimpliSafe alarm system. Entire home was insulated with spray foam. LED soffit lighting. Casement windows. This one-of-kind 5 bedroom 4 full baths with finished basement which includes full bath, separate shower and jacuzzi tub is being offered at $1,175,000. Walk through the leaded glass double doors into 2 story foyer with marble floors. You will notice the 10 ft. ceilings on main floor and crown molding throughout. Large formal living room and dining room to the right. Walk past full bath and stairs to huge open floor plan, where the kitchen over looks the family room featuring double sided gas fireplace, shared with den. The wet bar with wine frig and sunroom with custom book shelves and gas fireplace are adjacent to the family room. Kitchen has beautiful granite countertops, under cabinet lighting, 2 sinks, 5 burner gas cooktop, double oven, under counter microwave, large double door smart refrigerator, walk-in pantry and amble cabinet space. Island seating for 6. Off the family room are double French doors leading to large den/office with beautiful wall unit, hardwood floors and granite surround gas fireplace. Coming in from 2 car garage, equipped with 220 watt hookup for EV or RV and hose bib, is a 4 cubby with under cabinet storage mudroom, large coat closet and separate cleaning utensil closet. Moving upstairs you will find big bonus room / bedroom with 2 double folding door closets, 2 good size bedrooms with walk-in closets and jack & jill full bathroom. Next is the mother-in-law suite with full bathroom. Owner’s suite has huge walk-in closet, big shower with 2 shower heads & 2 sets of body sprays, double sinks, sitting make-up area and jetted tub. Outside, the backyard features a beautifully two tone stained deck & privacy screen off the sunroom. Step down to concrete patio to grill and / or sit at the cute bistro set. Outfront the driveway, and front porch were newly poured in 2019. Schools, churches, equestrian events, summer camps and the lake are just a short 10 minute walk away. Access to the Grosse Pointe Woods park, swimming pool, putt-putt, pickle ball, tennis, walking trails and workout facilities are an added PLUS. At 4,811 sf this is tremendous value at under $250 per sqft. Compare to the home listed for $1.9M in the Deeplands Development just 3 city blocks away.
MlsNumber: --
ListingId: 50149637


Listing Provided By: Real Estate One Grosse Pointe, original listing
Phone: (313) 319-5679
Office Phone: (313) 886-1000
Agent Name: Mary Aubrey-Rogers
Disclaimer: Copyright © 2024 Multiple Listing Service MiRealSource. 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