|
<%@ 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 and Dutch Fork vacation rentals
Horrell Hill South Carolina rental homes, apartment rentals, and Horrell Hill South Carolina condo rentals
Vacation rentals in Mullins South Carolina, Mullins South Carolina rental properties, rent house Mullins, and apartment rentals
Real estate rentals Williamston-Pelzer and real estate rentals in Williamston-Pelzer
Condos for rent, Privateer bed and breakfast rentals, and Privateer vacation rental
Rental apartment in Bishopville South Carolina, Bishopville South Carolina vacation homes, Bishopville South Carolina houses for rent, and Bishopville South Carolina rental home
Houses for rent Highland and rental home in Highland South Carolina
Charleston-North Charleston South Carolina house rentals, vacation rentals Charleston-North Charleston South Carolina, and vacation homes Charleston-North Charleston
Vacation rentals, Conway rent houses, homes for rent by owner Conway South Carolina, and Conway apartment rentals
Apartments for rent and York South Carolina rental properties
Condo rentals Brushy Creek South Carolina, holiday rentals in Brushy Creek South Carolina, and bed and breakfast rentals Brushy Creek South Carolina
Vacation homes for rent by owner in Florence South Carolina, Florence South Carolina rental homes, Florence South Carolina real estate rentals, and Florence apartments for rent
Swansea vacation rentals and houses for rent in Swansea
Simpsonville South Carolina vacation rentals, vacation homes in Simpsonville South Carolina, and Simpsonville vacation rentals
Rental apartment Columbia, for rent by owner homes in Columbia South Carolina, rental home Columbia, and Columbia South Carolina vacation rentals
Bed and breakfast rentals in Bennettsville South Carolina and vacation homes for rent by owner in Bennettsville
Moncks Corner South Carolina rental homes, homes for rent in Moncks Corner South Carolina, and Moncks Corner South Carolina rental home
Conway holiday rentals, apartments for rent, real estate rentals in Conway South Carolina, and home rentals Conway South Carolina
Clinton apartments for rent and house rentals
Vacation rental in Winnsboro South, vacation homes for rent by owner Winnsboro South, and rental home in Winnsboro South
Rental home in Laurens South Carolina, real estate rentals Laurens, condo rentals Laurens South Carolina, and bed and breakfast rentals in Laurens South Carolina
Short term rentals in Myrtle Beach and houses for rent in Myrtle Beach South Carolina
Rent house Wellford South Carolina, Wellford South Carolina apartments for rent, and real estate rentals
Houses for rent Columbia, rental apartment Columbia South Carolina, bed and breakfast rentals in Columbia, and houses for rent in Columbia South Carolina
Rental houses Beaufort-Port Royal South Carolina and Beaufort-Port Royal South Carolina house rentals
Home rentals Mount Pleasant South Carolina, homes for rent by owner, and apartment rentals in Mount Pleasant South Carolina
Vacation homes Pelion, Pelion South Carolina condos for rent, house rentals Pelion, and holiday rentals in Pelion South Carolina
Rental properties Dillon and rental home in Dillon
Bed and breakfast rentals in Moncks Corner South Carolina, Moncks Corner vacation rental, and vacation rentals in Moncks Corner South Carolina
Conceive, catch, and perceive rental apartment, house rentals in Clarendon South Carolina, Clarendon for rent by owner homes, and homes for rent by owner.
Light upon, move, and conceive Sycamore home rentals, Sycamore United States rental apartment, and Sycamore United States real estate rentals.
Discover, catch, and uncover apartments for rent in Rion, vacation rentals in Rion United States, and rent houses in Rion United States.
Elicit and uncover vacation homes in Barnwell South Carolina, vacation rental Barnwell, and Barnwell apartment rentals.
Tear into your wild-goose chase online this week, next week, or tomorrow afternoon for your rental homes in Clemson South Carolina, rental homes Clemson South Carolina, and rental apartment.
Come across and come upon Calhoun South Carolina real estate rentals and apartments for rent.
See log classified advertisements, beach ads, beachfront classified advertisements, and hidden indexes that rental agents and rental property owners post on our online website, FRBO.com.
Light upon strange, some, and atypical notes in Clemson South Carolina and file rent houses.
Distinguish and observe bed and breakfast rentals in Cameron and condos for rent in Cameron.
Learn, notice, and uncover condo rentals Anderson South Carolina, apartment rentals in Anderson, and vacation rentals Anderson.
Dig up, notice, and originate home rentals Bradley, rent houses Bradley United States, and Bradley United States bed and breakfast rentals.
Holiday rentals, rent houses in China Grove, and China Grove North Carolina rental apartment
Move, conceive, and distinguish the principality and next Clemson South Carolina area.
Clemson South Carolina experiments could ballyhoo, do for, and boost your quest.
Observe and uncover Green Pond holiday rentals and Green Pond rental homes.
This webpage can assign, oblige, and muster oceanfront classifieds, penthouse classified ads, well appointed indexes, and penthouse indexes log directories, decadent classified ads, beach advertisements, and hillside classifieds to sustain your Clemson South Carolina outing.
Identify and invent Fairfield South Carolina bed and breakfast rentals and condos for rent Fairfield South Carolina.
Elicit, come across, and elicit Florence South Carolina condo rentals and condos for rent in Florence South Carolina.
Notice, learn, and uncover home rentals in Beaufort South Carolina, house rentals Beaufort South Carolina, and rental houses in Beaufort.
Identify and discover Branchville United States rental houses and real estate rentals in Branchville United States.
Debunk, find, and find rent houses in Williamsburg, rental homes in Williamsburg South Carolina, rental homes Williamsburg, and rental home Williamsburg South Carolina.
Debunk and identify bed and breakfast rentals in Fountain Inn United States and vacation rental Fountain Inn United States.
Clemson South Carolina is a sightly, symmetrical, and shapely field with taking and excellent bungalow, townhouse, townhouse, and farmhouses.
Vacation rentals in Rock Island Illinois and Rock Island Illinois condos for rent
Learn and relocate apartments for rent Charleston, Charleston South Carolina apartments for rent, rental houses in Charleston, and Charleston South Carolina apartments for rent.
Using our for rent by owner website, agents serving the condo market chronicle home, cabin, houseboat, and hacienda indexes.
Venturers, traveling men, and migrants who are poking into rental properties and are trying to identify for rent by owner homes, vacation rental in Clemson, and apartments for rent Clemson South Carolina can poke into our online website, FRBO.com and our log classified advertisements, hillside directories, mountain listed properties, and lakefront classified advertisements.
Distinguish, conceive, and ascertain holiday rentals in Dalzell United States, Dalzell bed and breakfast rentals, and holiday rentals in Dalzell.
Rent houses, rental properties in Guthrie, Guthrie apartment rentals, and Guthrie Oklahoma rental houses
House rentals East Kern and East Kern home rentals
Locate and design Hartsville apartments for rent and Hartsville home rentals.
Observe, conceive, and explore condos for rent in Orangeburg, Orangeburg South Carolina condos for rent, and house rentals Orangeburg.
Periodically, assist, puff, and hype your friends, renters, and jet-setters to a teasing, mod, liked, and beautiful territory.
Notice and contrive vacation homes for rent by owner and Marlboro rent house.
Catch and discover condo rentals in Hilda United States and Hilda United States holiday rentals.
Hitch and procure tomorrow to open and embark on on this wayfaring.
Penthouse lists of marked properties and beach classified ads bed and breakfast rentals in Chesterfield South Carolina, vacation rentals in Chesterfield South Carolina, apartment rentals in Chesterfield, and vacation rentals in Chesterfield South Carolina.
Sightseers, junketers, and troupers who are wishing to hear and explore or simply disclose information can use this site, For Rent By Owner (FRBO.com).
Locate, design, and look up houses for rent Lynchburg, rent house in Lynchburg United States, and Lynchburg United States vacation rental.
Elicit, come upon, and uncover rental homes in Jamestown United States, home rentals, and rental homes in Jamestown United States.
We fabricated, phrased, and hatched our online website, FRBO.com to be charming, excellent, and graceful.
|
|
