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

3280 Tierney
Bronx, NY 10465

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,625,000
Beds: 4
Baths: 5
Status: Active
SqFt: 3327
Agency: NY SPACE FINDERS INC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1925
Notes: Introducing a truly extraordinary gem among waterfront properties, Bringing Hamptons Living to New York City. Behold the magnificent Three-Story Brick Colonial situated on a double lot, exquisitely renovated to perfection. This remarkable property is a unicorn in its own right, boasting features and qualities that make it an unparalleled and incomparable masterpiece. From the moment you set your eyes on this architectural marvel, you will be captivated by its commanding presence and timeless elegance. The stately brick exterior, adorned with meticulous craftsmanship, evokes a sense of grandeur and sophistication. The three-story design offers ample space, ensuring a luxurious and comfortable lifestyle for its fortunate occupants. Nestled upon a prime waterfront location, the property boasts breathtaking views that stretch as far as the eye can see. Whether you're lounging on the sprawling porch, savoring the gentle breeze from the nearby shore, or indulging in a picturesque sunset, the beauty of nature envelops you from every corner. Step inside, and prepare to be enchanted by the meticulously designed interior, where no expense has been spared in creating a truly lavish living experience. The renovation has seamlessly merged the classic charm of the past with the modern conveniences of the present, resulting in a harmonious blend of old-world elegance and contemporary luxury. As you explore the expansive living spaces, you'll discover a multitude of features that set this property apart from any other. High ceilings, intricate moldings, and custom finishes create an atmosphere of opulence and refinement. The magic of this property extends beyond its walls. With unlimited potential for growth , The double lot, an exceedingly rare find, provides an expansive outdoor haven that is ideal for hosting grand gatherings or simply enjoying the serene beauty of the surroundings, and a private dock all contribute to the allure of this one-of-a-kind oasis. Featured Residential Sales.
MlsNumber: 3488884


Listing Provided By: NY SPACE FINDERS INC, original listing
Name: NY SPACE FINDERS INC
Phone: (357) 242-0353
Office Name: NY Space Finders Inc
Office Phone: (718) 440-8162
Agent Name: Luca DiCiero
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