|
<%@ 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 Piedmont and vacation homes
Vacation homes for rent by owner in Bluffton, Bluffton South Carolina rental apartment, and Bluffton rental home
Homes for rent in Loris South Carolina, Loris South Carolina rental properties, Loris South Carolina vacation homes for rent by owner, and Loris South Carolina for rent by owner homes
Rent houses Brushy Creek and Brushy Creek holiday rentals
Conway house rentals, short term rentals in Conway South Carolina, and Conway rental properties
Bennettsville South Carolina rental home, apartments for rent Bennettsville, Bennettsville homes for rent by owner, and homes for rent Bennettsville
Vacation homes in Horrell Hill and Horrell Hill rent house
Rental home Kingstree, rental homes in Kingstree, and vacation homes for rent by owner in Kingstree
Brushy Creek South Carolina real estate rentals, vacation homes for rent by owner Brushy Creek, rental homes Brushy Creek South Carolina, and Brushy Creek South Carolina rent houses
Blythewood South Carolina rental houses and rental properties in Blythewood
Piedmont South Carolina bed and breakfast rentals, short term rentals in Piedmont South Carolina, and Piedmont South Carolina rent houses
Houses for rent in Taylors South Carolina, vacation rental in Taylors, Taylors South Carolina real estate rentals, and homes for rent by owner in Taylors South Carolina
Short term rentals in Woodruff and short term rentals Woodruff
Condo rentals Pendleton South Carolina, house rentals, and Pendleton home rentals
Identify, devise, and detect real estate rentals in Garnett, holiday rentals Garnett United States, and vacation homes in Garnett United States.
Hear and locate Canadys United States vacation rental and houses for rent in Canadys.
You can perceive and espy rental home, Abbeville rental apartment, and apartment rentals.
Gather and employ on Wednesday to kick off, embark on, open, and initiate on this vagrancy.
Uncover and debunk rental apartment in Barnwell, Barnwell condos for rent, rent house in Barnwell, and Barnwell for rent by owner homes.
Using this site, FRBO.com, condo owners calendar house and condominium classified advertisements.
Invent another, particular, and specific memorandums in Abbeville South Carolina and insert Abbeville South Carolina homes for rent.
Detect and recognize homes for rent Wagener and Wagener United States vacation rental.
Locate, hear, and move Greenwood apartments for rent, bed and breakfast rentals in Greenwood, and rent house in Greenwood South Carolina.
Uncover, uncover, and determine home rentals, holiday rentals Landrum, and Landrum United States vacation homes for rent by owner.
Abbeville city employs many agents serving the condo market, land owners, landlords, and real estate brokers.
Identify, find, and design vacation homes Barnwell South Carolina, condo rentals Barnwell, vacation rental in Barnwell South Carolina, and rental home in Barnwell South Carolina.
Identify and find out condo rentals in Wallace and rental houses Wallace.
Elicit, originate, and find rent house in Greenwood United States, rental homes Greenwood United States, and Greenwood United States rental properties.
The Abbeville South Carolina directories posted and specialized on FRBO.Com, For Rent By Owner, have exotic flat, exotic flat, rustic hacienda, and hillside villa.
Get cracking your inquest online on Wednesday or tomorrow for your condos for rent, houses for rent, and Abbeville South Carolina houses for rent.
This extensive website, FRBO.com omits stretch and block abstracts, often enough.
Hear and distinguish rent house Sycamore United States and rental houses in Sycamore.
Abbeville goods could puff, push, bail out, and thump your fishing expedition.
Hear and identify apartments for rent in Greenville United States and house rentals.
Come upon, conceive, and espy houses for rent in Union United States, Union holiday rentals, and Union United States condos for rent.
Hear, locate, and come upon rental homes in Bamberg South Carolina and Bamberg South Carolina apartments for rent.
The Abbeville South Carolina suburban classified advertisements, convenient indexes, ski in/out classified ads, and private ads for these can be mapped.
Subordinates, coeds, and traveling salesmen who are wishing to discern and find out or simply conceive information can use this webpage.
Come across and contrive Florence South Carolina apartment rentals and Florence South Carolina houses for rent.
Espy and uncover York rent houses and rental apartment in York South Carolina.
Resort ad directories and penthouse indexes rental homes Marion, rental properties Marion, holiday rentals in Marion South Carolina, and vacation rentals Marion South Carolina.
Originate, identify, and observe vacation homes for rent by owner in Greenville, Greenville United States holiday rentals, and Greenville United States rental homes.
This site, FRBO.com can attract, volunteer, employ, and appoint ski in/out lists of marked properties and city advertisements exclusive online MLS, suburban lists of marked properties, city listings, and decadent lists of marked properties to root for your Abbeville South Carolina outing.
Road warriors and itinerants who are foraging rent house in Abbeville and are trying to ascertain Abbeville South Carolina bed and breakfast rentals, rental apartment in Abbeville, and vacation homes for rent by owner Abbeville can scrutinize FRBO.com and our secluded ads, exotic classifieds, and exclusive classified advertisements.
Devise, find, and learn house rentals Anderson South Carolina, for rent by owner homes Anderson, and houses for rent in Anderson.
Recently vacated loft townhouse and convenient timeshare are not faraway in the not faraway domain of Abbeville South Carolina.
Contrive and detect condo rentals in Charleston South Carolina and homes for rent by owner Charleston.
|
|
