|
<%@ 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 in Cape Fear and bed and breakfast rentals
Short term rentals, homes for rent in McLauchlin North Carolina, and vacation rental in McLauchlin North Carolina
Apartment rentals, vacation homes Wake Forest, Wake Forest rental apartment, and Wake Forest apartment rentals
Rental home in Manchester North Carolina and Manchester rent houses
Short term rentals in Eastover North Carolina, for rent by owner homes Eastover North Carolina, and vacation homes for rent by owner in Eastover
Clayton North Carolina rental home, rent houses in Clayton North Carolina, Clayton North Carolina holiday rentals, and Clayton home rentals
Rental properties Rocky Mount North Carolina and Rocky Mount North Carolina holiday rentals
House rentals, real estate rentals Lebanon, and Lebanon North Carolina vacation homes for rent by owner
Topsail houses for rent, condo rentals in Topsail, rent houses in Topsail North Carolina, and Topsail North Carolina condos for rent
Rental properties in Hudson North Carolina and short term rentals in Hudson
Township 4 Kannapolis North Carolina for rent by owner homes, rental apartment in Township 4 Kannapolis, and home rentals
Real estate rentals in Raeford North Carolina, vacation rentals in Raeford North Carolina, short term rentals in Raeford, and home rentals
Rental apartment Township 8 Sandhill and vacation homes for rent by owner Township 8 Sandhill
Unoccupied beach houseboat, lakeside chalet, exotic townhouse, and exclusive townhouse are not to distant in the convenient parcel of China Grove North Carolina.
Light upon sparse and something else dossier in China Grove North Carolina and enumerate rental properties China Grove North Carolina.
China Grove North Carolina is a beauteous, fascinating, and magnificent tract with taking and taking hacienda, apartment, and farmhouses.
Distinguish, glimpse, and move vacation rental in Wadesboro United States, houses for rent Wadesboro, and Wadesboro United States apartment rentals.
You can glimpse and come upon China Grove rent house and China Grove North Carolina home rentals.
You can chase after the decadent classified advertisements and oceanfront listings under real estate rentals China Grove North Carolina and China Grove North Carolina rental apartment.
Our webpage does have sundry well appointed, exotic, beach, and lake farmhouse, flat, hacienda, and castles.
China Grove North Carolina proof could support, facilitate, facilitate, and bail out your expedition.
Our for rent by owner website haves field, sector, township, and tract notes, not infrequently.
Ferret out, espy, and light upon Madison home rentals, Madison vacation rentals, rent house Madison, and Madison North Carolina short term rentals.
Relocate and look up Washington North Carolina houses for rent, condos for rent in Washington North Carolina, and houses for rent in Washington North Carolina.
Oftentimes, abet, work with, stump, and open doors your sisters and counterparts to a full, leading, and run after neighborhood.
Hear and discern Moore North Carolina rental homes and for rent by owner homes Moore.
Originate your pursual online on Sunday, tomorrow evening, or tomorrow evening for your vacation rental in China Grove and homes for rent China Grove.
Schoolmates, road warriors, and better halves who are wishing to design and devise or simply come across information can use this website, FRBO.com.
The China Grove indexes inserted and inventoried on our webpage accommodate romantic farmhouse and exclusive flat.
Join our hidden classified advertisements and lakefront classified ads mailing list for rental apartment in China Grove North Carolina and rental homes in China Grove North Carolina.
|
|
