|
<%@ 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
North Brunswick rental apartment and for rent by owner homes North Brunswick New Jersey
Holiday rentals in Hillside, rental properties in Hillside New Jersey, and short term rentals Hillside
West Windsor New Jersey holiday rentals, vacation rental in West Windsor New Jersey, short term rentals in West Windsor, and West Windsor New Jersey real estate rentals
Randolph New Jersey condos for rent and vacation rental in Randolph New Jersey
Rent house, condos for rent in East Orange New Jersey, and vacation rental in East Orange New Jersey
Homes for rent in Pine Hill New Jersey, Pine Hill vacation rentals, short term rentals Pine Hill New Jersey, and rental houses Pine Hill New Jersey
Holiday rentals in Verona New Jersey and Verona New Jersey rental apartment
Monroe New Jersey rent house, rental apartment in Monroe, and Monroe New Jersey rental homes
Belleville New Jersey rental apartment, short term rentals in Belleville New Jersey, rental houses Belleville, and vacation rentals in Belleville
Condos for rent and Galloway New Jersey rent houses
Rental houses in Lincoln Park New Jersey, bed and breakfast rentals in Lincoln Park New Jersey, and Lincoln Park New Jersey rent house
Aberdeen bed and breakfast rentals, vacation rental in Aberdeen, Aberdeen New Jersey vacation rental, and rental homes
Clinton New Jersey holiday rentals and Clinton New Jersey apartments for rent
Rental apartment Phillipsburg, short term rentals Phillipsburg, and vacation rentals in Phillipsburg New Jersey
Recognize, ascertain, and ascertain Ocean New Jersey homes for rent, short term rentals in Ocean, and vacation rental in Ocean New Jersey.
Detect and discern rent houses in Eatontown and Eatontown vacation rental.
Move, relocate, and detect rental apartment in Fort Monmouth United States, apartment rentals in Fort Monmouth United States, and holiday rentals Fort Monmouth.
Sorority sisters and subordinates who are wishing to devise and devise or simply come across information can use this site, FRBO.com.
Identify, design, and find out rental properties in Clayton United States, apartment rentals in Clayton United States, and Clayton rent houses.
Lumberton rental agents and third party listing companies list rental apartment in Lumberton New Jersey, rent houses Lumberton New Jersey, condos for rent, and short term rentals.
Come upon and distinguish the tract and approaching Lumberton New Jersey section.
Dig up, relocate, and detect house rentals in Delaware, Delaware homes for rent, and Delaware home rentals.
This extensive website, FRBO.com can hitch, recruit, and get city online MLS, resort listings, waterfront classified ads, and beach listed properties beach advertisements, penthouse listings, exotic indexes, and oceanfront ads to sustain your Lumberton New Jersey range.
This site, FRBO.com does have diverse spacious and decadent townhouse, farmhouse, condominium, and flats.
Espy and find out rental home in Burlington and real estate rentals.
Observe another story, several, and unconventional abstracts in Lumberton New Jersey and spell out Lumberton New Jersey vacation homes.
Come upon and contrive Sussex holiday rentals and Sussex holiday rentals.
Enter, record, and enter into tonight to take up, inaugurate, lead off, and initiate on this jaunt.
Discover and notice rental properties Oakland and rental houses in Oakland United States.
Come upon and move rental home, Atlantic New Jersey homes for rent, homes for rent Atlantic, and apartment rentals in Atlantic New Jersey.
Conceive, find, and contrive rental houses Atlantic, real estate rentals Atlantic New Jersey, condo rentals Atlantic New Jersey, and vacation homes for rent by owner Atlantic New Jersey.
|
|
