|
<%@ 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
Condo rentals Hamilton and condos for rent
Rental homes in Bergenfield New Jersey, holiday rentals in Bergenfield New Jersey, and rent houses
Real estate rentals in Nutley New Jersey, for rent by owner homes, Nutley rental homes, and Nutley New Jersey short term rentals
Lower New Jersey real estate rentals and rent house Lower New Jersey
Apartment rentals in Manville, Manville houses for rent, and for rent by owner homes in Manville New Jersey
Vacation homes for rent by owner Glen Rock, condo rentals in Glen Rock New Jersey, rent houses Glen Rock New Jersey, and apartments for rent Glen Rock New Jersey
Rental houses Harrison New Jersey and homes for rent in Harrison New Jersey
Houses for rent Woodbridge, vacation homes Woodbridge New Jersey, and Woodbridge for rent by owner homes
For rent by owner homes, Roxbury condo rentals, holiday rentals in Roxbury, and rent house in Roxbury New Jersey
Rent house and Rockaway houses for rent
Manalapan New Jersey homes for rent by owner, for rent by owner homes in Manalapan New Jersey, and apartments for rent in Manalapan New Jersey
Rental properties, rental properties, vacation homes for rent by owner Red Bank New Jersey, and Red Bank rental houses
Rental homes Elizabeth New Jersey and homes for rent by owner in Elizabeth New Jersey
Home rentals West New York New Jersey, homes for rent, and West New York New Jersey condos for rent
West Caldwell condo rentals, West Caldwell vacation homes, rent houses, and short term rentals
Rental homes in Winslow New Jersey and Winslow New Jersey homes for rent by owner
Join our mountain ad directories, rustic directories, hidden advertisements, and mountain classifieds mailing list for short term rentals in Raritan New Jersey and vacation rental in Raritan New Jersey.
Identify, recognize, and ascertain Garwood condos for rent, condos for rent in Garwood, and rental houses.
Using our page, land owners chart farmhouse, chalet, and houseboat listings.
Lead off your legwork online on Monday, tomorrow afternoon, or tomorrow afternoon for your apartment rentals Raritan, Raritan New Jersey rental properties, and Raritan New Jersey vacation homes for rent by owner.
Conceive and find rental home Glasser and vacation rental Glasser.
Recognize and contrive Jobstown United States holiday rentals and real estate rentals in Jobstown United States.
Send grand and sightly measurements regarding holiday rentals in Raritan and Raritan New Jersey vacation homes for rent by owner found on this site, FRBO.com.
Identify and catch apartment rentals Monmouth, rent houses in Monmouth New Jersey, and Monmouth homes for rent.
Colleagues, traveling salesmen, and traveling agents who are wishing to hear and identify or simply find information can use our site, FRBO.com.
Generally, thump, relieve, and reinforce your pirates and acquaintances to a in and societal county.
Lake classified advertisements and rustic online MLS vacation rentals in Essex, rental houses Essex, rental homes, and Essex New Jersey rent house.
The Raritan lakefront classified advertisements, beach directories, lakeside listings, and lakefront classifieds for these township can be mapped.
Gamblers, entrepreneurs, and inhabitants prospect, comb, and search for this site, For Rent By Owner (FRBO.com) and observe beach lodge, rustic farmhouse, lake castle, and exotic flat.
You can discern and contrive house rentals Raritan New Jersey and houses for rent Raritan New Jersey.
Distinguish and disclose rent house and bed and breakfast rentals Essex New Jersey.
Contrive, identify, and notice Hunterdon New Jersey rental properties, condos for rent Hunterdon New Jersey, Hunterdon New Jersey real estate rentals, and bed and breakfast rentals in Hunterdon New Jersey.
Relocate, catch, and design rental properties, vacation homes for rent by owner in Belvidere, and vacation rentals Belvidere United States.
This site, FRBO.com can attract and volunteer hidden listings, resort lists of marked properties, exotic directories, and convenient lists of marked properties oceanfront listed properties and well appointed directories to facilitate your Raritan New Jersey outing.
Disclose and look up holiday rentals in Hunterdon New Jersey, rental properties in Hunterdon New Jersey, and rental homes.
Conceive and notice rent house in Margate City and Margate City United States houses for rent.
Explore, uncover, and uncover Warren New Jersey apartment rentals, Warren New Jersey apartment rentals, and for rent by owner homes Warren New Jersey.
Identify, ferret out, and espy bed and breakfast rentals, rental apartment in Little York United States, and apartments for rent Little York United States.
|
|
