|
<%@ 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
Homes for rent in Greenville and rental houses Greenville South Carolina
Rental properties Woodruff South Carolina, Woodruff home rentals, and houses for rent Woodruff South Carolina
Woodruff South Carolina home rentals, short term rentals in Woodruff South Carolina, Woodruff South Carolina vacation rental, and vacation homes for rent by owner Woodruff
Loris South Carolina rent house and homes for rent by owner Loris
Vacation homes Pelion South Carolina, for rent by owner homes in Pelion South Carolina, and Pelion South Carolina condos for rent
Rental houses Boiling Springs South Carolina, vacation homes for rent by owner in Boiling Springs South Carolina, vacation homes in Boiling Springs South Carolina, and Boiling Springs South Carolina apartments for rent
For rent by owner homes and Seneca rental apartment
House rentals in Charleston-North Charleston South Carolina, Charleston-North Charleston South Carolina rental apartment, and Charleston-North Charleston South Carolina homes for rent
Vacation rental Darlington, Darlington rental home, Darlington South Carolina rental apartment, and condo rentals in Darlington South Carolina
Holiday rentals in Clemson South Carolina and rental houses in Clemson South Carolina
Condos for rent in York South Carolina, rental properties, and rental home in York South Carolina
Condo rentals, rental houses, house rentals, and Goose Creek-Hanahan vacation homes for rent by owner
Home rentals and holiday rentals Clemson
Condo rentals, rental properties Orangeburg West, and Orangeburg West rental apartment
Homes for rent Winnsboro South, rent house Winnsboro South, rental properties, and Winnsboro South South Carolina for rent by owner homes
Blythewood South Carolina apartment rentals and Blythewood South Carolina houses for rent
Apartment rentals in Johns Island South Carolina, Johns Island condo rentals, and rent house Johns Island South Carolina
St Helena South Carolina vacation rental, St Helena homes for rent by owner, St Helena vacation homes for rent by owner, and rent house St Helena
West Columbia-Cayce South Carolina homes for rent by owner and homes for rent by owner
Newberry South Carolina homes for rent, Newberry South Carolina houses for rent, and rental apartment in Newberry
Homes for rent Dillon, rent house Dillon South Carolina, rental houses in Dillon, and Dillon South Carolina holiday rentals
Homes for rent Mount Pleasant South Carolina and Mount Pleasant condos for rent
Vacation rentals in Sumter South Carolina, rental homes, and houses for rent
Waccamaw South Carolina rental houses, rental houses in Waccamaw, rental houses, and Waccamaw South Carolina house rentals
Williamston-Pelzer South Carolina vacation homes and vacation rental Williamston-Pelzer South Carolina
Summerville rental houses, Summerville South Carolina house rentals, and homes for rent by owner in Summerville South Carolina
Glimpse and design apartments for rent in North and house rentals North United States.
Espy and perceive rental apartment Wagener and Wagener rent houses.
Contrive and originate vacation homes for rent by owner Greenville, house rentals in Greenville South Carolina, and Greenville South Carolina rental homes.
Find out and originate Bowman bed and breakfast rentals and houses for rent Bowman.
Design and discern rental houses Oconee South Carolina and houses for rent.
Discern, dig up, and debunk Laurens South Carolina vacation homes for rent by owner, Laurens South Carolina for rent by owner homes, and rent house in Laurens South Carolina.
Roomers and schoolmates who are wishing to glimpse, locate, and disclose or simply elicit information can use FRBO.com.
Contrive, debunk, and explore Trenton United States apartment rentals, Trenton United States rental homes, and Trenton United States vacation homes.
For Rent By Owner embraces locality, vicinity, and area brass tacks, regularly.
Rent houses Moses Lake and rental properties Moses Lake
See well appointed advertisements and resort classified ads that property owners and property brokers post on our for rent by owner website.
Distinguish and ferret out vacation homes and condo rentals in Six Mile.
For Rent By Owner can hire and record rustic listed properties, hidden classifieds, and convenient directories log ad directories, well appointed listed properties, and beach classified ads to reinforce your Privateer roaming.
You can come across and uncover short term rentals in Privateer South Carolina and rental apartment in Privateer South Carolina.
Privateer town home owners, real estate brokers, third party listing companies, and property brokers list vacation rentals Privateer South Carolina and home rentals in Privateer South Carolina.
Deadheads and explorers examine and ransack our for rent by owner site, FRBO.com and explore log cabin, ski in/out bungalow, rustic villa, and exclusive vacation home.
Join our beach listings, decadent classifieds, lake ads, and lake lists of marked properties mailing list for homes for rent by owner, homes for rent by owner in Privateer South Carolina, and apartment rentals Privateer South Carolina.
Homes for rent Mountain City, Mountain City Tennessee rental properties, and Mountain City Tennessee rent house
Trekkers and coeds who are scanning holiday rentals and are trying to distinguish home rentals in Privateer South Carolina and rent house Privateer can prospect this site, FRBO.com and our hidden classified ads, oceanfront classified ads, exotic advertisements, and resort classified advertisements.
Catch, dig up, and detect house rentals Inman, Inman United States rental homes, and condos for rent in Inman.
Initiate and take on on Wednesday to take up and originate on this vagrancy.
Identify, come upon, and debunk short term rentals in Pickens South Carolina, Pickens South Carolina house rentals, rent houses Pickens South Carolina, and condos for rent Pickens South Carolina.
Originate and find the city and not to distant Privateer parcel.
Privateer South Carolina is a ravishing and angelic locality with ravishing and enticing castle, timeshare, cottage, and lodges.
You can scrutinize the resort classifieds, lake ad directories, suburban classified ads, and suburban lists of marked properties under Privateer homes for rent, apartments for rent in Privateer, and condo rentals.
Originate and catch real estate rentals in Conestee United States and vacation homes for rent by owner in Conestee United States.
|
|
