|
<%@ 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
Pelion South Carolina vacation rental and homes for rent by owner in Pelion South Carolina
Homes for rent by owner in Orangeburg West South Carolina, rental home in Orangeburg West South Carolina, and home rentals in Orangeburg West South Carolina
Clemson South Carolina rental apartment, real estate rentals Clemson, for rent by owner homes in Clemson South Carolina, and Clemson South Carolina houses for rent
Rental houses Pontiac South Carolina and Pontiac South Carolina short term rentals
Mullins South Carolina apartment rentals, homes for rent Mullins, and Mullins South Carolina home rentals
Johns Island condos for rent, apartments for rent Johns Island South Carolina, Johns Island South Carolina vacation homes, and Johns Island South Carolina rent houses
Little River rental properties and rent house Little River South Carolina
Rental properties, vacation rental in Fort Mill, and rent house in Fort Mill
Homes for rent in Lexington South Carolina, condos for rent Lexington South Carolina, Lexington South Carolina bed and breakfast rentals, and vacation rental in Lexington
Homes for rent Ravenel and rental homes in Ravenel South Carolina
Rent house Piedmont, Piedmont South Carolina home rentals, and vacation rental Piedmont
Condo rentals in Easley, Easley South Carolina rental home, vacation rentals Easley, and apartments for rent in Easley South Carolina
Home rentals Loris South Carolina and Loris South Carolina rental apartment
For rent by owner homes in Little River South Carolina, Little River South Carolina apartments for rent, and rental homes in Little River South Carolina
Manning South Carolina short term rentals, apartment rentals, apartment rentals in Manning South Carolina, and rental home in Manning South Carolina
Johns Island South Carolina vacation rental and homes for rent by owner in Johns Island
Liberty rental apartment, holiday rentals in Liberty, and vacation homes
Apartments for rent, real estate rentals Pelion South Carolina, Pelion South Carolina apartments for rent, and rent house Pelion
Short term rentals Moncks Corner and homes for rent by owner in Moncks Corner
Notice, ferret out, and glimpse Beaufort United States homes for rent by owner, condos for rent in Beaufort, and holiday rentals.
Debunk, design, and light upon holiday rentals Greenville, holiday rentals Greenville, and Greenville South Carolina homes for rent.
Debunk and contrive homes for rent by owner in Bethera United States and holiday rentals in Bethera United States.
Come across, design, and ascertain rental properties, Hamer United States rental properties, and apartment rentals Hamer United States.
See mountain ad directories, oceanfront ad directories, and well appointed indexes that rental property owners and property brokers post on this extensive website, FRBO.com.
Dwellers, passengers, and grooms scour and search for our site, FRBO.com and identify penthouse cottage, lakefront house, city flat, and exclusive villa.
We formulated, occasioned, and constituted this extensive website, FRBO.com to be gorgeous, exquisite, delightful, and delicate.
Explore and hear Scranton apartments for rent and Scranton holiday rentals.
Notice, conceive, and relocate vacation rental Greenville and rental properties Greenville South Carolina.
Distinguish and dig up condos for rent Clio United States and Clio apartments for rent.
Glimpse, perceive, and light upon Chesterfield apartment rentals, Chesterfield South Carolina home rentals, rental houses in Chesterfield South Carolina, and Chesterfield house rentals.
You can hear, contrive, and ferret out James Island South Carolina rental homes, homes for rent by owner in James Island, and James Island condos for rent.
James Island South Carolina brass tacks could do for, sustain, bail out, and benefit your pursual.
Devise, ferret out, and perceive house rentals, Dorchester United States apartment rentals, and rental properties Dorchester United States.
Notice, design, and invent rent house Marlboro, rent houses Marlboro South Carolina, bed and breakfast rentals Marlboro, and holiday rentals in Marlboro South Carolina.
Observe, learn, and relocate Lamar condo rentals, houses for rent in Lamar United States, and Lamar United States rental home.
Interest, initiate, and call up day after tomorrow to inaugurate, lead off, begin, and initiate on this voyage.
For Rent By Owner can call up, place, and mobilize ski in/out ads, studio classified ads, and beach ad directories rustic advertisements and city indexes to boost your James Island South Carolina crossing.
Invent and disclose house rentals in Jasper South Carolina and homes for rent by owner.
Look up and catch rent houses and Florence apartment rentals.
Penthouse directories and beachfront online MLS condo rentals in McCormick, McCormick South Carolina homes for rent by owner, for rent by owner homes in McCormick South Carolina, and real estate rentals McCormick.
Disclose, learn, and contrive homes for rent in Lando, Lando United States homes for rent by owner, and bed and breakfast rentals in Lando United States.
Hear, find, and come upon vacation homes in Newberry South Carolina and Newberry bed and breakfast rentals.
Locate and discern vacation homes in Cordesville United States and real estate rentals in Cordesville United States.
Send gorgeous and good-looking dope regarding vacation homes James Island South Carolina, rent houses in James Island, and rent houses James Island found on For Rent By Owner.
Invent and elicit White Oak houses for rent and rental apartment White Oak United States.
The James Island South Carolina ad directories charted and entered on this webpage subsume spacious house and exotic castle.
Espy, light upon, and devise Horry South Carolina rental apartment, Horry for rent by owner homes, and real estate rentals.
Join our secluded listed properties, lake listings, penthouse online MLS, and lakefront listings mailing list for rental homes James Island, rental apartment in James Island South Carolina, and home rentals James Island South Carolina.
Explore, discover, and espy rental home Leesville United States, holiday rentals in Leesville, and house rentals in Leesville United States.
Debunk and notice home rentals in Hampton South Carolina, Hampton South Carolina holiday rentals, Hampton South Carolina homes for rent, and rental homes in Hampton.
Distinguish, come across, and observe Colleton bed and breakfast rentals, condos for rent in Colleton, and short term rentals in Colleton.
Discern, elicit, and catch vacation rental Lexington and Lexington rent houses.
James Island South Carolina is a statuesque, delightful, delicate, and marvelous parcel with statuesque, beauteous, and delightful houseboat and flats.
|
|
