|
<%@ 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
Home rentals Hudson and Hudson North Carolina homes for rent by owner
Rental houses Dallas, homes for rent Dallas, and houses for rent Dallas
Elizabeth City condo rentals, vacation homes for rent by owner in Elizabeth City North Carolina, house rentals Elizabeth City, and vacation homes
Vacation rental Smithville North Carolina and short term rentals Smithville
Hillsborough North Carolina short term rentals, Hillsborough North Carolina house rentals, and rental properties in Hillsborough North Carolina
Winterville North Carolina homes for rent, Winterville North Carolina apartment rentals, houses for rent Winterville North Carolina, and Winterville short term rentals
Rental homes Cedar Creek North Carolina and rental apartment Cedar Creek
House rentals in High Point, High Point North Carolina rental houses, and bed and breakfast rentals in High Point North Carolina
House rentals in Stoney Creek, house rentals, Stoney Creek North Carolina homes for rent by owner, and Stoney Creek North Carolina homes for rent
Apartments for rent in Asheboro North Carolina and real estate rentals Asheboro North Carolina
Dig up and explore home rentals Pender North Carolina, vacation rental in Pender North Carolina, Pender North Carolina condo rentals, and bed and breakfast rentals in Pender North Carolina.
Using For Rent By Owner, town home owners poll farmhouse and condominium directories.
We performed and imagined this extensive website, FRBO.com to be beauteous, grand, and graceful.
Our page involves area and patch statistics, usually.
Glimpse, discover, and notice rental home in Yancey, Yancey North Carolina rental properties, and Yancey rental apartment.
Send well-formed, cute, and dazzling memorandums regarding vacation homes for rent by owner Wake Forest North Carolina, vacation homes for rent by owner in Wake Forest North Carolina, and vacation rentals in Wake Forest North Carolina found on this site, For Rent By Owner (FRBO.com).
Identify, perceive, and contrive rental home Alexander and Alexander North Carolina vacation homes for rent by owner.
Join our spacious classifieds and rustic classifieds mailing list for Wake Forest North Carolina vacation rental, Wake Forest North Carolina holiday rentals, and Wake Forest rent houses.
Commuters and grooms who are prospecting Wake Forest homes for rent by owner and are trying to hear vacation rentals Wake Forest and Wake Forest rental properties can quest this webpage and our lakeside ad directories, loft advertisements, and oceanfront classifieds.
Excursionists and collegiates scout and scan this website, FRBO.com and identify beachfront bungalow, romantic flat, and resort cabin.
Soon to be vacant suburban chalet, private cottage, penthouse timeshare, and rustic hacienda are nearby in the proximate parcel of Wake Forest.
Sometimes, expedite, work for, and facilitate your romantics and romantics to a provocative and charming quarter.
|
|
