|
<%@ 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
Homes for rent by owner in Manning and rent houses
Rent house, home rentals Seneca, and apartment rentals Seneca
Travelers Rest home rentals, rental home in Travelers Rest, short term rentals in Travelers Rest South Carolina, and Travelers Rest South Carolina rental properties
Swansea real estate rentals and Swansea South Carolina apartment rentals
Rental apartment Lexington South Carolina, real estate rentals in Lexington South Carolina, and Lexington South Carolina apartment rentals
Conway East for rent by owner homes, rent house, Conway East South Carolina vacation rentals, and rental properties in Conway East South Carolina
Houses for rent and Boiling Springs South Carolina short term rentals
Holiday rentals Walterboro, rental apartment in Walterboro South Carolina, and holiday rentals in Walterboro
Real estate rentals in Orangeburg West South Carolina, Orangeburg West South Carolina rent house, condo rentals in Orangeburg West South Carolina, and condo rentals Orangeburg West South Carolina
Vacation rentals in Horrell Hill South Carolina and rent houses in Horrell Hill
Pickens apartments for rent, rental houses Pickens, and vacation homes in Pickens South Carolina
Bed and breakfast rentals in Williamston-Pelzer South Carolina, vacation homes for rent by owner in Williamston-Pelzer South Carolina, Williamston-Pelzer South Carolina houses for rent, and bed and breakfast rentals in Williamston-Pelzer
Johns Island South Carolina vacation homes and rental apartment
Rental apartment Beaufort-Port Royal, rental properties in Beaufort-Port Royal, and condos for rent in Beaufort-Port Royal South Carolina
Union South Carolina vacation rentals, Union vacation homes for rent by owner, Union South Carolina rental houses, and homes for rent
House rentals in Hartsville South Carolina and Hartsville South Carolina vacation homes
Houses for rent in Ravenel South Carolina, houses for rent in Ravenel South Carolina, and vacation rentals in Ravenel
Vacation rentals in Mount Pleasant, Mount Pleasant vacation homes for rent by owner, rental homes Mount Pleasant, and homes for rent by owner in Mount Pleasant South Carolina
Gaffney home rentals and vacation homes Gaffney
Uncover and discover apartments for rent in Greenville and vacation homes Greenville.
You can uncover, recognize, and design apartments for rent Inman South Carolina and vacation homes in Inman South Carolina.
We occasioned, sired, and spawned this extensive website, FRBO.com to be marvelous, radiant, and bewitching.
Detect and find homes for rent by owner in Lexington, Lexington South Carolina homes for rent by owner, vacation rental in Lexington South Carolina, and rental home in Lexington South Carolina.
Contrive and ferret out Calhoun Falls United States rental apartment and apartment rentals in Calhoun Falls United States.
Dig up, relocate, and learn homes for rent, house rentals, and homes for rent Liberty.
Debunk, come across, and uncover holiday rentals in Salley, Salley United States short term rentals, and apartment rentals Salley United States.
Look up and invent Horry South Carolina holiday rentals and Horry South Carolina apartment rentals.
Observe, espy, and invent Florence South Carolina real estate rentals and houses for rent in Florence South Carolina.
Hear, come upon, and elicit Centenary United States bed and breakfast rentals, bed and breakfast rentals, and Centenary United States short term rentals.
Debunk, dig up, and notice apartments for rent Pelzer United States, Pelzer United States homes for rent, and vacation rental.
Find out, debunk, and find out vacation homes for rent by owner Monetta, homes for rent by owner Monetta, and Monetta United States homes for rent.
Discover and debunk Clinton United States condo rentals and rental homes.
Join our penthouse listings, ski in/out classified advertisements, exotic classified ads, and lakeside classifieds mailing list for Inman South Carolina rent house, Inman South Carolina house rentals, and Inman homes for rent.
Devise, perceive, and debunk short term rentals, Saluda South Carolina condo rentals, rental home Saluda South Carolina, and houses for rent in Saluda South Carolina.
See ski in/out indexes and log ad directories that property managers and real estate brokers post on our page.
The Inman South Carolina beachfront advertisements, studio directories, and decadent lists of marked properties for these can be mapped.
Catch and come upon Lugoff short term rentals and Lugoff vacation rentals.
Ascertain and locate Hampton United States bed and breakfast rentals and Hampton United States home rentals.
Espy, elicit, and move Elliott United States rent house, rent house in Elliott, and rental homes.
Find, observe, and identify Lancaster South Carolina rental homes, Lancaster South Carolina for rent by owner homes, rental properties, and Lancaster South Carolina rental home.
Find, observe, and invent vacation homes for rent by owner Cherokee South Carolina, for rent by owner homes in Cherokee South Carolina, and apartment rentals in Cherokee South Carolina.
|
|
