The Stine Team of Northrop Realty
  • Home
  • Buying
    1. All Listings
    2. Featured Listings
    3. Sold Listings
  • Financing
  • Selling
    1. Sell My Home
    2. Home Valuation
  • About Us
    1. Media Room
    2. First State Living
    3. Our Mission
    4. Agents
    5. Reviews
  • Contact Us
  • Partner Lender
  • Register
  • /
  • Sign In

Your Home Search Starts Here!

Search

Ready to find your new dream home?

Share a few details about your ideal property with us, and we’ll handle the rest

Filters Reset
1 Filter
Price
  • Any
  • $ 100,000
  • $ 150,000
  • $ 200,000
  • $ 400,000
  • $ 800,000
  • Any
  • $ 200,000
  • $ 300,000
  • $ 400,000
  • $ 600,000
  • $ 1,000,000
  • $ 2,000,000
  • $ 3,000,000
  • $ 4,000,000
Beds
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
Baths
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
Reset
1 Filter
1 Filter Applied

Price
  • Any
  • $ 100,000
  • $ 150,000
  • $ 200,000
  • $ 400,000
  • $ 800,000
  • Any
  • $ 200,000
  • $ 300,000
  • $ 400,000
  • $ 600,000
  • $ 1,000,000
  • $ 2,000,000
  • $ 3,000,000
  • $ 4,000,000
Beds
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
Baths
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
  • Any
  • 1
  • 2
  • 3
  • 4
  • 5
Days On Site
Advanced
Less Than
Days
Unit Level
Unfin SqFt

SqFt
Switch to Acre
Sqft
Sqft
Lot Size
Switch to Acre
Sqft
Sqft
Price per Sqft
Monthly HOA Fee
Year Built
Stories
Kitchens
Acres
Full Bathrooms
Half Bathrooms
Frontage
Tax Amount
Land Lease Fee
Keyword
Assessed Value

Fireplace Number

Parking Space
Garage Space
Carport Spaces

Open House
Has Picture
New
Hot
Virtual Tour
3D Tour
Price Reduced
Save Search (2)
Save your search to get Alerts
12 Properties
Map

12 Properties Available In Overlook

  • Default
  • Price-High To Low
  • Price-Low To High
  • Newest Listings
  • Beds (Most)
  • Baths (Most)
  • Year Built (Newest)
  • Square Feet (Biggest)
MD >Frederick >Overlook >
Market Insights
505 SYLVAN CT, Frederick, MD 21703
Open Thu 2PM-3:15PM

$395,000

505 SYLVAN CT, Frederick, MD 21703

3 Beds4 Baths2,052 SqFt

MLS# MDFR2068376

Listed by Samson Properties

Bright MLS (BMLS)
500 BRADLEY CT #4B, Frederick, MD 21703
Open 8/15 5PM-7PM

$265,000

500 BRADLEY CT #4B, Frederick, MD 21703

2 Beds2 Baths

MLS# MDFR2067272

Listed by Charis Realty Group

Bright MLS (BMLS)
508 BOYSENBERRY LN, Frederick, MD 21703
New

$350,000

508 BOYSENBERRY LN, Frederick, MD 21703

3 Beds3 Baths1,600 SqFt

MLS# MDFR2068304

Listed by Keller Williams Realty

Bright MLS (BMLS)
502 BRADLEY CT #5D, Frederick, MD 21703
Active

$267,000

502 BRADLEY CT #5D, Frederick, MD 21703

2 Beds2 Baths

MLS# MDFR2068010

Listed by Long & Foster Real Estate, Inc.

Bright MLS (BMLS)
500 BRADLEY CT #M, Frederick, MD 21703
Price Dropped by $5K

$275,000

500 BRADLEY CT #M, Frederick, MD 21703

2 Beds2 Baths1,149 SqFt

MLS# MDFR2066966

Listed by EXP Realty, LLC

Bright MLS (BMLS)
572 CASCADE WAY, Frederick, MD 21703
3D
Active

$333,000

572 CASCADE WAY, Frederick, MD 21703

3 Beds3 Baths1,600 SqFt

MLS# MDFR2065758

Listed by Redfin Corp

Bright MLS (BMLS)
617 HIMES AVE #107, Frederick, MD 21703
Active

$244,900

