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

163-47 19th Avenue
Whitestone, NY 11357
Lorraine DiGregorio with COZY CORNER REALTY LLC, original listing - (917) 923-4038

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,399,000
Beds: 3
Baths: Full: 1, ½: 2
Status: Active
SqFt: 1728 Square Feet
Agency: COZY CORNER REALTY LLC
Agency Phone: (917) 923-4038

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1960
Notes: First time on the market is this beautiful, spacious single family, 3 bedroom house in the wonderful neighborhood of Whitestone. Has large, open space living room and dining room. Kitchen has an island for convenience and gathering plus lots of cabinet space. For convenience the first floor has a half bath. The house has hardwood floors throughout with a beautiful wooden staircase and custom railing up to the second floor. There are 3 large bedrooms and each has their own large closet space. Upstairs is 1 full bathroom. This house has both a full-size attic for storage and a full, unfinished basement. The basement can be used for storage or decorated for family use and there is a side entrance into the basement from the outside. There is a detached garage and long driveway. There are 2 central air conditioning units - 1 for the first floor and basement. The second covers the 2nd floor and attic. Outside there is a sprinkler system that covers the front yard, backyard and flower bed. Transportation into the city is close-by. The express bus in steps away from the house. Shopping centers, restaurants, parks and the Clearview Golf Course are all nearby. LaGuardia airport is 12 minutes away and Cross Island Pkwy, Clearview & Whitestone Expressways are nearby. The house is right off of Frances Lewis Blvd. Shopping centers include Bay Terrace, Whitestone Village and Whitestone Plaza. Elementary, middle and high schools are conveniently close by. Lot size: 41x97 sq. ft. / Building size: 26x33 sq. ft.
MlsNumber: --
ListingId: 11498891


Listing Provided By: COZY CORNER REALTY LLC, original listing
Phone: (917) 923-4038
Office Phone: (917) 923-4038
Agent Name: Lorraine DiGregorio
Disclaimer: Copyright © 2025 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