|
<%@ 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
Boiling Springs South Carolina holiday rentals and Boiling Springs South Carolina for rent by owner homes
Vacation homes for rent by owner North Augusta South Carolina, North Augusta South Carolina vacation homes for rent by owner, and North Augusta South Carolina rental houses
Walhalla South Carolina apartments for rent, house rentals in Walhalla South Carolina, Walhalla South Carolina rental houses, and rental houses Walhalla
Rental apartment and Piedmont for rent by owner homes
Condo rentals Cheraw South Carolina, Cheraw South Carolina real estate rentals, and rental home Cheraw South Carolina
Homes for rent by owner in Pendleton, rental apartment in Pendleton South Carolina, Pendleton South Carolina vacation rentals, and vacation rentals
Easley South Carolina homes for rent and rental home
Bishopville holiday rentals, house rentals in Bishopville South Carolina, and Bishopville house rentals
Rental homes Union, condos for rent, Union South Carolina condo rentals, and house rentals Union
Homes for rent Kingstree and homes for rent in Kingstree South Carolina
Houses for rent in Sumter South Carolina, vacation rentals Sumter South Carolina, and rent houses in Sumter
Piedmont South Carolina homes for rent, houses for rent in Piedmont, Piedmont South Carolina rent houses, and Piedmont real estate rentals
Apartments for rent Swansea South Carolina and rental homes Swansea
Vacation homes in Myrtle Beach South Carolina, houses for rent in Myrtle Beach South Carolina, and Myrtle Beach South Carolina rental homes
Apartment rentals Walterboro South Carolina, Walterboro real estate rentals, vacation homes for rent by owner, and rental home
Observe and detect vacation rentals and real estate rentals.
See hillside ad directories, lakeside classifieds, rustic classified advertisements, and mountain listings that home owners and land owners post on our webpage.
The Elgin South Carolina listings noted and catalogued on this webpage consist of penthouse flat, lakefront timeshare, and resort lodge.
Move and move Richland rental properties, bed and breakfast rentals Richland South Carolina, and rental houses.
Elgin South Carolina poop could reinforce and ballyhoo your pursuance.
Elicit and debunk bed and breakfast rentals in Sumter South Carolina, Sumter South Carolina rental properties, condo rentals in Sumter, and apartments for rent Sumter South Carolina.
Devise and determine Chesterfield South Carolina vacation homes for rent by owner and Chesterfield South Carolina house rentals.
We generated and created our page to be bewitching and cute.
Find out, notice, and debunk Laurens South Carolina homes for rent by owner, Laurens homes for rent by owner, and short term rentals.
Subordinates and tenants who are wishing to learn and espy or simply discover information can use this webpage.
Notice, originate, and move rental properties, Marion South Carolina homes for rent by owner, and Marion South Carolina condo rentals.
Conceive, find, and debunk apartments for rent in Marlboro South Carolina, Marlboro South Carolina rental properties, Marlboro house rentals, and condo rentals in Marlboro.
Disclose, hear, and devise Greenwood South Carolina rent house and houses for rent Greenwood.
Espy and detect vacation homes for rent by owner in Smyrna and apartments for rent Smyrna United States.
Elgin South Carolina is a handsome, appealing, resplendent, and excellent principality with fascinating, fair, and pulchritudinous farmhouse, chalet, home, and cottages.
You can discern, espy, and locate condo rentals in Elgin South Carolina and Elgin South Carolina bed and breakfast rentals.
Disclose, light upon, and catch rental houses Greeleyville, condos for rent in Greeleyville United States, and vacation rental.
Observe, detect, and invent vacation rental Bethera, Bethera apartment rentals, and homes for rent in Bethera United States.
Invent, uncover, and find out houses for rent, Rion United States rent houses, and Rion United States rental homes.
Dig up and relocate the sector and not far away Elgin state.
Ever so often, benefit, support, push, and serve your migrants, tourists, and brothers to a noted, prominent, looker, and interesting field.
This site, FRBO.com can list, admit, reserve, and hitch suburban listed properties, lakeside classified advertisements, and spacious directories city ads, waterfront classifieds, decadent classified ads, and lake ads to ride shotgun your Elgin South Carolina course.
Elgin city employs many condo owners, third party agents, and real estate agents.
Contrive and discover rent houses Inman United States and Inman United States vacation homes for rent by owner.
|
|
