|
<%@ 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
Vacation rentals in Marion North Carolina and condo rentals Marion North Carolina
Chapel Hill North Carolina for rent by owner homes, Chapel Hill North Carolina vacation rental, and vacation rentals Chapel Hill
Swift Creek North Carolina homes for rent by owner, apartments for rent in Swift Creek North Carolina, holiday rentals in Swift Creek, and Swift Creek North Carolina rental home
New Hope real estate rentals and New Hope rental properties
Condo rentals in Township 6 Clear Creek, house rentals Township 6 Clear Creek, and Township 6 Clear Creek North Carolina holiday rentals
Rental houses in Gilmer North Carolina, bed and breakfast rentals in Gilmer North Carolina, apartments for rent Gilmer, and rental properties
Short term rentals Town Creek North Carolina and Town Creek homes for rent by owner
Short term rentals in Locke, condos for rent in Locke North Carolina, and home rentals Locke
Morganton real estate rentals, home rentals in Morganton North Carolina, Morganton North Carolina bed and breakfast rentals, and house rentals in Morganton North Carolina
Friendship condos for rent and real estate rentals in Friendship North Carolina
House rentals, rent houses Yadkin North Carolina, and rental houses Yadkin
Sightseers and wanderers root and probe FRBO.com and relocate decadent chalet, lake house, beachfront duplex, and ski in/out duplex.
This webpage incorporates area and territory conclusions, periodically.
You can run down the ski in/out indexes and beach lists of marked properties under condo rentals in Catawba Springs, house rentals Catawba Springs North Carolina, and apartment rentals Catawba Springs.
Uncover and look up Bonlee United States short term rentals and home rentals in Bonlee United States.
The Catawba Springs North Carolina ad directories run down and buttoned down on this webpage consist of lake cottage, exotic hacienda, and exotic chalet.
Locate and uncover rent houses in Atkinson United States and for rent by owner homes Atkinson.
Light upon, relocate, and come across apartments for rent, homes for rent by owner Lenoir North Carolina, Lenoir condo rentals, and Lenoir North Carolina condos for rent.
Join our log classified advertisements, romantic classifieds, and beach directories mailing list for rental properties in Catawba Springs North Carolina and apartment rentals.
Get cracking your research online tomorrow afternoon, this evening, tonight, or on Saturday for your rental houses, Catawba Springs house rentals, and rent house Catawba Springs North Carolina.
Find, find out, and observe rental properties in Sedalia United States, Sedalia United States rental homes, and rental apartment in Sedalia United States.
Conceive rare and specific facts in Catawba Springs and detail condo rentals in Catawba Springs.
Detect and distinguish for rent by owner homes in Yancey North Carolina, vacation homes for rent by owner, and Yancey North Carolina holiday rentals.
Catawba Springs is a excellent, stunning, and charming section with delightful, bewitching, and grand house, duplex, villa, and villas.
Catawba Springs facts could sustain, further, and open doors your scrutiny.
|
|
