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 = 3391 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 = 3391 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 = 3391 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;

135 5th Avenue
Brooklyn, NY 11217

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,900,000
Beds: --
Baths: --
Status: Active
SqFt: 4800
Agency: RE/MAX Real Estate Professiona

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1,600 sqft
Property Type: Other
Year Built: 1920
Notes: Welcome to your Once in a Lifetime Dream Investment Opening... Discover this Rare Opportunity to Own a Vacant Massive High Income Producing 4 Story Mixed-Use Historic Brownstone Property in Absolute Prime North Park Slope, just steps from Barclays Center! Enjoy a Highly Desirable Ground Floor Store Front with Private Backyard Access and Three separate Floor-Through 3 Bedroom 1 Bath Apartments with Tons of Beautiful Original Details Fully Restored throughout including Exposed Brick, Hardwood Floors, Custom Wood Trim and New Stainless Steel Kitchens. This Sun-Drenched Favorable R6A Zoned Solid Brick Construction sits on a 20' X 80' Lot with a 20' X 60' Building Footprint, offering 4,800 SQFT of Living/Commercial Space that fetch Top Dollar on Today's Leasing Market due to the Incredible Location and Condition. A Full Basement with Separate Front and Back Gate Entrances and a Full Bathroom create Flexible and Convenient Options and Ease of Use. Only One House in from the Corner of St. Johns Pl and 5th Avenue, this Eye Catcher Benefits from the Tremendous Foot Traffic that this Red Hot Trendy Neighborhood has become known for... Close Proximity to Grand Army Plaza, Prospect Park, Brooklyn Botanical Gardens, Countless Successful and Busy Restaurants, Cafes, Bars and Retail Establishments all along 5th Ave and Beyond. Rest Assured, you will be in Excellent Company whether you are a Developer, Investor or End Users alike! On top of all that, commute into the city in just minutes away! Don't let the Chance Slip by to Own a Piece of History that has Appreciation, Earnings and Revenue Written All Over It!
MlsNumber: 441189


Listing Provided By: RE/MAX Real Estate Professiona, original listing
Name: RE/MAX Real Estate Professiona
Phone: (718) 532-2000
Office Name: RE/MAX Real Estate Professiona
Office Phone: (718) 532-2000
Agent Name: Vito Angelo
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