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 = 95 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 = 95 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 = 95 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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;

78 Second Street
Brooklyn, NY 11231

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,500,000
Beds: 4
Baths: 4
Status: Active
SqFt: --
Agency: REALTY COLLECTIVE LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1899
Notes: Dreamy renovated townhouse on idyllic Carroll Gardens block Rare opportunity to own a turnkey two-family home in this cherished neighborhood. Be the first to live in this beautifully renovated 3+br/3ba triplex with extravagant outdoor space. Enjoy income from the top floor rental, or combine for a massive single-family home. While this historic property was one of the earliest to be built in the neighborhood, it has been reimagined for the next century. Enter through the lush front garden, where a surprisingly spacious dwelling awaits below the brownstone stoop. Every inch of this triplex has been renovated with white oak hardwood floors, classic marble baths, and a kitchen you must see to believe. In addition to the large, comfortable rooms, there are exceptional closets throughout, each with built-in features to make storage a breeze. The kitchen pantry alone is worth the visit! The simple facade conceals an elegant, modern home. The first-floor mudroom entry has a marble floor - kick off your boots and leave your cares at the door. The extraordinary kitchen features lacquered cabinets, stainless appliances, acres of storage, and stone countertops. There's plenty of space for a dining table or island. Step down to the large living/dining room, with a full wall of glass to the mature garden beyond. Open the sliding doors and enjoy seamless indoor/outdoor living. This level also features a bedroom overlooking the front garden, a double coat closet, and a large marble bath with tub and shower. Upstairs, the primary bedroom is a true retreat. This king-sized room has an expansive closet with built-ins galore, and a glass door to a huge private terrace. Down the hall is the third bedroom with yet another oversized closet, as well as a luxurious windowed bathroom with a double sink. Enjoy the cross breeze, or cool down with energy-efficient split unit air conditioners. Down the stairs, you'll find a huge media/guest room with a projector and motorized screen. This windowed space is ideal for working from home as well. The adjacent room is perfect for a gym - there's even a sauna! And still another full marble bath with spa-style shower. Is a laundry room with a full-sized vented washer/dryer on your "must-have" list? You'll find that as well. The top-floor rental unit has its own entrance. With its own private terrace, washer/dryer, eat-in kitchen, and large living room, this one-bedroom apartment will generate substantial monthly rent. Or combine it with the triplex to create a massive, four-story home. There's even FAR available if you still need room to grow!
MlsNumber: 11271419


Listing Provided By: REALTY COLLECTIVE LLC, original listing
Name: REALTY COLLECTIVE LLC
Office Name: REALTY COLLECTIVE LLC
Office Phone: (718) 834-1440
Agent Name: Christina Fallon
Disclaimer: Copyright © 2024 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 95 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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;
Real Estate Expert Photo for Victoria M Sanchez
Victoria M Sanchez
ASCIIIrealty Professionals
Call Today!: (928) 713-4678

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App