Location/Property ID:
Arrival: Leave:
Weekly Rent:
From: To:
Bedrooms: Sleeps:

$0.00 - $0.00 week

Bedrooms: 2 | Sleeps: 6

911 Washington St
Cape May, NJ

$0.00 - $0.00 week

Bedrooms: 7 | Sleeps: 18

35 Jackson St
Cape May, NJ

718 Columbia Ave Cape May

$0.00 - $0.00 week

Bedrooms: 1 | Sleeps: 3

718 Columbia Ave
Cape May, NJ

718 Columbia Ave Cape May

$0.00 - $0.00 week

Bedrooms: 2 | Sleeps: 6

718 Columbia Ave
Cape May, NJ

718 Columbia Ave Cape May

$0.00 - $0.00 week

Bedrooms: 1 | Sleeps: 4

718 Columbia Ave
Cape May, NJ

227 Beach Ave Cape May

$0.00 - $0.00 week

Bedrooms: 2 | Sleeps: 6

227 Beach Ave
Cape May, NJ

$0.00 - $0.00 week

Bedrooms: 4 | Sleeps: 8

415 Sunset Boulevard
West Cape May, NJ

1249 Washington St Cape May

$0.00 - $0.00 week

Bedrooms: 3 | Sleeps: 6

1249 Washington St
Cape May, NJ

1250 Ohio Ave Cape May

$0.00 - $0.00 week

Bedrooms: 2 | Sleeps: 6

1250 Ohio Ave
Cape May, NJ

