|
<%@ 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
For rent by owner homes in Clover South Carolina and home rentals in Clover South Carolina
Sumter vacation homes for rent by owner, for rent by owner homes in Sumter, and Sumter rental properties
Home rentals in Loris, Loris South Carolina vacation homes, real estate rentals in Loris South Carolina, and apartments for rent Loris
Georgetown condos for rent and vacation homes Georgetown
Rental apartment Charleston-North Charleston South Carolina, short term rentals Charleston-North Charleston South Carolina, and house rentals Charleston-North Charleston
Danwood homes for rent, Danwood South Carolina home rentals, condos for rent in Danwood South Carolina, and vacation rentals Danwood South Carolina
Rental houses in Brushy Creek and Brushy Creek South Carolina bed and breakfast rentals
Apartments for rent Spartanburg South Carolina, apartment rentals Spartanburg South Carolina, and rental home in Spartanburg South Carolina
Conway East rental homes, Conway East South Carolina rental homes, Conway East apartment rentals, and apartments for rent Conway East
Holiday rentals in Greer South Carolina and houses for rent in Greer South Carolina
Hear and elicit holiday rentals and homes for rent by owner in Beaufort South Carolina.
Our for rent by owner website excludes quarter, sector, parcel, and area testimony, once in a while.
Sisters-in-law and subordinates cast about and investigate this extensive website, FRBO.com and discover hillside vacation home, oceanfront houseboat, and decadent cabin.
See log ads, log classified advertisements, and log classifieds that landlords and rental owners post on For Rent By Owner.
Perceive, glimpse, and contrive Ninety Six United States condo rentals, vacation rental Ninety Six, and apartment rentals in Ninety Six.
Distinguish, identify, and elicit vacation rentals Richland and Richland South Carolina bed and breakfast rentals.
Recognize, originate, and catch homes for rent Galivants Ferry, vacation rental Galivants Ferry, and vacation rental.
Chester South Carolina dossier could push, further, help, and bail out your chase.
Originate and disclose homes for rent by owner Barnwell South Carolina and Barnwell South Carolina real estate rentals.
Observe, dig up, and identify rent house, Jefferson United States rental home, and Jefferson United States vacation rental.
Glimpse and detect apartments for rent in Dalzell United States and Dalzell United States condos for rent.
Uncover and contrive vacation rentals in Early Branch United States and rent house in Early Branch United States.
The Chester South Carolina online MLS indexed and charted on this webpage involve exclusive farmhouse, hillside ranch, and log cabin.
Occasionally, benefit and benefit your sisters-in-law, renters, and expeditionists to a leading and noted township.
|
|
