Buy
  • Alabama Alaska California Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
    Canada Listings (730)
    Mexico Listings (329)
    Central America Listings (620)
    Caribbean Islands Listings (46)
    Asia Listings (20) Europe Listings (9)
    Advanced Search
Sell Find an Agent
BeachHouse.com BeachHouse.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • Sell
  • Find an Agent
  • My Account
    • Login
    • Manage My Real Estate Ads
    • Manage My Search Profile / Auto Notify
    • My Account Info
    • Manage My Favorites
  • Advertise
  • Join
Back to Search Back to Listing BeachHouse.com logo
Share
BeachHouse.com logo
Ad #7898065
MLS #1416890
Listing photo

Exceptional mixed-use opportunity featuring a professional

623 Post Rd, Warwick, RI 02888
$749,900
--Beds
--Baths
3,450Sqft
0.23Acres

About this property

Exceptional mixed-use opportunity featuring a professional office building with two (2) one-bedroom apartments, ideally situated on highly traveled Post Road at a signalized intersection. This attractive and distinctive property offers outstanding visibility, making it an excellent choice for an owner-occupant, professional office, or investor seeking additional residential rental income. The property includes 16 off-street parking spaces, providing ample parking for employees, clients, and tenants. Conveniently located just minutes from I-95, T.F. Green International Airport, and a wide array of restaurants, retail, and other amenities, this well-positioned property combines accessibility, income potential, and a highly desirable location.

Property Features

0 Beds
0 Baths
3,450 Sqft
Built in 1990
0.23 Acres
2 Stories
Siding: Brick
$10,219 / yr property tax
Kent County

Additional Photos

Additional listing photo 1
Additional listing photo 2
Additional listing photo 3
Additional listing photo 4

Contact Information

Doug Jeffrey

Broadway RE Group LLC

401-255-5530

Location

Map
Listing Agent: Doug Jeffrey 401-255-5530
Broker: Broadway RE Group LLC 401-255-5530 Listing Site
Copyright © 2026 State Wide MLS of Rhode Island, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
BeachHouse.com
Printed Aug 11, 2026

Photo Gallery

Exceptional mixed-use opportunity featuring a professional - photo 1
Exceptional mixed-use opportunity featuring a professional - photo 2
Exceptional mixed-use opportunity featuring a professional - photo 3
Exceptional mixed-use opportunity featuring a professional - photo 4
Exceptional mixed-use opportunity featuring a professional - photo 5
Exceptional mixed-use opportunity featuring a professional - photo 6
Exceptional mixed-use opportunity featuring a professional - photo 7
Exceptional mixed-use opportunity featuring a professional - photo 8
Exceptional mixed-use opportunity featuring a professional - photo 9
Exceptional mixed-use opportunity featuring a professional - photo 10
Exceptional mixed-use opportunity featuring a professional - photo 11
Exceptional mixed-use opportunity featuring a professional - photo 12
Exceptional mixed-use opportunity featuring a professional - photo 13
Exceptional mixed-use opportunity featuring a professional - photo 14
Exceptional mixed-use opportunity featuring a professional - photo 15
Exceptional mixed-use opportunity featuring a professional - photo 16
Exceptional mixed-use opportunity featuring a professional - photo 17
Exceptional mixed-use opportunity featuring a professional - photo 18
Exceptional mixed-use opportunity featuring a professional - photo 19

$749,900

--
Beds
--
Baths
3,450
Sqft

623 Post Rd, Warwick, RI 02888

By contacting this agent you agree to these Terms and Conditions.
Home Rhode Island Warwick
Exceptional mixed-use opportunity featuring a professional - photo 1
Exceptional mixed-use opportunity featuring a professional - photo 2
Exceptional mixed-use opportunity featuring a professional - photo 3
Exceptional mixed-use opportunity featuring a professional - photo 4
Exceptional mixed-use opportunity featuring a professional - photo 5
MLS# 1416890
Commercial For Sale

Exceptional mixed-use opportunity featuring a professional

$749,900

623 Post Rd, Warwick, RI 02888

