Buy
  • Alabama Alaska California Colorado Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
    Canada Listings (752)
    Mexico Listings (331)
    Central America Listings (627)
    Caribbean Islands Listings (44)
    Asia Listings (20) Europe Listings (9)
    Advanced Search
Sell Find an Agent
BeachHouse.com BeachHouse.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • Sell
  • Find an Agent
  • My Account
    • Login
    • Manage My Real Estate Ads
    • Manage My Search Profile / Auto Notify
    • My Account Info
    • Manage My Favorites
  • Advertise
  • Join
Back to Search Back to Listing BeachHouse.com logo
Share
BeachHouse.com logo
Ad #7786384
MLS #979596
Listing photo

Turnkey Two-Family Investment in Prime Brooklyn Location

697 Sheffield Ave, Brooklyn, New York, 11207
$850,000
5Beds
5Baths
--Sqft
0.026Acres

About this property

Turnkey Two-Family Investment in Prime Brooklyn Location Discover this pristine all-brick two-family home built in 2008, featuring modern finishes, brand-new appliances, and move-in ready condition - no renovations required. Perfect for owner-occupiers or investors seeking strong rental income and long-term appreciation. Key Features Total Interior: 2,034 sq ft over three stories plus basement Layout: 1st & 2nd floor duplex: 2 bedrooms, 1 living room, 1 bathroom 2nd & 3rd floor duplex: 3 bedrooms, 1 living room, 3 bathrooms Basement: Vacant with half bath, rear yard access, 8-ft ceilings, two new boilers, two hot water heaters, two electric meters , two gas meters Annual Taxes: Only $6,374 Turnkey condition with new appliances and mechanicals Strong rental history and vacant units ready for immediate income Excellent location with superior transit and neighborhood amenities Rare opportunity for a modern, brick two-family in East Brooklyn at this price Prime Transit Access Subway: J/Z Lines at Norwood Avenue Station, Cleveland Street Station nearby (~5-10 min walk) Bus: B14, B20, B83, Q24 - all routes connect to Broadway Junction, a major hub linking A, C, J, Z, L trains, and LIRR Commute: ~30-40 min to Lower Manhattan, quick access to Downtown Brooklyn and Williamsburg Pennsylvania Ave 3 trains, New Lots Ave L Train easy manhattan access, Junius St/ Van Siclen Ave 2/3/4/5 Train. Bus B15 one min walk and connects to JFK airport , bus B20 3 mins walk . Everything nearby. A must see.

Property Features

5 Beds
5 Baths
0 Sqft
Built in 2008
0.026 Acres
On Street
Siding: Brick
Natural Gas
$6,374 / yr property tax
Kings County

Additional Photos

Additional listing photo 1
Additional listing photo 2
Additional listing photo 3
Additional listing photo 4

Contact Information

Xingye Fu

eXp Realty

516-336-9417

Location

Map
Listing Agent: Xingye Fu 516-336-9417
Broker: eXp Realty 888-276-0630 Listing Site
Copyright © 2026 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.
BeachHouse.com
Printed Jul 24, 2026

Photo Gallery

Turnkey Two-Family Investment in Prime Brooklyn Location - photo 1
Turnkey Two-Family Investment in Prime Brooklyn Location - photo 2
Turnkey Two-Family Investment in Prime Brooklyn Location - photo 3
Turnkey Two-Family Investment in Prime Brooklyn Location - photo 4
Turnkey Two-Family Investment in Prime Brooklyn Location - photo 5
Turnkey Two-Family Investment in Prime Brooklyn Location - photo 6
Turnkey Two-Family Investment in Prime Brooklyn Location - photo 7
Turnkey Two-Family Investment in Prime Brooklyn Location - photo 8
Turnkey Two-Family Investment in Prime Brooklyn Location - photo 9
Turnkey Two-Family Investment in Prime Brooklyn Location - photo 10
Turnkey Two-Family Investment in Prime Brooklyn Location - photo 11
Turnkey Two-Family Investment in Prime Brooklyn Location - photo 12
Turnkey Two-Family Investment in Prime Brooklyn Location - photo 13
Turnkey Two-Family Investment in Prime Brooklyn Location - photo 14

$850,000

5
Beds
5
Baths
--
Sqft

697 Sheffield Ave, Brooklyn, New York, 11207

