Two-Unit Duplex with Detached
New
For Sale
$299,000
4 Sparkill Avenue, Albany, NY 12209
MultiFamily, Albany, NY
Property Size2,484 SF
Lot Size0.17 Acres
Price / SF$120.37
Days on Market3
Property Features for 4 Sparkill Avenue
General Information
Property type
Residential Multi Family
Property subtype
Duplex
Bedrooms
5
Bathrooms
2
Full bathrooms
2
Rooms
Bathroom 2, Bedroom 5, Bathroom 1, Bedroom 4, Bedroom 1, Bedroom 2, Bedroom 3
Parking
2
Parking features
Garage, Driveway
Patio and Porch features
Porch
Basement
Unfinished
Lot features
Level, Cleared
High school
Albany
Elementary school district
Albany
Middle school district
Albany
High school district
Albany
Directions
Kenwood to Delaware Ave.
Standard status
Active
APN
010100 75.76-1-31
Size
2,484 SF
Lot size
0.17 Acres
Taxes and HOA fees
Tax Annual Amount
6383
Utilities
Sewer type
Public Sewer
Heating system
Hot Water(Heating), Natural Gas
Water source
Public
Building Details
Year built
1925
Number of units
2
Flooring type
Tile, Hardwood, Carpet
Building materials
Aluminum Siding
Roof type
Asphalt
Architectural style
Other
Listing Agency:
Gabler Realty LLC
(518) 935-4800
Listed By:
Christina A Center · License #40CE1129368
(518) 573-5635
Added: Sep 16
Changed: Sep 18
Last Checked: Sep 18 at 12:06PM
MLS# 202626300
Copyright © 2026 Global MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
Investment Insights
Based on property information with market context.
This 1925 duplex contains two separate residences totaling 2,484 square feet. The first-floor unit offers two bedrooms and one bathroom, while the upper unit includes three bedrooms and one bathroom. Both apartments have living and dining areas, updated kitchens with newer cabinetry and appliances, pantry storage, and recently refinished hardwood floors. One bedroom includes a walk-in closet.
Exterior features include a front sitting porch, fenced backyard, oversized driveway, detached two-car garage, and an additional vacant lot included with the property. Improvements include newer electrical components, newer hot water heaters, and a newer natural-gas boiler serving one unit. The property has aluminum siding, an asphalt roof, public water, and public sewer. Tile, carpet, and hardwood flooring are present throughout the building. Bus-line access, shopping, dining, a library, and a theater are located nearby.
Exterior features include a front sitting porch, fenced backyard, oversized driveway, detached two-car garage, and an additional vacant lot included with the property. Improvements include newer electrical components, newer hot water heaters, and a newer natural-gas boiler serving one unit. The property has aluminum siding, an asphalt roof, public water, and public sewer. Tile, carpet, and hardwood flooring are present throughout the building. Bus-line access, shopping, dining, a library, and a theater are located nearby.
Key Highlights
- Two‑unit duplex totaling 2,484 square feet
- First‑floor 2‑bedroom unit and second‑floor 3‑bedroom unit
- Updated kitchens with newer cabinets, appliances, and pantry storage
Financial Insights
Estimated NOI and Cap Rate
NOI = area × lease_rate × (100 − vacancy) / 100 × (1 − expense_ratio). Net Operating Income — what the owner takes home each year before mortgage payments and income tax. Effective rent (asking rent minus vacancy losses) minus operating costs (taxes, insurance, maintenance, management).
NOI / Yr
$25,374
Cap rate = NOI / list price × 100. Capitalization rate — annual return on a fully cash purchase, before financing. NOI divided by price. Higher means more income per dollar invested, but usually also more risk or older condition. 5–8% is typical for stabilized commercial property; double digits often signal distressed deals.
Cap Rate
8.49%
Suggested Prices Based on Cap Rates
Cap rates vary significantly by property type, market, and asset quality.
Typical U.S. stable-market ranges:
Multifamily — 4.5% to 6.5% (Class A in primary markets often sub-5%; Class C in secondary markets 6%+)
Industrial / Logistics — 5.0% to 7.0% (compressed heavily in recent years due to e-commerce demand)
Office — 6.5% to 9%+ (wide spread post-2020; CBD Class A vs. suburban Class B varies dramatically)
Retail — 5.5% to 8.5% (grocery-anchored on the low end, unanchored strip centers higher)
Hospitality / Hotels — 7.5% to 10%+ (higher due to operational risk)
Self-Storage — 5.5% to 7.5%
Medical Office — 6.0% to 7.5%
Net Lease (single tenant, credit) — 5.0% to 7.0% depending on tenant credit and lease term
Rules of thumb:
Primary markets (NYC, SF, LA, Boston, DC) trade at lower cap rates than secondary/tertiary markets, often by 100–200 bps (bps, aka basis points; 1 bp = 0.01%).
Class A assets trade ~50–150 bps tighter than Class B, and Class B tighter than Class C.
Cap rates move inversely with price — a lower cap rate means a higher price for the same NOI.
Spread to the 10-year Treasury is a common benchmark; historically 200–400 bps over the 10-year.
Cap Rate 5%
$507,480
$507.5K
Cap Rate 7%
$362,486
$362.5K
Cap Rate 9%
$281,933
$281.9K
Market Conditions
NOI Build-Up for 2,484 SF
Vacancy — income lost from leasable area expected to sit empty during the year, subtracted from gross rent.
EGI (Effective Gross Income) — gross rent minus vacancy losses, the realistic income before paying operating costs.
OpEx (Operating Expenses) — recurring costs to operate the property (property tax, insurance, utilities, maintenance, management); excludes financing and capital improvements.
NOI (Net Operating Income) — income a property generates after operating costs but before financing and taxes.
Gross rent
$49.2K $19.80/SF
− Vacancy
−$3.0K −$1.23/SF
EGI
$46.1K $18.57/SF
− OpEx
−$20.8K −$8.36/SF
NOI
$25.4K $10.21/SF
Area
Albany, NY
Vacancy
6.20%
Lease Rate
$19.80 /SF/Yr
Expense Ratio
45.00%
Simulate Cap Rate and NOI
Suggested Prices Based on Cap Rates
Cap rates vary significantly by property type, market, and asset quality.
Typical U.S. stable-market ranges:
Multifamily — 4.5% to 6.5% (Class A in primary markets often sub-5%; Class C in secondary markets 6%+)
Industrial / Logistics — 5.0% to 7.0% (compressed heavily in recent years due to e-commerce demand)
Office — 6.5% to 9%+ (wide spread post-2020; CBD Class A vs. suburban Class B varies dramatically)
Retail — 5.5% to 8.5% (grocery-anchored on the low end, unanchored strip centers higher)
Hospitality / Hotels — 7.5% to 10%+ (higher due to operational risk)
Self-Storage — 5.5% to 7.5%
Medical Office — 6.0% to 7.5%
Net Lease (single tenant, credit) — 5.0% to 7.0% depending on tenant credit and lease term
Rules of thumb:
Primary markets (NYC, SF, LA, Boston, DC) trade at lower cap rates than secondary/tertiary markets, often by 100–200 bps (bps, aka basis points; 1 bp = 0.01%).
Class A assets trade ~50–150 bps tighter than Class B, and Class B tighter than Class C.
Cap rates move inversely with price — a lower cap rate means a higher price for the same NOI.
Spread to the 10-year Treasury is a common benchmark; historically 200–400 bps over the 10-year.
Cap Rate 5%
$507,480
Cap Rate 7%
$362,486
Cap Rate 9%
$281,933
Alternative Uses
Best Use
Multifamily LT 5
$404.1K
$353.6K – $471.5K
NOI $28,289 @ 7.0% cap · market cap 9.46%
Second Best
Apartment 5plus
$362.5K
$317.2K – $422.9K
NOI $25,374 @ 7.0% cap · market cap 8.49%
Theoretical Best
Office A
$655.4K
$573.4K – $764.6K
NOI $45,875 @ 7.0% cap · market cap 15.34%
Zoning and permitted uses should be independently verified with authorities.
Property Analytics
Unlock full access to Insights
Subscribe to Realmo Intelligence
Open Analytics
Current Use
Lease Details
2
Residential units
Yes
Paved road access
Location Intelligence
Trade Area within ½ mile
516
Businesses Nearby
Explore this area
Business Placement
Demographics for 12209, NY
10,231
Population
4,768
Households
2.1
Avg Household Size
37
Median Age
46%
College-Educated
88%
High-School Grad
2.2 sq mi
ZIP Area
4,650
Density / Sq Mi
$81,642
Median Household Income
$51,848
Median Earnings
$1,165
Median Rent
$200,800
Median Home Value
Check the figures for this property
Cap Rate, Value Estimation, Potential NOI and more
View Realmo Analytics
Market
Vacancy Rate% for Multifamily in Northeast region
Questions? Ask Rey
Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.
Frequently Asked Questions
What type of property is this?
Duplex - Well-maintained duplex with updated kitchens, hardwood flooring, private outdoor space, and convenient bus-line access.
Where is this duplex located?
The property is located at 4 Sparkill Avenue Albany, NY.
What is the asking price?
The asking price for this property is $299,000.
What are key features of this property?
This property features: Two‑unit duplex totaling 2,484 square feet; First‑floor 2‑bedroom unit and second‑floor 3‑bedroom unit; Updated kitchens with newer cabinets, appliances, and pantry storage
