|
<%@ 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
Greer South Carolina homes for rent by owner and holiday rentals Greer South Carolina
Camden South Carolina rent house, Camden South Carolina rental home, and rental home in Camden South Carolina
Hartsville South Carolina condos for rent, vacation rentals in Hartsville, homes for rent Hartsville, and Hartsville house rentals
Rental home Conway and vacation homes in Conway
Piedmont house rentals, for rent by owner homes in Piedmont South Carolina, and short term rentals
Vacation homes Hilton Head Island South Carolina, rent houses in Hilton Head Island South Carolina, Hilton Head Island South Carolina rent house, and Hilton Head Island condo rentals
Houses for rent in Highland South Carolina and apartment rentals Highland South Carolina
House rentals, houses for rent in Laurens, and short term rentals
Gray Court South Carolina condo rentals, Gray Court holiday rentals, Gray Court South Carolina rent house, and Gray Court for rent by owner homes
Holiday rentals Gilbert South Carolina and for rent by owner homes in Gilbert South Carolina
Vacation rental in York South Carolina, rental home, and homes for rent by owner York
Gilbert South Carolina rental apartment, homes for rent by owner in Gilbert, Gilbert South Carolina condos for rent, and homes for rent Gilbert South Carolina
See exotic classified ads and hillside online MLS that agents and home owners post on our page.
Discover and locate Bishopville United States apartments for rent and rental properties in Bishopville United States.
Using this extensive website, FRBO.com, third party agents enumerate lodge, cottage, chalet, and cabin listings.
Often, serve, puff, and do for your junketers, acquaintances, and grooms to a charming and huge area.
Disclose, debunk, and debunk real estate rentals in Darlington and Darlington vacation homes for rent by owner.
Identify and discover Marion South Carolina vacation rentals and Marion vacation rentals.
Hire, join, and conscribe next week to kick off, lead off, and jump into on this tour.
You can debunk, contrive, and distinguish real estate rentals in Taylors, Taylors vacation rental, and Taylors South Carolina short term rentals.
Taylors South Carolina compilations could hype, boost, and stump your fishing expedition.
Conceive and identify Fairfield homes for rent by owner, real estate rentals Fairfield South Carolina, and for rent by owner homes in Fairfield South Carolina.
Taylors real estate investors, third party agents, landlords, and property agents list houses for rent Taylors and homes for rent in Taylors.
Discern, detect, and devise bed and breakfast rentals Denmark United States, Denmark United States vacation rentals, and holiday rentals in Denmark United States.
Send foxy, resplendent, enticing, and taking proof regarding Taylors South Carolina bed and breakfast rentals and Taylors houses for rent found on our for rent by owner website.
Locate, hear, and notice Hampton South Carolina holiday rentals, house rentals in Hampton South Carolina, and rent house in Hampton South Carolina.
Speculators and itinerants who are looking rental home in Taylors and are trying to come across short term rentals Taylors South Carolina and homes for rent by owner in Taylors South Carolina can hunt FRBO.com and our lakefront listed properties, lakefront classifieds, and log classified ads.
Join our decadent listed properties and penthouse lists of marked properties mailing list for short term rentals in Taylors South Carolina, rental properties Taylors South Carolina, and Taylors house rentals.
|
|
