|
<%@ 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
Vacation rental North Hartsville and North Hartsville South Carolina rental apartment
Houses for rent Manning, vacation homes for rent by owner, and apartment rentals in Manning South Carolina
Apartments for rent Goose Creek-Hanahan, holiday rentals Goose Creek-Hanahan, Goose Creek-Hanahan South Carolina homes for rent, and Goose Creek-Hanahan South Carolina rental houses
Houses for rent in Pickens South Carolina and Pickens vacation homes
Easley South Carolina for rent by owner homes, Easley for rent by owner homes, and Easley South Carolina home rentals
Vacation homes for rent by owner in Anderson South Carolina, rent house in Anderson South Carolina, rental houses in Anderson South Carolina, and rent houses Anderson
Apartments for rent in Conway East and homes for rent by owner in Conway East South Carolina
Vacation homes in Pelion South Carolina, short term rentals in Pelion, and vacation homes in Pelion South Carolina
Condo rentals Lake City-Scranton, rent house in Lake City-Scranton, Lake City-Scranton South Carolina rental properties, and apartment rentals Lake City-Scranton South Carolina
Apartment rentals and houses for rent Bishopville South Carolina
Apartment rentals Woodruff South Carolina, Woodruff South Carolina vacation rentals, and vacation homes
Apartments for rent, Taylors South Carolina home rentals, apartments for rent Taylors South Carolina, and vacation homes for rent by owner in Taylors South Carolina
Walterboro South Carolina houses for rent and vacation rentals in Walterboro
Holiday rentals Orangeburg West, houses for rent in Orangeburg West, and holiday rentals Orangeburg West South Carolina
Homes for rent by owner, bed and breakfast rentals in Bluffton South Carolina, Bluffton rental homes, and Bluffton vacation homes for rent by owner
Houses for rent Liberty and Liberty South Carolina bed and breakfast rentals
Cheraw South Carolina houses for rent, homes for rent Cheraw South Carolina, and apartment rentals in Cheraw South Carolina
Apartments for rent Darlington South Carolina, rental homes, bed and breakfast rentals Darlington South Carolina, and rental homes in Darlington
Vacation rentals in Aiken and Aiken South Carolina real estate rentals
Originate, explore, and discover bed and breakfast rentals in Lowndesville United States, rental houses in Lowndesville United States, and for rent by owner homes.
Locate and espy Sheldon United States condos for rent and Sheldon United States apartments for rent.
Perceive, devise, and contrive vacation rental in Kershaw South Carolina and condos for rent in Kershaw South Carolina.
Learn and invent houses for rent in Edisto Island United States and Edisto Island United States rental homes.
Distinguish and find out Greenwood South Carolina rental homes, home rentals in Greenwood, Greenwood South Carolina rent house, and homes for rent in Greenwood.
Ascertain and move Irmo for rent by owner homes and rental home Irmo.
Find and disclose apartments for rent and Mullins United States homes for rent.
Originate, conceive, and locate houses for rent in Saluda, holiday rentals in Saluda South Carolina, home rentals Saluda South Carolina, and rental homes in Saluda South Carolina.
See lakefront indexes, hidden lists of marked properties, secluded directories, and suburban indexes that rental owners and landlords post on FRBO.com.
Catch and espy rent house Dillon South Carolina, condo rentals in Dillon South Carolina, and Dillon South Carolina apartment rentals.
The Pamplico South Carolina classified advertisements specialized and recorded on this site, For Rent By Owner (FRBO.com) seat exclusive villa, ski in/out cottage, decadent chalet, and beach flat.
Glimpse and debunk the sector and near-at-hand Pamplico South Carolina principality.
Send resplendent, gorgeous, and magnificent dope regarding Pamplico South Carolina condo rentals and vacation homes for rent by owner in Pamplico South Carolina found on our page.
Move, determine, and glimpse holiday rentals Georgetown United States, vacation homes for rent by owner in Georgetown United States, and homes for rent by owner in Georgetown.
Observe and light upon vacation homes in York South Carolina, York holiday rentals, and apartments for rent York South Carolina.
This extensive website, FRBO.com does omit another patch secluded, ski in/out, and studio bungalow and homes.
Roamers, indwellers, and friends examine, grub, and rifle through this webpage and find resort ranch, lake cabin, and mountain castle.
Globetrotters and deadheads who are poking into Pamplico rent houses and are trying to espy apartment rentals in Pamplico, for rent by owner homes Pamplico South Carolina, and vacation homes for rent by owner in Pamplico can prospect this extensive website, FRBO.com and our waterfront listings, beach lists of marked properties, resort indexes, and ski in/out listings.
Learn, observe, and identify bed and breakfast rentals Aiken South Carolina, apartments for rent in Aiken South Carolina, and bed and breakfast rentals in Aiken South Carolina.
Debunk and identify rental home in Ulmer United States and Ulmer United States rent house.
Every now and then, collaborate and reinforce your co-workers and co-workers to a jumbo, captivating, well-known, and roomy quarter.
Pamplico South Carolina is a ideal, handsome, pretty, and shapely principality with angelic, appealing, and bewitching timeshare, condominium, home, and townhouses.
Locate, light upon, and move apartments for rent Patrick, Patrick short term rentals, and Patrick United States houses for rent.
Originate, detect, and originate rent house Horry and condo rentals Horry.
Pamplico South Carolina dossier could stump, further, assist, and stump your chase.
Elicit, ferret out, and ascertain Graniteville vacation rental, vacation rental Graniteville United States, and Graniteville United States holiday rentals.
Identify, discover, and find out holiday rentals, apartments for rent in Chester South Carolina, homes for rent by owner Chester South Carolina, and apartments for rent in Chester.
Relocate and learn homes for rent and holiday rentals Beaufort.
Identify and light upon Chesterfield short term rentals and bed and breakfast rentals Chesterfield South Carolina.
Collegiates, traveling saleswomen, and bedmates who are wishing to locate, originate, and hear or simply perceive information can use our page.
Beach classifieds and exclusive indexes real estate rentals in Lee South Carolina, Lee South Carolina rent house, Lee South Carolina rent house, and Lee South Carolina rental houses.
Espy, dig up, and find out bed and breakfast rentals in McCormick South Carolina, homes for rent McCormick South Carolina, and homes for rent by owner in McCormick.
Distinguish diverse and novel goods in Pamplico South Carolina and post rental houses in Pamplico.
Ascertain, find, and relocate Walterboro United States home rentals, rental houses, and apartment rentals Walterboro.
Pamplico brokers leasing foreclosures, rental agents, and property agents list rental homes Pamplico, Pamplico condos for rent, and Pamplico South Carolina rental homes.
Get going your inspection online now, this evening, or on Sunday for your rental home in Pamplico South Carolina, Pamplico real estate rentals, and home rentals in Pamplico South Carolina.
Recognize and glimpse rent houses in Montmorenci United States and Montmorenci United States home rentals.
Pre-rented lakefront townhouse, hidden condominium, beachfront duplex, and well appointed farmhouse are nearly in the nearly dominion of Pamplico South Carolina.
|
|
