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

150-40 114th Place
South Ozone Park, NY 11420

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $999,888
Beds: 3
Baths: 3
Status: Active
SqFt: --
Agency: Keller Williams Realty Liberty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: MultiFamily
Year Built: 1950
Notes: Welcome to your dream home! Nestled in a sought-after neighborhood, this exceptional brick and vinyl two-family property epitomizes comfort, style, and convenience. Boasting a total of 3 bedrooms and 3 full baths, each unit offers spacious living areas, updated kitchens featuring granite countertops, and elegant dining rooms, perfect for hosting gatherings and creating lasting memories. Descend into the finished basement retreat, where convenience meets functionality. Complete with laundry facilities, a mechanics room, and a separate entrance, this versatile space adds both value and flexibility to your lifestyle. Step inside and be greeted by the warmth of hardwood floors throughout, complemented by custom Anderson windows that flood the interiors with natural light. Say goodbye to high energy bills, thanks to the added benefit of solar panels, ensuring efficient and sustainable living year-round. Park with ease in the detached single-car garage and private driveway, providing ample space for multiple vehicles. Enjoy the convenience of nearby amenities, including proximity to JFK airport, a vibrant resort casino, public transportation hubs, and major highways, simplifying your daily commute and weekend adventures. Embrace a lifestyle of comfort and convenience, with shops, entertainment venues, restaurants, and all necessities just moments away. Find solace in nearby houses of worship, unwind in local parks, and explore the endless possibilities this thriving community has to offer. Whether you're a first-time buyer looking to build equity or an investor seeking a lucrative opportunity, this property is your gateway to both homeownership and financial prosperity. Don't miss out on this rare chance to own a piece of paradise.
MlsNumber: 3545635


Listing Provided By: Keller Williams Realty Liberty, original listing
Name: Keller Williams Realty Liberty
Phone: (718) 848-4700
Office Name: Keller Williams Realty Liberty
Office Phone: (718) 848-4700
Agent Name: Chatter Singh
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