Spotlight on South Rehoboth

string(3614) "SELECT SQL_CACHE `t1`.`ListingMLS` AS 'ListingMLS', `t1`.`ListingPrice` AS 'ListingPrice', `t1`.`ListingType` AS 'ListingType', `t1`.`ListingSubType` AS 'ListingSubType', `t1`.`ListingStyle` AS 'ListingStyle', `t1`.`ListingStatus` AS 'ListingStatus', `t1`.`ListingRemarks` AS 'ListingRemarks', `t1`.`ListingImage` AS 'ListingImage', `t1`.`ListingDate` AS 'ListingDate', `t1`.`ListingDOM` AS 'ListingDOM', `t1`.`ListingPriceOld` AS 'ListingPriceOld', `t1`.`ListingPriceChanged` AS 'ListingPriceChanged', `t1`.`Address` AS 'Address', `t1`.`AddressArea` AS 'AddressArea', `t1`.`AddressSubdivision` AS 'AddressSubdivision', `t1`.`AddressCity` AS 'AddressCity', `t1`.`AddressCounty` AS 'AddressCounty', `t1`.`AddressState` AS 'AddressState', `t1`.`AddressZipCode` AS 'AddressZipCode', `t1`.`SchoolDistrict` AS 'SchoolDistrict', `t1`.`SchoolElementary` AS 'SchoolElementary', `t1`.`SchoolMiddle` AS 'SchoolMiddle', `t1`.`SchoolHigh` AS 'SchoolHigh', `t1`.`NumberOfBedrooms` AS 'NumberOfBedrooms', `t1`.`NumberOfBathrooms` AS 'NumberOfBathrooms', `t1`.`NumberOfBathsFull` AS 'NumberOfBathsFull', `t1`.`NumberOfBathsHalf` AS 'NumberOfBathsHalf', `t1`.`NumberOfSqFt` AS 'NumberOfSqFt', `t1`.`NumberOfAcres` AS 'NumberOfAcres', `t1`.`NumberOfStories` AS 'NumberOfStories', `t1`.`NumberOfGarages` AS 'NumberOfGarages', `t1`.`NumberOfParkingSpaces` AS 'NumberOfParkingSpaces', `t1`.`NumberOfFireplaces` AS 'NumberOfFireplaces', `t1`.`YearBuilt` AS 'YearBuilt', `t1`.`HasPool` AS 'HasPool', `t1`.`HasFireplace` AS 'HasFireplace', `t1`.`IsWaterfront` AS 'IsWaterfront', `t1`.`IsForeclosure` AS 'IsForeclosure', `t1`.`IsShortSale` AS 'IsShortSale', `t1`.`IsBankOwned` AS 'IsBankOwned', `t1`.`DescriptionLot` AS 'DescriptionLot', `t1`.`DescriptionSqFt` AS 'DescriptionSqFt', `t1`.`DescriptionPool` AS 'DescriptionPool', `t1`.`DescriptionView` AS 'DescriptionView', `t1`.`DescriptionStories` AS 'DescriptionStories', `t1`.`DescriptionFireplace` AS 'DescriptionFireplace', `t1`.`DescriptionWaterfront` AS 'DescriptionWaterfront', `t1`.`DescriptionGarages` AS 'DescriptionGarages', `t1`.`DescriptionParking` AS 'DescriptionParking', `t1`.`DescriptionAmenities` AS 'DescriptionAmenities', `t1`.`DescriptionAppliances` AS 'DescriptionAppliances', `t1`.`DescriptionUtilities` AS 'DescriptionUtilities', `t1`.`DescriptionFeatures` AS 'DescriptionFeatures', `t1`.`DescriptionExterior` AS 'DescriptionExterior', `t1`.`DescriptionExteriorFeatures` AS 'DescriptionExteriorFeatures', `t1`.`DescriptionInterior` AS 'DescriptionInterior', `t1`.`DescriptionInteriorFeatures` AS 'DescriptionInteriorFeatures', `t1`.`DescriptionHeating` AS 'DescriptionHeating', `t1`.`DescriptionCooling` AS 'DescriptionCooling', `t1`.`DescriptionZoning` AS 'DescriptionZoning', `t1`.`DescriptionRoofing` AS 'DescriptionRoofing', `t1`.`DescriptionWindows` AS 'DescriptionWindows', `t1`.`DescriptionConstruction` AS 'DescriptionConstruction', `t1`.`DescriptionFoundation` AS 'DescriptionFoundation', `t1`.`DescriptionHOAFees` AS 'DescriptionHOAFees', `t1`.`DescriptionHOAFeesFrequency` AS 'DescriptionHOAFeesFrequency', `t1`.`ListingOffice` AS 'ListingOffice', `t1`.`ListingOfficeID` AS 'ListingOfficeID', `t1`.`ListingAgent` AS 'ListingAgent', `t1`.`ListingAgentID` AS 'ListingAgentID', `t1`.`Latitude` AS 'Latitude', `t1`.`Longitude` AS 'Longitude', `t1`.`VirtualTour` AS 'VirtualTour' FROM `_rewidx_listings` `t1` JOIN (SELECT `t1`.`id` FROM `_rewidx_listings` `t1` WHERE (`t1`.`ListingType` = 'Residential') AND (`t1`.`AddressSubdivision` = 'South Rehoboth') ORDER BY `ListingPrice` DESC, `t1`.`id` ASC) p USING(`id`) ORDER BY `ListingPrice` DESC, `t1`.`id` ASC"
Price, High to Low
18 Properties Found.
Photo of Listing #1000329571
  • MLS® #: 1000329571
  • 319 S Boardwalk #2
  • REHOBOTH BEACH, DE 19971
  • $4,400,000
  • 4 Bed, 4½ Bath
  • Residential
