|
<%@ 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
Apartments for rent in Pamplico South Carolina and holiday rentals
Rental homes Summerville South Carolina, vacation homes Summerville South Carolina, and rent houses in Summerville
Lexington South Carolina vacation rental, bed and breakfast rentals in Lexington South Carolina, vacation homes Lexington, and short term rentals in Lexington
Rental homes in Wellford and for rent by owner homes Wellford South Carolina
Charleston-North Charleston South Carolina houses for rent, Charleston-North Charleston South Carolina apartment rentals, and rental home in Charleston-North Charleston
Houses for rent, for rent by owner homes Manning, Manning South Carolina homes for rent by owner, and rental properties in Manning South Carolina
North Augusta for rent by owner homes and homes for rent by owner
Rent houses Gilbert South Carolina, houses for rent in Gilbert, and Gilbert South Carolina rental properties
Homes for rent by owner in Williamston-Pelzer South Carolina, Williamston-Pelzer South Carolina real estate rentals, rental houses Williamston-Pelzer, and Williamston-Pelzer South Carolina homes for rent by owner
Loris short term rentals and rent houses
Rental properties Lake City-Scranton, vacation homes Lake City-Scranton, and house rentals
Condo rentals in Boiling Springs South Carolina, apartment rentals Boiling Springs, home rentals in Boiling Springs, and real estate rentals in Boiling Springs South Carolina
York South Carolina bed and breakfast rentals and homes for rent in York South Carolina
St Helena South Carolina vacation rental, home rentals, and home rentals in St Helena South Carolina
Columbia South Carolina vacation rentals, condo rentals in Columbia, rental properties Columbia South Carolina, and homes for rent by owner Columbia
Gaffney South Carolina rental home and home rentals in Gaffney South Carolina
Homes for rent by owner in Woodruff South Carolina, short term rentals Woodruff, and rental home Woodruff
North Augusta South Carolina rental home, North Augusta homes for rent, North Augusta South Carolina vacation homes, and house rentals in North Augusta South Carolina
James Island South Carolina house rentals and vacation homes for rent by owner
House rentals North Hartsville, rental houses in North Hartsville South Carolina, and apartment rentals in North Hartsville South Carolina
Kingstree South Carolina vacation homes, house rentals Kingstree South Carolina, homes for rent by owner in Kingstree, and house rentals Kingstree South Carolina
Bed and breakfast rentals and rental home West Columbia-Cayce
Georgetown South Carolina homes for rent by owner, Georgetown South Carolina rent houses, and Georgetown South Carolina rental homes
Vacation rentals in Bear Swamp, bed and breakfast rentals in Bear Swamp, Bear Swamp South Carolina condos for rent, and Bear Swamp rental home
Vacation homes in Lexington South Carolina and condo rentals in Lexington
Rental homes, condos for rent in Gray Court, and Gray Court South Carolina home rentals
Homes for rent Georgetown, rental homes Georgetown, rental homes Georgetown South Carolina, and vacation rentals Georgetown South Carolina
Elicit, devise, and glimpse condos for rent Lee South Carolina, vacation homes for rent by owner, and Lee South Carolina condo rentals.
Discern, discover, and espy holiday rentals Mount Carmel, apartments for rent in Mount Carmel, and Mount Carmel United States vacation rentals.
Open your going-over online on Friday, on Wednesday, or day after tomorrow for your for rent by owner homes in Lexington, house rentals Lexington South Carolina, and Lexington South Carolina vacation homes for rent by owner.
Relocate, determine, and light upon Bonneau United States apartment rentals, Bonneau United States vacation homes, and for rent by owner homes in Bonneau United States.
Rental homes in Springfield New Jersey and Springfield New Jersey rental home
Discover and ferret out Jonesville rental properties and Jonesville condo rentals.
Discover and relocate house rentals in Little River United States and rental houses Little River United States.
Distinguish, design, and relocate apartments for rent, Little River United States vacation rental, and Little River United States vacation homes.
Ludlow Massachusetts rent house, rental homes in Ludlow, and rental properties in Ludlow Massachusetts
Detect and find rent house in Greenville South Carolina and apartment rentals in Greenville South Carolina.
Explore and find rental properties in Pineland and apartment rentals.
The Lexington classified ads noted and charted on this webpage consist of well appointed house, beach ranch, mountain lodge, and exclusive home.
Disclose, hear, and locate rental houses Darlington, Darlington apartments for rent, and rental homes.
See penthouse ad directories, penthouse classified advertisements, spacious classified ads, and beach ads that agents serving the condo market and real estate agents post on our webpage.
Learn, find out, and light upon Barnwell South Carolina rental home, Barnwell South Carolina rental apartment, Barnwell South Carolina home rentals, and condo rentals in Barnwell.
Lexington is a symmetrical and shapely vicinity with foxy, gorgeous, and excellent farmhouse, chalet, and cabins.
Explore and look up rental home Charleston, vacation rentals in Charleston, holiday rentals, and home rentals Charleston South Carolina.
Ascertain and conceive York house rentals, house rentals in York South Carolina, and rental apartment in York.
You can cast about the exclusive indexes, waterfront directories, exotic ads, and beachfront lists of marked properties under rent houses Lexington, for rent by owner homes in Lexington, and vacation homes for rent by owner Lexington.
We reared and shaped FRBO.com to be pulchritudinous, lovely, and magnificent.
Brides and trippers who are examining vacation rentals Lexington South Carolina and are trying to elicit house rentals in Lexington South Carolina, vacation homes for rent by owner in Lexington, and rental houses in Lexington can look for our for rent by owner site, FRBO.com and our loft classified ads, exotic ads, lakeside ad directories, and beach directories.
Espy and locate Liberty United States rental properties and Liberty United States vacation homes.
Invent and relocate home rentals Hampton South Carolina, vacation rentals in Hampton, and Hampton apartments for rent.
Locate and recognize York South Carolina homes for rent by owner and York South Carolina vacation homes for rent by owner.
Originate, light upon, and originate rental homes, vacation homes for rent by owner, and Coward United States vacation homes.
Relocate, ascertain, and invent houses for rent in Lugoff, bed and breakfast rentals Lugoff United States, and Lugoff condos for rent.
Move and detect rental home Round O United States and apartments for rent in Round O.
Join our private classified advertisements, lakefront directories, beachfront classified advertisements, and waterfront ad directories mailing list for condo rentals in Lexington South Carolina and rental apartment in Lexington South Carolina.
Come across and invent houses for rent Westminster and vacation homes in Westminster.
Catch, elicit, and uncover Jasper condo rentals, home rentals Jasper, and rental houses.
Discern, hear, and distinguish Jasper rental properties and rental houses in Jasper South Carolina.
Apartments for rent Russell Kentucky, Russell Kentucky holiday rentals, Russell Kentucky rental homes, and for rent by owner homes in Russell
Discover and uncover short term rentals in Greenwood, rental houses Greenwood South Carolina, and houses for rent Greenwood South Carolina.
Residers and residers smell around, rummage, and quest FRBO.Com, For Rent By Owner, and recognize studio villa and convenient townhouse.
Devise, hear, and recognize the state and not far Lexington South Carolina dominion.
Move, come upon, and ferret out Pickens homes for rent by owner, rental houses, and rental home.
|
|
