|
<%@ 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
Apartments for rent and holiday rentals
Rent houses Camden South Carolina, houses for rent, and Camden South Carolina condos for rent
Rental home Horrell Hill, rental properties, Horrell Hill South Carolina apartment rentals, and house rentals in Horrell Hill
Condo rentals in Clover South Carolina and Clover South Carolina apartment rentals
Homes for rent by owner Travelers Rest South Carolina, homes for rent, and Travelers Rest South Carolina short term rentals
Rental apartment Clemson, house rentals Clemson, condo rentals in Clemson South Carolina, and homes for rent by owner in Clemson
Georgetown rental properties and rental properties Georgetown
Rental homes in Pendleton, Pendleton South Carolina rental homes, and vacation rentals in Pendleton
Rental houses Union, Union South Carolina condo rentals, vacation homes, and holiday rentals Union
Camden South Carolina holiday rentals and Camden real estate rentals
Vacation homes Waccamaw South Carolina, Waccamaw South Carolina apartment rentals, and vacation rentals Waccamaw
For rent by owner homes Anderson South Carolina, Anderson South Carolina rent house, rent house in Anderson South Carolina, and rental houses
Anderson South Carolina vacation rentals and condos for rent Anderson South Carolina
Rental homes in Seneca South Carolina, house rentals in Seneca South Carolina, and holiday rentals in Seneca South Carolina
Homes for rent by owner in Anderson South Carolina, short term rentals in Anderson, house rentals in Anderson, and Anderson South Carolina vacation homes
Rental houses Ravenel and Ravenel South Carolina rent houses
Rental home in Brushy Creek South Carolina, homes for rent by owner Brushy Creek, and houses for rent in Brushy Creek
Vacation homes for rent by owner, Clemson South Carolina apartment rentals, vacation homes in Clemson South Carolina, and Clemson South Carolina rent houses
Apartments for rent in Greer and Greer South Carolina rent houses
Holiday rentals, Orangeburg South Carolina houses for rent, and vacation homes for rent by owner Orangeburg South Carolina
Rent houses, vacation rental in Anderson South Carolina, house rentals Anderson South Carolina, and short term rentals Anderson South Carolina
Bed and breakfast rentals and bed and breakfast rentals Newberry South Carolina
Detect and recognize Lockhart United States condo rentals and apartment rentals in Lockhart United States.
Learn, come across, and come upon the principality and abutting Waccamaw South Carolina precinct.
Disclose and light upon rental homes in Jefferson United States and Jefferson United States houses for rent.
Identify, discern, and devise rental home in Aiken South Carolina, Aiken South Carolina home rentals, rental houses Aiken, and for rent by owner homes Aiken.
Notice, identify, and conceive rent house in Pinewood, Pinewood United States bed and breakfast rentals, and bed and breakfast rentals in Pinewood United States.
Relocate, find out, and identify bed and breakfast rentals, vacation rentals in Jacksonboro United States, and short term rentals in Jacksonboro United States.
Disclose extraordinary, specialized, singular, and various figures in Waccamaw South Carolina and detail bed and breakfast rentals Waccamaw.
Conceive and detect Aiken South Carolina vacation homes, rent houses in Aiken South Carolina, holiday rentals in Aiken South Carolina, and Aiken South Carolina apartment rentals.
Contrive, espy, and detect rent houses Newberry and vacation homes for rent by owner in Newberry South Carolina.
Waccamaw South Carolina plot employs many agents serving the condo market, rental agents, landlords, and property managers.
Waccamaw South Carolina is a marvelous, fair, shapely, and charming neighborhood with divine and stunning townhouse, villa, houseboat, and houses.
Disclose and light upon Aiken home rentals and rental homes Aiken.
Determine, ferret out, and move Williams vacation homes, Williams United States vacation homes, and short term rentals.
Gypsies and peers who are probing Waccamaw South Carolina short term rentals and are trying to notice vacation rentals in Waccamaw South Carolina, rental houses, and holiday rentals in Waccamaw South Carolina can scrutinize For Rent By Owner and our beach listings, lake lists of marked properties, and hidden indexes.
Ferret out, move, and detect short term rentals Effingham United States, for rent by owner homes, and vacation homes for rent by owner in Effingham.
Recognize, originate, and move condo rentals Barnwell and Barnwell rental properties.
Relocate, design, and discern condo rentals, for rent by owner homes in Oconee South Carolina, and Oconee South Carolina rental houses.
See lake listings and hidden advertisements that agents serving the condo market and real estate investors post on our website, FRBO.com.
Invent, determine, and conceive Marion house rentals, home rentals, and real estate rentals Marion South Carolina.
Exclusive lists of marked properties and private advertisements rent house in Anderson South Carolina, Anderson South Carolina short term rentals, home rentals Anderson South Carolina, and Anderson South Carolina vacation homes for rent by owner.
Dig up, hear, and perceive house rentals in White Oak, rental home in White Oak United States, and White Oak United States apartments for rent.
Ascertain and explore Spartanburg condos for rent and Spartanburg South Carolina home rentals.
Notice and detect Springfield United States home rentals and Springfield homes for rent by owner.
Take up your pursuance online tomorrow morning, this weekend, in the next few days, or on Saturday for your vacation homes for rent by owner Waccamaw, apartments for rent in Waccamaw South Carolina, and Waccamaw South Carolina holiday rentals.
Explore and originate Florence South Carolina house rentals, Florence South Carolina homes for rent by owner, and Florence South Carolina bed and breakfast rentals.
Free penthouse townhouse and waterfront townhouse are imminent in the neighboring principality of Waccamaw South Carolina.
FRBO.Com, For Rent By Owner, does omit distinct neighborhood penthouse, resort, and exotic vacation home, townhouse, houseboat, and ranchs.
FRBO.Com, For Rent By Owner, can attract, gather, and serve lakeside directories, suburban classifieds, romantic classified ads, and exclusive indexes resort listed properties, secluded advertisements, and log indexes to expedite your Waccamaw outing.
|
|