Add as Favorite
Photo of Listing #1001565094
  • MLS® #: 1001565094
  • 319 S Boardwalk #2
  • REHOBOTH BEACH, DE 19971
  • $4,400,000
  • 4 Bed, 4½ Bath
  • Residential
Add as Favorite
Photo of Listing #1001573604
  • MLS® #: 1001573604
  • 5 Stockley St
  • REHOBOTH BEACH, DE 19971
  • $3,750,000
  • 4 Bed, 3½ Bath, 2851 SqFt, 0.11 Acres
  • Residential
Add as Favorite
Photo of Listing #1001567932
  • MLS® #: 1001567932
  • 701 S Boardwalk
  • REHOBOTH BEACH, DE 19971
  • $2,900,000
  • 7 Bed, 4 Bath, 2100 SqFt, 0.22 Acres
  • Residential
Add as Favorite
Photo of Listing #1001571554
  • MLS® #: 1001571554
  • 105 Norfolk St
  • REHOBOTH BEACH, DE 19971
  • $2,847,000
  • 5 Bed, 5½ Bath, 3750 SqFt, 0.17 Acres
  • Residential
Add as Favorite
Photo of Listing #1001570520
  • MLS® #: 1001570520
  • 16 Norfolk St
  • REHOBOTH BEACH, DE 19971
  • $2,749,000
  • 4 Bed, 4½ Bath, 2928 SqFt, 0.11 Acres
  • Residential
Add as Favorite
Photo of Listing #1001566704
  • MLS® #: 1001566704
  • 15 Delaware Ave
  • REHOBOTH BEACH, DE 19971
  • $2,599,000
  • 5 Bed, 4½ Bath, 3000 SqFt, 0.11 Acres
  • Residential
Add as Favorite
Photo of Listing #1001569774
  • MLS® #: 1001569774
  • 805 King Charles Ave
  • REHOBOTH BEACH, DE 19971
  • $2,495,000
  • 5 Bed, 5½ Bath, 2463 SqFt, 0.1 Acres
  • Residential
Add as Favorite
Photo of Listing #1001569262
  • MLS® #: 1001569262
  • 15 Hickman St
  • REHOBOTH BEACH, DE 19971
  • $2,295,000
  • 5 Bed, 4 Bath, 3000 SqFt, 0.15 Acres
  • Residential
Add as Favorite
Photo of Listing #1001648426
  • MLS® #: 1001648426
  • 112 Norfolk St
  • REHOBOTH BEACH, DE 19971
  • $1,998,000
  • 6 Bed, 6½ Bath, 3500 SqFt, 0.11 Acres
  • Residential
