Ipswich Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Active

510 Newburyport Turnpike Rowley. MA 01969

$1,499,000

Single Family

4 Bedrooms

2.5 Bathrooms

3,700 sq ft

5 Parking Spots

2.04 Acres

Built in 2024

Osprey Court, Rowley’s newest premier six-lot subdivision, crafted by a renowned local builder, is a testament to luxury. Each lot, spanning two+ acres, is located on a quiet cul-de-sac off Route 1, offering easy access to highways, shopping, and restaurants. This beautiful spec home is ready for you, or you can design your dream home on one of the two remaining lots. All new homes, starting at 1.5 MM, are a sight to behold. Our homes, a showcase of high-quality finishes, feature gourmet kitchens, hardwood flooring throughout, coffered ceilings, custom built-ins, crown molding, wainscotting, custom-built benches and cubbies in the mudroom, custom-built fireplace mantels, and professional landscaping by architect Lori Johnson. With no expenses spared, these homes offer a level of detail and quality that is unmatched in New England.

This listing has been viewed 10 times in the past 14 days

Last Updated: November 7th, 2024 at 8:13am

Walk/jog Trails

Conservation Area

Highway Access

House Of Worship

Public School

Shopping

Golf

Park

Medical Facility

Bike Path

Public Transportation

Tennis Court(s)

Stable(s)

Marina

Private School

Sidewalks

General Information for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Property TypeResidential

Property Sub TypeResidential

Price$1,499,000

Price per sqft$405.14

MLS #73308954

Handicap Access / FeaturesNo

List Date2024-11-01

List Price$1,499,000

Special Listing ConditionsNo

Specific Zoning Code00

StateMassachusetts

Street NameNewburyport Turnpike

Style

TownRowley

CityRowley

Zip Code01969

CountyEssex

StatusActive

MLS Status

AssociationNo

Covered Parking Spaces3

Energy FeaturesNo

Heating Y/NYes

Heating System

Heat Zones2

Attached/DetachedYes

Sold Date

Green Energy EfficientThermostat

Green Energy Generation

Property C TypeResidential

Property Sub TypeResidential

C_SType_TempSingle Family

Property C StyleDetached

Building Area SourceOwner

Building Area Total3700

Building Area Units0

CarportNo

Close Date

Close Price$0

Covered Parking Spaces3

Listing ServiceEntry Only

UnparsedAddress510 Newburyport Turnpike, Rowley MA 01969

Zoning

Interior Features for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Master BathYes

* Approx. Living Area Total3,700 sq ft

Living Area Includes BasementNo

* Living Area Source4

Bedrooms4

* # Fireplaces1

Bathrooms (Total)2.5

Full Baths2

* # Half Baths1

* # Rooms

Basement

* CoolingNo

Heating System

AppliancesNo

Air ConditioningNo

* CoolingNo

Energy FeaturesNo

Electric

Living Area DisclosureAdditional 1550 SF walk-up attic space can be fini

Living Area Includes BasementNo

Door FeaturesInsulated Doors

ElectricYes

Electric$0

MLS Area (Major)

OffMarketDate

6 Lot Custom Home-Sub Division

Exterior Features for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

* Approximate Lot Size2.04 acres

Covered Parking Spaces3

Lot FeaturesCul-de-sac, Other

* Parking Spaces5

* Sewer Utilities

* Water Utilities

* Year Built2024

Year Built Details

Year Built SourceBuilder

Year Built Effective

Construction MaterialsFrame

Exterior Features

Foundation Area

Foundation MaterialsConcrete Perimeter

Approx. Street Frontage150.00

Horse PermittedNo

Horse Amenities

Parking Features

Utilities

Lot Size (Square Feet)89,000 Sqft

Disclosures for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Buyer Agent Compensation2

Contingency

FinancingNo

Disclosures

Documents AvailableNo

Exclusions

For Sale By OwnerNo

MLSPIN_COMP_BASED_ON

MLSPIN_COOP_COMP

MLSPIN_DISCLOSUREN

Lead PaintNone

Living Area DisclosureAdditional 1550 SF walk-up attic space can be fini

Living Area Includes BasementNo

Senior Community

Short Sale / Foreclosure (bank owned)No

Facilitator Compensation

TransactionBrokerCompensationType

BuyerAgencyCompensationType%

Financial Information for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Association Fee$0

Association Fee Frequency

Associaton Fee IncludesNo

AssociationNo

Assessed Value

Real Estate Tax$0

Tax Year

MLSPIN_SOLD_PRICE_PER_SQFT$0

OriginalListPrice$1,499,000

Lifestyle Information for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Association AmenitiesNo

FireplaceYNNo

Frontage Type

GarageYNNo

Waterview

Pool FeaturesNo

PoolPrivateYNNo

SeniorCommunityYN

Waterfront Features1 To 2 Mile To Beach, Beach Front

Location information for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Elementary School

Middle School

High School

Neighborhood/Sub-Division6 Lot Custom Home-Sub Division

Neighborhood (WPL, not MLS)Ipswich

Marketing History for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

MLSPIN_MARKET_TIME_BROKER5

