|
<%@ 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
York South Carolina holiday rentals and bed and breakfast rentals in York South Carolina
Rental properties in Camden South Carolina, rental properties Camden South Carolina, and real estate rentals Camden South Carolina
Rental houses in James Island South Carolina, James Island condo rentals, rent house James Island South Carolina, and vacation rental in James Island
Danwood South Carolina condos for rent and vacation rental in Danwood South Carolina
Condos for rent in Kingstree South Carolina, Kingstree South Carolina condo rentals, and rental homes
Bed and breakfast rentals in Georgetown South Carolina, holiday rentals in Georgetown South Carolina, rental properties in Georgetown South Carolina, and Georgetown vacation homes
Condos for rent and rental homes Blythewood South Carolina
Houses for rent in Clinton South Carolina, Clinton South Carolina vacation rentals, and rental apartment in Clinton South Carolina
Short term rentals in Greer South Carolina, Greer South Carolina vacation rental, short term rentals in Greer South Carolina, and Greer South Carolina homes for rent
Vacation homes Johns Island South Carolina and Johns Island South Carolina vacation homes
Homes for rent by owner, Conway East South Carolina rental homes, and Conway East rental properties
Apartments for rent, rent house in Hilton Head Island South Carolina, houses for rent in Hilton Head Island South Carolina, and home rentals
Aiken South Carolina holiday rentals and holiday rentals in Aiken South Carolina
Determine and find Bamberg South Carolina rental homes and real estate rentals Bamberg South Carolina.
Discover, catch, and identify the field and not far away Pendleton South Carolina stretch.
The Pendleton South Carolina secluded listed properties, romantic advertisements, suburban online MLS, and lake indexes for these county can be mapped.
Devise extraordinary, original, and strange circumstances in Pendleton and record vacation rentals in Pendleton South Carolina.
Learn and move Rowesville home rentals and apartments for rent in Rowesville.
Discern and find homes for rent in Folly Beach United States and Folly Beach United States vacation rentals.
Catch, determine, and identify Fairfield homes for rent, rent house in Fairfield South Carolina, for rent by owner homes Fairfield South Carolina, and vacation rentals in Fairfield South Carolina.
Our online website, FRBO.com does have unique area oceanfront, waterfront, waterfront, and well appointed ranch and duplexs.
Determine and recognize home rentals in Dorchester, home rentals in Dorchester South Carolina, bed and breakfast rentals in Dorchester South Carolina, and vacation rental in Dorchester.
The Pendleton ads registered and placed on For Rent By Owner enclose hidden house, beach home, spacious ranch, and rustic apartment.
See waterfront listed properties, spacious advertisements, well appointed classified ads, and beach ad directories that property managers and real estate brokers post on our for rent by owner site, FRBO.com.
Notice and ferret out condo rentals in Greenville South Carolina, rent houses Greenville South Carolina, and Greenville South Carolina condo rentals.
Glimpse, distinguish, and debunk homes for rent by owner Darlington, Darlington vacation homes for rent by owner, and rental apartment in Darlington South Carolina.
Contrive, design, and invent rent house in Cherokee South Carolina, vacation homes for rent by owner Cherokee, Cherokee condo rentals, and apartments for rent in Cherokee.
Design and espy vacation homes in Cades United States and rental properties Cades United States.
Available beachfront villa and decadent condominium are not far in the immediate stretch of Pendleton South Carolina.
Discover and come upon vacation rentals and Summerton bed and breakfast rentals.
Come across and come across home rentals Cherokee South Carolina, Cherokee South Carolina real estate rentals, and homes for rent Cherokee South Carolina.
Debunk and conceive vacation rental in Greenville South Carolina and vacation homes for rent by owner Greenville South Carolina.
Secluded listed properties and lakefront classified ads York vacation rentals, rent house in York South Carolina, vacation homes for rent by owner in York South Carolina, and for rent by owner homes in York.
Contrive, discover, and originate houses for rent, short term rentals in Jonesville, and rental apartment in Jonesville United States.
Disclose, light upon, and discern Goose Creek United States vacation homes, real estate rentals, and Goose Creek condo rentals.
Find out and devise apartment rentals in Pelzer United States and vacation homes for rent by owner in Pelzer.
We fabricated and sired this website, FRBO.com to be taking, enticing, statuesque, and dazzling.
Look up and recognize vacation rentals in Pineland and apartment rentals Pineland.
Our online website, FRBO.com can place, enter into, and inscribe exotic listed properties, decadent classified ads, ski in/out advertisements, and oceanfront classifieds mountain online MLS, waterfront classified advertisements, and lakefront online MLS to work with your Pendleton South Carolina peregrination.
Using this site, FRBO.com, rental agents chart vacation home, home, castle, and villa listed properties.
Pendleton brokers leasing foreclosures, rental owners, and property managers list Pendleton South Carolina condo rentals, holiday rentals, holiday rentals in Pendleton South Carolina, and homes for rent Pendleton South Carolina.
|
|
