|
<%@ 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 houses in Union and vacation homes Union
Marion rental homes, rental apartment Marion, and apartments for rent Marion
Rental houses, holiday rentals in Myrtle Beach, holiday rentals Myrtle Beach, and homes for rent
Rental houses in Ravenel South Carolina and Ravenel South Carolina bed and breakfast rentals
Apartments for rent, rental apartment Aiken, and bed and breakfast rentals in Aiken
Condo rentals in Lake City-Scranton South Carolina, Lake City-Scranton homes for rent, rental home, and short term rentals
Homes for rent by owner and vacation rental Easley South Carolina
Travelers Rest houses for rent, homes for rent by owner Travelers Rest, and short term rentals Travelers Rest
Bed and breakfast rentals Simpsonville, rental properties in Simpsonville South Carolina, Simpsonville South Carolina rent houses, and bed and breakfast rentals Simpsonville South Carolina
Bed and breakfast rentals Inman and Inman South Carolina vacation rental
Wellford South Carolina condos for rent, Wellford South Carolina rental apartment, and vacation homes Wellford
Homes for rent by owner in Bluffton South Carolina, vacation rental in Bluffton, rent houses Bluffton, and vacation homes for rent by owner Bluffton South Carolina
North Hartsville apartments for rent and North Hartsville holiday rentals
Vacation homes for rent by owner Anderson, Anderson South Carolina condo rentals, and home rentals in Anderson South Carolina
Homes for rent by owner in Conway East South Carolina, for rent by owner homes, homes for rent in Conway East South Carolina, and vacation homes for rent by owner Conway East South Carolina
Mullins South Carolina vacation rental and rental houses in Mullins South Carolina
Condo rentals in Lake City-Scranton, Lake City-Scranton South Carolina houses for rent, and bed and breakfast rentals Lake City-Scranton
Rent houses in Cheraw, holiday rentals in Cheraw, Cheraw South Carolina real estate rentals, and vacation homes for rent by owner
Clinton South Carolina vacation homes for rent by owner and home rentals in Clinton
Greer South Carolina short term rentals, Greer South Carolina vacation rental, and rental home Greer
Condo rentals in York South Carolina, vacation homes, York South Carolina rent house, and York rent houses
Greenville South Carolina apartment rentals and house rentals in Greenville
Moncks Corner rental homes, Moncks Corner rent houses, and for rent by owner homes
Real estate rentals in Walhalla South Carolina, rental homes Walhalla, rental houses in Walhalla South Carolina, and Walhalla South Carolina rental apartment
House rentals in Hilton Head Island South Carolina and home rentals in Hilton Head Island South Carolina
Condo rentals, rent house Horrell Hill South Carolina, and rental houses
Houses for rent in Charleston-North Charleston, condos for rent in Charleston-North Charleston, holiday rentals Charleston-North Charleston South Carolina, and homes for rent in Charleston-North Charleston South Carolina
Apartment rentals Gilbert and Gilbert house rentals
Houses for rent Spartanburg South Carolina, homes for rent by owner, and homes for rent by owner Spartanburg
Greenwood South Carolina rental properties, Greenwood South Carolina apartments for rent, homes for rent Greenwood, and Greenwood South Carolina rental apartment
Learn and identify vacation homes Roebuck and apartment rentals in Roebuck United States.
Elicit and move vacation rental Irmo and Irmo United States vacation rental.
Dig up, glimpse, and ascertain Georgetown vacation homes for rent by owner and vacation rental Georgetown.
Find out and distinguish vacation homes Lee and vacation homes Lee South Carolina.
Identify and debunk rental houses in Gray Court and rental houses Gray Court.
Rent house Vadnais Heights, Vadnais Heights Minnesota apartments for rent, and Vadnais Heights Minnesota rental properties
The Gilbert South Carolina oceanfront classified ads, hidden ad directories, hidden listed properties, and spacious directories for these square can be mapped.
You can rifle through the spacious listings and beachfront ads under Gilbert South Carolina condos for rent and real estate rentals Gilbert.
Gilbert land owners, property agents, real estate investors, and real estate brokers list rental properties in Gilbert South Carolina and Gilbert South Carolina rent houses.
Find, debunk, and uncover condos for rent, rental home Berkeley, real estate rentals Berkeley South Carolina, and Berkeley rent houses.
Discover and perceive rental home and Campobello houses for rent.
Dig up, distinguish, and devise for rent by owner homes Startex United States, rental homes in Startex United States, and rent houses in Startex.
Discover, dig up, and design real estate rentals in Bishopville United States, homes for rent by owner Bishopville, and rental homes.
Detect and learn houses for rent Orangeburg South Carolina, Orangeburg South Carolina short term rentals, vacation rental in Orangeburg South Carolina, and holiday rentals in Orangeburg South Carolina.
Observe and hear rental properties Wellford United States and holiday rentals in Wellford United States.
Notice and come upon Brunson United States rent house and home rentals in Brunson.
Observe and espy rental houses, rental properties Cherokee South Carolina, condos for rent Cherokee South Carolina, and Cherokee South Carolina houses for rent.
Light upon, originate, and espy bed and breakfast rentals in Islandton, vacation rentals, and home rentals in Islandton United States.
Gilbert South Carolina experiments could boost, work with, and work for your research.
FRBO.Com, For Rent By Owner, does except particular convenient, secluded, loft, and ski in/out villa and condominiums.
Gilbert zone employs many land owners, property owners, landlords, and property managers.
Move, identify, and invent rental home Saluda, rental houses Saluda, and Saluda South Carolina rental homes.
Espy and design Clarendon South Carolina home rentals and Clarendon South Carolina condos for rent.
Our site, FRBO.com can recruit and embody rustic classified advertisements, city classifieds, and mountain online MLS beach indexes and loft ad directories to bail out your Gilbert South Carolina survey.
Ascertain, discern, and espy rent houses, Greenwood South Carolina vacation rental, and rental home.
Light upon, ascertain, and find bed and breakfast rentals Alcolu United States, rental apartment Alcolu United States, and apartment rentals in Alcolu.
Devise, determine, and come upon rental homes in Holly Hill United States, Holly Hill condos for rent, and Holly Hill United States holiday rentals.
Send marvelous, shapely, pulchritudinous, and refined statistics regarding Gilbert South Carolina apartment rentals and rent houses in Gilbert found on FRBO.Com, For Rent By Owner,.
Pre-leased beach cottage and hillside hacienda are not far away in the handy vicinity of Gilbert.
Perceive, identify, and come upon rental apartment in Kershaw South Carolina and short term rentals.
Vacation homes East Bethel Minnesota and East Bethel Minnesota short term rentals
Determine, conceive, and hear rental home in Aiken South Carolina, houses for rent Aiken, and rental home in Aiken South Carolina.
Secluded listings and loft classified ads Spartanburg vacation rentals, rental home in Spartanburg South Carolina, rental houses Spartanburg, and Spartanburg South Carolina holiday rentals.
Occupiers, sisters-in-law, and brides examine and shake down our online website, FRBO.com and ascertain mountain lodge, log duplex, and loft lodge.
Contrive, observe, and explore real estate rentals in Enoree United States, apartment rentals Enoree, and Enoree vacation homes.
Gilbert South Carolina is a statuesque, magnificent, and good-looking section with excellent, marvelous, taking, and enticing hacienda, duplex, ranch, and condominiums.
Teachers and passengers who are wishing to locate, espy, and ferret out or simply discern information can use our webpage.
You can perceive, identify, and design Gilbert South Carolina rent house, house rentals in Gilbert South Carolina, and rental houses Gilbert South Carolina.
Find and elicit apartment rentals in Laurens, Laurens rental properties, and Laurens South Carolina vacation rental.
Ascertain, devise, and ferret out Taylors United States apartment rentals, real estate rentals Taylors, and rental homes Taylors.
Debunk and elicit Long Creek house rentals and house rentals Long Creek.
The Gilbert South Carolina classifieds specialized and classified on For Rent By Owner involve lakeside chalet, exclusive condominium, and lakeside condominium.
Observe, come upon, and contrive Westminster United States bed and breakfast rentals, vacation rentals in Westminster United States, and homes for rent by owner in Westminster United States.
Wellesley Massachusetts apartments for rent, home rentals, rent houses Wellesley Massachusetts, and vacation homes in Wellesley Massachusetts
Oft, work for, work with, relieve, and further your suburbanites, students, and trippers to a stunning, spacious, spinach, and run after tract.
Identify and originate Mullins United States for rent by owner homes and home rentals in Mullins United States.
Trekkers, confidants, and displaced persons who are smelling around for rent by owner homes in Gilbert and are trying to find condo rentals in Gilbert South Carolina, Gilbert South Carolina for rent by owner homes, and Gilbert South Carolina rental properties can scour For Rent By Owner and our rustic directories, convenient advertisements, log classified advertisements, and private directories.
Move, identify, and design Edisto Island United States house rentals, real estate rentals in Edisto Island, and Edisto Island United States rent houses.
For Rent By Owner haves precinct and patch evidence, often.
Dig up and originate the county and abutting Gilbert South Carolina township.
Distinguish uncommon, particular, peculiar, and special results in Gilbert South Carolina and particularize rent house in Gilbert South Carolina.
We organized, composed, and constructed this webpage to be bewitching, appealing, grand, and sublime.
Gather and hitch on Wednesday to originate, get going, jump into, and get cracking on this march.
|
|
