Properties

Browse or get in touch to schedule a walkthrough.

  • Nearby me
Price range

Popular Features

Community Features

Association

Property Features

Waterfront

View

Exterior Features

Interior Features

Style

10000 properties match your criteria

Updated 1 minute ago

E-Alert name

SDGRE is pleased to present The Gas Lamp Hotel, a fully operational 5-key boutique hotel located in the heart of Philadelphia's Old City Historic District. Built in 1899 and meticulously renovated in 2024, the property combines irreplaceable historic character with modern hospitality infrastructure across approximately 3,500 SF of mixed-use space at 140 N 2nd Street.

The asset is anchored by five individually designed guest suites. Adams, Davy, Edison, Latimer, and Tesla. The Edison Suite is a 3-bedroom premium configuration with a full kitchen, functionally equivalent to three rentable keys. The hotel is supplemented by an income-producing ground-floor art gallery, a private outdoor courtyard, and a fully built-out basement speakeasy currently activated as private event space.

Investment highlights
Fully operational 5-key boutique with a reservation system, OTA channels, a direct-booking website, and stabilizing month-over-month performance.
3-bedroom suite with full kitchen generates $391 ADR and $42,261 in 2025 room revenue — effectively three rentable keys within one physical suite, contributing meaningful incremental value beyond the physical room count.
The 1899 historic building was substantially renovated in 2024. Hotel opened August 2024 — buyer inherits modern systems, finishes, and FF&E with no near-term capital plan required.
Hotel rooms, ground-floor gallery lease, First Friday recurring events, and 5 confirmed private events for 2026 — diversifying cash flow with high-margin pass-through revenue.
+44% YoY revenue growth (Aug–Dec 2024 vs. 2025). +55% YoY direct-booking growth (Jan–Feb 2025 vs. 2026). Direct channel share now 58% of 2026 YTD revenue.
Steps from Independence Mall, the Delaware River waterfront, Race Street Pier, and Market Street's restaurant corridor — Philadelphia's #1 leisure tourism submarket.
Current 8% third-party management fee ( $19K/yr) represents  65 bps of stabilized cap rate expansion for an owner-operator buyer who self-manages the asset.
Listing Contacts
#PAPH2623330

PHILADELPHIA

140 N 2ND STREET

None Beds

None Baths

3,500 Sq.Ft.

$2,500,000

MLS#: PAPH2623330

Calling all builders, developers and dreamers!

This remarkable property is already incorporated into the Town of Middletown, with the potential to be subdivided into 12,500 sq ft homesites, creating a rare and compelling canvas for a refined residential enclave. The setting is nothing short of exceptional. 
Bordered by manicured fairways and upscale homes, offering the perfect backdrop for a thoughtfully designed luxury community.
At its center stands a home dating to the early 1900s,( The family believes the home was built in the 1800's), rich with character and history, awaiting a visionary touch. Whether restored into a timeless estate or incorporated into a larger development concept, it adds a layer of charm and legacy that new construction alone cannot replicate.
For the discerning builder, developer, or investor, this is more than land, t is a legacy opportunity. A chance to shape a signature community in one of Delaware’s most desirable and fastest-growing destinations.
Opportunities of this caliber are exceedingly rare. Create something remarkable at 224 Wiggins Mill Road Middletown Delaware
#DENC2101942

MIDDLETOWN

224 WIGGINS MILL ROAD

4 Beds

2 Baths

N/A

$2,500,000

MLS#: DENC2101942

Beautiful Southern Maryland Coastal Retreat. Gracious and sophisticated. Elegant details throughout this incredibly, well-appointed home.  Custom  barrel ceiling and stained glass make a beautiful  statement in the grand entry foyer.  Inviting Family Room with serene water views. Newly renovated gourmet chef's kitchen is a coastal lovers dream. Enjoy sub-zero Wolf and Cove stainless appliances throughout. Custom white Cabinets and a blueberry hued Island grace this light and bright kitchen. Creamy quartz counter-tops and backsplash w/ Kohler ceramic and cast-iron sinks. Custom lighting and hardware.  So very pretty with island seating and prep sink, all with water views. Kitchen and casual dining access to the large waterside screened porch for that morning coffee or evening dinner. Enjoy the walk-in pantry and open sight lines from the kitchen through the casual dining spaces and into the expansive Family Room. Warm Brazilian Cherry hardwood flooring flows through most of this spectacular home.  Stunning water and garden views abound. Formal Dining Room with Cherry Built-Ins and pretty French pocket doors. A newly remodeled cozy mud room w/ fireplace makes a fabulous drop-zone for family and friends.  Enjoy your Office library with cherry Built-Ins.  Main Floor Primary Suite Wing has dual renovated bathrooms complete with heated floors and steam shower. Dual walk-in closets. Relax in the Great Room with cherry built-ins, a gas fireplace and custom windows to optimize all the pretty water-views. Front and Back Deep Covered porches to enjoy Alfresco Dining, Entertaining and Peaceful Tranquility. Take the Elevator or stairs up to the 2nd floor for the additional 3 bedroom suites. Lovely  bonus Room upstairs for additional guests or a tucked away water view retreat. Custom arched doorways and rounded corners throughout. Niches and storage make this home so very special.  Basement has multiple rooms and  of course, MORE storage; a walk-in safe, a severe weather safety room,  exercise and hobby space, a half bath and more.   
4+ Car Garage is attached to the home via covered Breezeway. The entire space above the Garages is available for storage or expansion with upper access from the house via a gallery w/skylights or a wide staircase inside the garage. Pier is Large and has been expanded to include two lifts (20,000lb and 7,500lb) to meet all your boating and kayaking needs. Over 300' of shoreline on scenic Combs Creek (6-8' deep at  end of pier) and 5 minute boat ride to Breton Bay and the Potomac.  This home blends one-of-a-kind customized luxury with Southern Living Charm.  Located 5 minutes from the heart of Leonardtown you'll have all the privacy you could desire in your waterfront home yet still be close to area shopping and events. So much to love and see in this stunning custom home. Over 5900 finished sf above grade alone! Another 1720 sf is partially finished in the basement. The unfinished space above the garages is sub-floored and ready for your next expansion project. You will have room for everything and more. The perfect Retreat. 30 Minutes to NAS Patuxent River and 90 minutes to DC and VA. Appointment ONLY listing with prior notice required.
#MDSM2032468

