Loading...
Please wait
Fair Housing Notice
|
Standard Operating Procedure
Login
or
Register
for additional options
My account
Saved
Searches
Property Search
Featured Properties
Buyers
Sellers
Resources
Our Team
Prop Mgmt
Contact
show search panel
For Sale or For Lease:
Select
Lease
Sale
Select Type:
All Property Types
Retail
Lots and Land
Business/Property
Commercial
Farm and Agriculture
Apartment
Condo
Single Family
Land
Office
Heavy Industrial
General
Multi Family
Vacant Lot
Warehouse
Light Industrial
Commercial Co-op
Coop
Condo
Business Only
Apt House
Free St Bldg
Indus Bldg
Misc
Shop Center
Small Stores
Store
Office Bldg
In City Lot
Department Store
Apartment
Commercial
Altele
Hotel / Boarding House
Studio Apartment
Recreation Area
penthouse
Factory Area
Office Building
Out of City Lot
Farm
House
Production Area
Industrial
Mixed Use
Investment
LuxuryFull Service
Elevator
Walk-up
Live Work
Legal Accessory Apartment
Apartment in House
Advantage (DHS)
NYCHA Section 8
HPD Section 8
HASA
2-4 Multi-Family
5+ Multi-Family
Farm Estate
Half Duplex
Mobile Home With Land
Mobile Home Without Land
Multiple Residence
Commercial
Residential
1 Family Detached
Townhouse
HOA
Projects
1 Family + Access Apt
2 Family
3 Family
4 Family
Multi-Unit
Mobile Home
Vacation
House
Project
Gas Stations
Gas Station
Homeowner Assoc
Efficiency
Duplex
Triplex
Special
Lease
Zoned Boat Dock
Zoned Residential
Fourplex
Income
Hotel
Timeshare
Unimproved Agri/Recreation/Mobile Home
Villa
Zoned Boat Dock
Zoned Residential
Apartment In Building
Ranch
Property
Seasonal
Restaurant
Building
Studio
Unimproved Land
Stock Cooperative
Dockominium
ResidentialIncome
ResidentialLease
House Rental
Foreclosure
Short Sale
Select Price:
Min
100,000
150,000
200,000
250,000
300,000
350,000
400,000
450,000
500,000
550,000
600,000
650,000
700,000
750,000
800,000
850,000
900,000
950,000
1,000,000
1,100,000
1,200,000
1,300,000
1,400,000
1,500,000
1,600,000
1,700,000
1,800,000
1,900,000
2,000,000
2,100,000
2,200,000
2,300,000
2,400,000
2,500,000
2,600,000
2,700,000
2,800,000
2,900,000
3,000,000
5,000,000
10,000,000
50,000,000
100,000
150,000
200,000
250,000
300,000
350,000
400,000
450,000
500,000
550,000
600,000
650,000
700,000
750,000
800,000
850,000
900,000
950,000
1,000,000
1,100,000
1,200,000
1,300,000
1,400,000
1,500,000
1,600,000
1,700,000
1,800,000
1,900,000
2,000,000
2,100,000
2,200,000
2,300,000
2,400,000
2,500,000
2,600,000
2,700,000
2,800,000
2,900,000
3,000,000
5,000,000
10,000,000
50,000,000
Max
Beds:
Min
1
2
3
4
5
6
7
8
9
10
0
1
2
3
4
5
6
7
8
9
10
Max
Baths:
Min
1
2
3
4
5
6
7
8
9
10
0
1
2
3
4
5
6
7
8
9
10
Max
Sq. Ft.:
Min SqFt
100
200
300
400
500
600
700
800
900
1000
1100
1200
1300
1400
1500
1600
1700
1800
1900
2000
0
100
200
300
400
500
600
700
800
900
1000
1100
1200
1300
1400
1500
1600
1700
1800
1900
2000
Max SqFt
Foreclosure
Short Sale
Select Area:
All Counties
Nassau
Queens
Suffolk
Click to
Select a Town:
Addisleigh Park
Albertson
Amaganset
Amity Harbor
Amityville
Aquebogue
Arverne
Asharoken
Astoria
Atlantic Beach
Atlantique
Babylon
Baisley Park
Baiting Hollow
Baldwin
Baldwin Harbor
Bar Harbor
Barnum Isle
Baxter Estates
Bay Park
Bay Shore
Bayport
Bayside
Bayswater
Bayview
Bayville
Beechhurst
Bell Harbor
Bellaire
Belle Terre
Bellerose
Bellerose Terr
Bellerose Vill
Bellmore
Bellport
Bethel
Bethpage
Biltmore Shore
Blue Point
Bohemia
Breezy Point
Brentwood
Briarwood
Bridgehampton
Brightwaters
Broad Channel
Brookhaven
Brooklyn
Brookville
Calverton
Cambria Heights
Carle Place
Cedarhurst
Center Moriches
Centereach
Centerport
Centerville
Central Islip
Centre Island
Cherry Grove
City Line
Cold Spring Hill
Cold Spring Hrbr
College Point
Commack
Copiague
Coram
Corneille Estates
Corona
Cove Neck
Cutchogue
Cypress Hills
Davis Park
Deer Park
Deerfield
Dix Hills
Douglaston
Dunewood
E Atlantic Beach
E. Elmhurst
E. Farmingdale
E. Massapequa
E. New York
E. Northport
E. Patchogue
E. Quogue
E. Rockaway
E. Setauket
E. Williston
East Hampton
East Hills
East Islip
East Marion
East Meadow
East Moriches
East Norwich
Eastport
Eatons Neck
Edgemere
Edgewood
Elmhurst
Elmont
Elwood
Fair Harbor
Far Rockaway
Farmingdale
Farmingville
Fire Island Pine
Fishers Island
Flanders
Floral Park
Floral Park Ctr
Flower Hill
Flushing
Forest Hills
Forest Hills Gardens
Fort Salonga
Fort Tilden
Franklin Square
Freeport
Fresh Meadows
Garden City
Garden City Park
Garden City S
Garden City Vill
Gibson
Gilgo Beach
Glen Cove
Glen Head
Glen Oaks
Glendale
Glenwood Landing
Gordon Heights
Great Neck
Great Neck Est
Great Neck Plaza
Great River
Greenlawn
Greenport
Greenvale
Halesite
Half Hollow Hill
Hamilton Beach
Hampton Bays
Harbor Green
Harbor Green Est
Harbor Hills
Harbor Isle
Hauppauge
Head Of Harbor
Hempstead
Herricks
Hewlett
Hewlett Bay Park
Hewlett Harbor
Hewlett Neck
Hicksville
Highland Park
Hillcrest
Holbrook
Hollis
Hollis Hills
Holliswood
Holtsville
Howard Beach
Huntington
Huntington Bay
Huntington Manor
Huntington Sta
Huntington Station
Inwood
Island Park
Islandia
Islip
Islip Terrace
Jackson Heights
Jamaica
Jamaica Estates
Jamaica Hills
Jamaica N.
Jamaica S.
Jamesport
Jericho
Kensington
Kew Garden Hills
Kew Gardens
Kings Park
Kings Point
Kismet
Lake Grove
Lake Panamoka
Lake Ronkonkoma
Lake Success
Lakeview
Lattingtown
Laurel
Laurel Hill
Laurel Hollow
Laurelton
Lawrence
Levittown
Lido Beach
Lindenhurst
Lindenwood
Little Neck
Lloyd Harbor
Lloyd Neck
Locust Grove
Locust Valley
Lonelyville
Long Beach
Long Island City
Lynbrook
Malba
Malverne
Manhasset
Manhasset Hills
Manorhaven
Manorville
Maspeth
Massapequa
Massapequa Park
Massapequa Shores
Mastic
Mastic Beach
Matinecock
Mattituck
Meadowmere Park
Medford
Melville
Merrick
Middle Island
Middle Village
Middleville
Mill Neck
Miller Place
Mineola
Montauk
Moriches
Mt. Sinai
Munsey Park
Muttontown
N. Amityville
N. Babylon
N. Baldwin
N. Bellmore
N. Great River
N. Lindenhurst
N. Lynbrook
N. Massapequa
N. Merrick
N. New Hyde Park
N. Patchogue
N. Valley Stream
N. Wantagh
N. Woodmere
Nassau Point
Nassau Shores
Nesconset
Nesponsit
New Cassel
New Hyde Park
New Suffolk
Nissequogue
North Haven
North Hills
Northport
Northville
Noyack
Oak Beach
Oak Island
Oakdale
Oakland Gardens
Oakleyville
Ocean Bay Park
Ocean Beach
Ocean Ridge
Oceanside
Old Bethpage
Old Brookville
Old Field
Old Harbor Green
Old Westbury
Orient
Orient Point
Oyster Bay
Oyster Bay Cove
Ozone Park
Park Slope
Patchogue
Peconic
Pinelawn
Plainedge
Plainview
Plandome
Plandome Heights
Plandome Manor
Point Lookout
Point O'woods
Poquott
Port Jefferson
Port Washington
Pt. Washington N
Pt.Jefferson Sta
Pt.Jefferson Vil
Queens Village
Queens Village N
Queens Village S
Quogue
Rego Park
Remsenburg
Richmond Hill
Richmond Hill N.
Richmond Hill S.
Ridge
Ridgewood
Riverhead
Roanoke
Robbins Rest
Rochdale
Rochdale Village
Rockaway Beach
Rockaway Park
Rockaway Point
Rockville Centre
Rocky Point
Ronkonkoma
Roosevelt
Rose Grove
Rosedale
Roslyn
Roslyn Estates
Roslyn Harbor
Roslyn Heights
Russell Gardens
S. Bellmore
S. Farmingdale
S. Floral Park
S. Great River
S. Hauppauge
S. Hempstead
S. Huntington
S. Jamesport
S. Merrick
S. Ozone Park
S. Setauket
Saddle Rock
Sag Harbor
Sagaponack
Saltaire
San Remo
Sands Point
Sayville
Sea Cliff
Seaford
Searingtown
Seaside
Seaview
Selden
Setauket
Shelter Island
Shelter Island H
Shinnecock
Shirley
Shoreham
Smithtown
Sound Beach
South Haven
Southampton
Southold
Southport
Speonk
Springfield Gdns
Springs
St. Albans
St. James
Stewart Manor
Stony Brook
Strathmore
Sunken Forest
Sunnyside
Syosset
Tanglewood Hills
Terryville
The Pines
The Summer Club
Thomaston
Tudor Village
Uniondale
University Gdns
Upper Brookville
Upper Ditmars
Valley Stream
Villof Branch
W. Amityville
W. Babylon
W. Bay Shore
W. Gilgo Beach
W. Hempstead
W. Sayville
W. Yaphank
Wading River
Wainscott
Wakefield
Wantagh
Water Island
Water Mill
West Hills
West Islip
West Oakleyville
Westbury
Westhampton
Westhampton Bch
Wheatley Heights
Whitestone
Williston Park
Woodbury
Woodhaven
Woodmere
Woodsburgh
Woodside
Wyandanch
Yaphank
Click to
Remove a Town:
Select Town
Search
»
Location Criteria
Street Name:
Zip Code:
School District:
Select
Bronx 11
Brooklyn 13
Brooklyn 14
Brooklyn 17
Brooklyn 18
Brooklyn 19
Brooklyn 22
Brooklyn 23
Brooklyn 32
City of New York
Elmont
Floral Park-Bellerose
Great Neck
Hewlett-Woodmere
Lawrence
Manhattan 6
Queens 24
Queens 25
Queens 26
Queens 27
Queens 28
Queens 29
Queens 30
Amityville
Babylon
Baldwin
Bay Shore
Bay Terrace
Bayport-Blue Point
Bayside H.S.
Bellerose
Bellmore
Bethpage
Brentwood
Bridgehampton
Broaward
Bronx
Canarsie
Cardozo
Carle Place
Center Moriches
Central Islip
Clinton Hill
Cold Spring Harbor
Commack
Comsewogue
Connetquot
Copiague
Dacula
Deer Park
District 25
E.N.Y.
East Hampton
East Islip
East Meadow
East Moriches
East Quogue
East Rockaway
East Williston
Eastport
Elmont
Elwood
Eny
Farmingdale
Fire Island
Floral Park
Floral Park-Bellerose
Floral Parkway
Forest Hills
Franklin Square
Freeport
Garden City
Glen Cove
Great Neck
Greenport
Half Hollow Hills
Hampton Bays
Harborfields
Hauppauge
Hempstead
Herricks
Hewlett-Woodmere
Hicksville
Howard Beach
Huntington
Island Park
Island Trees
Islip
Jamaica
Jamaica Hills
Jericho
Kings Park
Laurel
Laurelton
Lawrence
Levittown
Lindenhurst
Locust Valley
Long Beach
Longwood
Lynbrook
Malverne
Manhasset
Maspeth
Massapequa
Mattituck-Cutchogue
Merrick
Middle Country
Miller Place
Mineola
Montauk
Mount Sinai
N. Babylon
N. Bellmore
N. Merrick
N/A
New Hyde Park
North Hills
North Shore
Northport-East Northport
Nyc Public
Oceanside
Oxford
Oyster Bay-East Norwich
Ozone Pk
Patchogue-Medford
Plainedge
Plainview-Old Bethpage
Port Jefferson
Port Washington
Queens
Queensvillage
Quogue
Remsenberg-Speonk
Richmond Hill
Riverhead
Rockville Centre
Rocky Point
Roosevelt
Rosedale
Roslyn
S. Huntington
S.Ozone Park
Sachem
Sag Harbor
Sayville
Seaford
Shoreham-Wading River
Smithtown
South Country
South Manor
Southampton
Southold
Springfield
Springs
St. Albans
Staten Island
Syosset
Three Village
Tuckahoe
Uniondale
Valley Stream 13
Valley Stream 30
Valley Stream 24
W. Babylon
W. Hempstead
Wantagh
West Islip
Westbury
Westhampton Beach
Whitestone
William Floyd
Wyandanch
27
29
»
Property Criteria
Property Style
Click to
Select a Property Style:
Please select
2 Family
2 Story
Antique/Hist
Apartment
Apt In Bldg
Apt In House
Barn
Building
Bungalow
Cape
Colonial
Comm/Ind
Condo
Contemporary
Co-Op
Co-Op
Cottage
Duplex
Estate
Exp Cape
Exp Ranch
Farm Ranch
Farmhouse
Garden Apt
Garden Building
Hi Ranch
Hi-Rise
Homeowner Assoc
House Rental
Houseboat
Land
Mediterranean
Mixed Use
Mobile Home
Modern
Nantucket
Other
Post Modern
Prewar
Raised Ranch
Ranch
Room Rental
Saltbox
Share Condo
Single Family
Splanch
Split
Split Ranch
Split Ranch
Store+Dwell
Store+Dwell
Studio
Timeshare
Townhouse
Traditional
Tudor
2 Family
Victorian
Click to
Remove a Property Style:
All Property Style
Type Sale
Select
Business
Bus+Office
Inc Prop
Office
Prop+Bus
Property
Store
StoreFnt
Business Type
Select
Audio
Auto
Bar
Beauty/Barber
Church
Deli
Distributor
Drug/Beauty
Fast Food
Florist/Nursery
Gas Station
Health Spa/Gym
Laund/Dry Clean
Liquor Store
Maintenance
Manufacturer
Marine
Misc
Motel/Hotel
Pizza
Recreation
Restaurant
Retail
Retail Food
Routes
Services
Stationary
Video
Wholesale
Rental Type
Select
August
AugustLabor
Flexible
July
July/August
June
Memorial-Labor
Month-Month
OffSeason
1 Year
2 Weeks
2 Year
Weekly
Winter
»
Description
Keyword
»
Features
Waterfront
Waterview
Adult Community
Garage
New Construction
Cul De Sac
Eat In Kitchen
Pets
Furnished
Smoking
Private Entrance
Wood Floors
Heat
Central Air
Handicapped access
Docking Rights
Beach Rights
Fireplace
Basement
Inground Pool
All Dogs
No Dogs
All Cats
No Cats
Restricted Weight
No Restrictions
Parking Spaces
Min Parking
1
2
3
4
5
6
7
8
9
10
0
1
2
3
4
5
6
7
8
9
10
Max Parking
Gas Type
Select
Included
Not Included
Partial
Yes
No
Heating Type
Select
Baseboard
Central Furnace
Electric Air Filter
Forced Air
Heat Pump
Hot Water
Hot Water Radiant Floor
Humidifier
Included
N/A
No
None
Not Included
Other
Partial
Pellet Stove
Radiant Ceiling
Radiant Floor
Radiator
Solar Active
Solar Active Passive
Solar Passive
Space Heater
Steam
Stove
SW Changeover
Unknown
Wall Unit
Yes
Zoned
»
Display Tools
Photos
Virtual Tours
Open Houses
New to Market:
In Last Day
In Last Week
In Last Month
All
Sort by:
Price
Location
Date
Order:
Ascending
Descending
Search
1
properties match your search ;
1
With
Multiple photos
;
0
With
Virtual Tour
;
0
With
Videos
Save Search
Showing
1 - 1
of
1
results
| view:
10
15
20
50
100
results per page
«
1
»
› More Photos (7)
› Save Listing
› Email to a friend
› Request More Info
Staten Island NY, 10302
$899,000
Misc Commercial , Sq. Ft. 3000
›
View details
ML# :3575740
297 Port Richmond Ave A 3000 Sq Ft mixed-use building with two separate streams of income. This investment property features a large 3-bedroom apartment above a commercial restaurant space presenting a fantastic investment opportunity.
Open House: - | | 297 Port Richmond Avenue, Staten Island, NY, 10302
Call Today:
(718) 848-7700, or
Email:
Mega Star Realty
Presented by:
Neuhaus Realty Inc
718-979-3400
Showing
1 - 1
of
1
results
| view:
10
15
20
50
100
results per page
«
1
»
The data relating to real estate for sale on this web site comes in part from the OneKey™ MLS. Real Estate listings held by brokerage firms other than Mega Star Realty are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers.