Vintage homes for sale & real estate in 12242, NY

89 homes

Sort:

Recommended

NEW 19 HRS AGO

ABOUT THIS HOME
Vintage Home for sale in 12242, NY:
Welcome to 184 Quail Street, a thoughtfully updated two-family home located in the heart of Albany's vibrant college area. This property offers a rare blend of modern upgrades, strong rental potential, and an unbeatable location, making it an excellent opportunity for both investors and owner-occupants. As you enter the building, you'll immediately notice the care and attention that has gone into recent renovations. Both units feature updated kitchens, appliances, Fresh paint throughout the interior gives each unit a bright, move-in-ready feel, while durable vinyl flooring runs through the building, providing both style and low-maintenance convenience. A key improvement to this property is

$229,000

6 beds3 baths1,853 sq ft

184 Quail St, Albany, NY 12203

Updated kitchens • 2,178 sq ft lot • Built 1900

Listing by NH Capital Realty

NEW 17 HRS AGO

ABOUT THIS HOME
Vintage Home for sale in 12242, NY:
A TRUE LEGACY INVESTMENT PROPERTY! SUPER RARE. This All Brick Beauty would cost multiple times the listing price to rebuild today! Own a piece of History in a very desirable area of Albany between Lark St. and Washington Park. Offers new flooring in many units, new luxury vinyl flooring in hallways and freshly painted hallways and some apartments, on street parking, large back yard, exterior maintenance person available to continue doing snow and lawn care. Walk to everything including the Capital Building, Albany Med. , Lark Street Entertainment and Restaurants, Etc. Newer rubber roof, yearly maintained and inspected heating systems, heat/hot water is included in rents and affordable due t

$675,000

6 beds6 baths3,564 sq ft

Undisclosed address, Albany, NY 12210

All brick beauty • New flooring • Large back yard

Listing by 518 Realty.Com Inc

3D WALKTHROUGH

ABOUT THIS HOME
Vintage Home for sale in 12242, NY:
Multiple Offers. Best and Final offers are due Sunday by 12PM. This legal 2-family is located in the heart of Albany's Center Square, 215 Jay is a uniquely restored historic home with over $55,000 in rental income potential. The brick facade and interior exposed brick walls showcase the historic charm, while the updated finishes offer the modern comforts - central air, walkin closets, updated bathrooms, recessed lighting, and more. The home features hardwood floors throughout, with original mantels and a clawfoot tub. The remodeled kitchen, includes updated hardwood cabinets, granite counters with an undermount sink. tiled backsplash, and stainless steal appliances, The private backyard is

$400,000

3 beds2.5 baths1,710 sq ft

215 Jay St, Albany, NY 12210

Exposed brick walls • Updated finishes • Walkin closets

Listing by Monticello

ABOUT THIS HOME
Vintage Home for sale in 12242, NY:
Three-family property offering strong upside potential for investors or rehab specialists. This building is in need of a full gut renovation and is being sold as-is. No interior access will be provided—drive-by only. Ideal for experienced buyers looking to reposition or redevelop a multi-unit asset in a convenient downtown Albany location close to schools, public transportation, and major routes. Bring your vision and unlock the potential. Cash or rehab financing only. NO INTERIOR ACCESS.

$85,000

8 beds3 baths3,234 sq ft

147 Clinton Ave, Albany, NY 12210

Close to schools • Major routes • Full gut renovation

Listing by Greenwood Realty Group of NY

ABOUT THIS HOME
Vintage Home for sale in 12242, NY:
Sale includes 65 & 67 Columbia Street. Which have one common hallway and a total of six units. #65; One 1BR, Two 2BR. #67 One 1BR, 2BR and a studio. Rent includes heat, hot water, and owner pays electric for #67 1BR apt. Needs a little TLC but fully functional.

$459,900

9 beds6 baths4,400 sq ft

65 Columbia St, Albany, NY 12210

2,613 sq ft lot • 4 parking spots • Built 1890

Listing by Heer Realty, Inc.

Property at 308 Quail St, Albany, NY 12208, 5 beds, 2 baths

$345,000

5 beds2 baths2,000 sq ft

308 Quail St, Albany, NY 12208

Listing by All in 1 Realty LLC

Property at 5 Moore St, Albany, NY 12202, 6 beds, 2 baths

$224,900

6 beds2 baths2,468 sq ft

5 Moore St, Albany, NY 12202

Listing by Wagner Real Estate Group

Property at 70 Fowler Ave, Rensselaer, NY 12144, 2 beds, 1 bath

