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 = 1863 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 = 1863 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 = 1863 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;

108-18 Pinegrove Street
Jamaica, NY 11435

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,325,000
Beds: 6
Baths: 5
Status: Active
SqFt: --
Agency: Keystone Realty USA

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: MultiFamily
Year Built: 2023
Notes: 108-18 Pinegrove Street is a BRAND NEW CONSTRUCTION, CUSTOM BUILT Brick 2 family that will captivate you from the moment you arrive with its warm & welcoming energy from the moment you arrive. Featuring a wide private driveway, and is the perfect opportunity for buyers looking for space, plus income generating rental property to assist with mortgage payments. Offering a 3 bedroom 2 bath rental unit which has the ability to generate $3,500/month to assist with mortgage payments. The First floor is also configured as 3 bedroom 2 bath unit and can easily be used as a duplex with the high ceiling full finished to create additional living/recreational space. Both units enjoy expansive sun drenched modern, open concept living/dining areas which provide great space for entertaining. Beautiful chefs granite kitchens equipped with floor to ceiling custom cabinetry & adorned with a full fleet of stainless steel appliances. Spacious bedrooms with ample closet space. Primary suite equipped with a private en suite. Fully tiled bathrooms that boast state of the art wall & floor tiles and much more! Must see to appreciate. Additionally, the fully tiled basement is fully finished with tile floors, has an additional full bathroom and has both interior and exterior access. 108-12 Pinegrove Street is conveniently located with close proximity to major transportation which makes commuting a breeze. Just off Lakewood Avenue, Van Wyck Expressway, Liberty Avenue. Stones throw to LIRR Jamaica Station, Jamaica Air Train Station, schools, shopping centers, restaurants, cafes, parks, JFK Airport and Airport Hotels. Additional Pictures Coming Soon
MlsNumber: 3534701


Listing Provided By: Keystone Realty USA, original listing
Name: Keystone Realty USA
Phone: (631) 486-1126
Office Name: Keystone Realty USA Corp
Office Phone: (631) 261-2800
Agent Name: Gabriel Kashi
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