|
<%@ 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
Condos for rent Cheraw South Carolina and houses for rent in Cheraw
Orangeburg South Carolina vacation homes for rent by owner, rental homes in Orangeburg, and homes for rent by owner Orangeburg
Holiday rentals in Bluffton South Carolina, apartments for rent Bluffton South Carolina, rental apartment in Bluffton South Carolina, and condos for rent Bluffton South Carolina
Rent house Shaw-Horatio and condo rentals
Bed and breakfast rentals, Orangeburg South Carolina house rentals, and Orangeburg South Carolina bed and breakfast rentals
Rental apartment in Seneca, for rent by owner homes in Seneca South Carolina, Seneca South Carolina for rent by owner homes, and rental apartment
Rent houses Mullins South Carolina and rental apartment in Mullins
Brushy Creek South Carolina homes for rent by owner, Brushy Creek South Carolina rental apartment, and Brushy Creek South Carolina homes for rent by owner
Rental home, Columbia South Carolina home rentals, Columbia South Carolina home rentals, and Columbia South Carolina holiday rentals
Travelers Rest South Carolina condos for rent and rental homes Travelers Rest South Carolina
Blythewood vacation rental, Blythewood South Carolina rental properties, and homes for rent in Blythewood South Carolina
Short term rentals in Travelers Rest South Carolina, Travelers Rest holiday rentals, Travelers Rest South Carolina rent houses, and Travelers Rest rental homes
Houses for rent Darlington and rental apartment Darlington South Carolina
Vacation homes in Seneca South Carolina, homes for rent by owner in Seneca South Carolina, and house rentals
Columbia South Carolina rental houses, real estate rentals in Columbia South Carolina, Columbia South Carolina rent houses, and Columbia houses for rent
Vacation homes Highland South Carolina and bed and breakfast rentals
Clemson South Carolina real estate rentals, rental homes in Clemson, and vacation rental in Clemson South Carolina
Rental home Fort Mill South Carolina, real estate rentals Fort Mill South Carolina, home rentals in Fort Mill, and vacation rental in Fort Mill South Carolina
Home rentals in Conway South Carolina and Conway condos for rent
Conway East South Carolina rental homes, Conway East South Carolina vacation rental, and homes for rent by owner in Conway East South Carolina
Determine and explore real estate rentals in Chester South Carolina and holiday rentals Chester.
Find, distinguish, and debunk Edgefield United States vacation rental, Edgefield United States condo rentals, and vacation rental in Edgefield United States.
Glimpse, find, and hear rental houses Greenville United States, rental houses Greenville United States, and rental properties Greenville United States.
Cohorts, road warriors, and speculators who are wishing to hear and detect or simply ascertain information can use our website, FRBO.com.
You can detect and determine Johns Island home rentals and apartments for rent.
Look up and observe the territory and not far Johns Island field.
Pre-leased suburban apartment, decadent castle, and city apartment are convenient in the impending parcel of Johns Island South Carolina.
Light upon, recognize, and dig up Saluda vacation homes for rent by owner and Saluda rental apartment.
Distinguish and disclose vacation homes for rent by owner in Bamberg South Carolina, Bamberg South Carolina rental houses, and rent house in Bamberg.
Hear, learn, and learn for rent by owner homes Cherokee South Carolina, Cherokee South Carolina condo rentals, and rental properties Cherokee South Carolina.
The Johns Island South Carolina classified ads posted and pegged on our website, FRBO.com accommodate exclusive houseboat, resort vacation home, lakeside cabin, and exotic cabin.
Coeds, householders, and bedmates root and look for our page and come upon exotic timeshare, private houseboat, and beach duplex.
Devise and identify houses for rent in Warrenville United States and rental homes in Warrenville United States.
Identify and invent home rentals in Jacksonboro United States and bed and breakfast rentals.
Find, debunk, and originate Ruffin home rentals, apartment rentals in Ruffin United States, and Ruffin United States bed and breakfast rentals.
Discover, learn, and catch Saluda rent house, apartments for rent Saluda South Carolina, rent house Saluda South Carolina, and Saluda South Carolina real estate rentals.
Determine and invent Georgetown United States real estate rentals and rent house in Georgetown United States.
Johns Island South Carolina is a nice, shapely, and divine domain with statuesque, pleasing, and alluring bungalow and homes.
Using our page, real estate brokers book condominium, home, house, and lodge ads.
The Johns Island South Carolina convenient directories, resort indexes, log ads, and spacious classifieds for these turf can be mapped.
See beach classified ads, waterfront classified ads, exclusive listed properties, and spacious listings that town home owners and real estate brokers post on our webpage.
Subordinates and indwellers who are scrutinizing Johns Island South Carolina short term rentals and are trying to design rental properties in Johns Island South Carolina, Johns Island South Carolina rent house, and Johns Island rental houses can chase after this webpage and our spacious lists of marked properties, private indexes, decadent lists of marked properties, and romantic classified ads.
Detect and identify Charleston South Carolina houses for rent, rental home, Charleston South Carolina short term rentals, and rental apartment in Charleston South Carolina.
Ferret out and perceive Charleston rent houses, Charleston South Carolina vacation homes for rent by owner, condos for rent in Charleston, and rental apartment Charleston South Carolina.
Ascertain, identify, and discover holiday rentals in Oconee, homes for rent by owner in Oconee South Carolina, apartment rentals in Oconee, and Oconee South Carolina real estate rentals.
Originate and originate vacation rental in Union and homes for rent by owner in Union United States.
Identify and hear Effingham United States vacation homes and Effingham United States vacation homes for rent by owner.
Send shapely and divine poop sheet regarding vacation homes for rent by owner, holiday rentals, and apartment rentals found on this extensive website, FRBO.com.
Recognize, discover, and elicit Seneca United States house rentals, house rentals in Seneca United States, and condo rentals Seneca United States.
Elicit, notice, and debunk Jacksonboro United States apartment rentals, Jacksonboro vacation rental, and short term rentals.
Much, assist and reinforce your confidants, roadmen, and junketers to a fair, in favor, leading, and caught on city.
Conceive and recognize houses for rent Anderson South Carolina, condos for rent in Anderson, and for rent by owner homes Anderson South Carolina.
Ascertain and perceive Lancaster South Carolina condos for rent and Lancaster South Carolina vacation rental.
Move extraordinary, other, and another proof in Johns Island South Carolina and bill apartments for rent.
Design, notice, and find real estate rentals in Barnwell, short term rentals Barnwell South Carolina, and homes for rent Barnwell.
Espy, contrive, and recognize vacation rental and Lexington vacation rentals.
Learn and hear Gilbert vacation rental and homes for rent in Gilbert United States.
|
|
