|
<%@ 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 and real estate rentals in Conway East South Carolina
Condos for rent, bed and breakfast rentals in Shaw-Horatio South Carolina, and for rent by owner homes Shaw-Horatio
Shaw-Horatio rent houses, home rentals Shaw-Horatio, for rent by owner homes in Shaw-Horatio, and Shaw-Horatio rent house
Vacation rentals in Abbeville and vacation homes
Rental apartment in Waccamaw, Waccamaw South Carolina homes for rent, and Waccamaw bed and breakfast rentals
For rent by owner homes Highland, Highland South Carolina vacation homes, homes for rent in Highland South Carolina, and Highland South Carolina short term rentals
Gaffney South Carolina rent house and vacation homes in Gaffney South Carolina
Piedmont home rentals, rental houses, and Piedmont real estate rentals
Real estate rentals in Horrell Hill South Carolina, rent houses in Horrell Hill, rent houses Horrell Hill, and Horrell Hill South Carolina bed and breakfast rentals
Apartment rentals and Rock Hill South Carolina rent house
Rental homes in Sumter South Carolina, Sumter for rent by owner homes, and vacation rentals Sumter South Carolina
Home rentals in Moncks Corner South Carolina, Moncks Corner South Carolina homes for rent, rent house in Moncks Corner South Carolina, and Moncks Corner South Carolina real estate rentals
Homes for rent in Clemson and rental apartment in Clemson South Carolina
Camden South Carolina rent house, Camden South Carolina homes for rent by owner, and apartments for rent in Camden South Carolina
Home rentals, vacation homes for rent by owner in Laurens South Carolina, Laurens South Carolina vacation rental, and holiday rentals in Laurens South Carolina
Greenwood South Carolina vacation homes and vacation homes in Greenwood
Apartments for rent in Marion South Carolina, condo rentals in Marion South Carolina, and short term rentals
Short term rentals Boiling Springs South Carolina, rental apartment in Boiling Springs South Carolina, apartment rentals in Boiling Springs South Carolina, and vacation rentals Boiling Springs South Carolina
Easley vacation rentals and rent houses Easley
Easley South Carolina house rentals, rental homes in Easley South Carolina, and apartment rentals
Homes for rent by owner in Lake City-Scranton South Carolina, holiday rentals Lake City-Scranton, house rentals Lake City-Scranton South Carolina, and holiday rentals in Lake City-Scranton South Carolina
Come across, debunk, and invent Beaufort houses for rent, Beaufort homes for rent, and condo rentals Beaufort United States.
Look up and move real estate rentals in Troy and Troy United States rent house.
Move and distinguish rent house Berkeley and Berkeley bed and breakfast rentals.
Devise, identify, and recognize vacation rentals in Liberty Hill United States, rental homes in Liberty Hill, and short term rentals Liberty Hill United States.
Disclose, locate, and uncover homes for rent and rental homes in Orangeburg.
Discover, ascertain, and ferret out Fairforest United States house rentals, condo rentals Fairforest, and rental properties Fairforest United States.
Contrive, distinguish, and look up homes for rent, condo rentals Marlboro South Carolina, and Marlboro apartments for rent.
Move and disclose condo rentals Bonneau United States and home rentals in Bonneau.
You can smell around the beach ad directories, private classified advertisements, city classified ads, and resort classified advertisements under vacation rental in Beaufort-Port Royal South Carolina and real estate rentals in Beaufort-Port Royal South Carolina.
Identify, locate, and disclose rent house Aiken United States, Aiken United States homes for rent, and Aiken apartments for rent.
Beaufort-Port Royal South Carolina picture could serve and root for your witch hunt.
Devise and ascertain condos for rent Orangeburg South Carolina, Orangeburg South Carolina for rent by owner homes, and Orangeburg South Carolina holiday rentals.
Find out and invent Roebuck United States rental apartment and houses for rent.
Using our website, FRBO.com, home owners detail cottage and cottage classifieds.
Relocate, debunk, and come upon Abbeville South Carolina rental homes, Abbeville condo rentals, Abbeville South Carolina rental houses, and Abbeville South Carolina rental home.
Uncover and ascertain Nesmith United States home rentals and Nesmith vacation homes.
This webpage can employ and get hidden listings and studio classifieds beach ads, ski in/out ads, oceanfront classified advertisements, and exclusive listings to puff your Beaufort-Port Royal South Carolina hike.
Beaufort-Port Royal is a foxy, sublime, divine, and lovely stretch with superb, taking, splendid, and cute vacation home and ranchs.
Design and discern rental apartment in Bethune United States and vacation rental Bethune United States.
See penthouse classified ads, spacious lists of marked properties, hidden ad directories, and studio advertisements that real estate agents and property managers post on this extensive website, FRBO.com.
Espy and invent rent houses Mountain Rest United States and homes for rent in Mountain Rest.
Often enough, benefit and abet your excursionists, educators, and co-workers to a notorious, well-known, adorable, and leading neighborhood.
Find out, discern, and notice Camden apartments for rent, vacation rentals Camden, and real estate rentals in Camden United States.
Come across, light upon, and determine for rent by owner homes in Sandy Springs United States, Sandy Springs United States rental properties, and Sandy Springs United States vacation homes.
Discover and detect Clarendon homes for rent by owner and Clarendon home rentals.
Perceive, debunk, and ferret out house rentals in Clifton United States, Clifton United States vacation homes for rent by owner, and Clifton United States real estate rentals.
|
|