Query
Template: C:\z_websites\capemayvacations.com\www09\MLS\z_index.cfm
Execution Time: 786 ms
Record Count: 273
Cached: No
Lazy: No
SQL:
SELECT
rp_id,
rp_street,
rp_city,
rp_state,
rp_propID,
rp_beds,
rp_sleeps,
(SELECT ri_localURL
FROM rentalimages_tb
WHERE ri_propertyID = rp_propID
LIMIT 1) AS TheOnePhoto,
(SELECT MAX(rentalrates_tb.rr_rateamt)
FROM rentalrates_tb
WHERE rr_propertyID = rp_propID
ORDER BY rentalrates_tb.rr_rateamt ASC) as themaxRate,
(SELECT Min(rentalrates_tb.rr_rateamt)
FROM rentalrates_tb
WHERE rr_propertyID = rp_propID
ORDER BY rentalrates_tb.rr_rateamt ASC) as theMinRate
FROM rentalprops_tb
WHERE rp_deleted = 0 AND
rp_inactive = 0
AND rp_beds >= 1
AND rp_sleeps >= 1
GROUP BY rp_propID
rp_idrp_streetrp_cityrp_staterp_propIDrp_bedsrp_sleepsTheOnePhotothemaxRatetheMinRate
11700221604 Maryland AveCape MayNJ3209515805340-0.jpg6900800
21700231520 New JerseyCape MayNJ322814806213-0.jpg100100
3170024302 Brainard AvenueCape May PointNJ325448805977-0.jpg3100500
4170025832 Kearney AvenueCape MayNJ3283614806165-0.jpg
51700261003 Kearney AvenueCape MayNJ3284410806500-0.jpg3700400
6170027613 Lighthouse AvenueCape May PointNJ3304410805359-0.jpg24001400
7170028202 Ocean AvenueCape May PointNJ333026805396-0.jpg21001800
81700291005 Beach AveCape MayNJ341224805972-0.jpg
91700301005 Beach AveCape MayNJ341338805970-0.jpg
101700311005 Beach AveCape MayNJ341424805971-0.jpg
11170032510 Pearl AveCape May PointNJ341626805489-0.jpg
12170033652 Hughes StCape MayNJ3417814806108-0.jpg7150500
13170034740 Maple AvenueWest Cape MayNJ3499612805932-0.jpg23001200
14170035OLD OLD OLD 202 Ocean AvenueCape May PointNJ350514805710-0.jpg
15170036714 Lighthouse AveCape May PointNJ354136806564-0.jpg
16170037819 Benton Ave. 2nd/3rd FloorCape MayNJ3551410806557-0.jpg
17170038220 Perry St-SOLD 2017Cape MayNJ3613716806550-0.jpg
18170039805 Pittsburgh Ave.Cape MayNJ361626806552-0.jpg17001175
19170040911 Washington StCape MayNJ365626806110-0.jpg
2017004135 Jackson StCape MayNJ3689718805394-0.jpg
21170042718 Columbia AveCape MayNJ371213
22170043718 Columbia AveCape MayNJ371326
23170044718 Columbia AveCape MayNJ371414
24170045227 Beach AveCape MayNJ381626
25170046415 Sunset BoulevardWest Cape MayNJ386048806458-0.jpg
261700471249 Washington StCape MayNJ388036
271700481250 Ohio AveCape MayNJ388226
28170049311 Howard StreetCape MayNJ4392510806202-0.jpg
29170050908 Stockton AveCape MayNJ5891410806186-0.jpg
30170051915 1/2 Queen StCape MayNJ594926805366-0.jpg
311700521013 Stockton AvenueCape MayNJ5953618811256-0.jpg6100450
321700531013 Stockton AveCape MayNJ595425811257-0.jpg19001900
331700541330C Illinois AvenueCape MayNJ601526
341700551228 New Jersey AveCape MayNJ6016614
351700561413 New Jersey AveCape MayNJ6017620805343-0.jpg110001200
36170057659 Lafayette StCape MayNJ603234820159-0.jpg14001300
371700581214 Maryland AvenueCape MayNJ605736805380-0.jpg15501300
381700591608 Maryland AvenueCape MayNJ6059414806326-0.jpg6100600
391700609 BroadwayCape MayNJ60701625805467-0.jpg6950750
401700611520 New Jersey AvenueCape MayNJ610114806051-0.jpg1150750
41170062641 Hughes StCape MayNJ613426
42170063401 Philadelphia AvenueCape MayNJ754136
43170064207 Congress PlaceCape MayNJ7866716813901-0.jpg
44170065917 Corgie StreetCape MayNJ790926
45170066513 Hughes StreetCape MayNJ8045612805410-0.jpg5300650
461700671015 Beach AvenueCape MayNJ8360616
471700681115 Indiana AvenueCape MayNJ8538412
48170069106 Baltimore AvenueCape MayNJ873038806578-0.jpg39002800
49170070310 Pacific AvenueCape MayNJ8830310
50170071511 Hughes StreetCape MayNJ8868612805446-0.jpg48502250
511700721321D Vermont AvenueCape MayNJ887126
52170073300 Third AvenueWest Cape MayNJ913538806428-0.jpg27902790
53170074926 Washington StreetCape MayNJ1037138805543-0.jpg900900
54170075409 Central AvenueCape May PointNJ1185337806575-0.jpg16001000
55170076409 Central CottageCape May PointNJ1185424806576-0.jpg1300850
561700775 Jackson StCape MayNJ1311325806209-0.jpg
57170078120 Decatur StreetCape MayNJ13128616805440-0.jpg5800500
581700791130 Virginia AveCape MayNJ1373828
591700801629 New York AveCape MayNJ13885410
60170081905 St. James PlaceCape MayNJ1414348
61170082126 Leaming AvenueWest Cape MayNJ1423036
62170083233 Fourth AvenueWest Cape MayNJ1442338806571-0.jpg
63170084203 Lincoln Avenue OLD OWNERCape May PointNJ1452138806322-0.jpg
641700851310 C Pennsylvania Avenue OLDCape MayNJ1559425805718-0.jpg
65170086905 Columbia AvenueCape MayNJ15948410
66170087905 Columbia AvenueCape MayNJ15953410
67170088115 York Ave.Cape MayNJ1684026
681700891033 Washington St.Cape MayNJ1834824
691700901033 Washington St.Cape MayNJ1835024
70170091701 Lighthouse AvenueCape May PointNJ1955738806010-0.jpg18751375
71170092720 Maple AvenueWest Cape MayNJ2188126805457-0.jpg14001200
72170093309 Ocean AvenueCape May PointNJ2210648806214-0.jpg
73170094205 Perry StreetCape MayNJ22226412
74170095621 Lafayette StreetCape MayNJ2246224
75170096422 Third Ave.West Cape MayNJ2248226
76170097712 Corgie Street Old Info don t useCape MayNJ2312524805711-0.jpg
771700989 Jackson StCape MayNJ2326514806457-0.jpg
78170099421 West Perry StreetWest Cape MayNJ2358424
79170100910 Columbia AvenueCape MayNJ2588048805425-0.jpg33001900
80170101637 Seagrove AvenueCape May PointNJ2597348806111-0.jpg3075325
81170102639 Seagrove AvenueCape May PointNJ2597724806112-0.jpg1875175
821701031424 New Jersey AvenueCape MayNJ26186722818757-0.jpg1300013000
83170104819 Kearney AvenueCape MayNJ26231816805441-0.jpg6800600
841701051032 Maryland AvenueCape MayNJ2741836806568-0.jpg
85170106201 Beach AvenueCape MayNJ2790948806333-0.jpg63002900
86170107915 Reading AveCape MayNJ2836738806481-0.jpg
87170108803 St. James PlaceCape MayNJ3053348805570-0.jpg37002900
88170109615 Broad StCape MayNJ3210458805719-0.jpg
89170110225 Grant StreetCape MayNJ32965922806551-0.jpg95001300
90170111429 Third AvenueWest Cape MayNJ3663726805541-0.jpg17001700
911701121140 Illinois AvenueCape MayNJ3803326
92170113129 Third AvenueCape MayNJ39610512
9317011441 Jackson Street-SOLD 2016Cape MayNJ41469410
94170115414 North BroadwayWest Cape MayNJ4297848806438-0.jpg
951701161033 Washington StCape MayNJ4304216
961701171033 Washington StCape MayNJ4304516
97170118515 Franklin StreetCape MayNJ4331336
98170119515 Franklin StreetCape MayNJ4331536
99170120514 Hughes StreetCape MayNJ43662615805712-0.jpg
10017012111 North StreetCape MayNJ4420026806497-0.jpg
1011701221311 D Illinois AvenueCape MayNJ4461726804883-0.jpg1200150
102170123531-533 Bank Street CondominiumCape MayNJ4831338
103170124531-533 Bank Street CondominiumCape MayNJ4832036
104170125OLD OLD OLD 227 Beach AvenueCape MayNJ4911438805484-0.jpg
105170126547 Sunset BoulevardCape MayNJ5220536806525-0.jpg1950200
106170127316 Third AveWest Cape MayNJ77551514806429-0.jpg44904490
1071701281232 Ohio AvenueCape MayNJ7910326
10817012915 BroadwayCape MayNJ79226372750250
109170130910 Lafayette StreetCape MayNJ8006338805723-0.jpg2900260
110170131103 S. BroadwayCape MayNJ8085128806570-0.jpg22501700
1111701321341 D Illinois AvenueCape MayNJ8216926806115-0.jpg
112170133232-34 Windsor AveCape MayNJ8221426
113170134232-34 Windsor AveCape MayNJ8221826
114170300819 Beach AvenueCape MayNJ9242514806194-0.jpg975800
115170136114 Decatur StreetCape MayNJ92478616805487-0.jpg7625700
116170137OLD OLD 12 North StCape MayNJ92497518805488-0.jpg
1171701391065 Idaho AvenueCape MayNJ9259028
1181701401217 Washington StCape MayNJ9262612
1191701411217 Washington StCape MayNJ9262734
1201701421217 Beach AvenueCape MayNJ92696413860319-0.jpg6600500
1211701431223 Illinois AveCape MayNJ9269927805348-0.jpg14501075
1221701441800 Maryland AvenueCape MayNJ9270238805479-0.jpg36003600
123170145933 Beach AveCape MayNJ9274826
124170146933 Beach AveCape MayNJ9274912
125170147933 Beach AveCape MayNJ9275325
126170148933 Beach AveCape MayNJ9275414
127170149933 Beach AveCape MayNJ9275538
1281701501731 New York AveCape MayNJ92762510806169-0.jpg
129170151202 Ocean Avenue OLD OLDCape May PointNJ9279814
1301701521007 New Jersey AvenueCape MayNJ9281248805941-0.jpg39003400
131170153218 Second AvenueWest Cape MayNJ9282128815130-0.jpg19201920
1321701541240 Delaware AveCape MayNJ9283638805407-0.jpg18001800
1331701551527 New Jersey AvenueCape MayNJ92843410806555-0.jpg59005900
134170156423 Third AvenueWest Cape MayNJ9287826805386-0.jpg
135170301108 South BroadwayCape MayNJ92925616806104-0.jpg5200500
136170158917 Stockton AveCape MayNJ92947512805346-0.jpg54003000
137170159102-102 Saint James PlaceCape MayNJ9313536
1381701601049 Lafayette StreetCape MayNJ9316014
1391701611012 Maryland Ave.Cape MayNJ93451616806492-0.jpg9600825
1401701623311 Bayshore RdCape MayNJ9413224
1411701631341 Illinois AvenueCape MayNJ9419225
142170164300 Columbia AvenueWest Cape MayNJ9477338806547-0.jpg
1431701651162 DelawareCape MayNJ9495936805478-0.jpg
144170166204 Whilldin AvenueCape May PointNJ95863612806211-0.jpg39003400
1451701671379 Washington StreetCape MayNJ9634238
146170168925 Farmdale DriveWest Cape MayNJ9634448
147170169100 Broadway SOLDCape MayNJ96369410804835-0.jpg
148170170211 Beach AveCape MayNJ9703114852012-0.jpg2150275
149170171624 Broad StreetCape MayNJ970413616151615
150170172624 Broad StreetCape MayNJ9704236
151170173211 Beach AvenueCape MayNJ9705726852013-0.jpg2750375
152170174Do not Use 817 Stockton AvenueCape MayNJ9709316
1531701751027 Lafayette StreetCape MayNJ9712549806027-0.jpg
15417017610 BroadwayCape MayNJ97136816806559-0.jpg4500400
1551701771748 New York AvenueCape MayNJ97212512805460-0.jpg
156170178824 Stockton AvenueCape MayNJ97300619811812-0.jpg6750650
157170179145 Yorke AvenueWest Cape MayNJ9734938806561-0.jpg2650250
158170180201 Beach AvenueCape MayNJ9776148
159170302211 Beach AvenueCape MayNJ9908814852016-1.jpg2200275
160170182915 Columbia AveCape MayNJ100272515805471-0.jpg
1611701831129 Washington St.Cape MayNJ10032137
162170184201 Third AvenueWest Cape MayNJ10105848805959-0.jpg
163170185806 Benton AvenueCape MayNJ101516512806193-1.jpg44501975
1641701865 Swan AvenueCape MayNJ10152338805953-0.jpg2400250
16517018723 Mt Vernon AvenueCape MayNJ10155148805934-0.jpg37003700
1661701881 Wilmington AvenueCape MayNJ10171248806515-0.jpg4900400
167170189408 Pacific AvenueWest Cape MayNJ10203826805943-0.jpg1600215
1681701901005 Pittsburgh AvenueCape MayNJ105315410882970-0.jpg3100350
16917019112 E. Mechanic StreetWest Cape MayNJ10779436806037-0.jpg15751100
17017019216 S. BroadwayCape MayNJ108357515806498-0.jpg
171170193306 Second AvenueWest Cape MayNJ10893638805356-0.jpg
1721701941042 Ohio AveneCape MayNJ10905438806002-23.jpg23001800
173170195409 Princeton AvenueCape May PointNJ11421748806487-0.jpg2500275
174170196605 Broad StreetCape MayNJ11704026806162-0.jpg13001300
17517019723 Race Track DriveNorth Cape MayNJ11737512806471-0.jpg755755
1761701981312 MarylandCape MayNJ117570616
177170199324 First AvenueWest Cape MayNJ118733510852017-0.jpg5750500
178170200707 Winslow AveNorth Cape MayNJ119462514806446-0.jpg
179170201680 Washington Street- OLD DO NOT USECape MayNJ12043538806556-0.jpg
18017020231 First AveCape MayNJ12049338805370-0.jpg25002500
18117020325 BeverlyTownbankNJ12063026805439-0.jpg
182170204211 Beach AvenueCape MayNJ12167014851984-0.jpg2150275
183170205211 Beach AvenueCape MayNJ12167214851985-0.jpg2150275
184170206215 Heritage TriangleCape MayNJ12301626805725-0.jpg2900175
185170207305 St. James PlaceCape MayNJ12304438805432-0.jpg
186170208304 S. BroadwayWest Cape MayNJ12326526806554-0.jpg1975145
1871702091625 Beach AvenueCape MayNJ12352426806167-0.jpg
188170210207 Second AvenueWest Cape MayNJ12353236805349-0.jpg1900190
189170211418 Elmira StreetCape MayNJ12403537810368-0.jpg1850275
190170212113 First AvenueCape MayNJ12452426811970-0.jpg19501950
191170213OLD 211 Beach AvenueCape MayNJ12513314852002-1.jpg2150275
192170214109B First AvenueCape MayNJ12527126806348-0.jpg1400975
193170215211 Beach Avenue DO NOT USECape MayNJ12622526852003-0.jpg
194170219905 McCullum AvenueCape MayNJ12640836900276-0.jpg21001300
195170220212 BroadwayWest Cape MayNJ12651612805720-0.jpg
196170221819 Beach Ave.Cape MayNJ1271551612501250
197170222629 Sea Grove Ave.Cape MayNJ12730738815252-0.jpg
198170223603 Leaming AvenueNorth Cape MayNJ12761124806203-0.jpg
1991703031534 Yacht AvenueCape MayNJ12787026811344-0.jpg2050195
200170225302 Central AvenueCape May PointNJ12818614805713-0.jpg
201170226117 Eldredge AvenueWest Cape MayNJ13031549811340-0.jpg1700150
202170227313 Fourth AveWest Cape MayNJ130776615804890-0.jpg35001500
2031702281005 Pittsburgh AvenueCape MayNJ13085348806191-0.jpg
204170229437 Sunset BoulevardWest Cape MayNJ13090126815253-0.jpg25001000
205170230216 BrainardCape May PointNJ13100426807487-0.jpg
2061702311005 Pittsburgh AveCape MayNJ13105448807939-0.jpg
207170232214 WindsorCape MayNJ131090613808315-0.jpg
2081702331513 Beach AveCape MayNJ13113426808764-0.jpg19001900
2091702341621 Beach AveCape MayNJ13127926810081-0.jpg
2101702351105 Ohio AveCape MayNJ13128538810093-0.jpg
2111702361125 Maryland AveCape MayNJ13129726810119-0.jpg
212170237115 Townbank RdCape MayNJ13130825810152-0.jpg
213170238918 Columbia AveCape MayNJ131413513810752-0.jpg
214170239410 State StCape May13149626811477-0.jpg
2151702401342 OhioCape MayNJ13150724811625-0.jpg
216170241357 S. Leipzig AveEgg HarborNJ13158736812318-0.jpg11001100
217170242215 Heritage TriangleCape MayNJ13161126812444-0.jpg
218170243202 Lincoln AveCape May PointNJ13163825812912-0.jpg15501550
219170244439 Third AveWest Cape MayNJ13166447813096-0.jpg32001300
2201702457 Elwood AptCape May BeachNJ13166824813134-0.jpg
221170246971 Sewell AveCape MayNJ131673417813157-0.jpg24502450
222170247826 Washington StreetCape MayNJ13168022813189-0.jpg12001200
223170248246 6th AveWest Cape MayNJ13168949813243-0.jpg1700150
224170249126 Fourth AveWest Cape MayNJ131704312813296-0.jpg
2251702501243 Pennsylvania AvenueCape MayNJ13175626838065-0.jpg1425150
2261702514 Brookdale RoadTownbankNJ13177626813816-0.jpg
2271702521016 Maryland AveCape MayNJ131855512814315-0.jpg
2281702531520 New Jersey AveCape MayNJ13192016814949-0.jpg
229170254123 York AveWest Cape MayNJ13204724816109-0.jpg
23017025516 Jackson StCape MayNJ13205125816173-0.jpg
2311702561061 Seashore RdCape MayNJ132092412816590-0.jpg
232170257413 Jefferson StreetCape MayNJ132126512816934-0.jpg5400395
233170258306 1/2 BroadwayWest Cape MayNJ13220912750750
234170259628 HughesCape MayNJ13222012818198-0.jpg
23517026020 Mowery AveVillasNJ13226848819271-0.jpg16501650
23617026120 Second AveCape MayNJ13229324819840-0.jpg
237170262307 Second AveWest Cape MayNJ13229437819853-0.jpg
238170263320 First AveWest Cape mayNJ13229526819857-0.jpg
239170264407 Lincoln AveCape May PointNJ13235138821279-0.jpg
240170265847 BroadwayWest Cape MayNJ13237538848159-0.jpg2800225
241170266847 BroadwayWest Cape MayNJ13237838848158-0.jpg2800225
2421702671 Atlantic TerraceCape MayNJ13251926828044-0.jpg1300200
2431702681374 Lafayette StCape MayNJ132571414829324-0.jpg21501400
24417027042 Jackson StreetCape MayNJ132935262250225
24517027118 Jackson StCape MayNJ13307236839310-0.jpg
246170272500 Fourth AveWest Cape MayNJ1336252212001200
247170273819 Benton AveCape MayNJ13373424845578-0.jpg
24817027410 Congress St.Cape MayNJ13403824848592-0.jpg
2491703041351 DelawareCape MayNJ13408426848944-0.jpg1800190
2501702761107 Beach AvenueCape MayNJ13413438849343-0.jpg3300450
251170277103 Delair RoadCape MayNJ13439926
25217027818 Jackson StreetCape MayNJ134557262400175
25317027921 BeverlyNorth Cape MayNJ13456538852663-0.jpg
254170280805 Pittsburgh AvenueCape MayNJ13505438856075-0.jpg2500850
255170281503 BayshoreWest Cape MayNJ135649614863178-0.jpg3200300
256170282202 Ocean AvenueCape May PointNJ136474141350925
257170283710 KearneyCape MayNJ136835614887267-0.jpg6800685
2581702841114 Lafayette StreetCape MayNJ136921512892951-0.jpg
25917028512 North StreetCape MayNJ1371135196250650
2601702869 MechanicCape MayNJ13749638893977-1.jpg18501500
261170287OLD 227 Beach Avenue- do not useCape MayNJ13764838
262170288227 Beach AvenueCape MayNJ1376533838001250
263170289680 Washington Not Renting StreetCape MayNJ13820938
264170290906 Stockton AvenueCape MayNJ138218372450250
265170291906 Stockton AvenueCape MayNJ138219373150250
266170292202 Ocean AvenueCape May PointNJ1382371412251100
2671702931105 Ohio AveCape MayNJ13869038906010-0.jpg2600250
268170294478 W. PerryWest Cape MayNJ13871839906691-0.jpg16501650
269170295480 W. PerryWest Cape MayNJ13872125906702-0.jpg
2701702961382 Lafayette StCape MayNJ13888346
271170297211 Beach AvenueCape MayNJ1389072627501150
272170298211 Beach AvenueCape MayNJ138997142150275
273170299500 Adriatic AveNorth Cape MayNJ13924946921016-0.jpg1950300
Home | Find A Rental | Buy A Property | Sell A Property | Links | Our Agents | News | Contact Us
1382 Lafayette Street · Cape May, NJ 08204 ·(800)-648-5558 · c21gilmart@aol.com
Joseph T. Gilmartin, Owner/Broker
REALTOR®-A registered collective membership mark which identifies a real estate professional who is a
member of the NATIONAL ASSOCIATION OF REALTORS® and subscribes to its strict Code of Ethics.
designed by: www.emaxed.com
©2018 CENTURY 21 Gilmartin & Company. CENTURY 21® and the CENTURY 21 Logo are registered service marks owned by CENTURY 21 Real Estate LLC. Equal Housing Opportunity. Each office is independently owned and operated.