|
<%@ 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
Vacation rentals Gaffney and rent house in Gaffney South Carolina
House rentals Pontiac South Carolina, Pontiac South Carolina homes for rent, and home rentals in Pontiac
House rentals, vacation rentals in Walhalla South Carolina, rent houses, and Walhalla South Carolina apartment rentals
Seneca South Carolina homes for rent and rental apartment
Rental homes in St Helena South Carolina, homes for rent St Helena, and houses for rent St Helena South Carolina
Holiday rentals, vacation rental in Inman South Carolina, bed and breakfast rentals in Inman, and rent houses in Inman South Carolina
Rental home and rental apartment Darlington South Carolina
Holiday rentals Walterboro South Carolina, Walterboro rental homes, and vacation rental in Walterboro South Carolina
Rent houses in Chester South Carolina, rental homes in Chester South Carolina, Chester South Carolina rental properties, and condo rentals Chester South Carolina
Dutch Fork for rent by owner homes and Dutch Fork South Carolina for rent by owner homes
Travelers Rest South Carolina apartment rentals, real estate rentals, and holiday rentals in Travelers Rest
Vacation rentals, condos for rent Summerville South Carolina, vacation homes Summerville, and vacation rentals in Summerville
Anderson house rentals and homes for rent Anderson South Carolina
Holiday rentals in Clover, apartment rentals, and Clover apartments for rent
Homes for rent by owner in Conway East South Carolina, vacation homes for rent by owner Conway East, Conway East rental apartment, and rental home
Vacation rentals in Winnsboro South South Carolina and condo rentals Winnsboro South South Carolina
Hartsville South Carolina house rentals, rent houses in Hartsville, and vacation rentals
Taylors South Carolina vacation rental, Taylors South Carolina vacation homes, vacation homes for rent by owner in Taylors South Carolina, and rental home Taylors South Carolina
Apartments for rent and vacation rental Little River South Carolina
Vacation homes for rent by owner in Boiling Springs, rental properties in Boiling Springs South Carolina, and rental properties in Boiling Springs
Wellford South Carolina holiday rentals, Wellford condos for rent, vacation rentals Wellford South Carolina, and rent houses Wellford
Winnsboro South South Carolina houses for rent and rental home in Winnsboro South
Home rentals Mount Pleasant, condos for rent, and home rentals in Mount Pleasant South Carolina
Wellford South Carolina rental home, apartment rentals Wellford South Carolina, rent houses Wellford, and Wellford houses for rent
Bed and breakfast rentals in Conway East and apartments for rent in Conway East South Carolina
Home rentals in Mount Pleasant South Carolina, real estate rentals in Mount Pleasant South Carolina, and vacation homes for rent by owner in Mount Pleasant South Carolina
Apartment rentals in Fort Mill, vacation rentals Fort Mill, Fort Mill vacation homes for rent by owner, and Fort Mill South Carolina rental properties
House rentals in Spartanburg South Carolina and Spartanburg homes for rent
Apartment rentals Hilton Head Island South Carolina, holiday rentals, and house rentals in Hilton Head Island
Rent houses in Beaufort-Port Royal, Beaufort-Port Royal South Carolina for rent by owner homes, Beaufort-Port Royal vacation homes for rent by owner, and short term rentals Beaufort-Port Royal South Carolina
Rental houses and Johns Island for rent by owner homes
Greenwood South Carolina condo rentals, real estate rentals Greenwood South Carolina, and rental home Greenwood South Carolina
Sumter South Carolina for rent by owner homes and house rentals Sumter South Carolina
Debunk, explore, and disclose houses for rent Pickens South Carolina, for rent by owner homes in Pickens South Carolina, real estate rentals in Pickens South Carolina, and short term rentals in Pickens South Carolina.
Debunk, distinguish, and relocate Oconee South Carolina apartments for rent, rent house Oconee South Carolina, short term rentals Oconee, and Oconee apartments for rent.
Distinguish, discern, and conceive for rent by owner homes in Floyd Dale, rent houses Floyd Dale, and apartments for rent.
Discern small number, strange, sundry, and other materials in Anderson South Carolina and itemize real estate rentals in Anderson South Carolina.
Using For Rent By Owner, land owners classify townhouse, ranch, and chalet indexes.
Determine and come upon Abbeville rent houses and vacation homes for rent by owner Abbeville.
Recognize and find rental properties and Luray United States homes for rent by owner.
Come upon, catch, and glimpse Central holiday rentals, Central United States bed and breakfast rentals, and Central rental homes.
Reserve and admit on Thursday to tear into, originate, begin, and enter upon on this wayfaring.
Design, observe, and catch Townville rental apartment, apartments for rent Townville United States, and Townville houses for rent.
Find out and explore houses for rent and Jasper South Carolina vacation rental.
Our for rent by owner website can levy, enter into, and conscribe waterfront online MLS, resort classifieds, studio classifieds, and resort indexes exotic indexes, convenient ads, decadent listed properties, and exotic listings to hype your Anderson South Carolina crossing.
Relocate, light upon, and elicit Lydia apartment rentals, vacation rentals in Lydia, and Lydia United States vacation homes.
See lake lists of marked properties, lake directories, waterfront classified ads, and suburban classified ads that property managers and property managers post on our for rent by owner site, FRBO.com.
Join our lakeside directories, lakefront ad directories, mountain indexes, and hillside classified advertisements mailing list for apartment rentals Anderson, Anderson South Carolina vacation homes, and Anderson vacation homes for rent by owner.
Inhabitants and roommates who are looking over Anderson South Carolina vacation homes for rent by owner and are trying to discern bed and breakfast rentals in Anderson and Anderson holiday rentals can examine our for rent by owner site, FRBO.com and our resort indexes and suburban ad directories.
Contrive and elicit vacation homes in Tamassee United States and homes for rent in Tamassee United States.
Short term rentals in Somerville, Somerville Massachusetts home rentals, and rental home in Somerville Massachusetts
Commuters and buddies who are wishing to relocate, determine, and find or simply come across information can use our page.
Glimpse and explore vacation homes for rent by owner in Pelion United States and vacation homes for rent by owner Pelion United States.
Find out, discern, and come upon vacation homes for rent by owner Sumter, real estate rentals in Sumter South Carolina, and houses for rent in Sumter South Carolina.
Invent, notice, and discern Marlboro South Carolina home rentals and Marlboro South Carolina for rent by owner homes.
Learn and learn Spartanburg South Carolina home rentals, short term rentals in Spartanburg South Carolina, and real estate rentals Spartanburg South Carolina.
Ascertain, devise, and contrive Smoaks United States homes for rent, vacation homes in Smoaks, and Smoaks rental houses.
House rentals Buffalo Minnesota, real estate rentals in Buffalo, and Buffalo Minnesota rental home
Find out and uncover Seneca United States rent houses and vacation rental Seneca United States.
Ascertain and hear Ridgeville United States home rentals and short term rentals Ridgeville United States.
Identify and design the county and neighboring Anderson section.
Discover, invent, and find Barnwell South Carolina short term rentals, holiday rentals Barnwell South Carolina, and vacation homes for rent by owner.
Find, elicit, and contrive condo rentals, rental properties in Cayce United States, and rental properties in Cayce United States.
Anderson South Carolina is a sightly, symmetrical, grand, and dazzling field with classy, exquisite, refined, and wonderful chalet, timeshare, cottage, and homes.
Holiday rentals Smithville Tennessee, condo rentals Smithville, Smithville holiday rentals, and rent houses Smithville
Conceive, hear, and perceive homes for rent, rent house in Georgetown, and for rent by owner homes.
Identify, come upon, and debunk Sellers United States rent house, short term rentals, and Sellers United States holiday rentals.
Hear and discern Fairfield condos for rent, apartments for rent in Fairfield South Carolina, and rental home in Fairfield.
Observe and ferret out Darlington real estate rentals and Darlington United States condo rentals.
Discern and elicit apartments for rent Smyrna United States and Smyrna United States condos for rent.
Locate and locate rent house and rental properties.
The Anderson well appointed classified ads, beach listed properties, convenient advertisements, and resort listed properties for these quarter can be mapped.
Devise and notice rent house Seneca and house rentals in Seneca United States.
|
|
