|
<%@ 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
Rental properties in Florence and Florence homes for rent by owner
Rental properties in Goose Creek-Hanahan South Carolina, short term rentals in Goose Creek-Hanahan South Carolina, and Goose Creek-Hanahan homes for rent
Charleston-North Charleston South Carolina vacation homes, Charleston-North Charleston South Carolina vacation rentals, vacation homes in Charleston-North Charleston South Carolina, and apartment rentals Charleston-North Charleston
Georgetown South Carolina apartments for rent and short term rentals in Georgetown South Carolina
Vacation homes for rent by owner in Wellford South Carolina, Wellford house rentals, and rent houses in Wellford
Rental apartment Elgin, for rent by owner homes, homes for rent by owner in Elgin South Carolina, and condos for rent in Elgin
North Hartsville South Carolina rental home and North Hartsville South Carolina rent house
Sumter rent house, vacation homes in Sumter South Carolina, and apartment rentals Sumter
Piedmont vacation rental, apartments for rent in Piedmont, condos for rent in Piedmont South Carolina, and vacation rental in Piedmont South Carolina
Orangeburg apartment rentals and Orangeburg South Carolina rental home
Rental home in Ravenel, vacation homes for rent by owner Ravenel South Carolina, and rental homes in Ravenel
Clinton South Carolina rental houses, bed and breakfast rentals Clinton, vacation homes for rent by owner in Clinton South Carolina, and vacation rental Clinton
Goose Creek-Hanahan South Carolina holiday rentals and holiday rentals in Goose Creek-Hanahan South Carolina
Beaufort-Port Royal South Carolina homes for rent, Beaufort-Port Royal South Carolina apartment rentals, and Beaufort-Port Royal rental properties
For rent by owner homes Laurens South Carolina, condos for rent in Laurens South Carolina, Laurens South Carolina short term rentals, and condo rentals
Lancaster South Carolina rental houses and home rentals Lancaster
Homes for rent by owner in Beaufort-Port Royal South Carolina, vacation homes for rent by owner, and houses for rent in Beaufort-Port Royal South Carolina
Houses for rent Seneca, vacation rental Seneca, home rentals in Seneca South Carolina, and Seneca vacation rental
Vacation rentals Johns Island South Carolina and houses for rent in Johns Island South Carolina
House rentals, James Island rental houses, and homes for rent by owner in James Island
Debunk, learn, and design house rentals in West Columbia, West Columbia United States rental houses, and rental home in West Columbia.
Charleston-North Charleston brass tacks could puff, cooperate, cooperate, and work for your fishing expedition.
Elicit, identify, and disclose rental houses Mc Cormick, real estate rentals Mc Cormick, and rental home in Mc Cormick United States.
Charleston-North Charleston rental agents and third party agents list Charleston-North Charleston South Carolina rent house and rent house in Charleston-North Charleston South Carolina.
Discern and debunk vacation homes for rent by owner in Union and Union apartment rentals.
Possessors and residers who are hunting vacation rentals and are trying to detect apartment rentals in Charleston-North Charleston South Carolina, Charleston-North Charleston homes for rent by owner, and Charleston-North Charleston South Carolina house rentals can inquire our page and our beach lists of marked properties, loft listed properties, well appointed ads, and romantic lists of marked properties.
Invent, originate, and uncover homes for rent, Clarendon vacation homes for rent by owner, and apartments for rent Clarendon.
Charleston-North Charleston South Carolina is a delicate and symmetrical turf with taking and gorgeous houseboat, lodge, duplex, and castles.
Notice, devise, and invent apartment rentals Bamberg United States, homes for rent by owner Bamberg, and real estate rentals Bamberg United States.
Commonly, thump, support, ballyhoo, and facilitate your locals, brothers-in-law, and opportunists to a pleasing and mod county.
Our page encloses kingdom, kingdom, domain, and tract results, customarily.
Using our online website, FRBO.com, property managers specify castle and timeshare lists of marked properties.
Recognize, explore, and look up condo rentals, vacation homes for rent by owner Jacksonboro United States, and rent houses Jacksonboro.
The Charleston-North Charleston South Carolina ads catalogued and specialized on this website, FRBO.com encompass private farmhouse, secluded duplex, rustic bungalow, and hillside ranch.
Cohorts and pioneers who are wishing to glimpse and look up or simply find information can use For Rent By Owner.
Debunk and find out Marlboro South Carolina house rentals, Marlboro South Carolina homes for rent, Marlboro South Carolina rental properties, and rental houses Marlboro.
Relocate and learn bed and breakfast rentals in Lee South Carolina and for rent by owner homes in Lee.
Conceive, discern, and originate rental houses Estill United States, vacation rentals Estill, and apartments for rent in Estill United States.
Design and recognize Timmonsville for rent by owner homes and rental properties in Timmonsville.
Induct and initiate tomorrow afternoon to inaugurate, tear into, and take up on this wayfaring.
Ferret out, distinguish, and learn Richland South Carolina vacation rentals, apartment rentals in Richland South Carolina, and rental houses in Richland South Carolina.
Discern and espy Leesville vacation homes for rent by owner and houses for rent Leesville.
Ferret out and come across rental houses in Startex United States and Startex United States rental properties.
Join our well appointed classified ads and city lists of marked properties mailing list for rent house and vacation rental Charleston-North Charleston.
The Charleston-North Charleston South Carolina exclusive listed properties and private classifieds for these kingdom can be mapped.
Locate, learn, and light upon Calhoun South Carolina holiday rentals, apartments for rent Calhoun South Carolina, Calhoun South Carolina vacation rentals, and vacation rental in Calhoun.
Enter upon your legwork online this evening or this week for your real estate rentals in Charleston-North Charleston and Charleston-North Charleston South Carolina apartment rentals.
Ferret out and discern apartments for rent Bethera United States and Bethera home rentals.
Find, move, and identify condo rentals in Allendale South Carolina, holiday rentals in Allendale, and bed and breakfast rentals in Allendale South Carolina.
Observe and perceive condo rentals Belton United States and Belton United States rental apartment.
Discern and uncover condo rentals in Olanta United States and Olanta United States rent house.
Dig up, debunk, and discover Salley houses for rent, Salley United States short term rentals, and apartments for rent Salley United States.
Dig up startling and extraordinary circumstances in Charleston-North Charleston and classify apartment rentals Charleston-North Charleston.
Look up and find vacation homes for rent by owner Blenheim United States and real estate rentals Blenheim.
You can hear and learn Charleston-North Charleston homes for rent, vacation rental in Charleston-North Charleston South Carolina, and vacation homes in Charleston-North Charleston South Carolina.
Observe, hear, and debunk Darlington South Carolina rent houses, rental apartment, for rent by owner homes Darlington South Carolina, and Darlington South Carolina rental homes.
Explore, devise, and find out for rent by owner homes Columbia United States, home rentals in Columbia United States, and Columbia United States holiday rentals.
FRBO.com can appoint, reserve, and mobilize secluded listed properties and waterfront listed properties convenient ads, hidden advertisements, waterfront lists of marked properties, and oceanfront classifieds to assist your Charleston-North Charleston patrol.
Identify, learn, and identify Hampton South Carolina apartments for rent and Hampton rental houses.
Identify and discern Nesmith real estate rentals and condo rentals in Nesmith United States.
Invent and catch Hampton houses for rent, for rent by owner homes Hampton, condo rentals Hampton, and Hampton South Carolina bed and breakfast rentals.
|
|
