140-142 Query St
New Bedford, MA 02745
$1,200,000
A rare investment opportunity! Discover 140-142 Query St in New Bedford, MA, an exceptional 6-family property offering an expansive 6414 sq ft of living space w/ 12 bedrooms & 6 bathrooms. This building is in pristine condition; in fact, contractors who have worked on the property describe it as "Mint," "A Cadillac," & the "Nicest Multifamily they have ever seen." The mechanicals are significantly upgraded: 4 units feature gas hot water baseboard heat, while the two 3rd-floor units are equipped w/ forced hot air. The exterior has been meticulously maintained, featuring a roof replacement in Dec 2013, plus low-maintenance vinyl siding & new gutters installed in 2022.This property is a true standout for investors. It boasts a massive 54-panel solar system producing over 18,000 kWh annually, offering incredible energy efficiency. Outside, you'll find a patio out back, a storage shed for extra space, & a 2-car garage that is split & separately rented for additional income. Location is a major plus: situated just minutes from the highway & only a 2-minute ride to the new Church St Commuter Rail station, making it highly attractive for commuters. Don't miss your chance to add this premier, turn-key asset to your portfolio!
| Listing ID: | 73585854 |
|---|---|
| List Price: | $1,200,000 |
| Property Type: | Residential Income |
| Property Sub Type: | 5-9 Family |
| Status: | Contingent |
| Bedrooms Total: | 12 |
| Bathrooms Full: | 6 |
| Living Area: | 6,414 |
| Tax Annual Amount: | $8,998 |
| Lot Size Square Feet: | 5,693 |
| Lot Size Acres: | 0.13 |
| City: | New Bedford |
| County Or Parish: | Bristol |
| Postal Code: | 02745 |
| Year Built: | 1924 |
| Number Of Units Total: | 6 |
| Flooring: | Vinyl, Hardwood |
| Parking Features: | Paved Drive, Off Street |
| Status: | Active Under Contract |
| State Or Province: | MA |
| Water Source: | Public |
| Roof: | Shingle |
| Laundry Features: | Electric Dryer Hookup, Washer Hookup |
| Foundation Details: | Block, Stone, Brick/Mortar, Granite |
| Electric: | Circuit Breakers, 60 Amps/Less, Individually Metered |
| Listing Contract Date: | 2026-09-29 |
| Garage?: | Yes |
| Lot Size Area: | 0.13 |
| Rooms Total: | 30 |
| Bathrooms Total Integer: | 6 |
| Basement: | true |
| Basement: | Full, Interior Entry, Concrete |
| Building Area Source: | Public Records |
| Community Features: | Public Transportation, Park, Laundromat, House of Worship, Public School, T-Station |
| Interior Features: | Living Room, Dining Room, Kitchen |
| Levels: | 5 |
| Living Area Units: | Square Feet |
| Lot Size Units: | Acres |
| Open Parking?: | Yes |
| Other Structures: | Shed(s) |
| Parcel Number: | 2900796 |
| Patio And Porch Features: | Porch, Deck - Roof, Deck - Composite, Patio |
| Road Frontage Type: | Public |
| Sewer: | Public Sewer |
| Utilities: | for Gas Range, for Electric Range, for Electric Oven, for Electric Dryer, Washer Hookup |
| Zoning: | RB |
| Covered Spaces: | 2 |
| Garage Spaces: | 2 |
| Stories Total: | 5 |
| Year Built Source: | Public Records |
| Farm Land Area Units: | Square Feet |
| Gross Income: | $68,400 |
| Apod Available: | Yes |
| Color: | Gray |
| Disclosure: | Yes |
| Dpr Flag: | No |
| Flrs 1: | 1 |
| Flrs 2: | 2 |
| Flrs 3: | 3 |
| Flrs 4: | 2 |
| Lead Paint: | None, Certified Treated |
| Lease 1: | Yes |
| Lease 2: | Yes |
| Lease 3: | Yes |
| Lease 4: | Yes |
| Levels 1: | 1 |
| Levels 2: | 1 |
| Levels 3: | 1 |
| Levels 4: | 1 |
| Listing Alert: | No |
| List Price Per Sqft: | $187.09 |
| Page: | 319 |
| Price Per Sqft: | $187.09 |
| Square Feet Incl Base: | No |
| Uffi: | Unknown |
| Net Operating Income: | $68,400 |
| Original List Price: | $1,200,000 |
| Parking Total: | 6 |
| Tax Assessed Value: | $651,300 |
| Tax Year: | 2026 |
| Total Actual Rent: | $4,500 |
| Year Built Details: | Actual |
| Waterview Flag: | No |
| Building Area Total: | 6,414 |
| Bedrms 1: | 2 |
| Bedrms 2: | 2 |
| Bedrms 3: | 2 |
| Bedrms 4: | 2 |
| F Bths 1: | 1 |
| F Bths 2: | 1 |
| F Bths 3: | 1 |
| F Bths 4: | 1 |
| Hot Water: | Natural Gas, Electric, Tank, Tankless |
| Above Grade Finished Area: | 6,414 |
| Open Parking Spaces: | 4 |
| Living Area Source: | Public Record |
| Power Production Annual: | 18198 |
| Rent1: | 1,000 |
| Power Production Annual Status: | B |
| Rent2: | 1,000 |
| Rent3: | 1,300 |
| Power Production Size: | 15.39 |
| Rent4: | 1,200 |
| Power Production Year Install: | 2016 |
| Total Flrs: | 11 |
| Power Production Type: | A |
| Beachfront Flag: | No |
Listing Courtesy of: Keller Williams Realty
Listing Agent: Stephen Medeiros
Mortgage Calculator
The property listing data and information, or the Images, set forth herein were provided to MLS Property Information Network, Inc. from third party sources, including sellers, lessors, landlords and public records, and were compiled by MLS Property Information Network, Inc. The property listing data and information, and the Images, are for the personal, non-commercial use of consumers having a good faith interest in purchasing, leasing or renting listed properties of the type displayed to them and may not be used for any purpose other than to identify prospective properties which such consumers may have a good faith interest in purchasing, leasing or renting. MLS Property Information Network, Inc. and its subscribers disclaim any and all representations and warranties as to the accuracy of the property listing data and information, or as to the accuracy of any of the Images, set forth herein.
MLS Property Information Network, Inc. data last updated on October 08, 2026 04:46 PM - ET
Property Last Updated: October 08, 2026 04:46 PM - ET






































