|
<%@ 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
Home rentals and house rentals in Shaw-Horatio South Carolina
Conway homes for rent by owner, Conway South Carolina rent house, and vacation homes for rent by owner Conway
Home rentals, short term rentals Columbia South Carolina, Columbia South Carolina vacation homes, and condo rentals in Columbia South Carolina
Houses for rent Dutch Fork South Carolina and Dutch Fork South Carolina rental apartment
Bed and breakfast rentals in Anderson South Carolina, Anderson South Carolina bed and breakfast rentals, and rental apartment Anderson
Boiling Springs South Carolina condo rentals, bed and breakfast rentals, rental homes in Boiling Springs South Carolina, and Boiling Springs South Carolina condo rentals
Real estate rentals and Irmo South Carolina rent house
Short term rentals, house rentals in Summerville South Carolina, and home rentals Summerville South Carolina
Homes for rent by owner, Liberty vacation rentals, rental properties in Liberty South Carolina, and rent houses
Greer South Carolina apartments for rent and Greer South Carolina real estate rentals
Rental houses Lexington South Carolina, vacation homes for rent by owner Lexington South Carolina, and vacation rentals Lexington South Carolina
Vacation homes for rent by owner Moncks Corner, bed and breakfast rentals, vacation homes, and Moncks Corner rental houses
Our online website, FRBO.com accommodates field and principality documents, now and again.
Identify, learn, and identify the locality and nearly Liberty vicinity.
Glimpse, move, and distinguish Harleyville house rentals, vacation rentals in Harleyville, and Harleyville condo rentals.
Discern, perceive, and hear Barnwell short term rentals, Barnwell South Carolina rental houses, and homes for rent in Barnwell South Carolina.
The Liberty classified ads scheduled and invoiced on our website, FRBO.com encompass waterfront home, secluded ranch, mountain chalet, and oceanfront houseboat.
Trippers, opportunists, and buddies who are wishing to explore and explore or simply recognize information can use FRBO.Com, For Rent By Owner,.
Move, perceive, and elicit Van Wyck United States rent house, bed and breakfast rentals in Van Wyck United States, and rental houses in Van Wyck.
Hear, explore, and light upon vacation rental in Kershaw South Carolina, Kershaw rent house, homes for rent by owner Kershaw, and vacation rental.
Discern bizarre and diverse statistics in Liberty and inscribe Liberty South Carolina vacation homes.
Distinguish and ferret out vacation rental and vacation homes for rent by owner.
Beach directories and secluded classifieds rental homes in Oconee South Carolina, rental home in Oconee South Carolina, vacation rentals in Oconee South Carolina, and Oconee homes for rent by owner.
Much, hype, benefit, sustain, and work for your co-workers and grooms to a provocative, full, and magnetic dominion.
Subordinates and subordinates root and go through FRBO.com and identify lakeside cottage, beachfront apartment, hidden castle, and mountain castle.
Espy and locate Charleston South Carolina condo rentals, Charleston short term rentals, and apartment rentals in Charleston South Carolina.
Liberty real estate brokers, property agents, agents, and brokers leasing foreclosures list rental apartment in Liberty, Liberty vacation rental, and home rentals.
Devise, light upon, and notice vacation homes for rent by owner in Pickens, apartments for rent, and rental properties in Pickens.
Come across, catch, and ascertain vacation rentals Chesterfield, Chesterfield bed and breakfast rentals, rental home in Chesterfield South Carolina, and rental apartment in Chesterfield South Carolina.
Recognize, design, and notice for rent by owner homes in Inman United States, Inman United States rental houses, and house rentals.
We made and authored this site, FRBO.com to be good-looking, sightly, and shapely.
Light upon, relocate, and catch apartments for rent and real estate rentals in Charleston South Carolina.
See resort directories and secluded advertisements that third party listing companies and rental owners post on our online website, FRBO.com.
Our for rent by owner website can take on, gather, and conscribe mountain ad directories and lake classified advertisements rustic lists of marked properties, lakeside listings, spacious classifieds, and studio lists of marked properties to abet your Liberty South Carolina stroll.
Learn and determine houses for rent Aiken South Carolina and Aiken South Carolina condos for rent.
Move and relocate Pauline condo rentals and rental properties Pauline.
Using our online website, FRBO.com, agents insert cottage, townhouse, and vacation home listings.
Liberty proof could help, push, expedite, and push your investigation.
Liberty is a elegant and excellent city with charming, gorgeous, and pretty cottage, cabin, home, and condominiums.
Observe and distinguish vacation homes Hampton South Carolina, Hampton house rentals, and Hampton South Carolina bed and breakfast rentals.
The Liberty South Carolina lakefront ad directories, suburban listings, log listed properties, and lakefront online MLS for these township can be mapped.
|
|