Add as Favorite
Photo of Listing #1001573272
  • MLS® #: 1001573272
  • 54 Delaware Ave
  • REHOBOTH BEACH, DE 19971
  • $1,850,000
  • 4 Bed, 3 Bath, 2896 SqFt, 0.11 Acres
  • Residential
Add as Favorite
Photo of Listing #1001572154
  • MLS® #: 1001572154
  • 227 Laurel St
  • REHOBOTH BEACH, DE 19971
  • $1,798,000
  • 5 Bed, 4½ Bath, 2530 SqFt, 0.11 Acres
  • Residential
Add as Favorite
Photo of Listing #1001572230
  • MLS® #: 1001572230
  • 229 Laurel St
  • REHOBOTH BEACH, DE 19971
  • $1,798,000
  • 5 Bed, 4½ Bath, 2530 SqFt, 0.11 Acres
  • Residential
Add as Favorite
Photo of Listing #1001573216
  • MLS® #: 1001573216
  • 4 Queen St
  • REHOBOTH BEACH, DE 19971
  • $1,795,000
  • 5 Bed, 3 Bath, 2248 SqFt, 0.11 Acres
  • Residential
Add as Favorite
Photo of Listing #1001571740
  • MLS® #: 1001571740
  • 111 New Castle St
  • REHOBOTH BEACH, DE 19971
  • $1,750,000
  • 6 Bed, 3 Bath, 2930 SqFt, 0.11 Acres
  • Residential
Add as Favorite
Photo of Listing #1001569794
  • MLS® #: 1001569794
  • 4 Laurel St #112c
  • REHOBOTH BEACH, DE 19971
  • $1,100,000
  • 2 Bed, 2 Bath, 1120 SqFt
  • Residential
Add as Favorite
Photo of Listing #1001573958
  • MLS® #: 1001573958
  • 4 Laurel St #101c
  • REHOBOTH BEACH, DE 19971
  • $919,900
  • 2 Bed, 2 Bath, 1120 SqFt
  • Residential
Add as Favorite
Photo of Listing #1001574154
  • MLS® #: 1001574154
  • 21 Wilmington Ave #1-e
  • REHOBOTH BEACH, DE 19971
  • $585,000
  • 2 Bed, 1 Bath, 819 SqFt
  • Residential
Add as Favorite

South Rehoboth Lots and Land

