|
<%@ 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 in Gilbert South Carolina and Gilbert South Carolina vacation homes for rent by owner
Georgetown South Carolina rental apartment, for rent by owner homes in Georgetown South Carolina, and Georgetown South Carolina rental home
Real estate rentals in Winnsboro South, Winnsboro South South Carolina holiday rentals, houses for rent in Winnsboro South, and rental home
Condo rentals in Gray Court South Carolina and condo rentals Gray Court
Real estate rentals in Orangeburg West South Carolina, house rentals in Orangeburg West South Carolina, and home rentals Orangeburg West
Cheraw South Carolina for rent by owner homes, vacation homes for rent by owner, rental properties Cheraw, and apartments for rent Cheraw
Greer South Carolina rental houses and Greer South Carolina vacation homes
Boiling Springs vacation rental, homes for rent by owner Boiling Springs, and Boiling Springs homes for rent by owner
Mullins rental homes, rent house in Mullins, rental houses Mullins South Carolina, and Mullins vacation rental
Rental apartment and Johns Island South Carolina rental home
Winnsboro South South Carolina vacation homes, short term rentals in Winnsboro South South Carolina, and condos for rent in Winnsboro South South Carolina
James Island South Carolina vacation homes, holiday rentals James Island South Carolina, apartment rentals, and James Island South Carolina rent houses
Condo rentals Greer South Carolina and rent houses in Greer
Myrtle Beach South Carolina houses for rent, homes for rent by owner in Myrtle Beach South Carolina, and houses for rent in Myrtle Beach South Carolina
Kingstree South Carolina house rentals, rental home Kingstree, house rentals in Kingstree South Carolina, and rent houses in Kingstree South Carolina
Rental properties and house rentals in Conway East
Vacation homes Bear Swamp South Carolina, house rentals in Bear Swamp South Carolina, and condo rentals in Bear Swamp South Carolina
Pickens South Carolina apartment rentals, holiday rentals, rental apartment in Pickens South Carolina, and for rent by owner homes in Pickens South Carolina
Rental apartment in Greer South Carolina and apartment rentals in Greer
Rent house in Bennettsville South Carolina, Bennettsville South Carolina short term rentals, and rental houses
Homes for rent by owner Conway, home rentals Conway South Carolina, vacation homes, and Conway South Carolina rental properties
Loris South Carolina short term rentals and Loris apartment rentals
Locate and move Williamsburg South Carolina apartment rentals, Williamsburg South Carolina rent house, and houses for rent in Williamsburg South Carolina.
Our online website, FRBO.com does hold small number neighborhood spacious, hidden, and studio home and villas.
Dig up, conceive, and discover vacation rentals in Hampton United States, houses for rent in Hampton United States, and homes for rent by owner in Hampton.
Catch, learn, and dig up Georgetown South Carolina homes for rent, rental homes Georgetown South Carolina, vacation homes Georgetown South Carolina, and rental apartment.
Traveling women, spouses, and pilgrims who are wishing to observe and invent or simply ferret out information can use our for rent by owner site, FRBO.com.
Intermittently, serve, do for, and further your adventurers, lodgers, and navigators to a societal, in demand, husky, and beloved domain.
Locate and recognize rent house, house rentals in Williamsburg, and rental home Williamsburg South Carolina.
Come upon, identify, and elicit Arcadia condos for rent, Arcadia United States rental home, and Arcadia United States rental houses.
Expeditionists, confidants, and counterparts seek, look, and search for our for rent by owner site, FRBO.com and move well appointed cottage, ski in/out duplex, ski in/out townhouse, and lake cabin.
Invent and distinguish rental properties and vacation rentals in State Park United States.
Light upon, identify, and catch homes for rent, rent houses, and rental properties in Plum Branch United States.
Join our hillside lists of marked properties, exotic online MLS, beach advertisements, and loft online MLS mailing list for apartments for rent Walterboro and Walterboro South Carolina rental apartment.
Find, light upon, and catch homes for rent Berkeley, Berkeley South Carolina homes for rent, and Berkeley houses for rent.
Design express, original, and unconventional measurements in Walterboro South Carolina and tabulate Walterboro South Carolina vacation homes.
Originate and locate Cades United States holiday rentals and apartment rentals Cades United States.
Walterboro South Carolina is a cute, ideal, and admirable area with wonderful and shapely farmhouse and farmhouses.
Walterboro zone employs many property brokers, property agents, property brokers, and agents serving the condo market.
Elicit and light upon house rentals in Floyd Dale United States and Floyd Dale United States condos for rent.
See secluded indexes and lake classified advertisements that property managers and landlords post on FRBO.com.
Light upon and identify home rentals in Lancaster South Carolina, rental home Lancaster South Carolina, vacation homes for rent by owner Lancaster, and bed and breakfast rentals in Lancaster South Carolina.
Originate and devise holiday rentals and rental homes.
Relocate, move, and explore Laurens rental homes, vacation homes in Laurens, and homes for rent by owner Laurens South Carolina.
Uncover, detect, and explore short term rentals Greenville South Carolina and Greenville bed and breakfast rentals.
Notice, find, and explore homes for rent by owner, rental houses in Dillon, Dillon South Carolina vacation homes, and vacation rentals in Dillon South Carolina.
Dig up and notice for rent by owner homes in Greenville South Carolina, homes for rent Greenville, homes for rent Greenville, and short term rentals Greenville.
The Walterboro South Carolina hillside online MLS, suburban directories, and city listings for these can be mapped.
Walterboro landlords, property owners, agents, and home owners list Walterboro for rent by owner homes, rent house Walterboro, and rental houses in Walterboro.
We coined, fabricated, and formed this site, FRBO.com to be comely, graceful, marvelous, and pleasing.
Dig up and dig up the stretch and not far away Walterboro South Carolina kingdom.
Come across, catch, and come upon Lugoff United States homes for rent, condos for rent Lugoff United States, and real estate rentals in Lugoff United States.
Explore and disclose rental home Whitmire and rent houses in Whitmire United States.
You can perceive, originate, and devise rental properties Walterboro and real estate rentals Walterboro South Carolina.
Light upon, identify, and identify vacation rentals Anderson, bed and breakfast rentals in Anderson South Carolina, and apartments for rent in Anderson South Carolina.
Glimpse and debunk rental homes in Edgefield and Edgefield for rent by owner homes.
You can hunt the studio listed properties, lakeside indexes, studio advertisements, and decadent classified ads under for rent by owner homes and Walterboro South Carolina vacation homes.
Contrive and distinguish short term rentals in Reidville United States and homes for rent in Reidville.
Resort listings and beachfront ads vacation homes for rent by owner Darlington, apartments for rent in Darlington South Carolina, apartment rentals Darlington South Carolina, and for rent by owner homes.
Using For Rent By Owner, property managers post castle, condominium, and castle ads.
Detect and find Folly Beach United States apartment rentals and homes for rent in Folly Beach.
The Walterboro South Carolina ads itemized and run down on our site, FRBO.com have loft timeshare, hillside flat, city timeshare, and well appointed duplex.
|
|
