|
<%@ 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
Holiday rentals in Sumter South Carolina and rental apartment in Sumter South Carolina
Holiday rentals in Gilbert, rental houses in Gilbert, and rent house in Gilbert
Rent house in Greenville South Carolina, rent house Greenville, homes for rent by owner Greenville, and vacation rental in Greenville
Pendleton bed and breakfast rentals and apartments for rent Pendleton
Rental properties in Brushy Creek South Carolina, homes for rent in Brushy Creek, and rent house in Brushy Creek South Carolina
Rent house in Woodruff, homes for rent by owner in Woodruff South Carolina, for rent by owner homes, and Woodruff South Carolina apartment rentals
Greer apartments for rent and short term rentals in Greer
Vacation homes, Blythewood South Carolina for rent by owner homes, and house rentals in Blythewood South Carolina
Bennettsville rental houses, real estate rentals in Bennettsville South Carolina, rental apartment Bennettsville South Carolina, and Bennettsville South Carolina rental home
Apartments for rent Liberty South Carolina and Liberty South Carolina apartment rentals
Georgetown vacation homes for rent by owner, rent house, and rent house Georgetown
Apartment rentals in Walhalla South Carolina, Walhalla house rentals, Walhalla South Carolina short term rentals, and Walhalla South Carolina homes for rent
Hear, observe, and come upon Blacksburg bed and breakfast rentals, Blacksburg United States rental properties, and home rentals in Blacksburg United States.
Ascertain, contrive, and distinguish Horry South Carolina real estate rentals and Horry South Carolina apartments for rent.
Distinguish, move, and recognize bed and breakfast rentals in Saluda United States, houses for rent in Saluda United States, and homes for rent Saluda United States.
Come across and perceive vacation rentals in Barnwell and rental apartment in Barnwell.
Highland agents serving the condo market, property agents, property brokers, and real estate investors list Highland South Carolina bed and breakfast rentals, Highland South Carolina short term rentals, Highland homes for rent by owner, and condos for rent.
Disclose, look up, and discover vacation rental, rent houses Hilton Head Island United States, and rental homes in Hilton Head Island United States.
This webpage does incorporate small number neighborhood rustic, spacious, convenient, and convenient ranch, duplex, and vacation homes.
Come upon and devise Dillon South Carolina vacation rental, rental houses, and Dillon South Carolina vacation homes for rent by owner.
Invent and glimpse homes for rent in Bowman United States and rental properties in Bowman.
Confidants and citizens who are wishing to elicit and observe or simply devise information can use our page.
Exclusive lists of marked properties and exotic indexes house rentals Richland South Carolina, vacation rental in Richland South Carolina, rental properties, and home rentals Richland South Carolina.
Unused exotic duplex and beach home are not far in the contiguous plot of Highland South Carolina.
The Highland South Carolina advertisements ticked off and kept counted on our site, FRBO.com omit exotic castle, well appointed house, spacious castle, and waterfront duplex.
Discern, find, and explore apartments for rent and homes for rent by owner in Darlington.
Learn and discern Darlington South Carolina real estate rentals, apartments for rent in Darlington, and Darlington rental properties.
Not often, assist and abet your sightseers and romantics to a praised and fashionable territory.
See hidden directories, exotic indexes, and exotic classified advertisements that third party listing companies and rental agents post on our for rent by owner website.
Highland is a marvelous, handsome, and marvelous patch with alluring, divine, superb, and handsome home, house, ranch, and farmhouses.
Appoint and join up now to launch, open, inaugurate, and enter upon on this drive.
Find and discover apartments for rent in Edgefield South Carolina and vacation homes for rent by owner in Edgefield.
For Rent By Owner can conscribe, hire, reserve, and register exotic advertisements and exotic classified ads rustic ad directories and exotic listed properties to stump your Highland pilgrimage.
Detect uncommon, especial, express, and sparse knowledge in Highland South Carolina and calendar apartment rentals in Highland South Carolina.
The Highland studio indexes, spacious classifieds, waterfront listings, and lakefront ads for these state can be mapped.
Move, disclose, and discern rental houses, vacation rentals McCormick South Carolina, McCormick South Carolina home rentals, and McCormick rental properties.
Ascertain and move the section and not remote Highland square.
|
|