By contacting this agent you agree to these Terms and Conditions.
Home New York Brooklyn
Turnkey Two-Family Investment in Prime Brooklyn Location - photo 1
Turnkey Two-Family Investment in Prime Brooklyn Location - photo 2
Turnkey Two-Family Investment in Prime Brooklyn Location - photo 3
Turnkey Two-Family Investment in Prime Brooklyn Location - photo 4
Turnkey Two-Family Investment in Prime Brooklyn Location - photo 5
MLS# 979596
Townhome/Townhouse For Sale

Turnkey Two-Family Investment in Prime Brooklyn Location

$850,000

697 Sheffield Ave, Brooklyn, New York, 11207

5
Beds
5
Baths
--
Sqft
0.026
Acres
$850,000
697 Sheffield Ave, Brooklyn, New York, 11207
5 Beds
5 Baths
-- Sqft
0.026 Acres
Turnkey Two-Family Investment in Prime Brooklyn Location Discover this pristine all-brick two-family home built in 2008, featuring modern finishes, brand-new appliances, and move-in ready condition - no renovations required. Perfect for owner-occupiers or investors seeking strong rental income and long-term appreciation. Key Features Total Interior: 2,034 sq ft over three stories plus basement Layout: 1st & 2nd floor duplex: 2 bedrooms, 1 living room, 1 bathroom 2nd & 3rd floor duplex: 3 bedrooms, 1 living room, 3 bathrooms Basement: Vacant with half bath, rear yard access, 8-ft ceilings, two new boilers, two hot water heaters, two electric meters , two gas meters Annual Taxes: Only $6,374 Turnkey condition with new appliances and mechanicals Strong rental history and vacant units ready for immediate income Excellent location with superior transit and neighborhood amenities Rare opportunity for a modern, brick two-family in East Brooklyn at this price Prime Transit Access Subway: J/Z Lines at Norwood Avenue Station, Cleveland Street Station nearby (~5-10 min walk) Bus: B14, B20, B83, Q24 - all routes connect to Broadway Junction, a major hub linking A, C, J, Z, L trains, and LIRR Commute: ~30-40 min to Lower Manhattan, quick access to Downtown Brooklyn and Williamsburg Pennsylvania Ave 3 trains, New Lots Ave L Train easy manhattan access, Junius St/ Van Siclen Ave 2/3/4/5 Train. Bus B15 one min walk and connects to JFK airport , bus B20 3 mins walk . Everything nearby. A must see.
41 days
on BeachHouse.com
17
views
0
saves

Property Details

HOME DETAILS

5 Beds
5 Baths
0 Sqft
Built in 2008
0.026 Acres

EXTERIOR

On Street
Siding: Brick

INTERIOR

Natural Gas

FINANCIAL & COMMUNITY

$6,374 / yr property tax
Kings County
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7786384
Viewed
17 times
Listing Status
Active
Added
Jun 13, 2026
Last Refresh
Jul 24, 2026 04:01:17 PM

Listing Information

Data Source
OneKey MLS
Source Property ID
979596
Listing Agent: Xingye Fu 516-336-9417
Broker: eXp Realty 888-276-0630 Listing Site
Copyright © 2026 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.

Request Information

By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.

Start advertising today

Explore options for real estate agents and homeowners advertising on BeachHouse.com
Sell Your Home

Explore Similar Properties

For Sale
Opportunity For Investors Or Owner-Occupants Looking For A Solid - photo 1
Opportunity For Investors Or Owner-Occupants Looking For A Solid - photo 2
Opportunity For Investors Or Owner-Occupants Looking For A Solid - photo 3

$1,000,000

4 Beds | 3.0 Baths | 2,836 Sqft

607 E 53rd St, Brooklyn, NY, 11203

Opportunity For Investors Or Owner-Occupants Looking For A Solid

Added: 07/14/2026 • Updated: 07/15/2026
For Sale
This Colonial Style 2 Family Home Features 6 Bedrooms, 3 Full - photo 1
This Colonial Style 2 Family Home Features 6 Bedrooms, 3 Full - photo 2
This Colonial Style 2 Family Home Features 6 Bedrooms, 3 Full - photo 3
This Colonial Style 2 Family Home Features 6 Bedrooms, 3 Full - photo 4

$1,000,000

6 Beds | 3.0 Baths | 0 Sqft

937 E 95th St, Brooklyn, NY, 11236

