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 = 3243 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 3243 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 3243 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

99-07 70 Avenue
Forest Hills, NY 11375

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,998,000
Beds: 6
Baths: Full: 3, ½: 1
Status: Active
SqFt: --
Agency: Keller Williams Realty Greater
Agency Phone: (516) 873-7100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1925
Notes: Welcome to 9907 70th Ave, nestled in the heart of Forest Hills, cross street from Forest Hills Garden, This detached colonial offering a prime location and a spacious layout ideal for modern living with 6 bedrooms and 3 full baths and 1 half bath. This lovely home boasts a thoughtfully designed floor plan spanning across three floors, presenting ample space for relaxation, entertainment, and work. As you step into the inviting foyer, you're greeted by a warm and cozy living room, complete with a wood-burning fireplace - perfect for those chilly evenings. Hardwood floors throughout and plenty of closets. Adjacent to the living room is a bright and airy formal dining room, seamlessly connected to the modern kitchen featuring sleek cabinetry, granite countertops, and stainless-steel appliances. The first floor also offers a versatile room that can be utilized as an office, den, or guest bedroom, along with a convenient half bathroom. Venture upstairs to discover three spacious bedrooms and a full bathroom on the second floor, offering comfort and privacy for family members or guests. The third-floor features two additional bedrooms and another full bathroom, providing ample space and versatility. The lower level of the home presents a spacious basement family room - perfect for movie nights or recreational activities - along with a full bathroom for added comfort. A private garden offers a serene retreat for outdoor entertaining or simply relaxing amidst lush greenery. Driveway provides convenient parking options. Conveniently located short of distance to shopping and restaurants around Austin Street, zoned for PS144 and Russel Sage Middle School. Commute To Midtown Manhattan in 20 minutes Via The Express E/F/M/R Subway And Less Than 15 Minutes Via The LIRR. Recreation Nearby with Parks, Hiking Trails, Horseback Riding, And Golfing in Forest Park. This home offers the perfect combination of luxury living and urban convenience. Don't miss your chance to make this Forest Hills gem your own!
MlsNumber: --
ListingId: 3552199


Listing Provided By: Keller Williams Realty Greater, original listing
Phone: (516) 873-7100
Office Phone: (516) 873-7100
Agent Name: Michele Cheng
Disclaimer: Copyright © 2024 OneKey MLS. 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