|
<%@ 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
Rental apartment in Limestone and Limestone North Carolina for rent by owner homes
Vacation homes in Township 6 Shelby, vacation rentals in Township 6 Shelby, and Township 6 Shelby North Carolina vacation rental
Bed and breakfast rentals, Statesville rent houses, Statesville North Carolina house rentals, and homes for rent by owner Statesville North Carolina
Apartments for rent in Rocky Mount North Carolina and Rocky Mount vacation rental
Brevard North Carolina homes for rent, Brevard North Carolina for rent by owner homes, and Brevard North Carolina home rentals
Manchester North Carolina rent house, apartment rentals in Manchester North Carolina, rental houses in Manchester, and Manchester North Carolina home rentals
Township 1 Harrisburg apartments for rent and short term rentals Township 1 Harrisburg
Houses for rent Township 6 West Sanford North Carolina, Township 6 West Sanford condos for rent, and Township 6 West Sanford vacation rentals
Rental apartment Morganton, homes for rent by owner in Morganton North Carolina, Morganton North Carolina short term rentals, and rent houses Morganton North Carolina
Condo rentals Crowders Mountain and Crowders Mountain North Carolina rental houses
Rental houses Davidson, rental houses in Davidson North Carolina, and Davidson North Carolina rental home
Home rentals in Pearces Mill North Carolina, vacation rentals in Pearces Mill North Carolina, Pearces Mill North Carolina holiday rentals, and for rent by owner homes in Pearces Mill North Carolina
Brogden North Carolina rental homes and Brogden North Carolina rental properties
Observe, come across, and conceive vacation rental Haywood North Carolina, homes for rent in Haywood North Carolina, and Haywood North Carolina rent houses.
Conceive, come upon, and catch rental home Lowgap United States, rental houses, and vacation rental Lowgap United States.
Devise and locate Sparta United States rental properties and real estate rentals Sparta.
Explore, relocate, and detect apartments for rent in Camp Lejeune United States, home rentals in Camp Lejeune United States, and vacation rentals in Camp Lejeune United States.
Seventy-First details could support, support, and expedite your shakedown.
Explore and locate East Bend United States apartments for rent and real estate rentals East Bend.
Ferret out, identify, and devise condo rentals, Dana United States apartments for rent, and rental home Dana.
Discover and explore vacation homes in Catawba, rental home Catawba North Carolina, and real estate rentals Catawba.
Devise and discover Avery North Carolina for rent by owner homes and rental homes Avery North Carolina.
Perceive, invent, and elicit condos for rent in Macon, vacation homes for rent by owner in Macon, Macon North Carolina condos for rent, and rental properties in Macon North Carolina.
We conceived and concocted our website, FRBO.com to be good-looking, dazzling, and comely.
Conceive and move rent house Gerton and vacation homes for rent by owner in Gerton United States.
Ready to move in exclusive lodge, secluded houseboat, hidden flat, and hidden house are impending in the nearest city of Seventy-First North Carolina.
Romantic lists of marked properties and lake listings rental houses, for rent by owner homes in Granville North Carolina, Granville North Carolina bed and breakfast rentals, and rental homes in Granville.
Hear, ascertain, and ferret out rental houses in Rural Hall, house rentals Rural Hall, and houses for rent Rural Hall United States.
Disclose and come across rental houses Granite Quarry United States and real estate rentals Granite Quarry United States.
Identify and identify Atlantic vacation homes for rent by owner and Atlantic United States rental home.
The Seventy-First North Carolina listed properties registered and itemized on this site, FRBO.com comprise decadent apartment, convenient castle, resort hacienda, and convenient castle.
|
|
