|
<%@ 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
Swansea South Carolina vacation rental and apartments for rent in Swansea South Carolina
Rental home Taylors, Taylors South Carolina condo rentals, and rental home in Taylors South Carolina
Vacation rental Shaw-Horatio South Carolina, rental houses Shaw-Horatio South Carolina, Shaw-Horatio South Carolina for rent by owner homes, and Shaw-Horatio South Carolina vacation rental
Horrell Hill South Carolina apartment rentals and Horrell Hill South Carolina homes for rent by owner
Home rentals in Lexington South Carolina, Lexington holiday rentals, and Lexington South Carolina condos for rent
Vacation homes Goose Creek-Hanahan, rental home in Goose Creek-Hanahan South Carolina, holiday rentals Goose Creek-Hanahan, and Goose Creek-Hanahan condos for rent
Anderson South Carolina home rentals and rental apartment Anderson South Carolina
Privateer holiday rentals, rent house Privateer, and Privateer condos for rent
Lexington for rent by owner homes, house rentals in Lexington South Carolina, Lexington South Carolina for rent by owner homes, and house rentals in Lexington
Clover condos for rent and condos for rent in Clover South Carolina
Rent house Gaffney, short term rentals Gaffney South Carolina, and rental apartment in Gaffney South Carolina
Horrell Hill South Carolina condos for rent, Horrell Hill South Carolina home rentals, Horrell Hill South Carolina condos for rent, and rent houses in Horrell Hill South Carolina
Gilbert house rentals and rent houses in Gilbert South Carolina
Camden South Carolina rental homes, vacation homes Camden, and Camden vacation rental
Rent house, vacation homes for rent by owner in Dutch Fork South Carolina, apartments for rent in Dutch Fork South Carolina, and vacation homes in Dutch Fork
Holiday rentals Highland South Carolina and rental apartment in Highland
Homes for rent by owner in North Hartsville South Carolina, holiday rentals, and North Hartsville apartment rentals
Vacation homes for rent by owner in Clemson, vacation homes for rent by owner Clemson, house rentals, and vacation homes for rent by owner Clemson South Carolina
Homes for rent and apartment rentals
Pontiac vacation rental, Pontiac houses for rent, and Pontiac South Carolina house rentals
Rental homes in Florence South Carolina, rent houses Florence, vacation homes for rent by owner Florence South Carolina, and holiday rentals in Florence South Carolina
Bed and breakfast rentals in Gray Court South Carolina and rental home in Gray Court
Clemson vacation homes for rent by owner, home rentals in Clemson, and rental properties in Clemson
Relocate, distinguish, and disclose rent houses, Florence South Carolina rental apartment, for rent by owner homes in Florence South Carolina, and apartment rentals Florence South Carolina.
Ascertain, dig up, and espy vacation homes and rental properties Calhoun.
Come upon and find vacation homes for rent by owner in Marion United States and condo rentals in Marion.
Identify, originate, and ferret out rental home in Marlboro South Carolina, Marlboro South Carolina real estate rentals, and Marlboro South Carolina condos for rent.
This site, For Rent By Owner (FRBO.com) does accommodate special county beach and hillside apartment, flat, and timeshares.
Send statuesque, beauteous, admirable, and good-looking notes regarding Loris South Carolina apartment rentals, vacation homes for rent by owner Loris, and rental homes in Loris South Carolina found on this webpage.
Oft, back, sustain, and sustain your dwellers and rent payers to a hep, in demand, and teasing vicinity.
Available romantic cabin and decadent flat are handy in the next domain of Loris.
Passengers and confreres who are wishing to ascertain, disclose, and find out or simply disclose information can use FRBO.Com, For Rent By Owner,.
Discover, learn, and detect the township and nearest Loris South Carolina domain.
Uncover and learn rental houses Chester South Carolina and rental houses in Chester.
FRBO.Com, For Rent By Owner, omits territory, county, and township evidence, infrequently.
Learn, invent, and devise Florence apartments for rent, for rent by owner homes in Florence South Carolina, homes for rent by owner in Florence South Carolina, and homes for rent.
Loris South Carolina is a pleasing, appealing, cute, and divine city with fair, charming, and admirable lodge, cottage, bungalow, and bungalows.
Light upon and come upon apartments for rent Darlington South Carolina and vacation rentals Darlington South Carolina.
Learn and invent rent houses and rental homes in Joanna United States.
Distinguish, find, and detect houses for rent Newberry South Carolina, vacation rentals in Newberry South Carolina, and rent house Newberry.
Light upon, observe, and explore vacation homes in Green Pond, holiday rentals Green Pond United States, and vacation homes in Green Pond.
Catch, elicit, and identify Hodges United States rent houses, bed and breakfast rentals Hodges United States, and Hodges apartments for rent.
Espy, move, and find out homes for rent Effingham, rental homes, and Effingham homes for rent.
Find out special, some, singular, and specialized conclusions in Loris South Carolina and invoice rental houses in Loris.
See hidden classified advertisements and penthouse ads that agents serving the condo market and rental owners post on our online website, FRBO.com.
Move and observe Lee South Carolina rental homes, Lee South Carolina condo rentals, and Lee South Carolina rental homes.
Voyagers and trekkers study, comb, and beat about our site, FRBO.com and debunk private vacation home, lake castle, studio villa, and exotic houseboat.
Contrive and debunk Orangeburg South Carolina rent house, house rentals, and Orangeburg holiday rentals.
|
|
