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;

7018 34 Avenue
Jackson Heights, NY 11372
Christos Lolis with EAST COAST NEW YORK INC, original listing - (718) 428-2900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,350,000
Beds: --
Baths: Full: 6
Status: Active
SqFt: 4740 Square Feet
Agency: EAST COAST NEW YORK INC
Agency Phone: (917) 974-0992

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Commercial Sale-Other
Year Built: 1928
Notes: Get yourself a very well-priced, prime investment opportunity. Introducing a multifamily building located in the heart of Jackson heights, Queens, located In school district 30. This multifamily is just one block off Northern Boulevard, about 2 blocks from the M&R train, close to multiple bus stops, right across from a school, and right off I-278. Enjoy access to Citi bike right outside of the property and just down the corner is a bowling alley. Local shops, supermarkets, banks, and stores are within close walking distance! The building is in prime condition and upkept well. A new boiler was installed in 2017 and a new water heater was installed last year. All apartments are in good shape, consisting of three one-bedroom apartments, and three two-bedroom apartments. The front side apartments are one bedroom and on the back side of the building are the two-bedroom units. Make your investment dreams come true! THE INFORMATION CONTAINED HEREIN HAS EITHER BEEN GIVEN TO US BY THE OWNER OF THE PROPERTY OR OBTAINED FROM SOURCES THAT WE DEEM RELIABLE. WE HAVE NO REASON TO DOUBT ITS ACCURACY BUT WE DO NOT GUARANTEE THE ACCURACY OF ANY INFORMATION PROVIDED HEREIN. AS AN EXAMPLE, ALL ZONING INFORMATION, BUILDABLE FOOTAGE ESTIMATES AND INDICATED USES MUST BE INDEPENDENTLY VERIFIED
MlsNumber: --
ListingId: 11362564


Listing Provided By: EAST COAST NEW YORK INC, original listing
Phone: (917) 974-0992
Office Phone: (718) 428-2900
Agent Name: Christos Lolis
Disclaimer: Copyright © 2024 My State 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