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;

1830 Linden Street
Ridgewood, NY 11385
Michelle J. Zhang with RE/MAX Edge, original listing - (718) 612-3088

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,400,000
Beds: 6
Baths: Full: 3, ¾: 2
Status: Active
SqFt: 3000 Square Feet
Agency: RE/MAX Edge
Agency Phone: (718) 612-3088

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1,250 sqft
Property Type: Residential-Single Family Attached
Year Built: 1999
Notes: Once upon a time, in the vibrant neighborhood of Ridgewood, New York, a beautiful home This legal two-family dwelling was a sight to behold, built in 1999 and spanning three stories, including a private car garage that offered convenient parking spaces. The house stood proudly, measuring 25 feet in width and 50 feet in depth, with each floor extending to a spacious 25 feet by 53 feet. Entering through the delightful front door, you would find yourself in a welcoming and well-designed foyer, leading to two comfortable rooms and the attached garage. The first floor of this magnificent house boasted three spacious rooms, including a cozy living room, and was complemented by one and a half bathrooms. It provided ample space for a growing family or an opportunity for rental income. Continuing to the second floor, you would discover another set of three well-appointed rooms, along with a gracious living room and one and a half bathrooms. The layout was perfect for accommodating a large family or offering additional rental units. The location of this enchanting property turned out to be a dream for those who valued connectivity and recreational opportunities. Situated near the M subway station and accessible bus route B13, commuting was convenient and hassle-free. For those who enjoyed outdoor activities, the nearby Forest Park Golf Course provided a serene escape. In total, the house offered eight bedrooms and five baths, ensuring enough space for comfort and privacy. Moreover, the heating system had been separated into two sets, allowing for independent temperature control and optimal energy efficiency. The house stood as a vibrant symbol of opportunity and a place where dreams could be realized.
MlsNumber: --
ListingId: 478287


Listing Provided By: RE/MAX Edge, original listing
Phone: (718) 612-3088
Office Phone: (718) 612-3088
Agent Name: Michelle J. Zhang
Disclaimer: Copyright © 2024 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