|
<%@ 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
Rent house in Winnsboro South and Winnsboro South houses for rent
Rock Hill South Carolina rental home, bed and breakfast rentals in Rock Hill South Carolina, and rental homes in Rock Hill
Apartments for rent in West Columbia-Cayce South Carolina, West Columbia-Cayce home rentals, condo rentals West Columbia-Cayce South Carolina, and bed and breakfast rentals in West Columbia-Cayce South Carolina
Apartment rentals and rental apartment in St Helena South Carolina
Home rentals in Horrell Hill, vacation homes in Horrell Hill South Carolina, and real estate rentals in Horrell Hill South Carolina
Rental home in Laurens, Laurens South Carolina real estate rentals, short term rentals in Laurens South Carolina, and houses for rent
Apartment rentals in Seneca South Carolina and rental apartment in Seneca South Carolina
Georgetown South Carolina homes for rent by owner, short term rentals Georgetown South Carolina, and Georgetown South Carolina short term rentals
Condo rentals Piedmont, vacation homes for rent by owner in Piedmont South Carolina, rent house Piedmont, and Piedmont vacation homes
Holiday rentals Laurens South Carolina and Laurens homes for rent
Bed and breakfast rentals in Ravenel, Ravenel South Carolina condos for rent, and homes for rent Ravenel South Carolina
Rental apartment in Dutch Fork South Carolina, Dutch Fork rental homes, homes for rent in Dutch Fork South Carolina, and rental home Dutch Fork South Carolina
Houses for rent and short term rentals in York
Rental houses in Belton South Carolina, Belton South Carolina real estate rentals, and Belton South Carolina holiday rentals
For rent by owner homes in Taylors South Carolina, holiday rentals in Taylors, rental houses in Taylors South Carolina, and condos for rent in Taylors South Carolina
Rent house in Inman South Carolina and Inman condos for rent
Apartments for rent Orangeburg West South Carolina, Orangeburg West vacation homes, and vacation homes for rent by owner in Orangeburg West South Carolina
For rent by owner homes Manning, Manning holiday rentals, real estate rentals in Manning, and rent houses in Manning
Vacation homes for rent by owner Columbia South Carolina and Columbia home rentals
Rental properties in Pickens, bed and breakfast rentals in Pickens South Carolina, and apartments for rent in Pickens South Carolina
Dillon South Carolina vacation homes, Dillon South Carolina rental properties, short term rentals in Dillon South Carolina, and Dillon South Carolina vacation rental
Pamplico South Carolina short term rentals and home rentals in Pamplico
Vacation homes for rent by owner Easley South Carolina, rent house Easley South Carolina, and Easley South Carolina holiday rentals
Lancaster South Carolina brass tacks could help, reinforce, run interference, and further your rummage.
Discover, discover, and detect Darlington for rent by owner homes, Darlington South Carolina apartments for rent, and Darlington for rent by owner homes.
Voyagers and natives who are ransacking rent houses Lancaster South Carolina and are trying to invent homes for rent in Lancaster South Carolina, holiday rentals in Lancaster South Carolina, and Lancaster South Carolina vacation homes for rent by owner can root our page and our beach online MLS, lakefront directories, and resort listings.
Come across and conceive real estate rentals Florence South Carolina and rent house in Florence South Carolina.
Disclose and detect rent houses in Oconee and vacation rental in Oconee.
Join our city classifieds, log classified ads, beachfront listings, and mountain ads mailing list for homes for rent Lancaster, apartment rentals Lancaster South Carolina, and vacation rental in Lancaster.
Debunk, glimpse, and identify Jonesville United States house rentals, Jonesville rental houses, and apartment rentals in Jonesville United States.
Hear, contrive, and observe Donalds United States condo rentals, Donalds United States rental properties, and rent houses Donalds United States.
Explore and learn homes for rent by owner in Charleston and Charleston South Carolina holiday rentals.
Lancaster property managers and property agents list Lancaster South Carolina for rent by owner homes, Lancaster South Carolina condo rentals, Lancaster South Carolina houses for rent, and Lancaster South Carolina homes for rent.
Uncover, dig up, and originate the county and not to distant Lancaster South Carolina locality.
Locate and glimpse homes for rent by owner in Marlboro South Carolina, homes for rent by owner Marlboro, home rentals in Marlboro South Carolina, and Marlboro South Carolina home rentals.
Detect, hear, and ferret out vacation rentals in Marion South Carolina, Marion South Carolina vacation rental, and vacation homes in Marion South Carolina.
Invent, learn, and dig up Jasper South Carolina apartments for rent, for rent by owner homes Jasper South Carolina, real estate rentals Jasper South Carolina, and apartments for rent in Jasper.
Perceive and elicit rental properties Lexington South Carolina, vacation homes for rent by owner in Lexington South Carolina, and vacation rental in Lexington.
FRBO.Com, For Rent By Owner, can draft and assign romantic directories, mountain advertisements, log online MLS, and hidden directories well appointed lists of marked properties, lake classified advertisements, city classified advertisements, and penthouse classifieds to assist your Lancaster South Carolina peregrination.
Identify and find out rent house in Central United States and Central holiday rentals.
Disclose, find, and notice homes for rent by owner in Allendale South Carolina, house rentals Allendale, and holiday rentals in Allendale South Carolina.
Find, learn, and originate Hampton vacation homes, condo rentals Hampton South Carolina, and bed and breakfast rentals Hampton.
Lancaster South Carolina is a fascinating and bewitching block with lovely, refined, angelic, and good-looking castle, condominium, duplex, and farmhouses.
Find out and identify rent houses Saluda South Carolina, vacation homes in Saluda, Saluda vacation rental, and Saluda South Carolina real estate rentals.
You can explore the convenient online MLS and exotic online MLS under Lancaster short term rentals, homes for rent in Lancaster, and apartments for rent in Lancaster South Carolina.
Available log home, waterfront cabin, and lakeside hacienda are imminent in the neighboring township of Lancaster South Carolina.
Distinguish, originate, and come across vacation rental Sumter, vacation rentals in Sumter, and Sumter United States rental houses.
Conceive, hear, and ferret out rent houses Chesterfield South Carolina, Chesterfield vacation homes for rent by owner, rental home, and Chesterfield South Carolina home rentals.
The Lancaster South Carolina classified advertisements specialized and tabbed on our site, FRBO.com embody beach timeshare, log lodge, rustic chalet, and city lodge.
Come across and catch rental apartment Newberry, rental properties in Newberry South Carolina, and Newberry South Carolina apartments for rent.
Intermittently, help, plug, and hype your venturers, roamers, and coeds to a vast, king sized, crowd-pleaser, and brimming field.
Notice, find out, and observe houses for rent, real estate rentals in Cross Hill, and vacation homes for rent by owner Cross Hill United States.
Glimpse, recognize, and conceive Coosawatchie rental properties, bed and breakfast rentals in Coosawatchie, and real estate rentals.
Come upon, distinguish, and light upon rental properties Newberry and house rentals Newberry South Carolina.
Learn, find out, and determine apartments for rent Kinards United States, Kinards United States bed and breakfast rentals, and rental properties in Kinards.
Identify and recognize vacation homes for rent by owner Pineland United States and Pineland apartments for rent.
Devise and observe house rentals in York South Carolina and York South Carolina rental houses.
Initiate your fishing expedition online tomorrow evening, in the morning, or this weekend for your Lancaster South Carolina holiday rentals, homes for rent by owner in Lancaster South Carolina, and bed and breakfast rentals in Lancaster South Carolina.
Relocate singular and particular circumstances in Lancaster South Carolina and census Lancaster rental houses.
We shaped and fathered this extensive website, FRBO.com to be exquisite, taking, marvelous, and stunning.
Send bewitching and alluring documents regarding vacation rental, home rentals in Lancaster South Carolina, and Lancaster South Carolina apartments for rent found on our webpage.
Ascertain and notice for rent by owner homes and Norway United States rent house.
Husbands, pioneers, and residers explore and rifle through this website, FRBO.com and locate romantic home, beach house, loft farmhouse, and secluded vacation home.
|
|
