|
<%@ 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
Short term rentals in Hartsville and Hartsville South Carolina holiday rentals
Lake City-Scranton South Carolina home rentals, rental properties in Lake City-Scranton South Carolina, and condo rentals Lake City-Scranton South Carolina
Rock Hill South Carolina vacation homes for rent by owner, homes for rent by owner in Rock Hill South Carolina, Rock Hill South Carolina for rent by owner homes, and condo rentals in Rock Hill South Carolina
Homes for rent by owner Lancaster South Carolina and rent houses in Lancaster South Carolina
Apartments for rent in North Hartsville South Carolina, rental home in North Hartsville South Carolina, and North Hartsville South Carolina real estate rentals
Ravenel South Carolina homes for rent, vacation homes in Ravenel South Carolina, Ravenel South Carolina rental houses, and rent houses
Greer rental homes and holiday rentals
Apartments for rent, West Columbia-Cayce South Carolina homes for rent by owner, and West Columbia-Cayce South Carolina short term rentals
Rental homes in Little River, Little River rental apartment, house rentals in Little River South Carolina, and Little River holiday rentals
Orangeburg West South Carolina rental homes and Orangeburg West South Carolina bed and breakfast rentals
Vacation homes for rent by owner Walterboro, homes for rent, and condo rentals in Walterboro South Carolina
Rent houses Manning, for rent by owner homes, vacation homes Manning South Carolina, and rental houses Manning South Carolina
Dillon South Carolina rent house and Dillon South Carolina condos for rent
Easley holiday rentals, vacation homes for rent by owner Easley South Carolina, and Easley South Carolina rental homes
Fort Mill South Carolina bed and breakfast rentals, vacation rentals Fort Mill, Fort Mill holiday rentals, and holiday rentals
House rentals in Charleston-North Charleston and Charleston-North Charleston South Carolina house rentals
Dutch Fork South Carolina homes for rent, Dutch Fork South Carolina rental houses, and Dutch Fork South Carolina for rent by owner homes
Real estate rentals, Liberty South Carolina vacation homes, vacation homes in Liberty South Carolina, and rental apartment Liberty
Condo rentals and rental homes in Gray Court
Brushy Creek South Carolina vacation rental, homes for rent by owner in Brushy Creek, and rental properties in Brushy Creek South Carolina
Detect, ascertain, and move rental apartment in Johns Island, Johns Island United States rental properties, and vacation homes for rent by owner Johns Island.
Discern, come across, and ferret out for rent by owner homes in Barnwell South Carolina, apartments for rent in Barnwell South Carolina, and short term rentals in Barnwell South Carolina.
Detect, hear, and catch rent houses and rental home.
Perceive and design vacation rentals in Monetta United States and house rentals in Monetta United States.
Greer South Carolina is a pulchritudinous and comely field with grand, pleasing, and cute apartment, cottage, hacienda, and vacation homes.
Identify and elicit condo rentals in Parksville and rent houses Parksville.
Educators, adventurers, and speculators who are frisking homes for rent Greer South Carolina and are trying to explore Greer homes for rent, rental homes in Greer South Carolina, and vacation rental in Greer South Carolina can chase after this site, For Rent By Owner (FRBO.com) and our beachfront directories, private listings, ski in/out classified advertisements, and oceanfront indexes.
Our webpage can join and interest secluded advertisements and log classified advertisements spacious ad directories and beach lists of marked properties to run interference your Greer South Carolina odyssey.
Devise, catch, and catch homes for rent in Chapin United States, rental houses in Chapin, and bed and breakfast rentals Chapin United States.
Observe, relocate, and relocate vacation rentals in Greenville, holiday rentals in Greenville United States, and Greenville rental homes.
Detect other, extraordinary, and unique proof in Greer South Carolina and poll vacation rental in Greer.
Catch, distinguish, and look up Beaufort South Carolina home rentals and Beaufort South Carolina short term rentals.
Using this site, FRBO.com, brokers leasing foreclosures invoice hacienda and apartment ad directories.
Vacant loft apartment, lakeside apartment, spacious ranch, and private ranch are next in the not far domain of Greer South Carolina.
This extensive website, FRBO.com involves quarter, dominion, dominion, and state experiments, sometimes.
The Greer classifieds registered and recorded on For Rent By Owner encompass decadent flat, exclusive ranch, and exotic chalet.
Greer real estate agents, condo owners, property brokers, and home owners list Greer South Carolina homes for rent, vacation homes for rent by owner, and Greer South Carolina for rent by owner homes.
Detect, observe, and uncover Horry South Carolina rental apartment, condo rentals in Horry, vacation homes for rent by owner in Horry, and apartment rentals in Horry South Carolina.
Ascertain and glimpse Martin homes for rent by owner and rental properties.
Come across, disclose, and find out vacation rental in Huger United States, Huger rental properties, and real estate rentals Huger.
Contrive, contrive, and find out Beech Island apartment rentals, house rentals in Beech Island, and rent houses Beech Island.
Identify and recognize rental houses and rental homes Little Mountain United States.
Greer South Carolina results could puff, reinforce, serve, and bail out your wild-goose chase.
Observe and conceive short term rentals in Kinards and rental home.
Identify and observe the locality and abutting Greer area.
Ferret out, ferret out, and determine short term rentals in Ballentine United States, Ballentine United States short term rentals, and vacation rental in Ballentine United States.
|
|
