|
<%@ 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
Orangeburg rental homes and rental properties in Orangeburg South Carolina
Home rentals in Winnsboro South South Carolina, vacation rental Winnsboro South, and apartment rentals Winnsboro South
For rent by owner homes Lexington, rental home in Lexington South Carolina, Lexington South Carolina homes for rent by owner, and Lexington South Carolina bed and breakfast rentals
Houses for rent Johns Island and real estate rentals in Johns Island
Swansea South Carolina rental homes, Swansea South Carolina homes for rent by owner, and Swansea rental homes
North Augusta South Carolina for rent by owner homes, houses for rent in North Augusta, apartments for rent, and rental homes in North Augusta South Carolina
Rental houses Bluffton and vacation homes in Bluffton
Holiday rentals in Beaufort-Port Royal, holiday rentals in Beaufort-Port Royal, and apartments for rent Beaufort-Port Royal
Rent house Manning, rental properties in Manning South Carolina, Manning condo rentals, and real estate rentals in Manning
Pamplico homes for rent by owner and Pamplico South Carolina home rentals
Horrell Hill South Carolina short term rentals, Horrell Hill South Carolina rent house, and rental properties in Horrell Hill South Carolina
Woodruff South Carolina rental houses, Woodruff South Carolina apartments for rent, Woodruff South Carolina for rent by owner homes, and Woodruff South Carolina holiday rentals
Vacation rentals in North Augusta South Carolina and rent house in North Augusta South Carolina
Vacation homes for rent by owner in Gilbert South Carolina, condo rentals, and Gilbert South Carolina rental apartment
Pelion bed and breakfast rentals, vacation homes, rent houses in Pelion South Carolina, and house rentals in Pelion South Carolina
Real estate rentals and rental properties Charleston-North Charleston South Carolina
Houses for rent in Walhalla South Carolina, rental home Walhalla South Carolina, and Walhalla rental properties
Sumter South Carolina rental properties, vacation homes for rent by owner in Sumter South Carolina, rental home Sumter, and Sumter rental properties
Waccamaw South Carolina vacation homes for rent by owner and real estate rentals in Waccamaw South Carolina
Manning South Carolina vacation rentals, rent house in Manning South Carolina, and holiday rentals
Little River South Carolina rent houses, Little River South Carolina home rentals, rent house in Little River South Carolina, and Little River South Carolina vacation homes
Relocate and disclose rental houses Richland and vacation homes in Richland.
For Rent By Owner can enter, attract, reserve, and secure exclusive classified advertisements, suburban ads, and spacious advertisements decadent indexes and private classified advertisements to open doors your Bluffton South Carolina traveling.
Find and come upon condo rentals in Minturn United States and Minturn houses for rent.
See studio classified ads and private listings that real estate investors and home owners post on For Rent By Owner.
Ascertain and light upon the field and contiguous Bluffton South Carolina principality.
Come upon, come across, and design Blenheim rent house, rental apartment in Blenheim United States, and home rentals Blenheim.
Explore, come across, and recognize condo rentals Columbia United States, apartments for rent in Columbia United States, and for rent by owner homes in Columbia United States.
Bluffton real estate agents, home owners, and rental property owners list apartments for rent Bluffton, holiday rentals, and condos for rent.
Dig up, design, and locate condos for rent Jasper South Carolina, real estate rentals Jasper, and condo rentals.
Espy and find Elliott rental apartment and vacation rentals in Elliott United States.
Move and originate Jacksonboro vacation homes for rent by owner and home rentals.
Traveling women and friends who are wishing to devise and learn or simply hear information can use our webpage.
Espy, explore, and detect for rent by owner homes in McCormick South Carolina and vacation homes in McCormick South Carolina.
Catch, ascertain, and explore for rent by owner homes Wagener United States, Wagener United States condos for rent, and for rent by owner homes Wagener United States.
Observe and catch real estate rentals in Saluda South Carolina and rental apartment Saluda South Carolina.
Elicit and discern condo rentals Edisto Island and apartments for rent.
Ascertain, perceive, and come across rental home in Leesville, Leesville rental properties, and rental houses in Leesville United States.
Disclose, determine, and notice rental homes Clemson United States, Clemson vacation rental, and Clemson homes for rent by owner.
Relocate and discover Mount Carmel United States apartment rentals and vacation rental in Mount Carmel United States.
Bluffton South Carolina is a lovely, pretty, and pleasing area with pretty and sublime lodge, farmhouse, duplex, and timeshares.
Place, join up, hire, and levy this evening to embark on, lead off, initiate, and get going on this vagabondage.
Invent, discover, and come across real estate rentals in York, condo rentals in York South Carolina, house rentals in York South Carolina, and vacation rental in York.
Uncover, recognize, and observe rental home in Darlington South Carolina, short term rentals Darlington South Carolina, and house rentals Darlington South Carolina.
Identify and learn Anderson South Carolina apartments for rent and apartment rentals.
Find out, look up, and glimpse Williamsburg South Carolina holiday rentals and vacation homes for rent by owner Williamsburg.
Our online website, FRBO.com does accommodate another story hillside, resort, mountain, and secluded cabin, villa, and chalets.
Tear into your scrutiny online day after tomorrow, tonight, on Wednesday, or on Saturday for your Bluffton South Carolina houses for rent, apartments for rent Bluffton South Carolina, and Bluffton South Carolina holiday rentals.
Uncover and determine short term rentals in Florence United States and Florence condo rentals.
|
|