617 HIMES AVE #107, Frederick, MD 21703

2 Beds2 Baths1,058 SqFt

MLS# MDFR2065986

Listed by L. P. Calomeris Realty

Bright MLS (BMLS)
512 ELLISON CT, Frederick, MD 21703
Active

$415,000

512 ELLISON CT, Frederick, MD 21703

4 Beds3 Baths2,272 SqFt

MLS# MDFR2065192

Listed by Samson Properties

Bright MLS (BMLS)
591 WINTERSPICE DR, Frederick, MD 21703
Price Dropped by $23K

$549,900

591 WINTERSPICE DR, Frederick, MD 21703

4 Beds4 Baths2,689 SqFt

MLS# MDFR2061708

Listed by Samson Properties

Bright MLS (BMLS)
567 ELLISON CT, Frederick, MD 21703
Active

$2,600

567 ELLISON CT, Frederick, MD 21703

3 Beds4 Baths2,052 SqFt

MLS# MDFR2066482

Listed by Hawkins Real Estate Company

Bright MLS (BMLS)
565 ELLISON CT, Frederick, MD 21703
Active

$2,600

565 ELLISON CT, Frederick, MD 21703

3 Beds3 Baths2,300 SqFt

MLS# MDFR2064618

Listed by United Realty, Inc.

Bright MLS (BMLS)
615 HIMES AVE #112, Frederick, MD 21703
Active

$279,900

615 HIMES AVE #112, Frederick, MD 21703

2 Beds2 Baths

MLS# MDFR2062392

Listed by Allison James Estates & Homes

Bright MLS (BMLS)
  • 1

explore listings near Overlook

  • Open House
  • Price Reduced
  • Virtual Tour
  • 3D Tour
IDX information is provided exclusively for consumers’ personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed to be accurate. Listing information updated daily.

SITE MAP

      Home
      Buying
      1. All Listings
      2. Featured Listings
      3. Sold Listings
      Financing
      Selling
      1. Sell My Home
      2. Home Valuation
      About Us
      1. Media Room
      2. First State Living
      3. Our Mission
      4. Agents
      5. Reviews
      Contact Us
      Partner Lender
stine-northrop-footer-logo copy

The Stine Team of Northrop Realty

Allison Stine

+1(302) 381-5565 allisonstine@northroprealty.com

209 5th Street , Bethany Beach, DE 19930

Office: 302-539-2900


300 Creek View Rd, Newark, DE 19711

Office: 302-539-2900

Get My App

Disclaimer: By entering your information and submitting this form, you agree to our Terms of Use and Privacy Policy and that you may be contacted by The Stine Team of Northrop Realty by phone, text message, and email about your real estate interests. Frequency of contact may vary, and message and data rates may apply. For assistance, call 302-381-5565 (cell) or text STOP to cancel.

Powered by Lofty Inc. Copyright 2025. All Rights Reserved.

Terms of Service & Privacy Policy | Cookie Policy | Cookie Preferences | Property Listings | Sitemap | Accessibility

IDX information is provided exclusively for consumers’ personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed to be accurate. Listing information updated daily.

SITE MAP

      Home
      Buying
      1. All Listings
      2. Featured Listings
      3. Sold Listings
      Financing
      Selling
      1. Sell My Home
      2. Home Valuation
      About Us
      1. Media Room
      2. First State Living
      3. Our Mission
      4. Agents
      5. Reviews
      Contact Us
      Partner Lender
stine-northrop-footer-logo copy

The Stine Team of Northrop Realty

Allison Stine

+1(302) 381-5565 allisonstine@northroprealty.com

209 5th Street , Bethany Beach, DE 19930

Office: 302-539-2900


300 Creek View Rd, Newark, DE 19711

Office: 302-539-2900

Get My App

Disclaimer: By entering your information and submitting this form, you agree to our Terms of Use and Privacy Policy and that you may be contacted by The Stine Team of Northrop Realty by phone, text message, and email about your real estate interests. Frequency of contact may vary, and message and data rates may apply. For assistance, call 302-381-5565 (cell) or text STOP to cancel.

Powered by Lofty Inc. Copyright 2025. All Rights Reserved.

Terms of Service & Privacy Policy | Cookie Policy | Cookie Preferences | Property Listings | Sitemap | Accessibility