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

684 E 226th Street
Bronx, NY 10466

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,150,000
Beds: 6
Baths: 3
Status: Pending
SqFt: --
Agency: Andrew J Markowitz Real Estate, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: MultiFamily
Year Built: 1930
Notes: Unveil the canvas of your dreams with this remarkable investment opportunity-a multi-family home in need of a full renovation that holds the potential to transform into a masterpiece of modern living. Calling out to investors and builders, this is your chance to shape an 8,370 sqft building, perfectly poised on a lot spanning 66.5' X 114.42'. Imagine the possibilities that await as you embrace the allure of this property. The current R6 zoning, coupled with the C1-4 overlay, opens the door to a world of creativity and innovation, allowing you to craft a truly unique space that blends residential and commercial potential seamlessly. Situated merely a block away from the 2 and 5 train station, convenience is at your doorstep, promising effortless commutes and boundless exploration. The surrounding neighborhood offers a vibrant tapestry of amenities, with shopping destinations just a stone's throw away, catering to every desire. And just a few short blocks down lies the serene expanse of Shoelace Park-an oasis of greenery where you can escape the city's hustle and bask in the tranquility of nature. Unlock the potential of this blank canvas, where your vision and imagination can shape a future that resonates with your aspirations. Transform this multi-family home into a captivating haven that stands as a testament to your creativity and vision. Seize this unparalleled opportunity to breathe new life into a space with endless possibilities. Don't miss out-this is your chance to turn a renovation project into a legacy of extraordinary living.
MlsNumber: 3496835


Listing Provided By: Andrew J Markowitz Real Estate, LLC, original listing
Name: Andrew J Markowitz Real Estate, LLC
Phone: (917) 548-9533
Office Name: Andrew J Markowitz R E LLC
Office Phone: (646) 688-5009
Agent Name: Andrew Markowitz
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