Over $200,000,000 of Property Sold in 2022 & 2023!
Team Frank Celeste is proud to announce that we closed over $200,000,000 of property in 2022 & 2023! Many of our transactions involved either off-market properties or properties that had accepted offers before they hit the public market.
One of the greatest advantages to working with our team is that we are often the first to hear about real estate opportunities. Single family, multi-family, condominium, and investment properties!
Let us know what’s on your wish list so we can provide you with information first! Contact Frank Celeste today.
Our Featured Properties in Boston
- 1174 sqft
- 4
- 1
Rare Commercial Condo Space in Charlestown!
1 Church Court, Unit 1-1, Charlestown, MA 02129
Absolutely Prime Location! an Extremely Rare Opportunity to own a private entrance commercial condominium space…
- 2234 sqft
- 3
- 2.5
Sudbury Single Family Home!
5 Louis Avenue, Sudbury, MA 01776
Welcome Home! Superior Custom Single family home! 3++Bedrooms, 2 full and 1 half bathrooms! Perfectly located…
- 1406 sqft
- 2
- 2
Oceanfront 2 BR 2 BA with 2 Garage Parking!
300 Pier 4 Boulevard, Unit 2E, Seaport, MA 02210
Breathtaking Oceanfront Two Bedroom, Two-bathroom Home with 2 Parking Spaces and a Private balcony with…
- 0 sqft
- 0
- 0
Charlestown Corner Lot!
24 Washington Street, Charlestown, MA 02129
Investors, Neighbors and and Developers! Welcome to 24 Washington Street in the heart of the…
- 153 sqft
- 0
- 0
Charlestown Garage Parking Space!
47 Harvard Street, Unit Garage Parking Space 104, Charlestown, MA 02129
Highly sought after drive in garage space at the Courtyard Condominiums in the heart of…
- 2520 sqft
- 2
- 2
1880’s Bowfront Brick Two-Family Property!
30 Harvard Street, Charlestown, MA 02129
Overlooking the John Harvard Mall! Rare & Embracing 1880’s Bowfront Brick Two Family! East to…
- 2100 sqft
- 4
- 2F,2H
Brick Two-Family Property with Courtyard & Roof Deck!
34 Soley Street, Charlestown, MA 02129
Striking 2100sf brick two-family property on the highly sought after, historic Soley Street, just off…
- 1046 sqft
- 1+
- 1.5
Waterfront 1+ BR with 1 Garage Parking!
300 Pier 4 Boulevard, Unit 7K, Seaport, MA 02210
Perfection is yours in the most sought after and established building in the Seaport! Live…
- 2100 sqft
- 4
- 3.5
Brick Two-Family Property with Courtyard & Roof Deck!
29 Soley Street, Charlestown, MA 02129
Striking 2100sf brick two-family property on the highly sought after, historic Soley Street, just off…
- 1732 sqft
- 5
- 2
East Boston Penthouse Unit with 1 Off-Street Parking!
14 Horace Street, Unit 2, East Boston, MA 02128
INVESTORS DREAM! LEASED THROUGH MAY 15TH OF 2025 @ $5,850/month! UNIQUE 5 BED, 2 FULL…
- 1730 sqft
- 2
- 2.5
Chestnut Hill Penthouse!
2420 Beacon Street, Unit Penthouse 6, Chestnut Hill, MA 02467
A rare opportunity to own an architecturally stunning Penthouse duplex in the coveted Whitehall building…
- 2541 sqft
- 3
- 3.5
Beacon Hill Residence with Private Elevator!
33 Bowdoin Street, Unit PH, Beacon Hill, MA 02114
Beacon Hill Beauty! Flawless 2500+SF Penthouse Triplex with a private elevator! One of a kind…
- 1428 sqft
- 2
- 2.5
Spectacular New Renovation!
33 Bowdoin Street, Unit 2, Beacon Hill, MA 02114
Perfect Location & Floor Plan! Dramatic Floor through 2 BR, 2.5 BA home with 2…
- 2348 sqft
- 4
- 4.5
Sundrenched PH with Private Deck & Private Roof Deck
22 Chestnut Street, Unit 102, Charlestown, MA 02129
Training Field! Spectacular Sundrenched Penthouse Duplex with 4 ensuite Bedrooms and 2 private decks including…
- sqft
- 3
- 2.5
Federal Single Family Residence with Courtyard & 2 Off-Street Parking
45 Park Street, Charlestown, MA 02129
Impeccably renovated 1840 Federal single family with three Bedrooms and two full and one half…
- 2546 sqft
- 4+
- 3 Full, 2 Half
Grand Duplex on Monument Square!
9 Monument Square, Unit 1, Charlestown, MA 02129
Rare Monument Square! Grand Duplex! Impressive 4 BR + Familyroom & office! 3 Lavish full…
- 1060 sqft
- 1
- 1
Open-Concept 1 BR with Parking!
1022 Hancock Street, Unit 114, Quincy, MA 02169
Outstanding value in Quincy Center! Tasteful and generously sized 1 bedroom, 1 bathroom unit at…
- 1479 sqft
- 4+
- 1.5
Single Family Townhouse with a Lovely Courtyard!
29 Soley Street, Charlestown, MA 02129
Prime Location! Just off Monument Square! Highly sought after gaslit Soley Street! Quintessential Charlestown! A…
- 640 sqft
- 1
- 1
One Bedroom with Off-Street Parking!
368 Main Street, Unit 2, Charlestown, MA 02129
City Living will be so easy in this impeccably renovated One bedroom with Off Street…
- 7022 sqft
- 6
- 6 Full, 2 Half
Beautiful Updated Home in Old Chestnut Hill!
46 Woodman Road, Chestnut Hill, MA 02467
A bespoke jewel of a home steeped in historical value. The former ‘Gardener’s Cottage’ for…
- 948 sqft
- 2
- 2
2 BR 2 BA with Parking in Charlestown’s Navy Yard!
42 Eighth Street, Unit 3411, Charlestown, MA 02129
Charlestown Navy Yard – Parris Landing! Don’t Miss Out on this Remarkable residence! Impeccably maintained…
- 1384 sqft
- 4+
- 2
Remarkable Single Family with Courtyard! Mint Condition!
10 Essex Street, Charlestown, MA 02129
A Warm & Wonderful Single Family Home! This picture perfect residence boasts 4 Bedrooms plus…
- 935 sqft
- 1+
- 1.5
1 BR + Office Loft, 1.5 BA with Garage Parking!
42 Eighth Street, Unit 3313, Charlestown, MA 02129
Rarely Available at Parris Landing in the Charlestown Navy Yard! Impeccable Duplex One Bedroom plus den…
- 1828 sqft
- 4+
- 1
Single Family Townhouse with Deck and Yard!
45 Mount Vernon Street, Charlestown, MA 02129
Premier Location! Just off Monument Square and minutes to the Training Field! Southwest Facing! Single…
- 1887 sqft
- 4+
- 1.5
Single Family Townhouse with Yard!
43 Mount Vernon Street, Charlestown, MA 02129
Prime Location! Just off Monument Square and minutes to the Training Field! Southwest Facing! Legacy…
- 1293 sqft
- 2
- 2
Carriage House with Garage Parking!
560 East Fifth Street, Unit Carriage House, South Boston, MA 02127
Extraordinary Carriage House Beyond Compare! This remarkable residence boasts a private entrance and offers an…
- 5500 sqft
- 5
- 5 Full, 2 Half
Historic Brick Townhouse with Parking & Outdoor Space!
20 Monument Square, Charlestown, MA 02129
Magnificent home with premier City location on Monument Square. Renovated for today’s modern living. The…
- 2020 sqft
- 4+
- 2
Single Family Residence – A Blank Canvas!
7 Russell Street, Charlestown, MA 02129
Rare & Embracing 1880’s Free Standing Single Family! East to West Sunshine! Sought after location!…
- 4255 sqft
- 5
- 4
Single Family Home with Parking and Outdoor Spaces!
23 & 25 Wall Street, Charlestown, MA 02129
Dreams do Come True! Impressive custom-built Single family residence with a drive in garage and…
- 655 sqft
- 1
- 1
Penthouse One Bedroom with Private Roof Deck!
2 Monument Square, Unit 5, Charlestown MA 02129
Atop the Monument! This beautiful penthouse home is in a stunning brick period townhouse on…
- 1152 sqft
- 2
- 2
Exceptional 2 Bedroom Residence with Roof Deck!
10 Prospect Street, Unit 2, Charlestown, MA 02129
Exceptional 2 BR, 2 BA home located on a desirable side street a few blocks…
- 1661 sqft
- 1+
- 2.5
Duplex with Roof Deck!
421 Main Street, Unit 1, Charlestown, MA 02129
Majestic Corner Brick townhouse! Impressive Duplex with almost 1700SF of Living Space on 2 levels!…
- 810 sqft
- 2
- 1
Worker’s Cottage with Private Yard & Parking!
2 Short Street Place, Charlestown, MA 02129
Nestled On a private lane! Nantucket-like tri-level Two bedroom worker’s cottage with a full drive-in…
- 810 sqft
- 2
- 1
Updated Residence with Private Yard & Parking!
1 Short Street Place, Charlestown, MA 02129
Nestled On a private lane! Nantucket-like tri-level Two bedroom worker’s cottage with a full drive-in…
- 930 sqft
- 2
- 1
2 Bedroom Unit with Private Deck & Parking!
18 Bartlett Street, Unit 2, Charlestown, MA 02129
Prime Location just off Monument Square! Beautiful Style & Impeccable Design! This Outstanding condominium home…
- 815 sqft
- 2
- 1
Single Family Home with Courtyard!
105 Elm Street, Charlestown, MA 02129
Don’t miss out on this enchanting center entrance antique circa 1870 Single Family residence situated…
- 2015 sqft
- 4+
- 1.5
East Side Single Family Residence with Yard & Parking!
551 East Fifth Street, South Boston, MA 02127
Unbelievable opportunity! Sizzling Eastside Location! 1880’s Remarkable stand alone Single Family residence situated on a…
- 992 sqft
- 1+
- 2
1 BR + Office with Parking, Elevator and Private Deck!
38 P Street, Unit 3, South Boston, MA 02127
Desirable east side location! 2020 new construction! Boutique elevator building by a prominent South Boston…
- 2400 sqft
- 4
- 2.5
Federal Period Single Family Townhouse with Tiered Private Courtyard!
20 Tremont Street, Charlestown, MA 02129
Prime Location! Just off Monument Square! Southwest Facing! Impeccable Single family federal Period townhouse! 2400SF!…
- 1256 sqft
- 2+
- 2
Duplex Penthouse with 2 Parking!
314 West Fourth Street, Unit 3, South Boston, MA 02127
Impressive Sun-Drenched Duplex Penthouse! Sweeping Skyline Views from one of your 2 decks! Prime Westside…
- 1190 sqft
- 3
- 2
3 BR with Parking and Private Decks!
3231 Washington Street, Unit 3, Jamaica Plain, MA 02130
Impeccably renovated 3 Bedroom, 2 bathroom home with 1 off street Parking Space! Two private…
- 2200 sqft
- 3+
- 3.5
Brick Single Family Residence with Parking!
15 Charles Street, Charlestown, MA 02129
Perfection! This brick single family residence will check off every box on your wishlist! Immaculate…
- 3606 sqft
- 4
- 3.5
Impeccable Tudor Style Home!
128 Colony Road, Longmeadow, MA 01106
Impeccable Tudor Style Home located in the highly sought after Colony Hills neighborhood of Longmeadow!…
- 1065 sqft
- 2
- 2
Back Bay 2 BR with Parking!
341 Beacon Street, Unit 3A, Back Bay, MA 02116
Refined Back Bay Elegance! Premier Location! Impeccably Maintained Floor through 2 Bedroom, 2 full Bath…
- 1054 sqft
- 3
- 1.5
Sundrenched Single Family Residence!
8 Short Street, Charlestown, MA 02129
Perfect Layout for any lifestyle! Nestled on the corner of a lovely private lane! 3…
- 2552 sqft
- 2+
- 3
Directly on the Public Garden!
95 Beacon Street, Unit 6, Beacon Hill, MA 02108
Absolutely Flawless Beacon Hill Location! On the Public Garden with Endless Postcard Views! One of…
- 1115 sqft
- 3
- 2
3 Bedroom Penthouse Duplex with Private Entrance!
11 Essex Street, Unit 2, Charlestown, MA 02129
Spectacular 2018 total renovation, custom-crafted by a premier developer! Amazing 3 Bedroom, 2 Bathroom Penthouse…
- 877 sqft
- 1+
- 1
Perfect 1 BR + Study with Private Deck!
42-44 Washington Street, Unit 5, Charlestown, MA 02129
Perfection in the City! Historic Town Hill Gaslight District! Glorious Sunshine! Southwestern Facing! Private deck…
- 2560 sqft
- 3+
- 3
Absolutely Prime Eastside Location!
538 East Seventh Street, Unit 1, South Boston, MA 02127
This Amazing Duplex Home lives like a large single family on two floors! Off Street…
- 4400 sqft
- 4
- 4.5
Under Agreement!
8 Ariana Lane, Norfolk, MA 02056
Spectacular Custom-Built Home in a Prime Location! Elegant & Sophisticated open concept 4 BR, 4.5…
- 530 sqft
- 1
- 1
Under Agreement!
202-206 K Street, Unit 3, South Boston, MA 02127
Prime Eastside Location! One block to East Broadway and minutes to shopping, restaurants, bars &…
- 1831 sqft
- 3
- 2
Penthouse with Private Roof Deck & Parking!
158 Newbury Street, Unit 3, Back Bay, MA 02116
Grand Back Bay Penthouse duplex offers a wide floor plan of stunning open concept living….
- 718 sqft
- 1
- 1
Under Agreement!
47 Harvard Street, Unit A309, Charlestown, MA 02129
Rare Offering! Highly sought after 1 Bedroom at the Courtyard Condominiums! 1st time available since…
- 1050 sqft
- 2
- 2.5
Offer Accepted!
4 Marshall Place, Charlestown, MA 02129
Perfectly Renovated Two Bedroom, Two and a Half Bath Workers Cottage nestled on a Private…
- 722 sqft
- 1
- 1
Oversized Back Bay 1 Bedroom!
4 Charlesgate East, Unit 102, Back Bay, MA 02116
Impressive Oversized 1 Bedroom! Back Bay living at its finest in this Architecturally significant and…
- 885 sqft
- 1
- 1
Duplex with Private Patio!
27 Swallow Street, Unit 1, South Boston, MA 02127
Spectacular One Bedroom Duplex in the City Point neighborhood of South Boston with a Gorgeous…
- 1131 sqft
- 3
- 1.5
Offer Accepted!
238 Allen Street, Randolph, MA 02368
This charming move-in-ready Cape with Three bedrooms, One Full and One-Half bathrooms is located in…
- 1128 sqft
- 2
- 1.5
Spectacular Home with Private Deck!
10 Clover Street, Unit 2, Dorchester, MA 02122
Spectacular, move-in ready 2 bedroom/1.5 bath all on one level! More than 1,100 sq/ft of…
- 637 sqft
- 0
- 1
Under Agreement!
9 Hawthorne Place, Unit 5K, Boston, MA 02114
Best Value on the market at Hawthorne Place! Sweeping Open floor plan Studio with spacious…
- 1528 sqft
- 2
- 2
Under Agreement!
25 Channel Center Street, Unit PH107, Boston, MA 02210
Sky High South facing Penthouse! Amazing Skyline views & garage parking! Huge balcony with direct…
- 1350 sqft
- 2
- 2
Offer Accepted!
687 East Second Street, Unit 6, South Boston, MA 02127
Amazing Custom 2 Bedroom, 2 Bathroom Residence with Garage Parking! Elevator Building! Built by a…
- 1088 sqft
- 2
- 1
Under Agreement!
50 Monument Square, Unit 5, Charlestown, MA 02129
Premier Location on Monument Square! Live in this Historic Circa 1866 Italianate Brick Townhouse! Pristine…
- 434 sqft
- Studio
- 1
Stunning Studio!
27 Swallow Street, Unit 2, South Boston, MA 02127
Blazing Sunshine, Exposed accented Brick Walls and High Ceilings throughout this Sparkling Condo in South…
- 487 sqft
- 1
- 1
Offer Accepted!
534 East Eighth Street, Unit 1, South Boston, MA 02127
Why rent when you can own in this sought after East Side Location! Minutes to…
- 1703 sqft
- 4
- 1.5
Under Agreement!
26 Humphrey Street, Lowell, MA 01850
Excellent opportunity to own in the highly sought after Christian Hill neighborhood. This well cared…
- 3657 sqft
- 4
- 4.5
Under Agreement!
27 Hopkins Road, Arlington, MA 02476
Located on a serene dead-end street, with seasonal views of Spy Pond. Remarkably Renovated with…
- 615 sqft
- 1
- 1
Beacon Hill Oversized One Bedroom Home!
36 Joy Court, Unit 4R, Beacon Hill, MA 02114
In the Heart of Beacon Hill! Live in this Beautiful, Bright & Airy top floor…
- 1824 sqft
- 3+
- 2.5
Under Agreement!
24 Pleasant Street, Charlestown, MA 02129
Premier Location! Just off the Monument! Impeccably renovated circa1851 residence within Charlestown’s most historic gas…
- 830 sqft
- 2
- 2
Under Agreement!
28 Concord Street, Unit 1, Charlestown, MA 02129
Prime Location just off Monument Square! Check all the Boxes on your home buying Wishlist!…
- 845 sqft
- 1
- 1
Offer Accepted!
43 Westland Avenue, Unit 601, The Fenway, MA 02115
Oversized and rarely available 6th floor residence offers astonishing views and blazing sunshine in the…
- 2870 sqft
- 5
- 4
Renovated Three-Family Property!
1382-1384 River Street, Hyde Park, MA 02136
Opportunity awaits! Renovated 3 family home with nothing to do but move in & start…
- 1293 sqft
- 2
- 2
Under Agreement!
560 East Fifth Street, Unit Carriage House, South Boston, MA 02127
Out of this World Carriage House! Just Completed! Spectacular private entrance 2 Bedroom, 2 Bath…
- 1000 sqft
- 2
- 1
Under Agreement!
53 Aberdeen Avenue, Unit 2, Cambridge, MA 02138
Impeccable Condition! Tastefully updated 2 bedroom residence in highly sought after West Cambridge! Rare amenity-…
- 1239 sqft
- 3
- 2
Under Agreement!
310 Bunker Hill Street, Unit 2, Charlestown, MA 02129
Custom-crafted by a premier developer! Amazing unit in a Prime location! Sparkling 3 Bedrooms and 2 full bathrooms!…
- 4500 sqft
- 5+
- 5F, 1H
Classic Brick Single Family Residence!
15 Cordis Street, Charlestown, MA 02129
Majestic 1874 Classic Brick Single Family Residence just off Monument Square! Over 4500sf of meticulously…
- 1505 sqft
- 3
- 2
Full Renovation with Private Patio & Yard!
239 Lexington Street, Unit 1, East Boston, MA 02128
Now Introducing this Remarkable Total Renovation Residence in East Boston! Custom-crafted by a Premier East…
- 3002 sqft
- 4
- 2
Two-Family Property with Garage!
45-47 Puritan Road, Somerville, MA 02145
A classic gem of a two-family home in the desirable Ten Hills neighborhood! Top floor…
- 1128 sqft
- 2
- 1.5
Spectacular 2 Bedroom!
10 Clover Street, Unit 2, Dorchester, MA 02122
Spectacular 2 Bedroom, 1.5 Bath with 1100+ SF of living space all on one level!…
- 2070 sqft
- 3
- 3
Fully Renovated Residence with Private Patio & Garage Parking!
560 East Fifth Street, Unit 1, South Boston, MA 02127
Amazing fully renovated 2070SF 3 Bedroom, 3 Bathroom residence with private direct access patio and…
- 1405 sqft
- 3
- 2
Offer Accepted!
560 East Fifth Street, Unit 2, South Boston, MA 02127
Amazing fully renovated 1405SF 3 Bedroom, 2 Bathroom residence with private direct access deck and…
- 1553 sqft
- 2
- 2
Under Agreement!
34 Monument Square, Unit 3, Charlestown, MA 02129
Unmatched in the marketplace with its Amazing location, directly on Monument Square! The massive &…
- 1545 sqft
- 3
- 2
Offer Accepted!
560 East Fifth Street, Unit PH, South Boston, MA 02127
Amazing fully renovated 1545SF Penthouse 3 bedroom, 2 Bathroom residence with private direct access Skyline…
- 1362 sqft
- 3
- 2
Total Renovation!
239 Lexington Street, Unit 2, East Boston, MA 02128
Now Introducing this Remarkable Total Renovation Residence in East Boston! Custom-crafted by a Premier East…
- 1482 sqft
- 2+
- 2
Under Agreement!
108 Main Street, Unit 4, Charlestown, MA 02129
Prime Location! Enormous 2+ Bedroom, 2 bathroom Penthouse with Parking in the heart of the…
- 1405 sqft
- 3
- 2
New Renovation with Private Deck!
239 Lexington Street, Unit 3, East Boston, MA 02128
Now Introducing this Remarkable Total Renovation Residence in East Boston! Custom-crafted by a Premier East…
- 2272 sqft
- 3
- 1F, 2H
Federalist Townhouse with Private Courtyard!
19 Ellwood Street, Charlestown, MA 02129
Charming four-story brick Federalist townhome located just off the Freedom Trail & adjacent to the…
- 2337 sqft
- 3+
- 3.5
Under Agreement!
3 Hilary Street, Charlestown, MA 02129
Perfect Single Family Home! Steps to Monument Square! On a private way, this Impeccable 3+BR,…
- 2007 sqft
- 4
- 2.5
Renovated Residence with 2 Parking!
20 Pearson Road, Unit B, Somerville, MA 02144
Dreams do Come True! Spectacular Renovated 4 Bedroom, 2.5 Bath Home with 2 Car Parking…
- 5100 sqft
- 14
- 4
Incredible Income Property!
78 & 84 Garfield Avenue, Chelsea, MA 02150
INCOME PROPERTY! 6.25% CAP RATE!! Enormous 4 Family in a Prime Chelsea location! Situated on…
- 4392 sqft
- 0
- 0
Mixed-Use Property
653 Columbia Road & 6-8 Annabel Street, Dorchester, MA 02125
Exceptional Development opportunity in DORCHESTER – 653 Columbia Road & 6-8 Annabel Street in Upham’s…
- 1710 sqft
- 0
- 0
Commercial Building!
24 Porter Street, East Boston, MA 02128
Now Offering this Exciting Opportunity to Purchase a Commercial Building in one of East Boston’s…
Frank has been asked for his expert real estate advice in numerous national and regional publications, such as The Charlestown Patriot Bridge “The Best is Yet to Come!” and has recently been quoted in the Boston Globe: Investors Swoop In, Some Massachusetts Areas See Rise in Home Values, and in Boston Globe Magazine articles about real estate:
Bathroom Renovations that Wow, 10 Steps to Take Before You Sell, and Money Growing in Your Garden.
Frank was also featured on “This Old House” television program.
Read Our Reviews!
D
DUNIARINE
Bought a Condo home in 2021 in South Boston, MA.
Highly likely to recommend
Ash Williams, who works with Frank Celeste, helped us find our dream home. As new homeowners, Ash made the whole process a breeze for us, guiding us every step of the way! Ash is professional, trustworthy, knowledgeable, has the best connections, the best attitude and always supported us. We are very grateful to have worked with him!
M
MitchPomerance
Bought a Condo home in 2021 in Charlestown, MA.
Highly likely to recommend
Where do I even begin with David Mogielnicki. He is the best. The absolute best. He suffered one listing after another with me for an entire year as we looked for the perfect place in Charlestown. The man is supportive and patient at all times. He treated me like a friend and professional. He went to bat for me as we negotiated several times and gave me invaluable advice as I navigated the real estate landscape as a new homeowner. He never pressured me in any way. He is very consultative in approach and is loyal to his client. The bar is extremely high now. I consider him a confidant and friend.