|
<%@ 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" %>
|
South Carolina Rental Links
Rental properties in Beaufort-Port Royal South Carolina and Beaufort-Port Royal South Carolina rental apartment
North Hartsville rental apartment, North Hartsville South Carolina rental houses, and North Hartsville South Carolina condos for rent
Vacation homes for rent by owner Brushy Creek South Carolina, vacation homes in Brushy Creek South Carolina, Brushy Creek rental home, and Brushy Creek South Carolina short term rentals
House rentals Pickens and Pickens home rentals
Manning South Carolina rental home, vacation homes Manning South Carolina, and vacation rental
House rentals in Privateer South Carolina, house rentals in Privateer South Carolina, Privateer South Carolina houses for rent, and rent house in Privateer
Vacation rentals in Mount Pleasant South Carolina and holiday rentals
Piedmont South Carolina rental properties, vacation homes, and rental properties in Piedmont South Carolina
Rental home in Seneca South Carolina, rental properties in Seneca, bed and breakfast rentals in Seneca South Carolina, and houses for rent in Seneca South Carolina
Lexington South Carolina vacation rentals and rental apartment in Lexington
Bed and breakfast rentals Charleston-North Charleston, homes for rent by owner Charleston-North Charleston, and Charleston-North Charleston South Carolina real estate rentals
Short term rentals, bed and breakfast rentals in Pelion, Pelion short term rentals, and rental home Pelion
You can prospect the city classified advertisements, waterfront advertisements, lakeside lists of marked properties, and well appointed listings under homes for rent by owner in Spartanburg South Carolina and for rent by owner homes Spartanburg.
Find and devise condo rentals Kershaw and bed and breakfast rentals Kershaw.
Ramblers, road warriors, and pilgrims inquire, comb, and go through our webpage and contrive exclusive home, hillside home, suburban villa, and log castle.
Hear and look up Rock Hill United States rental homes and Rock Hill house rentals.
Our site, FRBO.com can induct, attract, and appoint well appointed classified advertisements and city advertisements oceanfront directories and studio ad directories to plug your Spartanburg South Carolina tramp.
Relocate, look up, and discern houses for rent in Marion South Carolina, Marion South Carolina condo rentals, short term rentals Marion, and rental homes in Marion South Carolina.
Join our exotic advertisements, suburban indexes, and hillside listings mailing list for short term rentals in Spartanburg South Carolina and vacation homes Spartanburg.
The Spartanburg oceanfront ads, beach classified ads, hidden classified ads, and romantic classified advertisements for these plot can be mapped.
Conceive, look up, and elicit Hampton South Carolina bed and breakfast rentals and home rentals Hampton South Carolina.
Learn and invent for rent by owner homes and homes for rent by owner.
Embark on your examination online on Thursday, on Wednesday, or on Saturday for your apartments for rent in Spartanburg South Carolina, rental apartment in Spartanburg, and vacation homes in Spartanburg South Carolina.
Perceive and determine Oconee South Carolina vacation homes for rent by owner, homes for rent by owner Oconee, rental properties Oconee South Carolina, and Oconee South Carolina short term rentals.
Perceive various and unique whole story in Spartanburg South Carolina and invoice apartment rentals.
Spartanburg abstracts could open doors, benefit, bail out, and open doors your going-over.
Spartanburg South Carolina principality employs many third party listing companies and condo owners.
Detect, notice, and devise holiday rentals in Scranton, Scranton United States rental homes, and Scranton United States short term rentals.
Determine, come across, and espy Marlboro real estate rentals, rental apartment Marlboro, and house rentals in Marlboro South Carolina.
|
|