LEONARDTOWN

40111 ARMY WAY

4 Beds

4 Baths

7,679 Sq.Ft.

$2,500,000

MLS#: MDSM2032468

Exceptional bayfront estate boasting over 100 feet of direct waterfrontage and breathtaking panoramic views, including the iconic Indian River Inlet Bridge. This residence is perfectly positioned on one of the area’s most coveted waterfront parcels, blending timeless coastal architecture with refined modern luxury and is offered fully furnished. Designed to maximize its stunning setting, the home features an open-concept floor plan anchored by a dramatic great room with soaring cathedral ceilings and walls of windows that flood the space with natural light while showcasing the expansive water views. The gourmet kitchen is equally impressive, offering crisp white cabinetry, a spacious center island with seating, stainless steel appliances, and a classic subway tile backsplash. With 6 generously sized bedrooms, a versatile den that can serve as a 7th bedroom, and 7 full bathrooms, this home is ideally suited for hosting large gatherings. A secondary living and dining area complete with wet bar and full-size refrigerator adds to the home’s exceptional entertaining capabilities. Enjoy effortless access to the bay from your private boathouse dock—perfect for boating, fishing, and water sports. Outdoor living is unparalleled, with multiple waterfront spaces including a wraparound deck, screened porch, upper-level sun deck, ground-level porch, and private balconies—each offering a unique vantage point to take in the serene surroundings. Additional features include an outdoor shower for easy beach-day clean-up and ample covered parking with room for a boat and jet ski. Ideally located in a peaceful, private setting while remaining just minutes from the beach, boardwalk, restaurants, and shopping, this extraordinary property offers the ultimate coastal lifestyle.
#DESU2110754

OCEAN VIEW

29230 MARSHY HOPE WAY

6 Beds

7 Baths

6,000 Sq.Ft.

$2,500,000

MLS#: DESU2110754

Welcome to Jamesfield Place, a private enclave of only 7 estate-sized lots thoughtfully designed to maximize privacy and tranquility. Nestled among the rolling farm fields and hills of Lancaster County. This very limited and exclusive setting offers the perfect balance—just far enough from the hustle and bustle for peace and quiet. You are only a short drive to all convenience and access points such as Lancaster, Hershey/Harrisburg, access to the PA Turnpike and Harrisburg Airport all only a short scenic drive away.

This Organic Modern estate offers luxury living with 4 bedrooms and 5.5 bathrooms. Distinctive vertical wood siding, a standing seam metal roof, and expansive covered patios create a striking exterior presence, while high ceilings and exposed beams. The chef's kitchen boasts professional-grade appliance suite, and expansive pantry, perfect for both everyday convenience and entertaining. The private owner’s suite is a retreat with its own inspired bath and double walk-ins closets.

