Spotlight on North 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` = 'North Rehoboth') ORDER BY `ListingPrice` DESC, `t1`.`id` ASC) p USING(`id`) ORDER BY `ListingPrice` DESC, `t1`.`id` ASC"
Price, High to Low
31 Properties Found.
Photo of Listing #1001799220
  • MLS® #: 1001799220
  • 65 & 67 Lake Ave
  • REHOBOTH BEACH, DE 19971
  • $3,250,000
  • 14 Bed, 12½ Bath, 0.12 Acres
  • Residential
Add as Favorite
Photo of Listing #1001565154
  • MLS® #: 1001565154
  • 33 Park Ave
  • REHOBOTH BEACH, DE 19971
  • $2,795,000
  • 4 Bed, 4½ Bath
  • Residential
Add as Favorite
Photo of Listing #1001571026
  • MLS® #: 1001571026
  • 54 Park Ave
  • REHOBOTH BEACH, DE 19971
  • $2,495,000
  • 5 Bed, 5½ Bath, 2970 SqFt, 0.11 Acres
  • Residential
Add as Favorite
Photo of Listing #1001571868
  • MLS® #: 1001571868
  • 48 Park Ave
  • REHOBOTH BEACH, DE 19971
  • $2,495,000
  • 5 Bed, 5½ Bath, 3000 SqFt, 0.11 Acres
  • Residential
Add as Favorite
Photo of Listing #1001574040
  • MLS® #: 1001574040
  • 53 Columbia Ave
  • REHOBOTH BEACH, DE 19971
  • $2,398,000
  • 5 Bed, 5½ Bath, 3120 SqFt, 0.17 Acres
  • Residential
Add as Favorite
Photo of Listing #1001568824
  • MLS® #: 1001568824
  • 114 Henlopen Ave
  • REHOBOTH BEACH, DE 19971
  • $2,299,000
  • 5 Bed, 5½ Bath, 4823 SqFt, 0.19 Acres
  • Residential
Add as Favorite
Photo of Listing #1001569496
  • MLS® #: 1001569496
  • 25 Olive Ave
  • REHOBOTH BEACH, DE 19971
  • $2,250,000
  • 8 Bed, 4 Bath, 6000 SqFt, 0.18 Acres
  • Residential
Add as Favorite
Photo of Listing #1001566730
  • MLS® #: 1001566730
  • 55 Maryland Ave
  • REHOBOTH BEACH, DE 19971
  • $2,199,900
  • 4 Bed, 3½ Bath, 2600 SqFt, 0.11 Acres
  • Residential
Add as Favorite
Photo of Listing #1001899434
  • MLS® #: 1001899434
  • 31 Olive Ave #a
  • REHOBOTH BEACH, DE 19971
  • $2,047,000
  • 7 Bed, 7½ Bath, 4200 SqFt
  • Residential
Add as Favorite
Photo of Listing #1001573356
  • MLS® #: 1001573356
  • 42 Pennsylvania Ave
  • REHOBOTH BEACH, DE 19971
  • $1,850,000
  • 5 Bed, 3 Bath, 3960 SqFt, 0.11 Acres
  • Residential
Add as Favorite
Photo of Listing #1001570656
  • MLS® #: 1001570656
  • 73 Lake Ave
  • REHOBOTH BEACH, DE 19971
  • $1,730,000
  • 5 Bed, 4½ Bath, 2850 SqFt, 0.11 Acres
  • Residential
Add as Favorite
Photo of Listing #1001569802
  • MLS® #: 1001569802
  • 37 Virginia Ave
  • REHOBOTH BEACH, DE 19971
  • $1,698,900
  • 7 Bed, 3½ Bath, 2640 SqFt
  • Residential
Add as Favorite
Photo of Listing #1001569170
  • MLS® #: 1001569170
  • 32 Sussex St
  • REHOBOTH BEACH, DE 19971
  • $1,645,000
  • 5 Bed, 4½ Bath, 2500 SqFt, 0.1 Acres
  • Residential
Add as Favorite
Photo of Listing #1001567612
  • MLS® #: 1001567612
  • 41 Baltimore Ave
  • REHOBOTH BEACH, DE 19971
  • $1,499,000
  • 7 Bed, 8 Bath, 3000 SqFt, 0.11 Acres
  • Residential
Add as Favorite
Photo of Listing #1001567564
  • MLS® #: 1001567564
  • 98 Sussex St
  • REHOBOTH BEACH, DE 19971
  • $1,450,000
  • 4 Bed, 4½ Bath, 3200 SqFt, 0.11 Acres
  • Residential
Add as Favorite
Photo of Listing #1001569046
  • MLS® #: 1001569046
  • 31 Virginia Ave
  • REHOBOTH BEACH, DE 19971
  • $1,375,000
  • 5 Bed, 3 Bath, 2700 SqFt, 0.07 Acres
  • Residential
Add as Favorite
Photo of Listing #1001572526
  • MLS® #: 1001572526
  • 527 N Boardwalk #710
  • REHOBOTH BEACH, DE 19971
  • $1,328,000
  • 2 Bed, 2 Bath, 1450 SqFt
  • Residential
Add as Favorite
Photo of Listing #1001571872
  • MLS® #: 1001571872
  • 10 Cookman St
  • REHOBOTH BEACH, DE 19971
  • $1,249,000
  • 5 Bed, 3 Bath, 3000 SqFt, 0.09 Acres
  • Residential
Add as Favorite
Photo of Listing #1001572254
  • MLS® #: 1001572254
  • 527 N Boardwalk #206
  • REHOBOTH BEACH, DE 19971
  • $825,000
  • 2 Bed, 2 Bath, 1340 SqFt
  • Residential
Add as Favorite
Photo of Listing #1001569624
  • MLS® #: 1001569624
  • 527 N Boardwalk #617
  • REHOBOTH BEACH, DE 19971
  • $695,000
  • 2 Bed, 2 Bath, 1340 SqFt
  • Residential
Add as Favorite
Photo of Listing #1001573890
  • MLS® #: 1001573890
  • 2 Virginia Ave #525
  • REHOBOTH BEACH, DE 19971
  • $624,900
  • 2 Bed, 2 Bath, 1375 SqFt
  • Residential
Add as Favorite
Photo of Listing #1001568374
  • MLS® #: 1001568374
  • 32 Maryland Ave #4
  • REHOBOTH BEACH, DE 19971
  • $600,000
  • 3 Bed, 2 Bath, 1300 SqFt, 0.11 Acres
  • Residential
Add as Favorite
Photo of Listing #1001570530
  • MLS® #: 1001570530
  • 2 Virginia Ave #211
  • REHOBOTH BEACH, DE 19971
  • $539,000
  • 1 Bed, 1 Bath, 997 SqFt
  • Residential
Add as Favorite
Photo of Listing #1001565958
  • MLS® #: 1001565958
  • 1 Virginia Ave #204
  • REHOBOTH BEACH, DE 19971
  • $525,000
  • 2 Bed, 1 Bath, 712 SqFt
  • Residential
Add as Favorite
Photo of Listing #1001570244
  • MLS® #: 1001570244
  • 1 Virginia Ave #106
  • REHOBOTH BEACH, DE 19971
  • $525,000
  • 2 Bed, 2 Bath, 800 SqFt
  • Residential
Add as Favorite
Photo of Listing #1001585696
  • MLS® #: 1001585696
  • 1 Virginia Ave #316
  • REHOBOTH BEACH, DE 19971
  • $465,000
  • 1 Bed, 1 Bath, 673 SqFt
  • Residential
Add as Favorite
Photo of Listing #1001570130
  • MLS® #: 1001570130
  • 59 Maryland Ave
  • REHOBOTH BEACH, DE 19971
  • $439,000
  • 1 Bed, 1 Bath, 645 SqFt
  • Residential
Add as Favorite
Photo of Listing #1001566040
  • MLS® #: 1001566040
  • 59 Maryland Ave #401a
  • REHOBOTH BEACH, DE 19971
  • $424,900
  • 1 Bed, 1 Bath, 750 SqFt
  • Residential
Add as Favorite
Photo of Listing #1001873342
  • MLS® #: 1001873342
  • 2 Virginia Ave #218
  • REHOBOTH BEACH, DE 19971
  • $362,000
  • 1 Bath
  • Residential
Add as Favorite
Photo of Listing #1001805242
  • MLS® #: 1001805242
  • 49 Maryland Ave #d
  • REHOBOTH BEACH, DE 19971
  • $360,000
  • 3 Bed, 1 Bath
  • Residential
Add as Favorite
Photo of Listing #1001805522
  • MLS® #: 1001805522
  • 58 Maryland Ave #6
  • REHOBOTH BEACH, DE 19971
  • $360,000
  • 2 Bed, 1 Bath
  • Residential
Add as Favorite

North 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` = 'North 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.