$189,000

2 beds1 bath1,025 sq ft

70 Fowler Ave, Rensselaer, NY 12144

Listing by KW Platform

Property at 44 Clinton Ave, Albany, NY 12210, 4 beds, 3 baths

$375,000

4 beds3 baths2,834 sq ft

44 Clinton Ave, Albany, NY 12210

Listing by Berkshire Hathaway Home Services Blake

Property at 342 Madison Ave, Albany, NY 12210, 4 beds, 4 baths

$499,000

4 beds4 baths3,404 sq ft

342 Madison Ave, Albany, NY 12210

Listing by McDonald Real Estate Comp LLC

Property at 9 Pennsylvania Ave, Albany, NY 12206, 5 beds, 2 baths

$265,000

5 beds2 baths1,960 sq ft

9 Pennsylvania Ave, Albany, NY 12206

Listing by McDonald Real Estate Comp LLC

Property at 351 Sherman St, Albany, NY 12206, 2 beds, 2 baths

$219,000

2 beds2 baths1,060 sq ft

351 Sherman St, Albany, NY 12206

Listing by Empire Real Estate Firm LLC

Property at 34 Hampton St, Albany, NY 12209, 4 beds, 2 baths

$259,000

4 beds2 baths2,104 sq ft

34 Hampton St, Albany, NY 12209

Listing by Empire Real Estate Firm LLC

Property at 27 N Lake Ave, Albany, NY 12203, 6 beds, 2 baths

$329,000

6 beds2 baths2,364 sq ft

27 N Lake Ave, Albany, NY 12203

Listing by Gallup Property Group LLC

Property at 44 Pine St, Rensselaer, NY 12144, 4 beds, 2 baths

$210,000

4 beds2 baths2,026 sq ft

44 Pine St, Rensselaer, NY 12144

Listing by Miranda Real Estate Group, Inc

Property at 29 Bradford St, Albany, NY 12206, 4 beds, 1.5 baths

$159,900

4 beds1.5 baths1,504 sq ft

29 Bradford St, Albany, NY 12206

Listing by New Scotland Realty

Property at 891 Madison Ave, Albany, NY 12208, 2 beds, 2 baths

$405,000

2 beds2 baths4,489 sq ft

891 Madison Ave, Albany, NY 12208

Listing by Miranda Real Estate Group, Inc

Property at 129 Green St #1, Albany, NY 12202, 2 beds, 1 bath

$125,000

2 beds1 bath900 sq ft

129 Green St #1, Albany, NY 12202

Listing by Romeo Team Realty

Property at 87 Kent St, Albany, NY 12206, 5 beds, 2 baths

$297,000

5 beds2 baths1,784 sq ft

87 Kent St, Albany, NY 12206

Listing by Coldwell Banker Prime Properties

Property at 683 State St, Albany, NY 12203, 6 beds, 2 baths

$269,000

6 beds2 baths1,668 sq ft

683 State St, Albany, NY 12203

Listing by ADI Real Estate Services LLC

Property at 8 Catalpa Dr, Albany, NY 12209, 6 beds, 1.5 baths

$289,000

6 beds1.5 baths2,034 sq ft

8 Catalpa Dr, Albany, NY 12209

Listing by eXp Realty

Property at 340 Hamilton St, Albany, NY 12210, 1 bath

$475,000

— beds1 bath2,072 sq ft

340 Hamilton St, Albany, NY 12210

Listing by Empire Real Estate Firm LLC

Property at 79 Broad St, Albany, NY 12202, 3 beds, 1 bath

$199,900

3 beds1 bath1,364 sq ft

79 Broad St, Albany, NY 12202

Listing by CapMark Realty LLC

Property at 107 Kent St, Albany, NY 12206, 5 beds, 1.5 baths

$295,000

5 beds1.5 baths2,332 sq ft

107 Kent St, Albany, NY 12206

Listing by KW Platform

Property at 1547 5th St, Rensselaer, NY 12144, 3 beds, 1.5 baths

$195,000

3 beds1.5 baths1,192 sq ft

1547 5th St, Rensselaer, NY 12144

Listing by A 1 R E O Services LLC

Property at 72 Bassett St, Albany, NY 12202, 3 beds, 3 baths

$250,000

3 beds3 baths1,368 sq ft

72 Bassett St, Albany, NY 12202

Listing by CapMark Realty LLC

Property at 10 Putnam St, Albany, NY 12202, 6 beds, 2 baths

$385,000

6 beds2 baths2,764 sq ft

