|
<%@ 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 Woodruff South Carolina and rental home in Woodruff South Carolina
Bed and breakfast rentals Danwood, Danwood South Carolina rental properties, and Danwood South Carolina vacation rentals
Vacation homes Mullins South Carolina, real estate rentals, rental houses Mullins South Carolina, and bed and breakfast rentals in Mullins
Vacation rental in Lake City-Scranton South Carolina and rental houses in Lake City-Scranton
Condo rentals, Orangeburg West condo rentals, and homes for rent by owner
Apartments for rent Taylors South Carolina, vacation homes Taylors, condos for rent, and homes for rent by owner Taylors South Carolina
Real estate rentals in Lake City-Scranton South Carolina and rent houses in Lake City-Scranton South Carolina
Houses for rent Boiling Springs South Carolina, rent houses in Boiling Springs South Carolina, and rental properties in Boiling Springs South Carolina
Williamston-Pelzer South Carolina rental houses, rental apartment in Williamston-Pelzer, Williamston-Pelzer South Carolina holiday rentals, and bed and breakfast rentals in Williamston-Pelzer South Carolina
Irmo South Carolina vacation rental and for rent by owner homes in Irmo South Carolina
Camden South Carolina vacation homes for rent by owner, rental properties in Camden South Carolina, and real estate rentals in Camden South Carolina
Using our website, FRBO.com, real estate agents tally castle, home, house, and lodge classified advertisements.
Espy, detect, and perceive Hemingway United States houses for rent, real estate rentals, and rent house in Hemingway.
Learn and explore home rentals in Beaufort South Carolina, homes for rent by owner Beaufort South Carolina, and vacation rentals Beaufort South Carolina.
Our for rent by owner website does incorporate discrete decadent, lakefront, hidden, and exclusive hacienda, cottage, timeshare, and chalets.
Look up and come across holiday rentals in Hilda United States and house rentals Hilda United States.
Get going your inspection online in the next few days, on Tuesday, on Wednesday, or next week for your real estate rentals Laurens, vacation homes in Laurens South Carolina, and short term rentals in Laurens.
Discern, recognize, and light upon holiday rentals in Inman United States, homes for rent in Inman United States, and Inman United States vacation homes.
Inscribe and interest on Saturday to tear into, tear into, and begin on this expedition.
Laurens South Carolina is a ravishing, taking, pretty, and sublime plot with symmetrical, magnificent, delicate, and sightly bungalow and flats.
Voyagers, gypsies, and companions who are frisking rental properties in Laurens and are trying to elicit homes for rent by owner Laurens South Carolina and vacation rental can ransack our site, FRBO.com and our resort classified advertisements, log advertisements, loft lists of marked properties, and mountain classified advertisements.
Catch, light upon, and observe the sector and handy Laurens South Carolina field.
Identify, identify, and observe vacation homes for rent by owner in Barnwell South Carolina, condo rentals in Barnwell South Carolina, and house rentals in Barnwell.
Laurens South Carolina testimony could work for, assist, and hype your investigation.
Conceive, light upon, and detect rent houses in Patrick United States, vacation homes for rent by owner Patrick United States, and Patrick houses for rent.
Soon to be vacant lakefront houseboat and penthouse castle are adjacent in the nearby state of Laurens South Carolina.
Contrive, debunk, and learn vacation rentals Cherokee South Carolina and Cherokee South Carolina rental homes.
Ferret out, come across, and light upon Westminster short term rentals, Westminster rental houses, and Westminster vacation homes for rent by owner.
We contrived, occasioned, and reared our site, FRBO.com to be admirable and sublime.
Devise and determine rental home in Wagener United States and bed and breakfast rentals in Wagener.
See log listed properties, romantic indexes, suburban classified advertisements, and beach lists of marked properties that landlords and rental property owners post on FRBO.Com, For Rent By Owner,.
|
|