MLSPIN_MARKET_TIME_PROPERTY5

PurchaseContractDate

Agent Information for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Agent NameEdmund Wong

Agent MLS IDBB805141

Agent Phone #617-913-1460

Agent Phone Area

Office NameNew Year Realty

Office Phone339-400-8007

Office Phone Area

Office MLS IDAN1076

Buyer Agent MLS ID

Buyer Office MLS ID

Team Members

Payment Calculator

, Interest

Property Taxes $0

Principal & Interest 9236.36

HOA Dues $0

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

Edmund Wong

New Year Realty

Agent Phone

(617) 913-1460

Office Phone

(339) 400-8007

Text Agent Call Agent Call Office

Array
(
    [id] => 561140
    [kind] => 0
    [deleted] => 0
    [mls_id] => 73308954
    [mls_id_num] => 73308954
    [parent] => 0
    [pic_numb] => 6
    [user_id] => 1
    [listing] => 9
    [property_type] => 23
    [location1_id] => 254
    [location2_id] => 6026
    [location3_id] => 12
    [location4_id] => 217
    [location5_id] => 7153
    [location6_id] => 0
    [location7_id] => 0
    [location1_name] => United States
    [location2_name] => Massachusetts
    [location3_name] => Essex
    [location4_name] => Rowley
    [location5_name] => 6 Lot Custom Home-Sub Division
    [location6_name] => 
    [location7_name] => 
    [show_address] => 1
    [neighborhood_id] => 0
    [neighborhood_ids] => [0]
    [show_marker] => 2
    [price] => 1499000
    [price_unit] => 260
    [price_si] => 1499000
    [price_max] => 0
    [price_max_si] => 0
    [price_period] => 0
    [bedrooms] => 4
    [bedrooms_max] => 0
    [rooms] => 10
    [rooms_max] => 0
    [bathrooms] => 2.5
    [bathrooms_max] => 0
    [living_area] => 3700
    [living_area_unit] => 1
    [living_area_si] => 344.1
    [living_area_max] => 0
    [living_area_max_si] => 0
    [lot_area] => 2.04
    [lot_area_unit] => 1
    [lot_area_si] => 0.18972
    [lot_area_max] => 0
    [lot_area_max_si] => 0
    [googlemap_lt] => 42.72940700
    [googlemap_ln] => -70.90583600
    [geopoints] => ���������7��Q��<e5]]E@
    [finalized] => 1
    [add_date] => 2024-11-02 09:03:28
    [last_finalize_date] => 2024-11-07 08:13:46
    [expire_days] => 0
    [confirmed] => 1
    [expired] => 0
    [build_year] => 2024
    [zip_id] => 12904
    [zip_name] => 01969
    [last_modified_time_stamp] => 2024-11-12 23:05:55
    [post_code] => 
    [meta_description] => 4 Bedrooms Bedrooms 10 Rooms Rooms With 2.5 Bathrooms Bathrooms Residential For Sale Newburyport Turnpike In 510 Newburyport Turnpike, Rowley, Massachusetts 01969
    [meta_description_manual] => 0
    [meta_keywords] => 510 Newburyport Turnpike, Rowley, Massachusetts 01969, 4 Bedrooms Bedrooms, 10 Rooms Rooms,2.5 BathroomsBathrooms,Residential,For Sale,Newburyport Turnpike,73308954
    [meta_keywords_manual] => 0
    [street_no] => 510
    [sp_featured] => 0
    [sp_hot] => 0
    [sp_openhouse] => 0
    [sp_forclosure] => 0
    [textsearch] => Property Description Osprey Court, Rowley’s newest premier six-lot subdivision, crafted by a renowned local builder, is a testament to luxury. Each lot, spanning two+ acres, is located on a quiet cul-de-sac off Route 1, offering easy access to highways, shopping, and restaurants. This beautiful spec home is ready for you, or you can design your dream home on one of the two remaining lots. All new homes, starting at 1.5 MM, are a sight to behold. Our homes, a showcase of high-quality finishes, feature gourmet kitchens, hardwood flooring throughout, coffered ceilings, custom built-ins, crown molding, wainscotting, custom-built benches and cubbies in the mudroom, custom-built fireplace mantels, and professional landscaping by architect Lori Johnson. With no expenses spared, these homes offer a level of detail and quality that is unmatched in New England.\n Property Type Residential Listing Type For Sale Ref ID a3e4d2c6436d20ddf86bdbb5afc582f2 Full Bathrooms 2 Full Bathrooms two Status Active Property Category Residential Property Type Single Family C_Style Detached Zipcode 01969 Office Name New Year Realty Agent MLSID BB805141 Office Phone 339-400-8007 Agent Phone 617-913-1460 AttachedGarageYN 1 AttachedGarageYN one CoolingYN 1 CoolingYN one ParkingTotal 5 ParkingTotal five UnparsedAddress 510 Newburyport Turnpike, Rowley MA 01969 OpenParkingYN 1 OpenParkingYN one BRE_Total_Parking 8 BRE_Total_Parking eight  510 newburyport turnpike rowley massachusetts 01969 
    [location_text] => 510 Newburyport Turnpike, Rowley, Massachusetts 01969
    [field_42] => Newburyport Turnpike
    [field_312] => Residential For Sale - 10 Rooms - 4 Bedrooms - 2.5 Bathrooms - Price $
    [field_313] => Residential For Sale
    [field_308] => Osprey Court, Rowley’s newest premier six-lot subdivision, crafted by a renowned local builder, is a testament to luxury. Each lot, spanning two+ acres, is located on a quiet cul-de-sac off Route 1, offering easy access to highways, shopping, and restaurants. This beautiful spec home is ready for you, or you can design your dream home on one of the two remaining lots. All new homes, starting at 1.5 MM, are a sight to behold. Our homes, a showcase of high-quality finishes, feature gourmet kitchens, hardwood flooring throughout, coffered ceilings, custom built-ins, crown molding, wainscotting, custom-built benches and cubbies in the mudroom, custom-built fireplace mantels, and professional landscaping by architect Lori Johnson. With no expenses spared, these homes offer a level of detail and quality that is unmatched in New England.
    [field_7] => 0
    [n_103] => 
    [n_103_distance] => 
    [n_103_distance_by] => 
    [n_105] => 
    [n_105_distance] => 
    [n_105_distance_by] => 
    [n_107] => 
    [n_107_distance] => 
    [n_107_distance_by] => 
    [n_108] => 
    [n_108_distance] => 
    [n_108_distance_by] => 
    [n_109] => 
    [n_109_distance] => 
    [n_109_distance_by] => 
    [f_130_options] => ,3,6,46,
    [f_130] => 1
    [f_131_options] => ,7,
    [f_131] => 1
    [f_132_options] => 
    [f_132] => 
    [f_133_options] => 
    [f_133] => 
    [f_134_options] => ,4,
    [f_134] => 1
    [f_136_options] => 
    [f_136] => 
    [f_137_options] => ,0,
    [f_137] => 1
    [f_138_options] => 
    [f_138] => 
    [f_139_options] => 
    [f_139] => 
    [f_140_options] => ,6,
    [f_140] => 1
    [f_141_options] => 
    [f_141] => 
    [f_144_options] => ,20,
    [f_144] => 1
    [f_146_options] => 
    [f_146] => 
    [f_147_options] => ,7,
    [f_147] => 1
    [f_149_options] => 
    [f_149] => 
    [f_150_options] => ,19,16,
    [f_150] => 1
    [f_151_options] => 
    [f_151] => 
    [f_152_options] => 
    [f_152] => 
    [f_156_options] => 
    [f_156] => 
    [f_157_options] => 
    [f_157] => 
    [f_159_options] => 
    [f_159] => 
    [f_161_options] => 
    [f_161] => 
    [f_163_options] => 
    [f_163] => 
    [f_165_options] => 
    [f_165] => 
    [f_166_options] => 
    [f_166] => 
    [ref_id] => a3e4d2c6436d20ddf86bdbb5afc582f2
    [field_54] => 
    [half_bathrooms] => 1
    [half_bathrooms_max] => 0
    [field_55] => 0
    [rendered] => {"rendered":{"313":{"field_id":"313","type":"text","name":"Property Title","value":"Residential For Sale"},"312":{"field_id":"312","type":"text","name":"Property Page Title","value":"Residential For Sale - 10 Rooms - 4 Bedrooms - 2.5 Bathrooms - Price $"},"3":{"field_id":"3","type":"property_types","name":"Property Type","value":"Residential"},"2":{"field_id":"2","type":"listings","name":"Listing Type","value":"For Sale"},"55":{"field_id":"55","type":"number","name":"Floor Number","value":"0"}},"materials":{"field_313":{"field_id":"313","type":"text","name":"Property Title","value":"Residential For Sale"},"field_312":{"field_id":"312","type":"text","name":"Property Page Title","value":"Residential For Sale - 10 Rooms - 4 Bedrooms - 2.5 Bathrooms - Price $"},"property_type":{"field_id":"3","type":"property_types","name":"Property Type","value":"Residential"},"listing":{"field_id":"2","type":"listings","name":"Listing Type","value":"For Sale"},"field_55":{"field_id":"55","type":"number","name":"Floor Number","value":"0"}},"location_text":"510 Newburyport Turnpike, Rowley, Massachusetts 01969"}
    [alias] => Single-Family-510-Newburyport-Turnpike-Rowley-Massachusetts-01969-73308954-USD1-499-000
    [source] => mls
    [last_sync_date] => 2024-11-07 08:13:21
    [street_suffix] => 
    [energy_tag] => 
    [mls_server_id] => 3
    [mls_class_id] => Property
    [mls_query_id] => 9
    [field_2111] => New Year Realty
    [field_2112] => Edmund Wong
    [construnction_stage] => 
    [sys_complex_name] => 
    [sys_neighborhood_name] => 
    [field_3000] => BB805141
    [field_3001] => AN1076
    [listing_status] => 2
    [field_3052] => 
    [field_3054] => 
    [field_3071] => 5
    [field_3072] => 0
    [field_3074] => 
    [field_3075] => 2024-11-06 20:36:00
    [f_3102_options] => ,19,30,
    [f_3102] => 1
    [field_3103] => 
    [field_3164] => 0
    [field_3092] => 
    [field_3169] => 510 Newburyport Turnpike
    [field_3171] => 339-400-8007
    [field_3172] => 617-913-1460
    [field_3173] => 
    [field_3174] => 
    [field_3175] => 0
    [field_3176] => 2
    [field_3177] => 
    [field_3180] => 
    [field_3181] => 0
    [field_3191] => 0
    [field_3192] => 5
    [field_3212] => 0
    [field_3217] => 0
    [field_3219] => 
    [field_3227] => 
    [field_3233] => 
    [field_3235] => 
    [field_3236] => 2
    [f_3238_options] => ,2,
    [f_3238] => 1
    [field_3240] => 510 Newburyport Turnpike, Rowley MA 01969
    [f_3247_options] => ,18,
    [f_3247] => 1
    [field_3296] => 0
    [field_3298] => 6
    [field_3299] => 2
    [field_3300] => 17
    [field_3302] => 
    [field_3185] => 2
    [field_3186] => 1
    [field_3301] => 0
    [field_3306] => 0
    [field_3306_si] => 0
    [field_3306_unit] => 260
    [fly_field] => 
    [fly_value] => 
    [field_3120] => 
    [field_3055] => 
    [field_3056] => 0
    [field_3056_si] => 0
    [field_3056_unit] => 260
    [field_3311] => 8
    [att_numb] => 0
    [sent_numb] => 0
    [contact_numb] => 0
    [inc_in_listings_numb] => 25
    [visit_time] => 9
    [visit_date] => 2024-11-12 23:05:55
    [vids_numb] => 0
    [f_3002_options] => ,18,
    [f_3002] => 1
    [f_3003_options] => ,74,0,37,2,4,1,15,65,
    [f_3003] => 1
    [field_3004] => 
    [field_3005] => 
    [f_3006_options] => ,4,0,3,
    [f_3006] => 1
    [f_3007_options] => ,0,
    [f_3007] => 1
    [f_3008_options] => ,0,
    [f_3008] => 1
    [f_3009_options] => ,67,
    [f_3009] => 1
    [f_3010_options] => ,11,
    [f_3010] => 1
    [field_3011] => 0
    [field_3011_si] => 0
    [field_3011_unit] => 260
    [field_3017] => 
    [field_3018] => 6
    [field_3019] => 2024-11-02 03:05:39
    [field_3020] => 12
    [field_3021] => Owner,Accompanied Showings,Appointment Required,Ot
    [field_3022] => 
    [field_3023] => 0
    [field_3023_si] => 0
    [field_3023_unit] => 260
    [field_3024] => 9999
    [f_3025_options] => ,0,
    [f_3025] => 1
    [field_3027] => 
    [field_3028] => 9
    [field_3029] => 0
    [field_3032] => 00
    [field_3039] => Newburyport Turnpike is route 1 - GPS address is 5
    [field_3043] => 
    [field_3045] => 0
    [field_3045_si] => 0
    [field_3045_unit] => 260
    [f_3046_options] => ,43,
    [f_3046] => 1
    [field_3058] => 
    [field_3060] => 
    [field_3069] => 405.14
    [field_3069_si] => 405.14
    [field_3069_unit] => 260
    [field_3079] => 2024-11-06 20:12:00
    [field_3080] => 
    [field_3089] => 
    [field_3094] => 0
    [field_3094_si] => 0
    [field_3094_unit] => 260
    [field_3095] => 510
    [field_3096] => 
    [field_3097] => 
    [field_3098] => 
    [field_3105] => 
    [field_3109] => 1
    [field_3112] => 2
    [field_3113] => 
    [field_3114] => 
    [field_3115] => 
    [field_3116] => 
    [field_3118] => 0
    [field_3118_si] => 0
    [field_3118_unit] => 260
    [field_3119] => 
    [field_3121] => 
    [field_3122] => 
    [field_3123] => 
    [f_3125_options] => ,0,
    [f_3125] => 1
    [field_3126] => 
    [field_3131] => 2
    [field_3134] => 0
    [field_3135] => 
    [field_3136] => 
    [field_3140] => 
    [field_3145] => 
    [field_3151] => 
    [field_3156] => Additional 1550 SF walk-up attic space can be fini
    [f_3166_options] => ,94,
    [f_3166] => 1
    [field_3168] => 0
    [field_3168_si] => 0
    [field_3168_unit] => 260
    [field_3178] => 0
    [field_3179] => 
    [field_3182] => 4
    [field_3183] => 3700
    [field_3184] => 0
    [field_3187] => 
    [f_3188_options] => ,11,5,14,7,0,15,6,8,10,1,2,3,16,17,4,20,
    [f_3188] => 1
    [field_3189] => 0
    [field_3189_si] => 0
    [field_3189_unit] => 260
    [f_3190_options] => ,0,
    [f_3190] => 1
    [field_3193] => 3
    [field_3194] => 
    [f_3195_options] => ,19,
    [f_3195] => 1
    [f_3196_options] => ,40,
    [f_3196] => 1
    [field_3197] => 
    [f_3198_options] => ,0,
    [f_3198] => 1
    [field_3199] => 
    [field_3200] => 0
    [field_3200_si] => 0
    [field_3200_unit] => 260
    [field_3201] => 
    [field_3202] => 
    [field_3203] => 
    [field_3204] => 
    [field_3205] => 1900-01-01
    [field_3206] => 0
    [f_3207_options] => ,10,
    [f_3207] => 1
    [field_3208] => 0
    [field_3209] => Concrete Perimeter
    [field_3210] => 150.00
    [field_3211] => 3
    [field_3213] => 
    [field_3214] => Thermostat
    [field_3215] => 
    [field_3216] => 0
    [field_3216_si] => 0
    [field_3216_unit] => 260
    [field_3218] => 
    [field_3220] => 0
    [field_3220_si] => 0
    [field_3220_unit] => 260
    [field_3221] => 
    [field_3222] => Facilitation/Exclusive
    [field_3223] => 2024-11-01
    [field_3224] => Entry Only
    [f_3225_options] => ,10,5,
    [f_3225] => 1
    [field_3226_si] => 8277
    [field_3226_unit] => 1
    [field_3228] => 
    [field_3229] => 
    [field_3230] => 0
    [field_3230_si] => 0
    [field_3230_unit] => 260
    [field_3231] => 1499000
    [field_3231_si] => 1499000
    [field_3231_unit] => 260
    [field_3232] => 
    [field_3234] => 
    [field_3237] => 
    [field_3239] => 
    [field_3241] => 0
    [field_3241_si] => 0
    [field_3241_unit] => 260
    [field_3242] => 
    [field_3243] => Under Construction
    [field_3244] => 
    [field_3245] => Builder
    [field_3246] => 
    [field_3248] => 2024-11-02 03:05:00
    [field_3249] => 
    [field_3250] => 
    [field_3251] => 
    [field_3252] => 
    [field_3253] => 
    [field_3254] => 
    [field_3255] => 
    [field_3256] => 
    [field_3257] => 
    [field_3258] => 
    [field_3259] => 
    [field_3260] => N
    [field_3261] => 
    [field_3262] => 
    [field_3263] => 
    [field_3264] => 
    [field_3265] => 0
    [field_3265_si] => 0
    [field_3265_unit] => 260
    [field_3266] => 0
    [field_3266_si] => 0
    [field_3266_unit] => 260
    [field_3267] => 
    [field_3268] => 
    [field_3269] => 
    [field_3270] => 
    [field_3271] => 
    [field_3272] => None
    [field_3273] => 
    [field_3274] => 
    [field_3275] => 
    [field_3276] => 
    [field_3277] => AN1076
    [field_3278] => 
    [field_3279] => 
    [field_3280] => 5
    [field_3281] => 0
    [field_3281_si] => 0
    [field_3281_unit] => 260
    [field_3282] => 0
    [field_3282_si] => 0
    [field_3282_unit] => 260
    [field_3283] => 
    [field_3284] => 
    [field_3285] => 0
    [field_3285_si] => 0
    [field_3285_unit] => 260
    [field_3286] => 
    [field_3287] => 
    [field_3288] => 
    [field_3289] => 
    [field_3290] => 405.14
    [field_3290_si] => 405.14
    [field_3290_unit] => 260
    [field_3291] => 
    [field_3292] => 0
    [field_3292_si] => 0
    [field_3292_unit] => 260
    [field_3293] => 0
    [field_3293_si] => 0
    [field_3293_unit] => 260
    [field_3294] => 
    [field_3295] => 0
    [field_3297] => 
    [field_3303] => 
    [f_3304_options] => ,22,
    [f_3304] => 1
    [f_3305_options] => ,12,
    [f_3305] => 1
    [field_3307] => 
    [field_3308] => 
    [field_3309] => 
    [field_3310] => 
    [field_3226] => 89000
)

