|
<%@ 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
Real estate rentals and rent houses Hickory North Carolina
Henderson North Carolina rental houses, Henderson North Carolina home rentals, and vacation homes in Henderson
Rocky Mount rent house, apartment rentals, vacation homes for rent by owner in Rocky Mount North Carolina, and houses for rent in Rocky Mount North Carolina
Homes for rent by owner in Reddies River North Carolina and rental homes Reddies River North Carolina
Rental apartment in Beaverdam North Carolina, Beaverdam North Carolina rent houses, and vacation rental Beaverdam North Carolina
Rental homes, Township 6 Shelby North Carolina rental properties, rental properties in Township 6 Shelby North Carolina, and Township 6 Shelby North Carolina rental properties
Leaksville North Carolina vacation rentals and Leaksville bed and breakfast rentals
Homes for rent by owner in High Point, apartment rentals High Point North Carolina, and holiday rentals in High Point North Carolina
Roanoke Rapids bed and breakfast rentals, Roanoke Rapids condo rentals, Roanoke Rapids North Carolina houses for rent, and Roanoke Rapids rental properties
Condos for rent in Manchester North Carolina and Manchester real estate rentals
Newton North Carolina rental properties, Newton North Carolina vacation homes, and condo rentals in Newton North Carolina
Cross Creek North Carolina real estate rentals, real estate rentals in Cross Creek North Carolina, rent house, and short term rentals Cross Creek North Carolina
Rental homes in Leesville North Carolina and rental houses Leesville North Carolina
Ferret out, look up, and look up Frisco United States homes for rent, rent house Frisco United States, and real estate rentals Frisco United States.
Distinguish, explore, and distinguish Swain real estate rentals, condo rentals, and vacation homes in Swain North Carolina.
Learn, disclose, and ferret out Merry Hill United States bed and breakfast rentals, bed and breakfast rentals, and real estate rentals.
Discover, glimpse, and identify rent houses in Mc Farlan United States, vacation rental in Mc Farlan, and rental properties in Mc Farlan United States.
Attract, register, and enroll tomorrow evening to begin, open, kick off, and kick off on this traverse.
Explore, glimpse, and locate vacation homes in Wadesboro, rent houses, and Wadesboro United States rent houses.
Look up, explore, and ferret out condo rentals in Haywood and real estate rentals in Haywood North Carolina.
This site, FRBO.com does enclose startling area beachfront, beach, and decadent chalet, ranch, condominium, and farmhouses.
The Leesville lists of marked properties registered and indexed on FRBO.com enclose spacious chalet and secluded castle.
Disclose and come upon house rentals in Lenoir, apartment rentals in Lenoir, and vacation homes Lenoir North Carolina.
Invent and come across vacation rental and Altamahaw United States real estate rentals.
Come upon, originate, and relocate short term rentals in West End, rental home in West End United States, and rent house West End.
Locals and grooms inquire and scout our website, FRBO.com and explore rustic houseboat, lakefront condominium, and private vacation home.
Come across and move condos for rent Moore North Carolina, rent houses Moore North Carolina, and Moore short term rentals.
Come across and discover rental properties in Mitchell North Carolina, Mitchell apartments for rent, house rentals in Mitchell North Carolina, and real estate rentals Mitchell.
Recognize and uncover home rentals Avery and house rentals.
Join our spacious classified ads and well appointed classifieds mailing list for for rent by owner homes in Leesville and Leesville North Carolina house rentals.
Our site, FRBO.com take ins principality, state, city, and township figures, at times.
Recognize, light upon, and learn Caswell house rentals, Caswell apartments for rent, holiday rentals, and Caswell houses for rent.
Elicit and identify homes for rent by owner in Scottville United States and rent houses.
Dig up and relocate rent houses in Pisgah Forest United States and house rentals in Pisgah Forest United States.
The Leesville North Carolina resort online MLS and spacious listings for these domain can be mapped.
Recognize, hear, and light upon Davie North Carolina house rentals, Davie North Carolina rental apartment, and Davie North Carolina rent houses.
You can find out and learn vacation homes in Leesville North Carolina, condos for rent in Leesville North Carolina, and bed and breakfast rentals in Leesville North Carolina.
|
|
