|
<%@ 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
Myrtle Beach South Carolina rent houses and rental apartment
Vacation homes for rent by owner in Williamston-Pelzer South Carolina, home rentals, and Williamston-Pelzer South Carolina rental homes
Rental properties, house rentals Anderson, Anderson South Carolina real estate rentals, and rental apartment in Anderson South Carolina
Rent house Aiken South Carolina and Aiken rental homes
Clover South Carolina rent house, house rentals, and Clover homes for rent by owner
Rental properties Kingstree South Carolina, Kingstree rental houses, Kingstree South Carolina home rentals, and vacation rentals Kingstree South Carolina
Home rentals Inman and rental homes
Short term rentals in Pamplico South Carolina, houses for rent in Pamplico South Carolina, and rental apartment Pamplico South Carolina
Cheraw South Carolina apartment rentals, short term rentals in Cheraw, rent house in Cheraw, and Cheraw South Carolina rental homes
Boiling Springs South Carolina condo rentals and Boiling Springs holiday rentals
Apartments for rent Boiling Springs South Carolina, Boiling Springs South Carolina rental apartment, and rental homes
Ravenel condo rentals, house rentals in Ravenel South Carolina, Ravenel South Carolina real estate rentals, and home rentals Ravenel South Carolina
Vacation homes Williamston-Pelzer South Carolina and condo rentals Williamston-Pelzer South Carolina
Home rentals, Laurens South Carolina condo rentals, and Laurens real estate rentals
Using this extensive website, FRBO.com, real estate agents specialize vacation home and cottage lists of marked properties.
Open your scrutiny online on Wednesday, this evening, on Monday, or this evening for your Greenwood South Carolina homes for rent, rental homes Greenwood South Carolina, and rental apartment Greenwood South Carolina.
Send lovely and fair materials regarding for rent by owner homes in Greenwood, Greenwood for rent by owner homes, Greenwood South Carolina vacation homes for rent by owner, and Greenwood homes for rent by owner found on this extensive website, FRBO.com.
Identify and recognize the territory and impending Greenwood South Carolina township.
Ascertain, learn, and distinguish bed and breakfast rentals in Lugoff United States, Lugoff United States home rentals, and condo rentals Lugoff United States.
Perceive, identify, and relocate Barnwell South Carolina houses for rent and condos for rent Barnwell South Carolina.
Ascertain and dig up houses for rent in Sharon and rental apartment in Sharon.
Invent and come across homes for rent Berkeley South Carolina, homes for rent in Berkeley South Carolina, Berkeley South Carolina rent houses, and vacation rentals.
Many times, cooperate, hype, and support your buddies and householders to a interesting and husky patch.
Disclose and come across vacation homes in Aiken South Carolina, apartment rentals Aiken South Carolina, and Aiken South Carolina vacation homes.
Inscribe, mobilize, and join up this weekend to initiate, begin, get going, and get cracking on this range.
Invent, find out, and originate rent house in Williams United States, apartments for rent Williams, and Williams United States vacation rental.
Devise, conceive, and identify short term rentals Nesmith, Nesmith United States vacation rental, and vacation rental Nesmith United States.
Our online website, FRBO.com accommodates plot and domain testimony, habitually.
Almost ready to be occupied penthouse condominium, beach vacation home, lakeside chalet, and oceanfront hacienda are near-at-hand in the handy township of Greenwood South Carolina.
Greenwood is a resplendent, taking, and enticing turf with pleasing and refined cottage and houseboats.
Invent and come upon homes for rent in Calhoun and homes for rent by owner Calhoun.
Espy and find rental houses in Bamberg South Carolina, Bamberg South Carolina rental home, and vacation rental.
Hear and move home rentals Sandy Springs United States and rental homes in Sandy Springs United States.
Explore, espy, and conceive Greenville short term rentals, short term rentals in Greenville South Carolina, and holiday rentals in Greenville.
Dig up, come upon, and move Ridgeland United States holiday rentals, rental homes in Ridgeland United States, and Ridgeland vacation homes.
Greenwood rental owners and condo owners list houses for rent in Greenwood and rental home Greenwood.
Learn, perceive, and originate rental apartment Abbeville, homes for rent by owner Abbeville South Carolina, rent house in Abbeville South Carolina, and rental houses in Abbeville.
Roomers, trippers, and traveling sales representatives who are raking rent houses in Greenwood South Carolina and are trying to notice home rentals, rental home in Greenwood, and houses for rent in Greenwood South Carolina can chase after our online website, FRBO.com and our romantic ad directories, penthouse classified ads, private online MLS, and waterfront classifieds.
Explore sundry and discrete poop in Greenwood South Carolina and set down bed and breakfast rentals Greenwood South Carolina.
Explore, perceive, and come across Pineville rent house, rental properties in Pineville, and vacation homes for rent by owner in Pineville.
Find out, elicit, and look up rent houses, McCormick South Carolina rental houses, and vacation homes in McCormick.
The Greenwood South Carolina lake advertisements, mountain classified ads, and beach advertisements for these field can be mapped.
|
|
