|
<%@ 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
South River New Jersey house rentals and bed and breakfast rentals
Condo rentals Ocean, Ocean New Jersey homes for rent by owner, and Ocean New Jersey rental apartment
Mount Laurel New Jersey vacation rentals, rent house Mount Laurel, Mount Laurel New Jersey vacation rental, and Mount Laurel New Jersey condos for rent
Washington New Jersey apartments for rent and holiday rentals Washington New Jersey
Homes for rent by owner in City of Orange New Jersey, vacation homes for rent by owner City of Orange New Jersey, and short term rentals in City of Orange New Jersey
Condos for rent in Madison New Jersey, Madison rent houses, real estate rentals in Madison, and rent house in Madison New Jersey
North Brunswick New Jersey rent houses and holiday rentals in North Brunswick New Jersey
Pequannock New Jersey for rent by owner homes, Pequannock house rentals, and bed and breakfast rentals in Pequannock New Jersey
Southampton condo rentals, short term rentals in Southampton, rent houses in Southampton New Jersey, and vacation homes for rent by owner in Southampton New Jersey
Vacation rental in Roselle Park New Jersey and rent house in Roselle Park New Jersey
Condo rentals, for rent by owner homes, and Medford New Jersey apartments for rent
Lindenwold rental houses, home rentals in Lindenwold, rental houses in Lindenwold New Jersey, and homes for rent in Lindenwold New Jersey
Rental properties and Cliffside Park New Jersey homes for rent by owner
Bridgewater condos for rent, rental home in Bridgewater New Jersey, and rental apartment in Bridgewater New Jersey
Stafford bed and breakfast rentals, Stafford New Jersey apartment rentals, homes for rent, and rent house Stafford New Jersey
Vacation rentals in Bound Brook and Bound Brook house rentals
Tenafly New Jersey bed and breakfast rentals, Tenafly New Jersey holiday rentals, and holiday rentals
Locate, observe, and uncover the stretch and not remote Manville New Jersey domain.
Dig up, move, and perceive rental apartment in Salem New Jersey and rental homes.
Manville New Jersey compilations could abet, help, aid, and serve your legwork.
We constituted and designed our webpage to be taking, refined, and elegant.
Relocate and move Somerset New Jersey condos for rent, Somerset New Jersey apartments for rent, and Somerset New Jersey vacation homes.
Expeditionists and travelers who are shaking down Manville New Jersey rent houses and are trying to disclose vacation homes for rent by owner Manville and holiday rentals Manville can hunt for this website, FRBO.com and our lake classifieds, beachfront classifieds, and beachfront listed properties.
Originate, relocate, and distinguish houses for rent in Bergen New Jersey and short term rentals Bergen New Jersey.
Conceive and uncover Cedarville United States rent house and Cedarville United States houses for rent.
Hear, relocate, and catch home rentals in Wayne United States, vacation homes for rent by owner in Wayne United States, and rental homes in Wayne.
Glimpse, light upon, and design houses for rent, Hunterdon New Jersey home rentals, and Hunterdon vacation rental.
Elicit and elicit Somerset apartment rentals, Somerset New Jersey rental home, Somerset New Jersey real estate rentals, and rent houses.
Globetrotters and roomers who are wishing to explore, look up, and contrive or simply find information can use this website, FRBO.com.
You can hunt for the loft classified ads and hidden advertisements under condos for rent, rental apartment Manville, and vacation homes for rent by owner in Manville New Jersey.
Originate and discover houses for rent in Deal United States and short term rentals Deal.
Hear and dig up holiday rentals in East Brunswick Towns United States and East Brunswick Towns home rentals.
Our page does except specific romantic, secluded, beachfront, and spacious house and lodges.
Discover and disclose Imlaystown United States for rent by owner homes and homes for rent by owner in Imlaystown United States.
Identify and relocate rental apartment, Mercer New Jersey vacation rental, and rent houses in Mercer New Jersey.
Originate various, sparse, and unconventional details in Manville New Jersey and itemize rent houses Manville.
The Manville lakefront ads and lakeside classified advertisements for these zone can be mapped.
Dig up, contrive, and devise Hudson New Jersey condo rentals, Hudson New Jersey for rent by owner homes, Hudson New Jersey apartment rentals, and Hudson New Jersey homes for rent.
Find out and ascertain Wallington condo rentals and apartments for rent Wallington.
Glimpse and come across Allenhurst homes for rent and homes for rent in Allenhurst United States.
Find out and recognize vacation homes in Somerset New Jersey, vacation rental, rental homes in Somerset, and homes for rent.
|
|
