|
<%@ 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
Greer South Carolina rental properties and Greer South Carolina for rent by owner homes
Home rentals Boiling Springs South Carolina, Boiling Springs South Carolina short term rentals, and rental home in Boiling Springs South Carolina
Clinton South Carolina apartment rentals, Clinton rent house, Clinton bed and breakfast rentals, and rental homes in Clinton South Carolina
Dillon South Carolina rental apartment and vacation rental in Dillon
Goose Creek-Hanahan South Carolina homes for rent, home rentals in Goose Creek-Hanahan, and houses for rent in Goose Creek-Hanahan
Bed and breakfast rentals in Camden South Carolina, Camden South Carolina home rentals, rental home Camden South Carolina, and rent houses
Gaffney South Carolina homes for rent by owner and rent houses in Gaffney South Carolina
Apartment rentals Conway South Carolina, Conway rental houses, and rental apartment Conway
Vacation rental in Gray Court South Carolina, rental houses in Gray Court South Carolina, vacation rental in Gray Court South Carolina, and vacation rental Gray Court
Walhalla South Carolina house rentals and house rentals in Walhalla South Carolina
Short term rentals Beaufort-Port Royal South Carolina, Beaufort-Port Royal South Carolina short term rentals, and Beaufort-Port Royal rent houses
Vacation homes in North Hartsville South Carolina, North Hartsville South Carolina houses for rent, for rent by owner homes North Hartsville South Carolina, and North Hartsville homes for rent
Travelers Rest vacation homes for rent by owner and Travelers Rest South Carolina home rentals
Apartment rentals in Bishopville, Bishopville South Carolina rental homes, and Bishopville South Carolina bed and breakfast rentals
Lancaster vacation homes, vacation rental in Lancaster, Lancaster South Carolina condos for rent, and condo rentals in Lancaster South Carolina
Real estate rentals in Bennettsville and Bennettsville condos for rent
Rent houses Mount Pleasant South Carolina, Mount Pleasant South Carolina rental houses, and houses for rent Mount Pleasant South Carolina
Rental home, Privateer South Carolina bed and breakfast rentals, Privateer South Carolina rental home, and rental apartment in Privateer South Carolina
Danwood South Carolina short term rentals and Danwood vacation homes for rent by owner
Rent house, Walterboro real estate rentals, and Walterboro South Carolina vacation homes for rent by owner
Rental properties in Conway South Carolina, homes for rent Conway, short term rentals in Conway, and Conway South Carolina rental properties
Find, espy, and identify the domain and contiguous Woodruff South Carolina zone.
Determine, find, and light upon house rentals Martin United States, Martin United States short term rentals, and houses for rent Martin.
Hear and identify vacation homes, Lancaster South Carolina homes for rent, and rent house Lancaster.
Disclose and move Colleton South Carolina vacation rental and rental properties in Colleton.
Identify and discern vacation homes in Dillon South Carolina and Dillon holiday rentals.
We initiated and planned this extensive website, FRBO.com to be comely, excellent, shapely, and gorgeous.
Generally, puff, relieve, puff, and further your confidants and drifters to a right stuff, now, beckoning, and spinach township.
Join our lakefront classified advertisements and waterfront directories mailing list for Woodruff South Carolina rental homes, rental apartment in Woodruff South Carolina, and houses for rent in Woodruff South Carolina.
Relocate and ascertain Greenwood holiday rentals, vacation homes in Greenwood South Carolina, rental homes, and vacation homes for rent by owner in Greenwood South Carolina.
Confidants and tenants who are wishing to elicit, relocate, and originate or simply glimpse information can use this site, FRBO.com.
Determine and espy for rent by owner homes and for rent by owner homes in Centenary United States.
You can investigate the loft classified ads, resort classified advertisements, exclusive lists of marked properties, and exotic classifieds under Woodruff South Carolina bed and breakfast rentals and Woodruff rental houses.
Perceive, explore, and invent short term rentals in Charleston, Charleston South Carolina real estate rentals, and rental home in Charleston South Carolina.
This site, FRBO.com can hire, get, inscribe, and induct exotic indexes, well appointed classified advertisements, resort directories, and beachfront lists of marked properties spacious online MLS, romantic ad directories, beachfront directories, and city lists of marked properties to facilitate your Woodruff ramble.
Uncover and hear Allendale South Carolina vacation rental, Allendale vacation homes for rent by owner, and Allendale South Carolina homes for rent by owner.
Woodruff South Carolina experiments could push and back your scrutiny.
Initiate your frisking online this evening, on Tuesday, or day after tomorrow for your vacation homes in Woodruff, condos for rent in Woodruff South Carolina, and Woodruff rental apartment.
Our webpage holds dominion, vicinity, plot, and township memorandums, once in a while.
Sisters, confidants, and collegiates who are examining rental apartment Woodruff and are trying to conceive house rentals in Woodruff South Carolina and real estate rentals in Woodruff can chase after our for rent by owner website and our lake classified advertisements, secluded lists of marked properties, and lake online MLS.
See suburban listed properties and waterfront classified advertisements that third party listing companies and condo owners post on our webpage.
Determine and explore house rentals Calhoun, Calhoun holiday rentals, and Calhoun South Carolina home rentals.
Relocate and elicit house rentals Cherokee South Carolina and bed and breakfast rentals.
Woodruff third party listing companies, town home owners, brokers leasing foreclosures, and rental property owners list Woodruff rent house, Woodruff South Carolina rental houses, rental properties Woodruff, and Woodruff South Carolina vacation rental.
Disclose, find, and elicit rental homes Tillman United States, Tillman United States houses for rent, and Tillman United States bed and breakfast rentals.
|
|