Outside, there is a covered patios offering protection from the elements. Complementing the design are two separate oversized two-car garages.

This custom home is to be constructed. Additional lots remain available and the builder is ready to collaborate on a fully custom plan.  By appointment only.
#PALA2091538

MANHEIM

101 JAMESFIELD PLACE LOT 2

5 Beds

6 Baths

5,582 Sq.Ft.

$2,500,000

MLS#: PALA2091538

A truly rare opportunity to own approximately 3.63 acres consisting of two contiguous parcels along highly traveled Route 24 (John J. Williams Highway), one of eastern Sussex County's fastest-growing commercial corridors. Located less than five minutes from Route 1 and surrounded by significant residential and commercial growth, this unique offering combines exceptional visibility, accessibility, and long-term investment potential.

Whether you're an investor, entrepreneur, owner-user, or someone seeking a one-of-a-kind live/work property, the possibilities here are extraordinary. Buyers may wish to explore Multi-Family, Commercial, or Conditional Use opportunities (subject to approvals), making this an exceptional opportunity for medical or professional offices, wellness services, boutique retail, personal services, contractor offices, mixed-use concepts, and other business ventures seeking prominent exposure in a rapidly expanding area.

The property includes a distinctive contemporary home offering three bedrooms, an open-concept floor plan, geothermal heating and cooling, and a private backyard complete with an in-ground pool surrounded by mature landscaping. An expansive front field creates an impressive setting while offering additional flexibility for future use.

Adding to the property's appeal is the former glass-blowing studio, a truly unique structure featuring additional bedrooms and a bathroom on the upper level, creating incredible flexibility for studio space, offices, guest accommodations, creative pursuits, or future business opportunities.

Properties offering this combination of acreage, location, existing improvements, and future potential rarely become available. While the two parcels are listed separately in the MLS, they are being offered and sold together as one property. This represents one of the most unique investment and development opportunities to come to the open market in Sussex County in many years.  Also listed under Residential- DESU2116538.
#DESU2116598

LEWES

20231 JOHN J WILLIAMS HIGHWAY

None Beds

None Baths

N/A

$2,500,000

MLS#: DESU2116598

Seek and you will find.
This redevelopment opportunity answers the call for the high demand in finding a church, sportsplex, school, daycare or community center site. Formerly a motel, this 6.5 acre lot has existing buildings that could be repurposed or scrapped with water and sewer connections. Located on US 29 Lee Highway in Centreville near the Interstate 66 interchange, this property has 700 feet of frontage and 2 enterances on Lee Highway and a traffic count of 15,000 vehicles per day. 

Other uses with a special use permit or exemption may include the following:
Church, Sportsplex, School, Veterinary, Daycare, Agritourism, Horse Stable, Single Family Dwelling, Group Residential Facility, Congregate Living Facility, Community Center, Recreation Club, Museum, Church, Heavy or Light Utility Facility, Animal Shelter, Kennel, Bed and Breakfast, Campground, Outdoor Recreation or Playground. 

Tax Id#: 0641-01-006
#VAFX2089362

CENTREVILLE

15500 LEE HIGHWAY

None Beds

None Baths

6.52 acres

$2,500,000

MLS#: VAFX2089362

Tucked away on one of Alexandria’s most sought-after streets, this exceptional 4-bedroom, 3-bath classic brick Colonial offers rare privacy on a quiet lane with only three homes. Set on over half an acre, the property combines timeless charm with thoughtful spaces designed for both elegant entertaining and everyday living.

A spacious front yard and gravel driveway accommodate up to five cars, while a brick walkway leads to the welcoming front entry. Inside, the foyer offers a stunning sightline straight through to the backyard, setting the tone for the home’s open and inviting feel.

Just off the foyer, a cozy den with built-ins and a wood-burning fireplace provide the perfect space for a home office or library. The expansive living room features a wall of windows overlooking the private backyard, along with built-ins and a second wood-burning fireplace. It seamlessly connects to both the formal dining room and a spectacular family room with vaulted ceilings, three walls of windows, and French doors opening to a covered flagstone porch.

The chef’s kitchen is beautifully appointed with white cabinetry, honed black granite countertops, stainless steel appliances, a gas range, and a large island with a secondary sink. A convenient laundry/utility room off the kitchen offers additional storage and functions perfectly as a mudroom with access to the side yard.

The main level also includes a bedroom and full bath—ideal for guests or flexible living arrangements.

