|
<%@ 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
House rentals Township 4 Kings Mountain North Carolina and vacation rentals in Township 4 Kings Mountain North Carolina
Condos for rent in Marks Creek North Carolina, apartments for rent in Marks Creek North Carolina, and rental homes in Marks Creek
Real estate rentals Brevard North Carolina, rent houses in Brevard North Carolina, apartment rentals in Brevard North Carolina, and bed and breakfast rentals Brevard
Real estate rentals Brogden North Carolina and rental home in Brogden North Carolina
North Clinton vacation rentals, homes for rent by owner, and rental homes North Clinton North Carolina
Rental home in Atlantic North Carolina, bed and breakfast rentals in Atlantic North Carolina, bed and breakfast rentals, and Atlantic North Carolina for rent by owner homes
Condos for rent and rental home Wilmington
Cary vacation homes, Cary vacation homes, and Cary North Carolina vacation homes
Bed and breakfast rentals Limestone North Carolina, homes for rent by owner, homes for rent Limestone North Carolina, and Limestone bed and breakfast rentals
Township 11 Long Creek houses for rent and homes for rent in Township 11 Long Creek North Carolina
Real estate rentals, apartments for rent Richlands North Carolina, and Richlands North Carolina condos for rent
Houses for rent in Township 13 Morning Star North Carolina, rent houses Township 13 Morning Star North Carolina, for rent by owner homes in Township 13 Morning Star, and rental home in Township 13 Morning Star
House rentals in Middle Creek North Carolina and rental houses Middle Creek
Hear and detect short term rentals in Mecklenburg North Carolina, Mecklenburg North Carolina house rentals, and Mecklenburg vacation rentals.
Conceive and recognize rental properties and holiday rentals in Shannon United States.
Hear, identify, and identify vacation rentals Clayton United States, Clayton rent houses, and Clayton United States rent house.
Loft advertisements and waterfront lists of marked properties Stokes North Carolina rent houses, rent house, condo rentals in Stokes North Carolina, and Stokes North Carolina vacation homes for rent by owner.
Disclose, devise, and recognize rental homes in Alleghany North Carolina, Alleghany condo rentals, and Alleghany North Carolina rental houses.
FRBO.Com, For Rent By Owner, does comprehend particular sector decadent, lakeside, well appointed, and city lodge and timeshares.
Ready to move in mountain flat and exclusive cabin are adjoining in the not faraway county of Township 12 Rocky Mount North Carolina.
Espy, relocate, and glimpse the vicinity and contiguous Township 12 Rocky Mount North Carolina parcel.
Using our for rent by owner site, FRBO.com, rental property owners invoice chalet, houseboat, and flat ads.
Explore, relocate, and dig up Bladen North Carolina short term rentals, house rentals in Bladen, and rent house in Bladen North Carolina.
Disclose and uncover condo rentals Avery North Carolina, Avery homes for rent, and vacation rental Avery.
Distinguish and notice vacation rentals in Wilson North Carolina and Wilson rental houses.
Elicit and detect houses for rent in Snow Camp and rent house Snow Camp.
|
|
