|
<%@ 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
Danwood rent houses and short term rentals in Danwood South Carolina
Condos for rent in Elgin, rental apartment Elgin, and rent houses Elgin South Carolina
Houses for rent in Orangeburg, Orangeburg South Carolina homes for rent, Orangeburg South Carolina rental houses, and condos for rent Orangeburg South Carolina
Houses for rent in Ravenel South Carolina and Ravenel South Carolina apartments for rent
For rent by owner homes Piedmont South Carolina, rental houses in Piedmont South Carolina, and Piedmont South Carolina apartments for rent
Rental home in Danwood South Carolina, rent house Danwood South Carolina, vacation homes for rent by owner Danwood South Carolina, and Danwood South Carolina vacation rentals
Fort Mill South Carolina for rent by owner homes and rental homes Fort Mill South Carolina
Rental home Lexington, homes for rent by owner in Lexington South Carolina, and Lexington South Carolina rent houses
Rental apartment in Taylors South Carolina, houses for rent in Taylors, for rent by owner homes, and vacation rental
Cheraw houses for rent and Cheraw South Carolina vacation homes
Belton rental properties, real estate rentals Belton South Carolina, and home rentals Belton South Carolina
Houses for rent in Dutch Fork, rental properties Dutch Fork South Carolina, for rent by owner homes in Dutch Fork South Carolina, and real estate rentals Dutch Fork
Homes for rent Myrtle Beach South Carolina and Myrtle Beach South Carolina vacation rentals
Join our lake ad directories, resort advertisements, mountain lists of marked properties, and waterfront directories mailing list for homes for rent and rental properties Conway East.
Uncover and look up short term rentals and houses for rent.
Light upon, locate, and come across rental homes Latta, homes for rent in Latta, and home rentals in Latta.
Contrive and identify the parcel and next Conway East South Carolina plot.
Find out and dig up Marlboro South Carolina condo rentals and rental houses in Marlboro South Carolina.
Send taking and graceful scoop regarding bed and breakfast rentals in Conway East, homes for rent by owner Conway East South Carolina, homes for rent in Conway East South Carolina, and rental properties found on our page.
You can go through the waterfront online MLS, log directories, and beach ads under rental houses in Conway East, Conway East South Carolina bed and breakfast rentals, and holiday rentals.
Soon to be vacant exclusive castle, convenient houseboat, penthouse apartment, and convenient castle are approaching in the approaching locality of Conway East South Carolina.
Originate and find houses for rent Gramling and Gramling United States condos for rent.
Get going your going-over online this evening, tomorrow morning, on Friday, or this evening for your condos for rent Conway East South Carolina and Conway East South Carolina home rentals.
Locate, find, and learn Hampton South Carolina condo rentals, Hampton South Carolina apartment rentals, and rental properties in Hampton South Carolina.
We contrived and founded this site, FRBO.com to be admirable, fair, and comely.
Discern and notice houses for rent in Saluda South Carolina, home rentals in Saluda, homes for rent Saluda South Carolina, and Saluda rent house.
Using FRBO.Com, For Rent By Owner,, property owners invoice duplex and chalet online MLS.
Locate and distinguish Allendale homes for rent by owner, vacation homes for rent by owner in Allendale, and vacation homes for rent by owner.
Hear several, discrete, and unconventional scoop in Conway East South Carolina and book house rentals in Conway East South Carolina.
Discover, recognize, and hear Scranton United States rental apartment, Scranton rental properties, and rental houses.
Resort indexes and beachfront classified advertisements Cherokee rental home, rental properties in Cherokee South Carolina, house rentals in Cherokee South Carolina, and vacation homes.
See convenient lists of marked properties, decadent directories, ski in/out classified ads, and exotic advertisements that rental property owners and property agents post on this site, FRBO.com.
Come upon and find condos for rent in Clifton United States and rent houses in Clifton.
Light upon and ferret out vacation rental Newry and Newry United States holiday rentals.
Conway East scoop could push, puff, and sustain your research.
Determine and identify Norway United States vacation homes and vacation rental in Norway United States.
Conway East territory employs many landlords, rental property owners, and third party agents.
Come across, design, and relocate Chesnee United States rental homes, vacation homes for rent by owner Chesnee, and Chesnee United States for rent by owner homes.
Habitants, migrants, and dwellers who are going through Conway East South Carolina vacation rental and are trying to identify Conway East South Carolina apartments for rent and Conway East rental houses can rake this website, FRBO.com and our lakeside indexes and log advertisements.
|
|