Upstairs, a gracious winding staircase leads to the spacious primary suite featuring a walk-in closet and a luxurious en-suite bath with double vanities, a soaking tub, and a glass-enclosed walk-in shower. Two additional generously sized bedrooms share an updated hall bath.

The partially finished lower level provides additional living space and direct access to the backyard.

Outdoors, the property truly shines. Mature trees and lush landscaping create a serene setting, while multiple outdoor living areas make it an entertainer’s dream. Enjoy gatherings on the expansive brick patio, shaded by a stunning 12-foot magnolia tree, or relax on the covered porch just off the family room.

A rare opportunity to own a private retreat in an unbeatable Alexandria location.
#VAAX2058660

ALEXANDRIA

1803 NICHOLSON LANE

4 Beds

3 Baths

3,914 Sq.Ft.

$2,500,000

MLS#: VAAX2058660

This property is set up as a contractors office , show room, and storage yard. Zoned C4 there is not much you can't do here. Perfect for the growing contractor.
#MDAA2134196

GAMBRILLS

766 MD. ROUTE 3 NORTH LN

None Beds

None Baths

4,650 Sq.Ft.

$2,500,000

MLS#: MDAA2134196

Heavy industrial office/warehouse unit with outdoor storage yard. Unit is 3,010 SF and consists of 3 offices, 2 bathrooms, 2 open areas, a kitchenette and 1 drive in door (12' x 14'). Reserved parking spaces plus private gated outdoor storage of 0.2102 AC (9,156 SF). M-1 zoning allows for many uses by-right including contractor/tradesman's shop, manufacturing, R&D and more. 
Currently leased through 7/31/27. Lease includes the option for a potential Purchaser to terminate with 90 days notice to Tenant upon sale of the property. Current rental income - $6,077/month NNN. Conveniently positioned unit with prominent visibility from Rt. 234 Bypass/Prince William Pkwy, boasting exposure to 39,000 vehicles daily! Accessible via Wellington Rd., with an additional 17,000 VPD. Just minutes away from Gainesville, Manassas, & Bristow, this prime location is nestled within a bustling industrial park and surrounded by fellow industrial users.
Tax records are for unit 123 only. Additional parcel 7596-39-6784.00
#VAPW2111104

MANASSAS

11900 LIVINGSTON ROAD

None Beds

None Baths

3,010 Sq.Ft.

$2,500,000

MLS#: VAPW2111104

Iconic Estate | Hedgerow Estates – Clarksville’s Most Exclusive Enclave
Set on 3 acres of exquisitely curated grounds, this over 9,000 sq ft custom estate offers a rare combination of scale, craftsmanship, and resort-caliber living. Nearly $1 million in transformative upgrades have elevated the home to a level of finish and lifestyle seldom found in the market. A grand arrival begins with an expansive front courtyard, while the rear grounds showcase artfully designed French gardens, extensive hardscaping, and a newly built pool and spa, creating a private retreat ideal for both entertaining and everyday luxury. Residents also enjoy exclusive neighborhood amenities including a private tennis court, bike path, and tranquil lake. Inside, the home spans four fully finished levels with 8 bedrooms and 8 bathrooms, blending timeless architecture with modern sophistication. Features include new custom windows and doors, new wide plank matte hardwood floors, beautifully updated bathrooms, bespoke millwork, and luxurious custom lighting throughout. The updated chef’s kitchen is equipped with premium appliances, including a Sub-Zero refrigerator, while the main-level primary suite offers a spa-inspired bath and dual custom closets. The newly reimagined lower level rivals private clubs, featuring a wine cellar, entertainment bar, expansive recreation spaces, and a custom wellness center with gym and spa-like amenities. The rare fourth level adds exceptional flexibility with a second large executive office, lounge space, and private au pair suite. A one-of-a-kind estate where architectural presence, meticulous upgrades, and resort-style amenities converge in one of Howard County’s most coveted settings.
#MDHW2062572

CLARKSVILLE

13633 GILBRIDE LANE

8 Beds

6 Baths

9,126 Sq.Ft.

$2,500,000

MLS#: MDHW2062572