--
Beds
--
Baths
3,450
Sqft
0.23
Acres
$749,900
623 Post Rd, Warwick, RI 02888
-- Beds
-- Baths
3,450 Sqft
0.23 Acres
Exceptional mixed-use opportunity featuring a professional office building with two (2) one-bedroom apartments, ideally situated on highly traveled Post Road at a signalized intersection. This attractive and distinctive property offers outstanding visibility, making it an excellent choice for an owner-occupant, professional office, or investor seeking additional residential rental income. The property includes 16 off-street parking spaces, providing ample parking for employees, clients, and tenants. Conveniently located just minutes from I-95, T.F. Green International Airport, and a wide array of restaurants, retail, and other amenities, this well-positioned property combines accessibility, income potential, and a highly desirable location.
36 days
on BeachHouse.com
0
view
0
saves

Property Details

HOME DETAILS

0 Beds
0 Baths
3,450 Sqft
Built in 1990
0.23 Acres
2 Stories

EXTERIOR

Siding: Brick

FINANCIAL & COMMUNITY

$10,219 / yr property tax
Kent County
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7898065
Viewed
0 time
Listing Status
Active
Added
Jul 06, 2026
Last Refreshed
Jul 03, 2026 06:17:28 PM

Listing Information

Data Source
State Wide MLS of Rhode Island, Inc.
Source Property ID
1416890
Listing Agent: Doug Jeffrey 401-255-5530
Broker: Broadway RE Group LLC 401-255-5530 Listing Site
Copyright © 2026 State Wide MLS of Rhode Island, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Request Information

By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.

Start advertising today

Explore options for real estate agents and homeowners advertising on BeachHouse.com
Sell Your Home

Explore Similar Properties

For Sale
Incredibly unique mixed-use property offering the perfect blend - photo 1
Incredibly unique mixed-use property offering the perfect blend - photo 2
Incredibly unique mixed-use property offering the perfect blend - photo 3
Incredibly unique mixed-use property offering the perfect blend - photo 4
Incredibly unique mixed-use property offering the perfect blend - photo 5
Incredibly unique mixed-use property offering the perfect blend - photo 6
Incredibly unique mixed-use property offering the perfect blend - photo 7
Incredibly unique mixed-use property offering the perfect blend - photo 8
Incredibly unique mixed-use property offering the perfect blend - photo 9
Incredibly unique mixed-use property offering the perfect blend - photo 10
Incredibly unique mixed-use property offering the perfect blend - photo 11
Incredibly unique mixed-use property offering the perfect blend - photo 12
Incredibly unique mixed-use property offering the perfect blend - photo 13
Incredibly unique mixed-use property offering the perfect blend - photo 14
Incredibly unique mixed-use property offering the perfect blend - photo 15
Incredibly unique mixed-use property offering the perfect blend - photo 16
Incredibly unique mixed-use property offering the perfect blend - photo 17
Incredibly unique mixed-use property offering the perfect blend - photo 18
Incredibly unique mixed-use property offering the perfect blend - photo 19
Incredibly unique mixed-use property offering the perfect blend - photo 20
Incredibly unique mixed-use property offering the perfect blend - photo 21
Incredibly unique mixed-use property offering the perfect blend - photo 22
Incredibly unique mixed-use property offering the perfect blend - photo 23
Incredibly unique mixed-use property offering the perfect blend - photo 24
Incredibly unique mixed-use property offering the perfect blend - photo 25
Incredibly unique mixed-use property offering the perfect blend - photo 26
Incredibly unique mixed-use property offering the perfect blend - photo 27
Incredibly unique mixed-use property offering the perfect blend - photo 28
Incredibly unique mixed-use property offering the perfect blend - photo 29
Incredibly unique mixed-use property offering the perfect blend - photo 30
Incredibly unique mixed-use property offering the perfect blend - photo 31
Incredibly unique mixed-use property offering the perfect blend - photo 32
Incredibly unique mixed-use property offering the perfect blend - photo 33
Incredibly unique mixed-use property offering the perfect blend - photo 34
Incredibly unique mixed-use property offering the perfect blend - photo 35
Incredibly unique mixed-use property offering the perfect blend - photo 36
Incredibly unique mixed-use property offering the perfect blend - photo 37
Incredibly unique mixed-use property offering the perfect blend - photo 38
Incredibly unique mixed-use property offering the perfect blend - photo 39
Incredibly unique mixed-use property offering the perfect blend - photo 40