10 Putnam St, Albany, NY 12202

Listing by KW Platform

Property at 249 Quail St, Albany, NY 12203, 3 beds, 1.5 baths

$215,000

3 beds1.5 baths1,472 sq ft

249 Quail St, Albany, NY 12203

Listing by KW Platform

Property at 95 Clinton Ave, Albany, NY 12210, 4 beds, 4 baths

$320,000

4 beds4 baths3,864 sq ft

95 Clinton Ave, Albany, NY 12210

Listing by Howard Hanna Capital Inc

Property at 941 6th St St, Rensselaer, NY 12144, 3 beds, 1.5 baths

$215,000

3 beds1.5 baths1,380 sq ft

941 6th St St, Rensselaer, NY 12144

Listing by Find Advisors

Property at 70 Willett St, Albany, NY 12210, 9 beds, 8.5 baths

$830,000

9 beds8.5 baths3,438 sq ft

70 Willett St, Albany, NY 12210

Listing by KW Platform

Property at 72 3rd St, Albany, NY 12210, 6 beds, 3 baths

$79,999

6 beds3 baths1,980 sq ft

72 3rd St, Albany, NY 12210

Listing by Lombardo Homes & Estates, (516) 316-9974

Property at 343 Madison Ave, Albany, NY 12210, 6 beds, 2 baths

$350,000

6 beds2 baths2,382 sq ft

343 Madison Ave, Albany, NY 12210

Listing by Rooted Property Group LLC

Property at 98 Livingston Ave, Albany, NY 12207, 3 beds, 2 baths

$239,000

3 beds2 baths1,530 sq ft

98 Livingston Ave, Albany, NY 12207

Listing by KW Platform

Property at 206 N Pearl St #204, Albany, NY 12207, 2 beds, 2 baths

$219,900

2 beds2 baths1,266 sq ft

206 N Pearl St #204, Albany, NY 12207

Listing by Howard Hanna Capital Inc

Property at 106 Mcalpin St, Albany, NY 12209, 4 beds, 2 baths

$275,000

4 beds2 baths2,304 sq ft

106 Mcalpin St, Albany, NY 12209

Listing by Schermerhorn Realty Group LLC

Property at 189-B Quail St, Albany, NY 12203, 6 beds, 2 baths

$234,900

6 beds2 baths2,512 sq ft

189-B Quail St, Albany, NY 12203

Listing by Coldwell Banker Prime Properties

Property at 142 Chestnut St, Albany, NY 12210, 5 beds, 4 baths

$599,900

5 beds4 baths2,750 sq ft

142 Chestnut St, Albany, NY 12210

Listing by KW Platform

Property at 287 1st St, Albany, NY 12206, 4 beds, 2 baths

$150,000

4 beds2 baths2,036 sq ft

287 1st St, Albany, NY 12206

Listing by Real Broker NY LLC

Property at 206 N Pearl St Apt 102, Albany, NY 12207, 1 bed, 1 bath

$172,000

1 bed1 bath907 sq ft

206 N Pearl St Apt 102, Albany, NY 12207

Listing by Hunt ERA

Property at 399 State St Apt 803, Albany, NY 12210, 1 bed, 1 bath

$179,000

1 bed1 bath615 sq ft

399 State St Apt 803, Albany, NY 12210

Listing by Realty One Group Key

Viewing page 1 of 3

Vintage Homes for Sale in 12242

There are currently 89 vintage homes for sale in 12242. Some of these homes are "Hot Homes," meaning they're likely to sell quickly. This map is refreshed with the newest listings in 12242 every 15 minutes.

Find your dream home in 12242 using the tools above. Use filters to narrow your search by price, square feet, beds, and baths to find homes that fit your criteria. Our top-rated real estate agents in 12242 are local experts and are ready to answer your questions about properties, neighborhoods, schools, and the newest listings for sale in 12242. If you're looking to sell your home in the 12242 area, our listing agents can help you get the best price. Redfin is redefining real estate and the home buying process in 12242 with industry-leading technology, full-service agents, and lower fees that provide a better value for Redfin buyers and sellers.

More real estate resources for 12242, NY

Nearby Zip Codes

Cities

Nearby Zip Codes with Vintage Homes

Nearby Cities with Vintage Homes

More to explore in 12242, NY

How to buy a house in 12242, NY

How much house can I afford?

How to buy a house in 10 steps

First-time homebuyer's guide

See more home buying guides

Popular Markets in New York

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Why Redfin?

Community Impact

Diversity & Inclusion

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.