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

251-11 Memphis Ave
Rosedale, NY 11422
Kenneth Pierre-louis with Hope Realty Group, original listing - (917) 250-5956

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,150,000
Beds: 5
Baths: Full: 4, ½: 2
Status: Active
SqFt: 1916 Square Feet
Agency: Hope Realty Group
Agency Phone: (917) 250-5956

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential Multi Family-Other
Year Built: 1950
Notes: Discover modern living and excellent investment potential in this fully renovated two-family home in the heart of Rosedale! This spacious, move-in-ready property was completely updated in 2022, blending contemporary design with functional living. Boasting two well-appointed units, this home is ideal for both homeowners looking for additional rental income and investors seeking a strong return. Property Highlights: Two-family layout - Live in one unit and rent the other! Unit 1: 2 bedrooms, 2 full bathrooms, modern open-concept kitchen & living space Unit 2: 3 bedrooms, 1 full bathroom, spacious layout with updated finishes Fully finished basement with a half bathroom and additional recreational space Renovated kitchens with quartz countertops, stainless steel appliances, and stylish cabinetry Modern bathrooms with sleek fixtures and designer tile work Updated systems - Electrical, plumbing, and heating for worry-free living Hardwood and tile flooring throughout for a clean and sophisticated look Private driveway with off-street parking Outdoor spaces - Enjoy a charming front porch and a large rear deck Location Perks: Close to major highways, shopping, and dining Minutes from public transportation for easy commuting Nearby parks and recreation areas for an active lifestyle Convenient access to schools and community amenities This turnkey investment opportunity won't last long! Whether you're an investor looking for a high-income rental property or a homeowner searching for the perfect multi-family residence, this home is ready to meet your needs.
MlsNumber: --
ListingId: 11433324


Listing Provided By: Hope Realty Group, original listing
Phone: (917) 250-5956
Office Phone: (917) 250-5956
Agent Name: Kenneth Pierre-louis
Disclaimer: Copyright © 2025 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App