Welcome to this exquisite waterfront retreat nestled in the highly sought-after community of Ulmstead Estates.  Lovingly reimagined and meticulously maintained, this stunning five-bedroom + home delivers breathtaking water views from virtually every room — a rare luxury that never grows old.
Step inside to discover many sun-drenched living spaces framed by walls of windows, hardwood floors, and elegant lighting that flood the home with natural light. The custom gourmet kitchen anchors the main level, flowing seamlessly into a cozy family room with a fireplace — perfect for gathering on cool evenings. Formal living and dining rooms offer refined spaces for entertaining.
The spacious primary suite is a true sanctuary, featuring a sitting room, his-and-hers en-suite baths with a steam shower and soaking tub, and generous walk-in closets. A versatile au-pair suite with a second kitchen provides flexible living options, while a fifth bedroom doubles as a private office. The Florida room and expansive decks showcase panoramic river views that will steal your heart.
Outside, beautifully landscaped grounds with mature trees lead to your private pier equipped with water and electric hookups. Enjoy seasonal bi-weekly sailboat racing from your deck and sip a summer beverage from recently installed hot tub. Ulmstead Estates residents enjoy an extraordinary array of exceptional amenities, including a marina, sport courts, beach, outdoor pool, tennis & pickle ball courts, a community center, and playground. Minutes from downtown Annapolis and convenient access to Baltimore and Washington, DC, this is waterfront living perfected.
#MDAA2146568

ARNOLD

893 MALLARD CIRCLE

5 Beds

4 Baths

4,740 Sq.Ft.

$2,500,000

MLS#: MDAA2146568

RARE  M-2 heavy industrial property located in Stafford , Virginia !!  Just 3 miles from Rt 17 / I95 corridor.
Building is over 3100 sqft with current lease through Feb 2026.  16+ acre pond  ( parcel 56-36 ) also included in the sale.
#VAST2035934

FREDERICKSBURG

125 PERRY WINKLE LANE

None Beds

None Baths

3,000 Sq.Ft.

$2,500,000

MLS#: VAST2035934

• 12,000 SF Flex Space
• 2,400 SF 4-Bedroom Apartment
• 4.5 Acres
• Currently Used as an Automotive Machine Shop
• Radiant Heat
• 5 Drive-In Doors
• Public Sewer—Well Water
• Outdoor Storage Available
• Great Access to Rt 422 & Ridge Pike
#PAMC2167892

POTTSTOWN

114 AIRPORT ROAD

None Beds

None Baths

N/A

$2,500,000

MLS#: PAMC2167892

Welcome to 144 Torquay Court in the sought-after Rehoboth Beach Yacht & Country Club community. Set along the Rehoboth Canal, this two-story waterfront home offers approximately 2,900 square feet, 4 bedrooms, 3.5 bathrooms, a private dock, boat lift, jet ski lift, and a 15-by-approximately-30-foot in-ground pool.
The property features a manicured lawn, mature landscaping, classic exterior details, and multiple outdoor living areas, including a large Trex-style deck, fire pit, outside shower, and patio space around the pool. With direct canal access and boating amenities already in place, the backyard is designed for easy waterfront living.
Inside, the home offers bright, open living spaces with crown moldings, plantation shutters, and hardwood flooring through many rooms. The great room includes a gas fireplace, while the kitchen is well-equipped with granite countertops, a large breakfast bar, gas cooktop, warming drawer, two wall ovens, bar sink, tile backsplash, abundant cabinetry, and generous prep space. A formal dining room, butler’s pantry, mud room, office that could serve as a 5th bedroom, and large walk-in attic add flexibility and function.
The layout includes a first-floor owner’s suite for convenient main-level living. Upstairs, a second large suite is privately situated over the garage, separate from the main bedroom area. Two additional bedrooms share a hall bath on the second floor of the main section of the home.
Located minutes from Rehoboth Beach, the boardwalk, Dewey Beach, shopping, restaurants, entertainment, and Tanger Outlets, this home offers easy access to the best of coastal Delaware.
#DESU2114848

REHOBOTH BEACH

144 TORQUAY COURT

4 Beds

3 Baths

2,900 Sq.Ft.

$2,500,000

MLS#: DESU2114848

1 ... 662 663 664 665 666
* Listings identified with the FMLS IDX logo come from FMLS and are held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request. © 2024. First Multiple Listing Service, Inc.
 - property

Send a message

Message successfully sent.

Your message

What is 3 + 4 ?

Reason for contacting?

I agree to receive email communication and understand I can unsubscribe at any time.

I agree to be contacted by Charis Realty Group via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Sign Out

Virtual Assistant

Would you like to take the next step with this property? We can help you schedule a showing or virtual tour, or send you more details.

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

I agree to receive communications and understand I can unsubscribe at any time.

I agree to be contacted by Charis Realty Group via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Already have an account ? Login here

We use cookies

We use cookies primarily for analytics to enhance your experience. By accepting, you agree to our use of these cookies. You can manage your preferences or learn more about our cookies policy.