6-Unit Apartment
New
For Sale
Under Contract
$1,200,000
140-142 Query St, New Bedford, MA 02745
Residential Income, New Bedford, MA
Property Size6,414 SF
Lot Size0.13 Acres
Price / SF$187.09
Days on Market7
Property Features for 140-142 Query St
General Information
Property type
Residential Multi Family
Property subtype
Other
Zoning
RB
Bedrooms
12
Bathrooms
6
Full bathrooms
6
Rooms
Bedroom 12, Bedroom 10, Bathroom 1, Bathroom 4, Bathroom 3, Bedroom 5, Bedroom 8, Bedroom 1, Bedroom 7, Bedroom 2, Bedroom 11, Bedroom 9, Bathroom 2, Bedroom 3, Bathroom 6, Bedroom 4, Bedroom 6, Bathroom 5
Parking
6
Directions
Nash Rd to North on Ashley Blvd to right on Query St
Standard status
Active Under Contract
APN
2900796
Size
6,414 SF
Lot size
0.13 Acres
Taxes and HOA fees
Tax Year
2026
Tax Annual Amount
8998
Amenities
patio
storage shed
solar system
Building Details
Year built
1924
Floors in Building
5
Number of units
6
Listing Agency:
Keller Williams Realty
Listed By:
Scott Morris
(508) 238-5000
Added: Sep 29
Changed: Oct 2
Last Checked: Oct 5 at 3:06PM
MLS# 73585854
Copyright © 2026 MLS Property Information Network 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 six-unit apartment property contains 6,414 square feet, with 12 bedrooms and 6 bathrooms. Four apartments have gas hot-water baseboard heat; the two third-floor units use forced-air heat. A 54-panel solar installation produces more than 18,000 kWh annually. Exterior features include vinyl siding and gutters installed in 2022, along with a roof replaced in December 2013. The grounds also include a rear patio and storage shed.
A two-car garage is divided and rented separately. The property is approximately a two-minute drive from the Church Street Commuter Rail station and minutes from the highway. It sits on a 0.1307-acre lot and carries RB zoning.
A two-car garage is divided and rented separately. The property is approximately a two-minute drive from the Church Street Commuter Rail station and minutes from the highway. It sits on a 0.1307-acre lot and carries RB zoning.
Key Highlights
- Six apartments with 12 bedrooms and 6 bathrooms across 6,414 square feet
- 54‑panel solar system producing over 18,000 kWh annually
- Four units have gas hot‑water baseboard heat; two third‑floor units have forced‑air heat
Financial Insights
Estimated NOI and Cap Rate
NOI / Yr
$84,644
Cap Rate
7.05%
Suggested Prices Based on Cap Rates
Cap Rate 5%
$1,692,880
$1.7M
Cap Rate 7%
$1,209,200
$1.2M
Cap Rate 9%
$940,489
$940.5K
Market Conditions
NOI Build-Up for 6,414 SF
Gross rent
$165.5K $25.80/SF
− Vacancy
−$11.6K −$1.81/SF
EGI
$153.9K $23.99/SF
− OpEx
−$69.3K −$10.80/SF
NOI
$84.6K $13.20/SF
Area
New Bedford, MA
Vacancy
7.00%
Lease Rate
$25.80 /SF/Yr
Expense Ratio
45.00%
Simulate Cap Rate and NOI
Suggested Prices Based on Cap Rates
Cap Rate 5%
$1,692,880
Cap Rate 7%
$1,209,200
Cap Rate 9%
$940,489
Alternative Uses
Best Use
Apartment 5plus
$1.21M
$1.06M – $1.41M
NOI $84,644 @ 7.0% cap · market cap 7.05%
Second Best
—
—
no second resolved use
Theoretical Best
Office A
$1.89M
$1.65M – $2.21M
NOI $132,385 @ 7.0% cap · market cap 11.03%
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
6
Residential units
Yes
Highway access
Location Intelligence
Trade Area within ½ mile
906
Businesses Nearby
Explore this area
Business Placement
Demographics for 02745, MA
25,336
Population
10,649
Households
2.4
Avg Household Size
41
Median Age
20%
College-Educated
83%
High-School Grad
9.8 sq mi
ZIP Area
2,585
Density / Sq Mi
$73,154
Median Household Income
$46,978
Median Earnings
$1,104
Median Rent
$339,600
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?
Apartment building - Six residential units are complemented by a separately rented, divided garage and a rooftop solar array.
Where is this apartment building located?
The property is located at 140-142 Query St New Bedford, MA.
What is the asking price?
The asking price for this property is $1,200,000.
What are key features of this property?
This property features: Six apartments with 12 bedrooms and 6 bathrooms across 6,414 square feet; 54‑panel solar system producing over 18,000 kWh annually; Four units have gas hot‑water baseboard heat; two third‑floor units have forced‑air heat