Array
(
    [property_type] => Array
        (
            [field_id] => 3
            [type] => property_types
            [name] => Property Type
            [value] => Residential
        )

[field_3236] => Array
        (
            [field_id] => 3236
            [type] => select
            [name] => PropertySubType
            [value] => Single Family Residence
        )

[listing] => Array
        (
            [field_id] => 2
            [type] => listings
            [name] => Listing Type
            [value] => For Sale
        )

[field_3176] => Array
        (
            [field_id] => 3176
            [type] => number
            [name] => Full Bathrooms
            [value] => 2
        )

[field_3175] => Array
        (
            [field_id] => 3175
            [type] => select
            [name] => Status
            [value] => Active
        )

[field_3299] => Array
        (
            [field_id] => 3299
            [type] => select
            [name] => Property Category
            [value] => Residential
        )

[field_3298] => Array
        (
            [field_id] => 3298
            [type] => select
            [name] => Property Type
            [value] => Single Family
        )

[field_3300] => Array
        (
            [field_id] => 3300
            [type] => select
            [name] => C_Style
            [value] => Detached
        )

[f_131] => Array
        (
            [field_id] => 131
            [type] => feature
            [name] => Swimming Pool
            [values] => Array
                (
                    [0] => No
                )

)

[f_140] => Array
        (
            [field_id] => 140
            [type] => feature
            [name] => Pet Policy
            [values] => Array
                (
                    [0] => No
                )

)

[field_55] => Array
        (
            [field_id] => 55
            [type] => number
            [name] => Floor Number
            [value] => 0
        )

[googlemap_ln] => Array
        (
            [field_id] => 51
            [type] => text
            [name] => Longitude
            [value] => W71° 5' 39'' 
        )

[googlemap_lt] => Array
        (
            [field_id] => 52
            [type] => text
            [name] => Latitude
            [value] => N42° 43' 45.9'' 
        )

[field_2111] => Array
        (
            [field_id] => 2111
            [type] => text
            [name] => Office Name
            [value] => New Year Realty
        )

[field_3000] => Array
        (
            [field_id] => 3000
            [type] => text
            [name] => Agent MLSID
            [value] => BB805141
        )

[field_3045] => Array
        (
            [field_id] => 3045
            [type] => price
            [name] => HOA_FEE
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[f_3046] => Array
        (
            [field_id] => 3046
            [type] => feature
            [name] => ASSC_FEE_INCLUDES
            [values] => Array
                (
                    [0] => No
                )

)

[field_3056] => Array
        (
            [field_id] => 3056
            [type] => price
            [name] => ClosePrice
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3069] => Array
        (
            [field_id] => 3069
            [type] => price
            [name] => LIST_PRICE_PER_SQFT
            [raw] => 405.14
            [unit_id] => 260
            [value] => $405
            [price_only] => $405
        )

[field_3071] => Array
        (
            [field_id] => 3071
            [type] => number
            [name] => MARKET_TIME_BROKER
            [value] => 5
        )

[field_3072] => Array
        (
            [field_id] => 3072
            [type] => number
            [name] => MARKET_TIME_BROKER_PREV
            [value] => 0
        )

[field_3075] => Array
        (
            [field_id] => 3075
            [type] => datetime
            [name] => ModificationTimestamp
            [value] => 06/11/2024 20:36:00
        )

[field_3094] => Array
        (
            [field_id] => 3094
            [type] => price
            [name] => SOLD_PRICE_PER_SQFT
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3095] => Array
        (
            [field_id] => 3095
            [type] => number
            [name] => STREET_NUM
            [value] => 510
        )

[f_3102] => Array
        (
            [field_id] => 3102
            [type] => feature
            [name] => Waterfront
            [values] => Array
                (
                    [0] => Beach Front
                    [1] => 1 To 2 Mile To Beach
                )

)

[field_3109] => Array
        (
            [field_id] => 3109
            [type] => number
            [name] => FIRE_PLACES
            [value] => 1
        )

[field_3112] => Array
        (
            [field_id] => 3112
            [type] => number
            [name] => HEAT_ZONES
            [value] => 2
        )

[field_3118] => Array
        (
            [field_id] => 3118
            [type] => price
            [name] => NOI
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[f_3125] => Array
        (
            [field_id] => 3125
            [type] => feature
            [name] => ROAD_TYPE
            [values] => Array
                (
                    [0] => Public
                )

)

[field_3131] => Array
        (
            [field_id] => 3131
            [type] => number
            [name] => COOLING_ZONES
            [value] => 2
        )

[field_3134] => Array
        (
            [field_id] => 3134
            [type] => select
            [name] => SQUARE_FEET_INCL_BASE
            [value] => No
        )

[field_3156] => Array
        (
            [field_id] => 3156
            [type] => text
            [name] => SQUARE_FEET_DISCLOSURES
            [value] => Additional 1550 SF walk-up attic space can be fini
        )

[field_3164] => Array
        (
            [field_id] => 3164
            [type] => boolean
            [name] => AvailableNow
            [value] => No
        )

[f_3166] => Array
        (
            [field_id] => 3166
            [type] => feature
            [name] => RENT_FEE_INCLUDES
            [values] => Array
                (
                    [0] => No
                )

)

[field_3168] => Array
        (
            [field_id] => 3168
            [type] => price
            [name] => SEC_DEPOSIT
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3171] => Array
        (
            [field_id] => 3171
            [type] => text
            [name] => Office Phone
            [value] => 339-400-8007
        )

[field_3172] => Array
        (
            [field_id] => 3172
            [type] => text
            [name] => Agent Phone
            [value] => 617-913-1460
        )

[field_3178] => Array
        (
            [field_id] => 3178
            [type] => boolean
            [name] => AdditionalParcelsYN
            [value] => No
        )

[field_3181] => Array
        (
            [field_id] => 3181
            [type] => select
            [name] => AttachedGarageYN
            [value] => 1
        )

[field_3182] => Array
        (
            [field_id] => 3182
            [type] => select
            [name] => BuildingAreaSource
            [value] => Owner
        )

[field_3183] => Array
        (
            [field_id] => 3183
            [type] => number
            [name] => BuildingAreaTotal
            [value] => 3700
        )

[field_3184] => Array
        (
            [field_id] => 3184
            [type] => select
            [name] => BuildingAreaUnits
            [value] => Square Feet
        )

[field_3185] => Array
        (
            [field_id] => 3185
            [type] => text
            [name] => BuyerAgencyCompensation
            [value] => 2
        )

[field_3186] => Array
        (
            [field_id] => 3186
            [type] => select
            [name] => BuyerAgencyCompensationType
            [value] => %
        )

[f_3188] => Array
        (
            [field_id] => 3188
            [type] => feature
            [name] => CommunityFeatures
            [values] => Array
                (
                    [0] => Walk/jog Trails
                    [1] => Conservation Area
                    [2] => Highway Access
                    [3] => House Of Worship
                    [4] => Public School
                    [5] => Shopping
                    [6] => Golf
                    [7] => Park
                    [8] => Medical Facility
                    [9] => Bike Path
                    [10] => Public Transportation
                    [11] => Tennis Court(s)
                    [12] => Stable(s)
                    [13] => Marina
                    [14] => Private School
                    [15] => Sidewalks
                )

)

[field_3189] => Array
        (
            [field_id] => 3189
            [type] => price
            [name] => ConcessionsAmount
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[f_3190] => Array
        (
            [field_id] => 3190
            [type] => feature
            [name] => ConstructionMaterials
            [values] => Array
                (
                    [0] => Frame
                )

)

[field_3191] => Array
        (
            [field_id] => 3191
            [type] => select
            [name] => CoolingYN
            [value] => 1
        )

[field_3192] => Array
        (
            [field_id] => 3192
            [type] => number
            [name] => ParkingTotal
            [value] => 5
        )

[field_3193] => Array
        (
            [field_id] => 3193
            [type] => number
            [name] => CoveredSpaces
            [value] => 3
        )

[f_3195] => Array
        (
            [field_id] => 3195
            [type] => feature
            [name] => CurrentFinancing
            [values] => Array
                (
                    [0] => No
                )

)

[f_3196] => Array
        (
            [field_id] => 3196
            [type] => feature
            [name] => DocumentsAvailable
            [values] => Array
                (
                    [0] => No
                )

)

[f_3198] => Array
        (
            [field_id] => 3198
            [type] => feature
            [name] => DoorFeatures
            [values] => Array
                (
                    [0] => Insulated Doors
                )

)

[field_3200] => Array
        (
            [field_id] => 3200
            [type] => price
            [name] => ElectricExpense
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3205] => Array
        (
            [field_id] => 3205
            [type] => date
            [name] => ExpirationDate
            [value] => 01/01/1900
        )

[field_3206] => Array
        (
            [field_id] => 3206
            [type] => select
            [name] => FarmLandAreaUnits
            [value] => Square Feet
        )

[f_3207] => Array
        (
            [field_id] => 3207
            [type] => feature
            [name] => FinancialDataSource
            [values] => Array
                (
                    [0] => No
                )

)

[field_3208] => Array
        (
            [field_id] => 3208
            [type] => select
            [name] => FireplaceYN
            [value] => 1
        )

[field_3209] => Array
        (
            [field_id] => 3209
            [type] => text
            [name] => FoundationDetails
            [value] => Concrete Perimeter
        )

[field_3210] => Array
        (
            [field_id] => 3210
            [type] => text
            [name] => FrontageLength
            [value] => 150.00
        )

[field_3211] => Array
        (
            [field_id] => 3211
            [type] => number
            [name] => GarageSpaces
            [value] => 3
        )

[field_3212] => Array
        (
            [field_id] => 3212
            [type] => select
            [name] => GarageYN
            [value] => 1
        )

[field_3214] => Array
        (
            [field_id] => 3214
            [type] => text
            [name] => GreenEnergyEfficient
            [value] => Thermostat
        )

[field_3216] => Array
        (
            [field_id] => 3216
            [type] => price
            [name] => GrossIncome
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3217] => Array
        (
            [field_id] => 3217
            [type] => select
            [name] => HeatingYN
            [value] => 1
        )

[field_3220] => Array
        (
            [field_id] => 3220
            [type] => price
            [name] => InsuranceExpense
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3222] => Array
        (
            [field_id] => 3222
            [type] => text
            [name] => ListingAgreement
            [value] => Facilitation/Exclusive
        )

[field_3223] => Array
        (
            [field_id] => 3223
            [type] => date
            [name] => ListingContractDate
            [value] => 01/11/2024
        )

[field_3224] => Array
        (
            [field_id] => 3224
            [type] => text
            [name] => ListingService
            [value] => Entry Only
        )

[f_3225] => Array
        (
            [field_id] => 3225
            [type] => feature
            [name] => LotFeatures
            [values] => Array
                (
                    [0] => Other
                    [1] => Cul-de-sac
                )

)

[field_3226] => Array
        (
            [field_id] => 3226
            [type] => area
            [name] => LotSizeSquareFeet
            [value] => 89,000 Sqft
            [raw] => 89000
            [unit_id] => 1
        )

[field_3230] => Array
        (
            [field_id] => 3230
            [type] => price
            [name] => OperatingExpense
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3231] => Array
        (
            [field_id] => 3231
            [type] => price
            [name] => OriginalListPrice
            [raw] => 1499000
            [unit_id] => 260
            [value] => $1,499,000
            [price_only] => $1,499,000
        )

[f_3238] => Array
        (
            [field_id] => 3238
            [type] => feature
            [name] => SpecialListingConditions
            [values] => Array
                (
                    [0] => No
                )

)

[field_3240] => Array
        (
            [field_id] => 3240
            [type] => text
            [name] => UnparsedAddress
            [value] => 510 Newburyport Turnpike, Rowley MA 01969
        )

[field_3241] => Array
        (
            [field_id] => 3241
            [type] => price
            [name] => WaterSewerExpense
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3243] => Array
        (
            [field_id] => 3243
            [type] => text
            [name] => YearBuiltDetails
            [value] => Under Construction
        )

[field_3245] => Array
        (
            [field_id] => 3245
            [type] => text
            [name] => YearBuiltSource
            [value] => Builder
        )

[f_3247] => Array
        (
            [field_id] => 3247
            [type] => feature
            [name] => BusinessType
            [values] => Array
                (
                    [0] => No
                )

)

[field_3248] => Array
        (
            [field_id] => 3248
            [type] => datetime
            [name] => OriginalEntryTimestamp
            [value] => 02/11/2024 03:05:00
        )

[field_3260] => Array
        (
            [field_id] => 3260
            [type] => text
            [name] => MLSPIN_DISCLOSURE
            [value] => N
        )

[field_3265] => Array
        (
            [field_id] => 3265
            [type] => price
            [name] => MLSPIN_GRE
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3266] => Array
        (
            [field_id] => 3266
            [type] => price
            [name] => MLSPIN_HTE
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3272] => Array
        (
            [field_id] => 3272
            [type] => text
            [name] => MLSPIN_LEAD_PAINT
            [value] => None
        )

[field_3277] => Array
        (
            [field_id] => 3277
            [type] => text
            [name] => MLSPIN_MAIN_LO
            [value] => AN1076
        )

[field_3280] => Array
        (
            [field_id] => 3280
            [type] => number
            [name] => MLSPIN_MARKET_TIME_PROPERTY
            [value] => 5
        )

[field_3281] => Array
        (
            [field_id] => 3281
            [type] => price
            [name] => MLSPIN_MGF
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3282] => Array
        (
            [field_id] => 3282
            [type] => price
            [name] => MLSPIN_MSE
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3285] => Array
        (
            [field_id] => 3285
            [type] => price
            [name] => MLSPIN_OPTIONAL_FEE
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3290] => Array
        (
            [field_id] => 3290
            [type] => price
            [name] => MLSPIN_PRICE_PER_SQFT
            [raw] => 405.14
            [unit_id] => 260
            [value] => $405
            [price_only] => $405
        )

[field_3292] => Array
        (
            [field_id] => 3292
            [type] => price
            [name] => MLSPIN_RFS
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3293] => Array
        (
            [field_id] => 3293
            [type] => price
            [name] => MLSPIN_RME
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3295] => Array
        (
            [field_id] => 3295
            [type] => select
            [name] => MLSPIN_WATERVIEW_FLAG
            [value] => No
        )

[field_3296] => Array
        (
            [field_id] => 3296
            [type] => select
            [name] => OpenParkingYN
            [value] => 1
        )

[field_3301] => Array
        (
            [field_id] => 3301
            [type] => select
            [name] => RoomMasterBathroomFeatures
            [value] => Yes
        )

[f_3304] => Array
        (
            [field_id] => 3304
            [type] => feature
            [name] => AssociationAmenities
            [values] => Array
                (
                    [0] => No
                )

)

[f_3305] => Array
        (
            [field_id] => 3305
            [type] => feature
            [name] => TenantPays
            [values] => Array
                (
                    [0] => No
                )

)

[field_3306] => Array
        (
            [field_id] => 3306
            [type] => price
            [name] => GrossScheduledIncome
            [raw] => 0
            [unit_id] => 260
            [value] => $0
            [price_only] => $0
        )

[field_3311] => Array
        (
            [field_id] => 3311
            [type] => number
            [name] => BRE_Total_Parking
            [value] => 8
        )

)

EXIT

4 More Photos

Active

510 Newburyport Turnpike Rowley. MA 01969

$1,499,000

General Information for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Interior Features for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Exterior Features for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Disclosures for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Financial Information for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Lifestyle Information for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Location information for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Marketing History for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Agent Information for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Payment Calculator

Exclusive Listing Agent

Edmund Wong

New Year Realty

EXIT

4 More Photos

Active

510 Newburyport Turnpike Rowley. MA 01969

$1,499,000

General Information for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Interior Features for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Exterior Features for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Disclosures for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Financial Information for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Lifestyle Information for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Location information for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Marketing History for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Agent Information for 510 Newburyport Turnpike, Rowley, Massachusetts 01969

Payment Calculator

Exclusive Listing Agent

Edmund Wong

New Year Realty

Neighborhood

Properties for sale in Ipswich