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','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 = 3377 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 = 3377 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;

14715 73 Ave
Flushing, NY 11367

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,299,000
Beds: 5
Baths: 4
Status: Active
SqFt: --
Agency: WINZONE REALTY INC.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1950
Notes: Beautiful, Fully Gut Renovated House From Outside to Inside. This Home Provides the Perfect living environment with over 3228 Square Feet of living space, custom painted walls, Central AC, new hardwood floors and crown moldings throughout. The Sun Drenched First Floor boasts a spacious foyer with Radiant flooring, Extra Large Living Room With Cristal Shandeliers, Beautifull Hardwood Floors, Dining Room Leading to A Porch and To the Back Yard.. Extra Large Eat-In Kitchen With Custom-made Cabintes, Subzero Refrigerator, 2 Sinks, Granite Countertops and Dishwasher, Heated Floors, Plus 2 Cristal Shandeliers. Custom Staircase leading to the Second Floor, Has a Large MasterBedroom With Master bathroom, and a Balcony. 3 More Bedrooms and a Full Bath with One Shower and One bathtub, in the Hallway. Third Floor Has a Spacious Room. Full, Finished Basement with Marble Tiles on the Floor, Laundry Room, Boiler Room and a Full Bath. Gated Driveway for 2 Cars. Large Backyard. FULLY detached House in Prime Location. Off Main Street. Close to Many Good Schools and Houses of Worship, and Many Good Restaurants and Supermarkets and Shops. Close to public Transportaion and Bus Stops.
MlsNumber: 3533681


Listing Provided By: WINZONE REALTY INC., original listing
Name: WINZONE REALTY INC.
Phone: (HOM) ES3-68GM xAILCOM
Office Name: Winzone Realty Inc
Office Phone: (HOM) ES3-68GM xAILCOM
Agent Name: Rita Mahgerefteh
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