|
<%@ 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" %>
|
North Carolina Rental Links
Vacation rental Cary North Carolina and rent house in Cary North Carolina
Rockingham apartments for rent, Rockingham bed and breakfast rentals, and short term rentals in Rockingham
Vacation homes in Brogden North Carolina, rental homes Brogden North Carolina, vacation homes for rent by owner in Brogden North Carolina, and Brogden North Carolina condos for rent
Home rentals in Township 6 West Sanford and Township 6 West Sanford North Carolina rental apartment
Monroe homes for rent by owner, Monroe North Carolina rental apartment, and Monroe North Carolina rental homes
Condos for rent, homes for rent by owner in Beaverdam, Beaverdam house rentals, and real estate rentals
Real estate rentals in Winston North Carolina and rental apartment in Winston
Swansboro real estate rentals, vacation homes for rent by owner in Swansboro North Carolina, and holiday rentals in Swansboro North Carolina
Houses for rent in Rutherfordton North Carolina, homes for rent in Rutherfordton, Rutherfordton rental apartment, and Rutherfordton homes for rent
Seventy-First rent house and apartment rentals in Seventy-First North Carolina
Vacation rental, Cary North Carolina holiday rentals, and Cary bed and breakfast rentals
Distinguish, discover, and debunk rental houses Pitt, house rentals in Pitt, and rental properties Pitt North Carolina.
Employ and levy this weekend to begin, jump into, and lead off on this ramble.
Originate, espy, and identify bed and breakfast rentals in Carolina Beach United States, holiday rentals, and Carolina Beach United States holiday rentals.
Distinguish, debunk, and dig up Garner rental houses, holiday rentals Garner United States, and Garner vacation homes for rent by owner.
Look up and catch rent house in Clayton United States and Clayton United States rental apartment.
Kick off your chase online tomorrow afternoon, on Thursday, or on Friday for your apartments for rent in Lebanon North Carolina, home rentals in Lebanon North Carolina, and rent houses in Lebanon.
Glimpse and hear Bridgeton vacation rental and rental apartment Bridgeton.
Design and recognize Jackson North Carolina vacation homes for rent by owner and rental houses in Jackson North Carolina.
Glimpse and ascertain rental homes in Bladen, Bladen rental apartment, and Bladen vacation rental.
Come upon and light upon real estate rentals Yadkin and bed and breakfast rentals.
Successively, support and root for your pioneers and townies to a enormous and thundering sector.
Come upon and locate rental home in Nash North Carolina, real estate rentals in Nash, Nash North Carolina homes for rent, and apartments for rent in Nash.
Ascertain and learn Penland United States holiday rentals and condos for rent in Penland United States.
Lebanon North Carolina is a cute, lovely, divine, and divine vicinity with admirable, classy, and sublime home and castles.
Come across, dig up, and find out rental apartment in Northampton North Carolina and apartment rentals in Northampton.
Collegiates and traveling women who are wishing to design and hear or simply invent information can use FRBO.com.
Identify, ascertain, and invent for rent by owner homes in Trinity United States, Trinity vacation rental, and house rentals Trinity United States.
You can inspect the log indexes and exclusive classifieds under rental properties, Lebanon North Carolina rent houses, and rental houses in Lebanon North Carolina.
See waterfront lists of marked properties and city classified ads that third party listing companies and third party listing companies post on our for rent by owner site, FRBO.com.
Traveling saleswomen, jet-setters, and rent payers who are checking Lebanon rental properties and are trying to distinguish apartment rentals and holiday rentals Lebanon can grub this site, FRBO.com and our city classifieds and beachfront classified ads.
Available waterfront condominium, city house, studio farmhouse, and city apartment are neighboring in the not faraway plot of Lebanon.
Determine and discern houses for rent and Grimesland vacation homes for rent by owner.
|
|
