3717 Newcastle Dr.
Rochester Hills, MI 48306
- 4 beds
- 4.2 baths
- 4,258 sqft
- 13,068 sqft lot
- $185 per sqft
- 1993 build
- – on site
More homes
*All offers to be submitted by noon May 1, 2023* A rare opportunity to live on a desirable wooded lot in the highly coveted sub of Hawthorn Hills. Close to Adams High School & the Village. This custom built Lubin/Tringali home will immediately capture your heart with its impeccable curb appeal. From the custom stone work entry, to the peaceful wooded back yard giving you vibes of being up north to the meticulously manicured lawn, pride in ownership at its absolute best. Enter lg. front door to spacious foyer. Immediate warmth & joy greet you in this home designed for creating memories. Floor to ceiling windows throughout the main level allow for warmth of daylight sun to brighten your space and spirits. Work from home office is a mill work masterpiece of rich wood, custom built-ins and lighting. Formal dining allows everyone to have a spot at the table. Living room offers flexibility for second in home office or lounging. Trim and millwork are front and center throughout the entire home. Double and triple crown molding, wainscoting, judges paneling, cross beams and built in shelving. New central vacuum system. Cathedral ceiling in the family room with double sided fireplace & windows offers endless views of the wooded backyard.The kitchen is the heart of the home with an extensive 5X7 granite island, eat in kitchen and double sided fireplace. Slip out the sliding glass door to the lg deck to enjoy the sweet sounds of nature on perfect summer nights. Plenty of storage in custom closets with shelving. Upper level Primary bdrm with pan ceiling, lg. windows, vanity, 2 walk in closets, jetted tub & shower. 2 additional bedrooms share J&J bath & an ensuite for guests or the one who drew the longest straw. Endless instagram moments in the lower level walk out. Get ready to party on the custom dance floor surrounded by professional lighting, bose speakers, fog machine & D.J booth. Full bathroom, bar area for entertaining & natural fireplace.
Listing courtesy of REALCOMP / Keller Williams Realty Lakeside
Last checked:
Checking…
•
Last updated Oct 30, 2024
•
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
MLS# 58050106968 —
The Building
-
Year Built:1993
-
Construction Materials:Brick, Block/Concrete/Masonry
-
Architectural Style:Colonial
-
Foundation:Brick/Mortar
-
Foundation Features:Sump Pump
-
Foundation Details:Basement
-
Features:Electricity, Attached
-
Porch Type:Deck, Breezeway
-
Stories:2 Story
Interior
-
Features:Other, Central Vacuum, High Spd Internet Avail, Humidifier, Jetted Tub, Wet Bar
-
Room Count:18
-
Lower Floor:1,972 Sqft
-
Basement:Yes
-
Basement Type:Partially Finished, Walkout Access
-
Fireplace:Yes
-
Fireplace Locations:Basement, Great Room
-
Total:4,258 Sqft
-
Total Combined:6,230 Sqft
-
Total Basement:2,244 Sqft
Financial & Terms
-
Land Contract:No
-
Short Sale:No
Location
-
Directions From East West Detail:/ West of Adams Rd.
-
Directions From North South Detail:South of Dutton Rd.
The Property
-
Property Type:Residential
-
Parcel Number:1506151040
-
Homestead:Yes
-
Lot Features:Wooded, Sprinkler(s)
-
Lot Size Dimensions:118x145x82x130
-
Lot Size Area:0.30
-
Waterfront:No
Listing Agent
- Contact info:
- Agent phone:
- (248) 943-7876
- Office phone:
- (586) 532-0500
Taxes
-
Total Taxes:$7,441
-
Taxable Value:299500.0000
-
Tax Amount Summer:$3,665
-
Tax Amount Winter:$3,776
Beds
-
Beds Total:4
Baths
-
Total Baths:4.20
-
Full Baths:4
-
Half Baths:2
Heating & Cooling
-
Cooling:Ceiling Fan(s), Central Air
-
Heating:Forced Air
-
Heating Fuel:Natural Gas
-
Fireplace Fuel:Gas, Natural
Utilities
-
Sewer:Public Sewer (Sewer-Sanitary), Sewer at Street
-
Water Source:Public (Municipal)
-
Water Heater Fuel:Natural Gas
Appliances
-
Kitchen:Dishwasher, Microwave, Oven, Range/Stove, Refrigerator, Washer
Schools
-
School District:Rochester
The Community
-
Subdivision Name:Hawthorn Hills 7
-
Pets Allowed:Call
-
Association Fee:1
-
Association Fee Paid:Annually
-
Association Fee Includes:Maintenance Grounds
Parking
-
Garage:Yes
-
Garage Size:3 Car
-
MF Parking:Garages
Extra Units
-
Other Buildings:Garage
IDX provided courtesy of Realcomp II Ltd., via Estately and MiRealSource, © 2024 Realcomp II Ltd. Shareholders
Keller Williams Realty Lakeside
Estately Inc. is a Michigan licensed brokerage #6505374810, managed by Michigan licensed REALTOR® broker Darren Yearsley #6505374810.
IDX information is provided exclusively for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
IDX provided courtesy of Realcomp II Ltd. via Estately Inc. and REALCOMP. ©2024 Realcomp II Ltd. Shareholders.
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
6/2/23
Jun 2, 2023
|
Sold | REALCOMP | $790,000 | 4.1% |
5/3/23
May 3, 2023
|
Pending | REALCOMP | $759,000 | |
4/27/23
Apr 27, 2023
|
Listed / Active | REALCOMP | $759,000 |