|
<%@ 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
Short term rentals in Lake City-Scranton and rental home Lake City-Scranton South Carolina
Privateer South Carolina house rentals, rent house in Privateer, and Privateer rental properties
Real estate rentals, rental properties in Mount Pleasant South Carolina, Mount Pleasant South Carolina for rent by owner homes, and rent houses Mount Pleasant
Spartanburg South Carolina vacation homes and condo rentals
Condo rentals Dillon, vacation homes for rent by owner in Dillon, and vacation rentals in Dillon South Carolina
Rental homes in Lake City-Scranton, rental houses Lake City-Scranton South Carolina, rent house, and Lake City-Scranton South Carolina apartments for rent
Orangeburg apartment rentals and holiday rentals Orangeburg
Short term rentals Horrell Hill South Carolina, Horrell Hill rent houses, and homes for rent Horrell Hill South Carolina
Vacation rentals, rent houses in Abbeville South Carolina, real estate rentals Abbeville, and houses for rent
Gray Court houses for rent and homes for rent in Gray Court South Carolina
Chester South Carolina homes for rent, homes for rent by owner in Chester, and bed and breakfast rentals Chester South Carolina
Marion South Carolina condos for rent, rental homes, Marion South Carolina condo rentals, and rental properties in Marion South Carolina
Rent house Newberry and Newberry South Carolina rental apartment
Observe and invent holiday rentals Hardeeville United States and Hardeeville United States home rentals.
The Orangeburg West South Carolina exclusive classified advertisements, beach listings, beach classified ads, and resort online MLS for these precinct can be mapped.
Our website, FRBO.com comprises square, sector, township, and zone goods, at times.
Using our for rent by owner website, real estate brokers specialize hacienda, ranch, apartment, and castle indexes.
Join our hillside indexes and loft listings mailing list for rental home in Orangeburg West South Carolina and Orangeburg West South Carolina condo rentals.
Penthouse classified ads and studio advertisements condos for rent Greenwood South Carolina, rental home Greenwood South Carolina, condos for rent in Greenwood South Carolina, and Greenwood South Carolina condo rentals.
Natives and teachers who are wishing to catch and debunk or simply invent information can use our online website, FRBO.com.
Wanderers, rent payers, and jet-setters who are scouring for rent by owner homes in Orangeburg West South Carolina and are trying to look up vacation rental in Orangeburg West and houses for rent in Orangeburg West South Carolina can grub our webpage and our exclusive online MLS, private lists of marked properties, and suburban lists of marked properties.
Debunk and light upon for rent by owner homes in Anderson United States and Anderson real estate rentals.
Orangeburg West is a symmetrical and grand locality with sightly and lovely ranch, vacation home, and castles.
Vacant secluded apartment, lake townhouse, and beach apartment are contiguous in the imminent patch of Orangeburg West.
Sign on, attract, oblige, and engage tomorrow morning to initiate, initiate, and begin on this sally.
Learn and contrive Chesterfield South Carolina apartments for rent and real estate rentals in Chesterfield.
Discover, learn, and come upon apartment rentals in Pickens, short term rentals in Pickens South Carolina, condo rentals in Pickens South Carolina, and Pickens South Carolina vacation rentals.
Ascertain, move, and light upon homes for rent by owner in Wallace United States, Wallace United States vacation rental, and short term rentals.
Explore and learn Lexington South Carolina homes for rent by owner and apartment rentals Lexington.
Jump into your research online on Monday, this evening, tonight, or day after tomorrow for your condo rentals Orangeburg West South Carolina, homes for rent in Orangeburg West South Carolina, and Orangeburg West houses for rent.
Disclose, light upon, and espy vacation homes in Florence South Carolina, Florence South Carolina homes for rent by owner, and rental houses in Florence.
Ascertain and ferret out vacation homes for rent by owner Chester and rental properties in Chester United States.
Originate and ascertain for rent by owner homes, Abbeville South Carolina rental home, bed and breakfast rentals in Abbeville South Carolina, and bed and breakfast rentals.
Detect, uncover, and observe rent house Marlboro South Carolina and Marlboro South Carolina rental apartment.
Explore and uncover rent houses in Mount Pleasant United States and vacation homes for rent by owner in Mount Pleasant United States.
Hear and contrive homes for rent by owner Laurens South Carolina and vacation homes in Laurens South Carolina.
|
|
