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

50-15 39th Street
Sunnyside, NY 11104
Jaroslaw Kaszuba with Exit All Seasons Realty, original listing - (718) 345-4545

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $299,000
Beds: --
Baths: Full: 1
Status: Active
SqFt: 500 Square Feet
Agency: Exit All Seasons Realty
Agency Phone: (718) 345-4545

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Stock Cooperative
Year Built: 1960
Notes: Say Goodbye To Renting & Unleash Your Imagination To Customize Your PERFECT APARTMENT. This Second Floor Co-Op Is A Large Studio (Approximately 500 Sq Ft) That Has Been Converted To A One Bedroom. Still Spacious And Bright, It Features Separate Bedroom, Full Size Open Kitchen With Granite Countertops & A DISHWASHER, Modern Bathroom With A New Shower System & An Extra Electric Ventilation For Humidity Control. Nicely Sized Living Room Is Filled With Plenty Of Natural Light Because Of The Oversized Triple Window That Opens To A Quiet Street. In Addition, There Are TWO CLOSETS To Accommodate Your Storage Needs, New Wall Unit AC & HARDWOOD FLOORS Throughout For The Feel Of Warmth & Value. It Is Situated In A Very Well Maintained Building With An IMPRESSIVE ROOF TERRACE, BIKE ROOM & 24/7 LAUNDRY ROOM. LOW MONTHLY MAINTENANCE Of $606 ALREADY INCLUDES HEAT, HOT WATER & COOKING GAS. SUBLETTING Is Permitted After 5 Years & Smaller Size Pets Are Allowed. There Is Plenty Of Street Parking But You Don't Have To Drive Because There Are Many Public Transportation Options (Multiple Bus Lines & 7 Train) For A Quick & Easy Access To Manhattan, LIC & Greenpoint. Don't Miss Your Chance Because This Apartment And Various Local Amenities Including Restaurants & Coffee Shops Are Really Easy to Love.
MlsNumber: --
ListingId: 488517


Listing Provided By: Exit All Seasons Realty, original listing
Phone: (718) 345-4545
Office Phone: (718) 345-4545
Agent Name: Jaroslaw Kaszuba
Disclaimer: Copyright © 2025 Brooklyn New York Multiple Listing Service. 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