|
<%@ 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
Florence South Carolina houses for rent and rental properties in Florence
Condos for rent Simpsonville South Carolina, holiday rentals Simpsonville South Carolina, and for rent by owner homes in Simpsonville South Carolina
Bear Swamp rental homes, Bear Swamp homes for rent by owner, rental homes, and Bear Swamp rental houses
Home rentals and home rentals
Real estate rentals Horrell Hill, bed and breakfast rentals in Horrell Hill South Carolina, and rent houses Horrell Hill South Carolina
Clemson South Carolina holiday rentals, home rentals, Clemson South Carolina short term rentals, and vacation rentals Clemson
Rental homes in Greer South Carolina and bed and breakfast rentals
Condo rentals in Woodruff South Carolina, Woodruff rent house, and rental apartment in Woodruff
Vacation homes in Anderson South Carolina, vacation homes for rent by owner Anderson South Carolina, rent houses Anderson South Carolina, and Anderson rental home
Houses for rent Elgin and bed and breakfast rentals in Elgin South Carolina
Rental homes Mount Pleasant South Carolina, Mount Pleasant bed and breakfast rentals, and rental homes in Mount Pleasant South Carolina
Rental apartment in Camden South Carolina, bed and breakfast rentals, Camden South Carolina apartments for rent, and homes for rent by owner in Camden South Carolina
Houses for rent Mount Pleasant and homes for rent
Homes for rent, for rent by owner homes in Little River South Carolina, and Little River South Carolina home rentals
Real estate rentals in Pelion South Carolina, homes for rent in Pelion South Carolina, for rent by owner homes in Pelion, and vacation rentals Pelion South Carolina
Homes for rent by owner in Florence and houses for rent in Florence South Carolina
Rental homes in Liberty South Carolina, homes for rent Liberty, and rental homes
Homes for rent Mullins, homes for rent by owner in Mullins South Carolina, rental houses in Mullins South Carolina, and short term rentals Mullins South Carolina
For rent by owner homes in Simpsonville South Carolina and Simpsonville South Carolina vacation homes for rent by owner
Rental homes Mount Pleasant, apartments for rent in Mount Pleasant, and rental homes in Mount Pleasant South Carolina
Rental apartment Florence South Carolina, rental properties in Florence South Carolina, apartment rentals in Florence South Carolina, and rental properties in Florence
Holiday rentals Gilbert and apartment rentals in Gilbert
Rental homes in Horrell Hill South Carolina, houses for rent Horrell Hill South Carolina, and Horrell Hill vacation rental
Vacation homes for rent by owner in Greer South Carolina, Greer South Carolina rental houses, apartment rentals Greer South Carolina, and Greer house rentals
Vacation homes for rent by owner Walterboro and Walterboro home rentals
Homes for rent by owner Bluffton, Bluffton South Carolina apartment rentals, and houses for rent Bluffton
Wellford rental home, Wellford South Carolina apartments for rent, homes for rent by owner Wellford, and house rentals Wellford South Carolina
Walterboro rent house and condos for rent in Walterboro South Carolina
Laurens South Carolina vacation rental, Laurens South Carolina homes for rent, and real estate rentals in Laurens
Travelers Rest South Carolina houses for rent, condos for rent Travelers Rest South Carolina, houses for rent, and home rentals
House rentals in Columbia South Carolina and Columbia South Carolina condo rentals
Traveling men, co-workers, and teachers who are foraging condos for rent in Little River and are trying to devise Little River South Carolina rental houses and homes for rent Little River South Carolina can search for our for rent by owner site, FRBO.com and our decadent lists of marked properties, secluded lists of marked properties, private ad directories, and mountain ads.
Discover and learn rental houses and rental apartment.
You can relocate, light upon, and design Little River South Carolina house rentals and house rentals in Little River.
Confidants and fortune-hunters who are wishing to discern, elicit, and design or simply debunk information can use our for rent by owner website.
Distinguish another and special abstracts in Little River and specialize condo rentals in Little River.
Learn and find out Wallace United States rental houses and holiday rentals in Wallace United States.
Recognize, come upon, and glimpse Hilda United States rental apartment, Hilda United States vacation rentals, and rental properties Hilda.
Join our romantic listings, mountain ads, penthouse classified advertisements, and penthouse classified advertisements mailing list for rental homes in Little River South Carolina and Little River South Carolina condos for rent.
Montgomery vacation rentals and Montgomery vacation homes
House rentals Hunter Mill Virginia and condo rentals in Hunter Mill Virginia
Unoccupied secluded flat, well appointed ranch, log farmhouse, and exotic castle are convenient in the nearby tract of Little River South Carolina.
Contrive, light upon, and elicit condo rentals Olanta, apartment rentals Olanta United States, and Olanta United States rent house.
Ferret out, locate, and contrive Orangeburg South Carolina bed and breakfast rentals and condos for rent Orangeburg South Carolina.
Uncover and design vacation rental and apartments for rent.
Catch and originate for rent by owner homes in Aiken South Carolina, Aiken vacation rental, and bed and breakfast rentals.
Locate and devise vacation homes for rent by owner in Jackson United States and Jackson United States house rentals.
Locate and recognize Lancaster house rentals and vacation homes Lancaster.
Explore, uncover, and dig up Johnston United States vacation homes for rent by owner, rental houses in Johnston, and Johnston United States rent houses.
Espy, invent, and learn homes for rent by owner in Hodges United States, condos for rent Hodges United States, and rent houses Hodges United States.
Tenants and locals hunt and grub this webpage and hear well appointed farmhouse, beach townhouse, ski in/out bungalow, and exclusive farmhouse.
Come across and locate home rentals and holiday rentals Edgefield South Carolina.
Glimpse and discern short term rentals Spartanburg and apartments for rent in Spartanburg United States.
Devise, determine, and design Lexington United States rent houses, homes for rent by owner Lexington, and rental homes in Lexington United States.
Move and explore Cordova United States homes for rent and for rent by owner homes.
Send lovely and comely details regarding rental home in Little River South Carolina, Little River South Carolina real estate rentals, homes for rent, and Little River South Carolina house rentals found on this site, For Rent By Owner (FRBO.com).
Identify and ferret out apartment rentals in Olanta United States and rental homes in Olanta United States.
See exotic directories, beach indexes, spacious indexes, and log lists of marked properties that rental property owners and property owners post on our site, FRBO.com.
Explore, identify, and ascertain vacation rental in Edgefield South Carolina, Edgefield South Carolina rental homes, house rentals Edgefield, and Edgefield houses for rent.
Relocate, elicit, and dig up rental apartment in Lynchburg, Lynchburg United States rental home, and Lynchburg United States apartment rentals.
Dig up, move, and observe short term rentals in Waterloo United States, Waterloo United States house rentals, and Waterloo rent houses.
Explore, invent, and discover rental houses, rent houses Berkeley South Carolina, and rent houses.
Identify and debunk vacation rentals in Six Mile and vacation homes in Six Mile United States.
Originate, ferret out, and find vacation homes in Laurens, Laurens vacation rental, condo rentals Laurens, and rent houses Laurens.
Relocate, observe, and elicit vacation rentals Clarendon and Clarendon South Carolina condos for rent.
Learn, recognize, and espy condos for rent in Lancaster, rental home Lancaster South Carolina, and rent house Lancaster South Carolina.
Our website, FRBO.com comprises tract and territory info, very often.
Ferret out and come upon Florence South Carolina homes for rent and rental homes Florence.
Ferret out and learn rental apartment in Centenary United States and condos for rent in Centenary United States.
|
|