$799,900

4 Beds | 3.0 Baths | 4,271 Sqft

14 W Natick Rd, Warwick, RI 02886

Incredibly unique mixed-use property offering the perfect blend

Added: 12/11/2025 • Updated: 05/14/2026
For Sale
Who wants to live on the beach?? Breathtaking views from this - photo 1
Who wants to live on the beach?? Breathtaking views from this - photo 2
Who wants to live on the beach?? Breathtaking views from this - photo 3
Who wants to live on the beach?? Breathtaking views from this - photo 4
Who wants to live on the beach?? Breathtaking views from this - photo 5
Who wants to live on the beach?? Breathtaking views from this - photo 6
Who wants to live on the beach?? Breathtaking views from this - photo 7

$760,000

2 Beds | 1.0 Baths | 984 Sqft

300 Shawomet Ave, Warwick, RI 02889

Who wants to live on the beach?? Breathtaking views from this

Added: 07/02/2026 • Updated: 07/02/2026
For Sale
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 1
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 2
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 3
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 4
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 5
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 6
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 7
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 8
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 9
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 10
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 11
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 12
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 13
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 14
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 15
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 16
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 17
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 18
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 19
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 20
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 21
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 22
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 23
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 24
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 25
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 26
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 27
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 28
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 29
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 30
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 31
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 32
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 33
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 34
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 35
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 36
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 37
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 38
THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN - photo 39

$750,000

3 Beds | 4.0 Baths | 2,090 Sqft

58 Rip Van Winkle Cir, Warwick, RI 02886

THIS OVERSIZED RAISED RANCH SITS IN A QUIET NEIGHBORHOOD IN

Added: 06/29/2026 • Updated: 07/04/2026
For Sale
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 1
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 2
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 3
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 4
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 5
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 6
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 7
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 8
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 9
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 10
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 11
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 12
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 13
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 14
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 15
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 16
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 17
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 18
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 19
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 20
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 21
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 22
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 23
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 24
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 25
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 26
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 27
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 28
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 29
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 30
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 31
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 32
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 33
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 34
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 35
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 36
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 37
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 38
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 39
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 40
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 41
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 42
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 43
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 44
Stunning Turn-Key Colonial ideally located in Governor Francis - photo 45

$750,000

3 Beds | 2.0 Baths | 1,776 Sqft

39 Merry Mount Dr, Warwick, RI 02888

Stunning Turn-Key Colonial ideally located in Governor Francis

Added: 06/27/2026 • Updated: 07/08/2026
SEARCH STATES
Alabama Alaska California Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.08.11
Terms & Policy

Search Filters
Price
-
0
$100,000
$100,000+
$200,000
$200,000+
$300,000
$300,000+
$400,000
$400,000+
$500,000
$500,000+
$600,000
$600,000+
$700,000
$700,000+
$800,000
$800,000+
$900,000
Any Price
Any Price
Beds & Baths
-
-
Property Type
Sale Status
More Filters
-
-
-
-
Advanced Search

Warwick

Read more
Sort By:
  • Featured
  • Newest
  • Price - Low To High
  • Price - High To Low
  • Sqft - Low To High
  • Sqft - High To Low

Warwick Real Estate Agent Info

About Warwick

Click to activate
Request Information
By proceeding you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), and its affiliates, to contact me using the contact details you provided, via phone call or text (SMS) using automated dialing technology for marketing or advertising purposes, including contacting me about my inquiry and other home-related matters. Not a condition for purchase. Message and data rates may apply.
This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what I am looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at  csv@dreamhomenetwork.com.
Contact Agent
By contacting this agent you agree to these Terms and Conditions.
Share this Ad
Link copied
Video/Virtual Tour
Loading...
SEARCH STATES
Alabama Alaska California Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.08.11
Terms & Policy