string(3607) "SELECT SQL_CACHE `t1`.`ListingMLS` AS 'ListingMLS', `t1`.`ListingPrice` AS 'ListingPrice', `t1`.`ListingType` AS 'ListingType', `t1`.`ListingSubType` AS 'ListingSubType', `t1`.`ListingStyle` AS 'ListingStyle', `t1`.`ListingStatus` AS 'ListingStatus', `t1`.`ListingRemarks` AS 'ListingRemarks', `t1`.`ListingImage` AS 'ListingImage', `t1`.`ListingDate` AS 'ListingDate', `t1`.`ListingDOM` AS 'ListingDOM', `t1`.`ListingPriceOld` AS 'ListingPriceOld', `t1`.`ListingPriceChanged` AS 'ListingPriceChanged', `t1`.`Address` AS 'Address', `t1`.`AddressArea` AS 'AddressArea', `t1`.`AddressSubdivision` AS 'AddressSubdivision', `t1`.`AddressCity` AS 'AddressCity', `t1`.`AddressCounty` AS 'AddressCounty', `t1`.`AddressState` AS 'AddressState', `t1`.`AddressZipCode` AS 'AddressZipCode', `t1`.`SchoolDistrict` AS 'SchoolDistrict', `t1`.`SchoolElementary` AS 'SchoolElementary', `t1`.`SchoolMiddle` AS 'SchoolMiddle', `t1`.`SchoolHigh` AS 'SchoolHigh', `t1`.`NumberOfBedrooms` AS 'NumberOfBedrooms', `t1`.`NumberOfBathrooms` AS 'NumberOfBathrooms', `t1`.`NumberOfBathsFull` AS 'NumberOfBathsFull', `t1`.`NumberOfBathsHalf` AS 'NumberOfBathsHalf', `t1`.`NumberOfSqFt` AS 'NumberOfSqFt', `t1`.`NumberOfAcres` AS 'NumberOfAcres', `t1`.`NumberOfStories` AS 'NumberOfStories', `t1`.`NumberOfGarages` AS 'NumberOfGarages', `t1`.`NumberOfParkingSpaces` AS 'NumberOfParkingSpaces', `t1`.`NumberOfFireplaces` AS 'NumberOfFireplaces', `t1`.`YearBuilt` AS 'YearBuilt', `t1`.`HasPool` AS 'HasPool', `t1`.`HasFireplace` AS 'HasFireplace', `t1`.`IsWaterfront` AS 'IsWaterfront', `t1`.`IsForeclosure` AS 'IsForeclosure', `t1`.`IsShortSale` AS 'IsShortSale', `t1`.`IsBankOwned` AS 'IsBankOwned', `t1`.`DescriptionLot` AS 'DescriptionLot', `t1`.`DescriptionSqFt` AS 'DescriptionSqFt', `t1`.`DescriptionPool` AS 'DescriptionPool', `t1`.`DescriptionView` AS 'DescriptionView', `t1`.`DescriptionStories` AS 'DescriptionStories', `t1`.`DescriptionFireplace` AS 'DescriptionFireplace', `t1`.`DescriptionWaterfront` AS 'DescriptionWaterfront', `t1`.`DescriptionGarages` AS 'DescriptionGarages', `t1`.`DescriptionParking` AS 'DescriptionParking', `t1`.`DescriptionAmenities` AS 'DescriptionAmenities', `t1`.`DescriptionAppliances` AS 'DescriptionAppliances', `t1`.`DescriptionUtilities` AS 'DescriptionUtilities', `t1`.`DescriptionFeatures` AS 'DescriptionFeatures', `t1`.`DescriptionExterior` AS 'DescriptionExterior', `t1`.`DescriptionExteriorFeatures` AS 'DescriptionExteriorFeatures', `t1`.`DescriptionInterior` AS 'DescriptionInterior', `t1`.`DescriptionInteriorFeatures` AS 'DescriptionInteriorFeatures', `t1`.`DescriptionHeating` AS 'DescriptionHeating', `t1`.`DescriptionCooling` AS 'DescriptionCooling', `t1`.`DescriptionZoning` AS 'DescriptionZoning', `t1`.`DescriptionRoofing` AS 'DescriptionRoofing', `t1`.`DescriptionWindows` AS 'DescriptionWindows', `t1`.`DescriptionConstruction` AS 'DescriptionConstruction', `t1`.`DescriptionFoundation` AS 'DescriptionFoundation', `t1`.`DescriptionHOAFees` AS 'DescriptionHOAFees', `t1`.`DescriptionHOAFeesFrequency` AS 'DescriptionHOAFeesFrequency', `t1`.`ListingOffice` AS 'ListingOffice', `t1`.`ListingOfficeID` AS 'ListingOfficeID', `t1`.`ListingAgent` AS 'ListingAgent', `t1`.`ListingAgentID` AS 'ListingAgentID', `t1`.`Latitude` AS 'Latitude', `t1`.`Longitude` AS 'Longitude', `t1`.`VirtualTour` AS 'VirtualTour' FROM `_rewidx_listings` `t1` JOIN (SELECT `t1`.`id` FROM `_rewidx_listings` `t1` WHERE (`t1`.`ListingType` = 'Land') AND (`t1`.`AddressSubdivision` = 'South Rehoboth') ORDER BY `ListingPrice` DESC, `t1`.`id` ASC) p USING(`id`) ORDER BY `ListingPrice` DESC, `t1`.`id` ASC"
Price, High to Low
0 Properties Found.

No listings were found matching your search criteria.

Based on information from Sussex County Association of REALTORS®, Inc which neither guarantees nor is in any way responsible for it's accuracy. All data is provided "AS IS" and with all it's faults. Data maintained by Sussex County Association of REALTORS®, Inc. may not reflect all real estate activity in the market Keller Williams Realty at the Beach is a Real Estate licensee in the State of Delaware. SCAOR DE License Number: SCAOR 10197.

Copyright 2018 Sussex County Association of REALTORS®, Inc.