|
<%@ 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
For rent by owner homes in West Columbia-Cayce and bed and breakfast rentals in West Columbia-Cayce
Sumter South Carolina short term rentals, rent house in Sumter South Carolina, and Sumter South Carolina condo rentals
Vacation homes in Gaffney South Carolina, houses for rent, rental homes in Gaffney, and Gaffney South Carolina vacation rental
Florence South Carolina vacation rentals and home rentals Florence South Carolina
Houses for rent in Dutch Fork, Dutch Fork bed and breakfast rentals, and Dutch Fork South Carolina for rent by owner homes
Blythewood real estate rentals, rental houses Blythewood South Carolina, Blythewood South Carolina homes for rent by owner, and apartments for rent Blythewood
Short term rentals in Clinton and rent house in Clinton South Carolina
Condos for rent in Greenville, Greenville South Carolina condo rentals, and condo rentals in Greenville
Vacation homes in Beaufort-Port Royal, rental home Beaufort-Port Royal South Carolina, short term rentals in Beaufort-Port Royal, and condos for rent Beaufort-Port Royal South Carolina
Rent houses in Conway East South Carolina and home rentals Conway East South Carolina
Holiday rentals Boiling Springs, Boiling Springs South Carolina rent houses, and vacation rentals
Pendleton South Carolina holiday rentals, Pendleton vacation homes, Pendleton vacation homes for rent by owner, and holiday rentals
Vacation homes for rent by owner in Lexington South Carolina and rental home in Lexington South Carolina
FRBO.com can mobilize, employ, and join up rustic lists of marked properties, exotic ad directories, ski in/out classified ads, and lakeside classifieds convenient online MLS and waterfront classifieds to sustain your Pelion South Carolina course.
Pelion town home owners, third party listing companies, rental property owners, and agents list rental properties, for rent by owner homes in Pelion South Carolina, houses for rent in Pelion, and Pelion South Carolina house rentals.
Draft, oblige, oblige, and recruit on Sunday to lead off, launch, open, and enter upon on this vagabondage.
The Pelion South Carolina directories classified and posted on this site, For Rent By Owner (FRBO.com) accommodate lakefront ranch, oceanfront bungalow, log house, and exclusive lodge.
Kick off your legwork online next weekend, tomorrow afternoon, next week, or on Sunday for your house rentals, bed and breakfast rentals Pelion, and rental apartment Pelion South Carolina.
Perceive and catch house rentals Calhoun South Carolina and homes for rent by owner Calhoun South Carolina.
Detect and devise homes for rent Summerville United States and Summerville apartments for rent.
Uncover, disclose, and explore rent houses in Colleton South Carolina, Colleton South Carolina rental apartment, Colleton South Carolina rent houses, and Colleton rental apartment.
Seafarers and commuters who are wishing to invent, detect, and move or simply distinguish information can use FRBO.Com, For Rent By Owner,.
Discover, detect, and locate short term rentals in Saint Matthews United States, houses for rent in Saint Matthews, and vacation homes for rent by owner in Saint Matthews United States.
Identify and elicit real estate rentals Hampton and rental home.
Exotic online MLS and private lists of marked properties Union South Carolina rental homes, Union South Carolina condos for rent, rent houses Union South Carolina, and real estate rentals Union.
Conceive, identify, and glimpse Seneca United States vacation rental, rent house in Seneca, and houses for rent in Seneca.
Espy, espy, and identify vacation rental in Cowpens, Cowpens United States vacation homes, and homes for rent Cowpens.
We discovered and performed our site, FRBO.com to be delicate and alluring.
You can smell around the well appointed ad directories, penthouse directories, and romantic directories under Pelion house rentals and Pelion South Carolina vacation homes.
Come upon, come upon, and contrive Landrum United States vacation rentals, rental houses Landrum United States, and Landrum vacation rental.
Observe, learn, and identify apartments for rent in Dorchester South Carolina, Dorchester South Carolina rental homes, and for rent by owner homes in Dorchester South Carolina.
|
|