This Colonial Style 2 Family Home Features 6 Bedrooms, 3 Full

Added: 06/29/2026 • Updated: 06/29/2026
For Sale
Exceptional Investment Opportunity - Solid Brick 3-Family Home - photo 1
Exceptional Investment Opportunity - Solid Brick 3-Family Home - photo 2
Exceptional Investment Opportunity - Solid Brick 3-Family Home - photo 3
Exceptional Investment Opportunity - Solid Brick 3-Family Home - photo 4
Exceptional Investment Opportunity - Solid Brick 3-Family Home - photo 5
Exceptional Investment Opportunity - Solid Brick 3-Family Home - photo 6
Exceptional Investment Opportunity - Solid Brick 3-Family Home - photo 7

$999,999

4 Beds | 3.0 Baths | 2,660 Sqft

3811 Kings Hwy, Brooklyn, NY, 11234

Exceptional Investment Opportunity - Solid Brick 3-Family Home

Added: 07/02/2026 • Updated: 07/06/2026
For Sale
Opportunity, flexibility, and space all come together in this - photo 1
Opportunity, flexibility, and space all come together in this - photo 2
Opportunity, flexibility, and space all come together in this - photo 3
Opportunity, flexibility, and space all come together in this - photo 4
Opportunity, flexibility, and space all come together in this - photo 5
Opportunity, flexibility, and space all come together in this - photo 6
Opportunity, flexibility, and space all come together in this - photo 7
Opportunity, flexibility, and space all come together in this - photo 8
Opportunity, flexibility, and space all come together in this - photo 9
Opportunity, flexibility, and space all come together in this - photo 10
Opportunity, flexibility, and space all come together in this - photo 11
Opportunity, flexibility, and space all come together in this - photo 12
Opportunity, flexibility, and space all come together in this - photo 13
Opportunity, flexibility, and space all come together in this - photo 14
Opportunity, flexibility, and space all come together in this - photo 15
Opportunity, flexibility, and space all come together in this - photo 16
Opportunity, flexibility, and space all come together in this - photo 17
Opportunity, flexibility, and space all come together in this - photo 18
Opportunity, flexibility, and space all come together in this - photo 19
Opportunity, flexibility, and space all come together in this - photo 20
Opportunity, flexibility, and space all come together in this - photo 21
Opportunity, flexibility, and space all come together in this - photo 22
Opportunity, flexibility, and space all come together in this - photo 23
Opportunity, flexibility, and space all come together in this - photo 24
Opportunity, flexibility, and space all come together in this - photo 25
Opportunity, flexibility, and space all come together in this - photo 26
Opportunity, flexibility, and space all come together in this - photo 27
Opportunity, flexibility, and space all come together in this - photo 28
Opportunity, flexibility, and space all come together in this - photo 29
Opportunity, flexibility, and space all come together in this - photo 30

$999,999

6 Beds | 5.0 Baths | 0 Sqft

850 E 95th St, Brooklyn, NY, 11236

Opportunity, flexibility, and space all come together in this

Added: 06/29/2026 • Updated: 06/29/2026
View more View More
SEARCH STATES
Alabama Alaska California Colorado Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.24
Terms & Policy

Search Filters
Price
-
0
$100,000
$100,000+
$200,000
$200,000+
$300,000
$300,000+
$400,000
$400,000+
$500,000
$500,000+
$600,000
$600,000+
$700,000
$700,000+
$800,000
$800,000+
$900,000
Any Price
Any Price
Beds & Baths
-
-
Property Type
Sale Status
More Filters
-
-
-
-
Advanced Search

Brooklyn

Read more
Sort By: Featured
  • Featured
  • Newest
  • Price - Low To High
  • Price - High To Low
  • Sqft - Low To High
  • Sqft - High To Low

Brooklyn Real Estate Agent Info

About Brooklyn

Click to activate
Request Information
By proceeding you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), and its affiliates, to contact me using the contact details you provided, via phone call or text (SMS) using automated dialing technology for marketing or advertising purposes, including contacting me about my inquiry and other home-related matters. Not a condition for purchase. Message and data rates may apply.
This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what I am looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at  csv@dreamhomenetwork.com.
Contact Agent
By contacting this agent you agree to these Terms and Conditions.
Share this Ad
Link copied
Video/Virtual Tour
Loading...
SEARCH STATES
Alabama Alaska California Colorado Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.24
Terms & Policy