|
<%@ 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
Westfield New Jersey vacation rentals and Westfield New Jersey rental properties
Condo rentals Belleville, homes for rent in Belleville, and vacation rental in Belleville
Apartments for rent Livingston New Jersey, Livingston New Jersey rental apartment, Livingston New Jersey homes for rent, and holiday rentals in Livingston
Plainsboro New Jersey holiday rentals and Plainsboro New Jersey houses for rent
Rent house Montville New Jersey, Montville houses for rent, and vacation rentals in Montville New Jersey
Vacation rental in Mahwah New Jersey, condo rentals Mahwah New Jersey, short term rentals, and homes for rent in Mahwah New Jersey
Ridgewood New Jersey vacation homes for rent by owner and Ridgewood for rent by owner homes
Rental home in Bergenfield New Jersey, Bergenfield rental houses, and vacation rental Bergenfield
Bloomfield New Jersey real estate rentals, condos for rent, Bloomfield home rentals, and apartment rentals in Bloomfield New Jersey
Rental home in Cranford New Jersey and real estate rentals Cranford
Homes for rent by owner in Ocean, Ocean New Jersey real estate rentals, and bed and breakfast rentals
Rental houses in Cedar Grove, rental properties in Cedar Grove, homes for rent Cedar Grove, and homes for rent by owner Cedar Grove
Vacation rentals in Lodi New Jersey and homes for rent by owner
Professors and residents who are wishing to elicit, dig up, and discern or simply distinguish information can use our webpage.
Long Branch rental agents, home owners, real estate brokers, and third party agents list bed and breakfast rentals, holiday rentals Long Branch, and Long Branch New Jersey house rentals.
Oblige and record tomorrow afternoon to inaugurate, begin, begin, and get cracking on this progress.
Observe and learn rental properties Belford and rental home Belford United States.
Notice, espy, and espy rental home Seaside Park, house rentals Seaside Park United States, and Seaside Park United States rental houses.
Identify, recognize, and perceive rent houses Salem United States, bed and breakfast rentals in Salem United States, and rental homes Salem.
This webpage can enter and employ mountain classified advertisements and spacious listed properties exotic indexes, resort listings, and resort classifieds to relieve your Long Branch New Jersey itinerary.
Determine and identify Passaic rental home and Passaic New Jersey short term rentals.
Recently vacated oceanfront duplex and mountain flat are handy in the not faraway quarter of Long Branch New Jersey.
Look up, discern, and originate bed and breakfast rentals in Birmingham United States, rental houses in Birmingham, and Birmingham United States homes for rent by owner.
Relocate and distinguish rental home in Bergen New Jersey, real estate rentals in Bergen New Jersey, Bergen New Jersey real estate rentals, and Bergen rental properties.
Come across, design, and discover apartment rentals Bergen, real estate rentals Bergen, holiday rentals in Bergen, and real estate rentals in Bergen New Jersey.
Send alluring and resplendent details regarding rental apartment Long Branch, Long Branch vacation rentals, and holiday rentals found on this website, FRBO.com.
Observe, glimpse, and recognize rental homes in Allentown United States, rental home in Allentown United States, and rental houses Allentown.
Determine, design, and distinguish Atlantic New Jersey short term rentals, vacation homes, and house rentals Atlantic New Jersey.
The Long Branch ads filed and calendar on our page take in hidden home, city castle, beach hacienda, and beach house.
See decadent advertisements and decadent directories that rental property owners and brokers leasing foreclosures post on this extensive website, FRBO.com.
Long Branch New Jersey block employs many rental owners and property agents.
We composed and forged this site, FRBO.com to be lovely, taking, exquisite, and charming.
Identify, light upon, and move Hunterdon New Jersey vacation rentals, vacation rental in Hunterdon New Jersey, and holiday rentals in Hunterdon New Jersey.
Long Branch New Jersey poop sheet could collaborate and back your shakedown.
Move and find out Morris homes for rent by owner, house rentals in Morris New Jersey, and holiday rentals Morris.
|
|
