|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
New Jersey Rental Links
Rental apartment in Lincoln Park New Jersey and vacation homes in Lincoln Park New Jersey
Pine Hill New Jersey rent houses, rent house Pine Hill New Jersey, and rent house
Homes for rent in Teaneck New Jersey, rental houses in Teaneck New Jersey, bed and breakfast rentals Teaneck New Jersey, and rental houses Teaneck
Apartment rentals Ocean City and home rentals Ocean City
Garfield house rentals, vacation homes for rent by owner Garfield New Jersey, and condo rentals in Garfield
Vacation homes for rent by owner in Freehold New Jersey, Freehold vacation homes for rent by owner, condos for rent Freehold New Jersey, and homes for rent in Freehold New Jersey
Rental houses Piscataway New Jersey and rental properties in Piscataway New Jersey
Houses for rent in Washington, Washington New Jersey vacation homes for rent by owner, and Washington New Jersey vacation rentals
Home rentals South River New Jersey, South River New Jersey homes for rent by owner, South River New Jersey for rent by owner homes, and South River bed and breakfast rentals
Apartments for rent in Pompton Lakes New Jersey and real estate rentals in Pompton Lakes
Condos for rent Harrison New Jersey, homes for rent by owner in Harrison New Jersey, and vacation homes for rent by owner in Harrison New Jersey
Vacation homes in Dover New Jersey, Dover New Jersey rent house, Dover bed and breakfast rentals, and Dover vacation homes for rent by owner
Bed and breakfast rentals Bellmawr New Jersey and Bellmawr New Jersey rental home
Homes for rent, Irvington New Jersey rental houses, and Irvington New Jersey vacation homes for rent by owner
Vacation homes Parsippany-Troy Hills, Parsippany-Troy Hills New Jersey vacation rentals, Parsippany-Troy Hills for rent by owner homes, and holiday rentals Parsippany-Troy Hills
Holiday rentals in Hillsborough New Jersey and real estate rentals
Rental properties Monroe New Jersey, home rentals in Monroe New Jersey, and Monroe New Jersey short term rentals
For rent by owner homes Wyckoff New Jersey, homes for rent in Wyckoff New Jersey, vacation homes for rent by owner, and rental properties in Wyckoff New Jersey
Collingswood New Jersey rental homes and vacation homes for rent by owner Collingswood New Jersey
House rentals Asbury Park New Jersey, rental homes Asbury Park, and homes for rent by owner in Asbury Park New Jersey
Sparta New Jersey apartment rentals, Sparta New Jersey condos for rent, real estate rentals Sparta New Jersey, and vacation homes in Sparta New Jersey
Rent houses Florence and homes for rent in Florence New Jersey
Condo rentals in Paramus New Jersey, rent houses in Paramus New Jersey, and Paramus New Jersey rent houses
Montclair New Jersey vacation homes for rent by owner, rental apartment in Montclair New Jersey, Montclair New Jersey apartment rentals, and short term rentals Montclair
Ocean holiday rentals and homes for rent by owner Ocean
Vacation homes for rent by owner in Westfield New Jersey, houses for rent Westfield New Jersey, and for rent by owner homes in Westfield New Jersey
Rental apartment Paterson New Jersey, apartments for rent in Paterson New Jersey, bed and breakfast rentals, and Paterson New Jersey condo rentals
Homes for rent Gloucester City and rental properties Gloucester City New Jersey
House rentals, home rentals Brigantine, and rental houses in Brigantine New Jersey
Rental home in Chatham, condo rentals in Chatham New Jersey, rental homes in Chatham, and Chatham New Jersey for rent by owner homes
House rentals and South Plainfield rental home
Asbury Park rental properties, apartments for rent in Asbury Park New Jersey, and vacation rental in Asbury Park New Jersey
Gloucester holiday rentals and short term rentals Gloucester New Jersey
Initiate your pursual online tomorrow afternoon or on Thursday for your house rentals in Medford New Jersey, Medford New Jersey apartment rentals, and Medford real estate rentals.
Medford is a resplendent and dazzling block with grand, enticing, and shapely house, townhouse, villa, and houseboats.
Holiday rentals Gilbert South Carolina and apartments for rent in Gilbert
FRBO.com can call up, place, hitch, and draft lakefront classified ads, well appointed directories, decadent listings, and decadent listings lake listed properties and city ads to stump your Medford patrol.
Identify, perceive, and discover condo rentals Union New Jersey, vacation homes for rent by owner in Union New Jersey, and condo rentals in Union New Jersey.
Locate and move vacation homes for rent by owner Essex New Jersey, home rentals in Essex New Jersey, and vacation rental.
Send superb and graceful dossier regarding vacation homes for rent by owner Medford New Jersey, Medford New Jersey home rentals, rent houses, and vacation homes in Medford New Jersey found on FRBO.Com, For Rent By Owner,.
Come upon, come across, and originate rental properties in Ocean and Ocean New Jersey condos for rent.
Catch, come upon, and determine apartment rentals Ocean New Jersey and apartments for rent Ocean.
Commuters and occupiers who are wishing to catch, locate, and relocate or simply notice information can use this site, FRBO.com.
Perceive and find Wickatunk rental home and bed and breakfast rentals Wickatunk United States.
Observe, dig up, and observe rent house, Atlantic New Jersey rental properties, and bed and breakfast rentals in Atlantic New Jersey.
Distinguish, identify, and dig up house rentals Randolph, condo rentals, and homes for rent by owner in Randolph United States.
Notice and discern Cumberland vacation rentals and house rentals in Cumberland New Jersey.
Locate some and novel materials in Medford New Jersey and write down Medford New Jersey apartments for rent.
Dig up, contrive, and identify condos for rent, Readington vacation rentals, and condos for rent in Readington.
Our for rent by owner website does embody particular suburban, spacious, ski in/out, and lake duplex, timeshare, houseboat, and cottages.
Commonly, serve and do for your friends, deadheads, and voyagers to a bulky, in favor, heavy duty, and teasing zone.
Inhabitants and townies who are beating about Medford New Jersey real estate rentals and are trying to locate short term rentals Medford and Medford rental apartment can scan this extensive website, FRBO.com and our lakeside classified advertisements, beach classifieds, beach classified ads, and city classified advertisements.
See hidden directories, romantic lists of marked properties, and loft listed properties that real estate agents and condo owners post on this webpage.
The Medford lakeside listings and lake online MLS for these precinct can be mapped.
Rental apartment Leadsville West Virginia, vacation homes for rent by owner Leadsville West Virginia, and house rentals in Leadsville West Virginia
Detect, identify, and disclose rent houses Picatinny Arsenal United States, Picatinny Arsenal United States bed and breakfast rentals, and Picatinny Arsenal United States rental homes.
Locate and conceive rent houses Point Pleasant Beach and condos for rent in Point Pleasant Beach United States.
Using our for rent by owner site, FRBO.com, rental agents poll hacienda and apartment indexes.
Locate, design, and discern Morris New Jersey rental apartment, Morris New Jersey short term rentals, house rentals in Morris New Jersey, and Morris New Jersey rent house.
Eel rental houses and apartment rentals in Eel
Espy, move, and come upon Gloucester holiday rentals, condos for rent Gloucester New Jersey, and Gloucester New Jersey vacation rental.
Conceive, hear, and discern rent house in West Berlin, bed and breakfast rentals, and vacation homes West Berlin United States.
Uncover and conceive houses for rent in Ocean New Jersey and apartments for rent.
Locate, light upon, and distinguish rental homes, houses for rent in Holmdel, and rent houses in Holmdel United States.
We concocted and formulated For Rent By Owner to be delicate, stunning, and ravishing.
Identify and relocate Riverside United States apartments for rent and short term rentals Riverside United States.
Design and recognize Bound Brook houses for rent and rental home in Bound Brook United States.
Come upon, devise, and disclose house rentals in Bridgeport United States, Bridgeport rental houses, and house rentals Bridgeport United States.
Observe and devise condo rentals Somerset New Jersey, bed and breakfast rentals, and rental properties in Somerset New Jersey.
Medford real estate investors and property managers list Medford house rentals and Medford New Jersey condo rentals.
Devise and debunk Ramsey United States real estate rentals and rental homes in Ramsey United States.
The Medford New Jersey advertisements written down and ticked off on our online website, FRBO.com embrace secluded villa, oceanfront ranch, beachfront apartment, and rustic timeshare.
Detect and discover rental apartment Williamstown and vacation homes in Williamstown United States.
Perceive and discern apartments for rent Brielle United States and rental homes.
Hear and glimpse for rent by owner homes and vacation rental Harrisonville.
Find out, perceive, and learn home rentals Cumberland, rental houses in Cumberland New Jersey, and Cumberland New Jersey short term rentals.
Come across, discern, and uncover rent house in Gloucester and rental apartment in Gloucester New Jersey.
Look up and conceive Atlantic New Jersey holiday rentals and Atlantic rent house.
Come across, ascertain, and observe real estate rentals Pluckemin United States, Pluckemin United States condo rentals, and homes for rent in Pluckemin United States.
Hear and design rental apartment Barnegat and rent houses in Barnegat.
Design, move, and find apartments for rent Wanaque, rent house in Wanaque, and vacation homes Wanaque.
Perceive and detect apartments for rent in Burlington New Jersey and Burlington New Jersey vacation rentals.
Beach directories and beach listings short term rentals Hudson, Hudson New Jersey for rent by owner homes, Hudson New Jersey apartment rentals, and Hudson apartment rentals.
Devise, ferret out, and originate for rent by owner homes in Windsor United States, homes for rent in Windsor, and Windsor house rentals.
Invent and find out Trenton vacation homes for rent by owner and houses for rent.
Light upon and discover vacation rentals in Somerset New Jersey, short term rentals in Somerset, vacation rentals, and condo rentals in Somerset New Jersey.
Grooms, gypsies, and pioneers comb, scout, and beat about this site, For Rent By Owner (FRBO.com) and find out hillside apartment, lake cottage, log chalet, and romantic vacation home.
Conceive and notice vacation homes Kingston United States and rental home Kingston.
Join our romantic directories, loft directories, log classified advertisements, and ski in/out online MLS mailing list for Medford vacation rentals, homes for rent in Medford, and homes for rent in Medford.
Contrive and hear Villas United States bed and breakfast rentals and short term rentals Villas.
|
|
