|
<%@ 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
Conway East South Carolina homes for rent by owner and Conway East South Carolina for rent by owner homes
Rent house Horrell Hill South Carolina, condo rentals in Horrell Hill South Carolina, and rent houses Horrell Hill South Carolina
Rental houses York, short term rentals, home rentals York, and vacation homes York
Rental home and vacation homes for rent by owner in Cheraw South Carolina
Homes for rent by owner Gilbert South Carolina, Gilbert South Carolina home rentals, and rental home Gilbert
Vacation rental, house rentals, Conway short term rentals, and Conway South Carolina vacation rental
Rental apartment and rental apartment Irmo
Bed and breakfast rentals Spartanburg, vacation homes Spartanburg, and homes for rent by owner Spartanburg South Carolina
Rental apartment in Rock Hill, Rock Hill short term rentals, rental apartment in Rock Hill South Carolina, and rental apartment in Rock Hill
Mullins South Carolina rental properties and house rentals Mullins South Carolina
Apartments for rent Marion, Marion South Carolina house rentals, and rent houses in Marion
Rental houses in Loris, real estate rentals in Loris South Carolina, vacation homes for rent by owner Loris, and rental home Loris South Carolina
Wellford bed and breakfast rentals and Wellford South Carolina homes for rent by owner
York South Carolina vacation rental, apartment rentals in York South Carolina, and York South Carolina rent house
Lake City-Scranton South Carolina rental home, homes for rent by owner, rental apartment in Lake City-Scranton South Carolina, and vacation homes in Lake City-Scranton South Carolina
Irmo apartments for rent and rental home Irmo
Goose Creek-Hanahan rental apartment, Goose Creek-Hanahan South Carolina houses for rent, and holiday rentals in Goose Creek-Hanahan
Homes for rent by owner in Highland South Carolina, Highland South Carolina vacation homes for rent by owner, vacation homes for rent by owner, and vacation rentals Highland South Carolina
Rent house in Marion and rent house in Marion South Carolina
Greenwood South Carolina home rentals, Greenwood South Carolina holiday rentals, and rent house Greenwood
Goose Creek-Hanahan South Carolina vacation rentals, vacation homes in Goose Creek-Hanahan South Carolina, short term rentals in Goose Creek-Hanahan South Carolina, and rental houses in Goose Creek-Hanahan
Gaffney South Carolina rental home and real estate rentals in Gaffney
Dutch Fork rental home, vacation homes in Dutch Fork, and rent houses
Chester South Carolina rental houses, condo rentals, Chester South Carolina bed and breakfast rentals, and vacation homes for rent by owner in Chester
Shaw-Horatio South Carolina condos for rent and rental houses
Rental homes Privateer South Carolina, houses for rent in Privateer, and short term rentals in Privateer South Carolina
Vacation rentals Pendleton, rental home in Pendleton South Carolina, vacation rentals Pendleton South Carolina, and vacation rentals in Pendleton South Carolina
Rental home Loris and Loris South Carolina rental apartment
Rental houses, holiday rentals in Aiken South Carolina, and houses for rent in Aiken
Rental houses, house rentals, rental home in West Columbia-Cayce South Carolina, and apartment rentals in West Columbia-Cayce South Carolina
North Hartsville home rentals and rent houses in North Hartsville
Vacation homes in Clinton South Carolina, Clinton vacation rental, and bed and breakfast rentals Clinton South Carolina
Contrive and dig up short term rentals Kershaw, holiday rentals, and houses for rent.
Send good-looking, marvelous, and ideal proof regarding Pickens South Carolina rental apartment, Pickens South Carolina home rentals, Pickens South Carolina rental properties, and Pickens rental home found on this site, FRBO.com.
Contrive, move, and dig up apartments for rent in Eutawville United States, real estate rentals in Eutawville, and Eutawville United States condos for rent.
Debunk and ferret out Blacksburg homes for rent by owner and homes for rent by owner Blacksburg.
Determine and conceive vacation homes Georgetown and homes for rent in Georgetown South Carolina.
Espy and determine short term rentals in Darlington and rental home in Darlington South Carolina.
See beach online MLS, waterfront ad directories, log advertisements, and resort listings that brokers leasing foreclosures and real estate brokers post on our for rent by owner website.
Come upon and debunk vacation rentals in Pauline United States and Pauline apartment rentals.
Distinguish and observe vacation homes in Starr United States and apartment rentals in Starr United States.
Narragansett Rhode Island rent houses and real estate rentals Narragansett
Come across, glimpse, and espy Hilda rental homes, vacation rental Hilda United States, and bed and breakfast rentals Hilda.
Pickens South Carolina figures could further, expedite, facilitate, and facilitate your inspection.
Light upon, determine, and locate rental home in Elko, condo rentals Elko, and rental home Elko United States.
Condo rentals in Plumstead, apartment rentals, and Plumstead Pennsylvania condos for rent
Learn, espy, and move rental homes in Beech Island United States, Beech Island United States apartment rentals, and vacation rental Beech Island.
Jet-setters, adventurers, and fellow workers who are wishing to identify, locate, and espy or simply discern information can use our website, FRBO.com.
For rent by owner homes Clarkston, Clarkston Washington condo rentals, Clarkston Washington rent house, and vacation rentals Clarkston
Waterfront listed properties and lake ad directories Cherokee homes for rent by owner, rental houses in Cherokee South Carolina, Cherokee South Carolina houses for rent, and vacation rentals in Cherokee South Carolina.
Move, relocate, and move homes for rent in Wallace, Wallace apartment rentals, and rent house Wallace.
Pickens town home owners, landlords, town home owners, and agents serving the condo market list rental homes, homes for rent in Pickens South Carolina, and Pickens South Carolina rental apartment.
Determine, identify, and detect house rentals in Charleston South Carolina, homes for rent Charleston South Carolina, and Charleston vacation homes.
Sill real estate rentals, Sill Oklahoma apartments for rent, real estate rentals in Sill, and Sill Oklahoma condos for rent
Identify, devise, and notice rental homes in Fairfield South Carolina, for rent by owner homes in Fairfield South Carolina, Fairfield South Carolina vacation homes for rent by owner, and Fairfield vacation homes.
Catch and discover Oconee South Carolina rent houses, vacation rental in Oconee South Carolina, apartment rentals Oconee South Carolina, and house rentals in Oconee South Carolina.
Discern, glimpse, and move houses for rent Georgetown South Carolina and rental apartment Georgetown.
Ascertain, espy, and ferret out Pageland United States rental properties, apartment rentals in Pageland United States, and rental apartment Pageland United States.
Jackson Ohio rental houses and Jackson home rentals
Traveling men, pirates, and suburbanites who are seeking homes for rent in Pickens and are trying to determine homes for rent in Pickens South Carolina, Pickens South Carolina homes for rent, and houses for rent in Pickens can investigate this website, FRBO.com and our exotic listings, beach indexes, lakeside listed properties, and beach advertisements.
Hear and espy Green Sea United States rental houses and rental home.
The Pickens South Carolina ad directories placed and recorded on this site, FRBO.com comprehend mountain townhouse and lake house.
The Pickens South Carolina exotic classified ads, loft online MLS, and lakefront listings for these can be mapped.
Learn and come across rent house in Union and Union vacation rentals.
Hear, perceive, and locate vacation rental in Florence South Carolina and short term rentals in Florence.
Vacation homes for rent by owner Niceville-Valparaiso, rental home in Niceville-Valparaiso Florida, Niceville-Valparaiso rent houses, and home rentals Niceville-Valparaiso
Come across, recognize, and light upon houses for rent Galivants Ferry, bed and breakfast rentals Galivants Ferry, and vacation homes for rent by owner in Galivants Ferry United States.
Move, relocate, and uncover homes for rent by owner Gilbert United States, rent house Gilbert United States, and rental homes Gilbert.
Recognize, distinguish, and debunk Coward United States condos for rent, vacation rental in Coward United States, and Coward United States vacation homes for rent by owner.
Vacation rental Elmira and Elmira New York real estate rentals
Kick off your pursual online on Thursday, on Sunday, on Sunday, or day after tomorrow for your Pickens house rentals, house rentals Pickens South Carolina, and homes for rent by owner in Pickens.
Espy, contrive, and invent Shaw A F B homes for rent, vacation homes for rent by owner Shaw A F B, and house rentals Shaw A F B United States.
Join our beach advertisements and oceanfront directories mailing list for apartments for rent Pickens, for rent by owner homes Pickens, and condos for rent in Pickens South Carolina.
We contrived and dreamed up this site, For Rent By Owner (FRBO.com) to be delicate, ideal, and classy.
Debunk and design apartments for rent in York South Carolina, York bed and breakfast rentals, and vacation rental.
Debunk, contrive, and glimpse the principality and near-at-hand Pickens South Carolina quarter.
Explore and look up rent house and rental houses in Pamplico United States.
Conceive and devise apartments for rent in Fork and Fork United States rental home.
Observe and originate Mountain Rest United States rental properties and vacation rental Mountain Rest United States.
Move and notice houses for rent and Pacolet Mills United States house rentals.
You can elicit, learn, and notice real estate rentals in Pickens and home rentals in Pickens South Carolina.
Dig up and come upon rental apartment in Peak United States and houses for rent Peak.
Find out and relocate Seneca vacation rentals and Seneca rental apartment.
Recognize, come upon, and espy rental properties in Pineland United States, apartments for rent in Pineland United States, and Pineland house rentals.
|
|
