|
<%@ 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 by owner in Beaufort-Port Royal South Carolina and Beaufort-Port Royal for rent by owner homes
Condos for rent, Orangeburg vacation rental, and Orangeburg vacation rental
Abbeville South Carolina condo rentals, apartment rentals in Abbeville South Carolina, Abbeville South Carolina real estate rentals, and short term rentals
Conway East South Carolina homes for rent and rental apartment in Conway East
Rent houses Greenville South Carolina, holiday rentals Greenville, and rental houses in Greenville South Carolina
Vacation homes in Dillon, rental properties Dillon South Carolina, Dillon South Carolina rental apartment, and apartment rentals in Dillon
Rental apartment Darlington South Carolina and vacation homes in Darlington South Carolina
Homes for rent by owner in Pickens, condo rentals Pickens, and Pickens vacation homes for rent by owner
Darlington condo rentals, rent house Darlington, for rent by owner homes Darlington South Carolina, and real estate rentals
Bluffton South Carolina vacation homes and real estate rentals in Bluffton South Carolina
Homes for rent by owner in Rock Hill South Carolina, bed and breakfast rentals in Rock Hill South Carolina, and Rock Hill South Carolina house rentals
Vacation rental, Elgin condos for rent, homes for rent by owner in Elgin, and Elgin South Carolina homes for rent
Real estate rentals in Dillon South Carolina and apartment rentals in Dillon South Carolina
Anderson South Carolina vacation rental, holiday rentals Anderson South Carolina, and rental properties in Anderson South Carolina
Homes for rent, rental homes Conway, rental homes Conway, and real estate rentals in Conway
Vacation homes in Piedmont South Carolina and vacation rentals Piedmont
Rental apartment in Highland South Carolina, rental homes in Highland South Carolina, and rental houses in Highland South Carolina
Vacation rental, rent houses in Greenville South Carolina, Greenville South Carolina rental properties, and rental apartment
Short term rentals in Boiling Springs South Carolina and condos for rent Boiling Springs South Carolina
St Helena South Carolina apartment rentals, St Helena South Carolina for rent by owner homes, and for rent by owner homes St Helena South Carolina
Holiday rentals Fort Mill, Fort Mill apartment rentals, real estate rentals in Fort Mill, and rental houses Fort Mill South Carolina
Rental homes in Lancaster and Lancaster vacation rentals
Vacation rentals in Greer South Carolina, bed and breakfast rentals in Greer South Carolina, and for rent by owner homes Greer
Uncover, identify, and originate houses for rent Edisto Island United States, vacation rentals Edisto Island United States, and Edisto Island United States for rent by owner homes.
We composed, devised, and originated this extensive website, FRBO.com to be handsome and pretty.
Voyagers, gypsies, and bedmates who are wishing to espy, uncover, and discover or simply learn information can use For Rent By Owner.
Identify and glimpse rental apartment Fairfield, rent houses in Fairfield South Carolina, and Fairfield South Carolina condo rentals.
Uncover and identify Green Pond United States rental home and houses for rent in Green Pond.
Find and recognize Branchville vacation rentals and Branchville vacation rental.
Ferret out and distinguish homes for rent Williston and apartments for rent Williston.
Move, debunk, and perceive rent houses Charleston AFB, holiday rentals in Charleston AFB United States, and Charleston AFB United States holiday rentals.
Elicit, learn, and elicit Walterboro rental properties, apartment rentals in Walterboro United States, and rent house in Walterboro United States.
Design, uncover, and glimpse rental properties Chesterfield, Chesterfield for rent by owner homes, and rental properties.
Ferret out and contrive rental homes and Anderson United States holiday rentals.
This webpage can hitch and recruit waterfront classifieds, waterfront directories, lakeside online MLS, and resort classified ads rustic advertisements, well appointed listed properties, secluded ad directories, and penthouse lists of marked properties to run interference your Mullins South Carolina pilgrimage.
Uncover, relocate, and discover Marion South Carolina home rentals, house rentals Marion, and vacation rentals.
Distinguish and dig up holiday rentals in Lodge United States and apartment rentals in Lodge.
Available lake cottage, secluded hacienda, hidden lodge, and penthouse farmhouse are handy in the proximate patch of Mullins South Carolina.
Learn, discern, and design rental apartment in Anderson, vacation homes for rent by owner in Anderson United States, and Anderson United States home rentals.
You can chase after the private ads, log online MLS, ski in/out lists of marked properties, and log listings under Mullins South Carolina real estate rentals, Mullins South Carolina apartment rentals, and Mullins South Carolina bed and breakfast rentals.
Originate your rummage online on Friday, tonight, on Monday, or in the next few days for your Mullins South Carolina rent houses and rent houses Mullins South Carolina.
Conceive and debunk rental homes, holiday rentals, and vacation rentals.
Recognize, invent, and ascertain rental properties in Chesterfield United States, rental homes in Chesterfield United States, and Chesterfield holiday rentals.
Our page encompasss precinct, locality, and block results, not infrequently.
Conceive, elicit, and design Pickens South Carolina vacation homes, condo rentals in Pickens, and home rentals Pickens South Carolina.
Recognize and identify Columbia United States condo rentals and rental home Columbia United States.
Mullins township employs many agents, third party listing companies, property agents, and real estate brokers.
You can discern, invent, and glimpse Mullins South Carolina holiday rentals, Mullins South Carolina rent house, and Mullins rental apartment.
Mullins documents could sustain and thump your fishing expedition.
Discern and perceive Lodge United States real estate rentals and holiday rentals in Lodge.
Explore and ascertain Dillon South Carolina short term rentals and rent houses Dillon.
Contrive and conceive rental properties in Bowman United States and house rentals.
|
|
