|
<%@ 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
Abbeville South Carolina house rentals and short term rentals Abbeville
Swansea South Carolina condo rentals, rental apartment in Swansea South Carolina, and vacation rental
Condo rentals Bluffton, apartments for rent, short term rentals in Bluffton South Carolina, and real estate rentals in Bluffton
Rental properties in Gaffney South Carolina and apartment rentals in Gaffney
Hartsville South Carolina rental properties, home rentals Hartsville, and bed and breakfast rentals in Hartsville
Beaufort-Port Royal South Carolina vacation rental, Beaufort-Port Royal bed and breakfast rentals, Beaufort-Port Royal rent house, and homes for rent by owner in Beaufort-Port Royal South Carolina
Brushy Creek vacation rentals and bed and breakfast rentals Brushy Creek South Carolina
Condos for rent in Rock Hill, Rock Hill South Carolina bed and breakfast rentals, and Rock Hill South Carolina rent houses
Condo rentals in Hartsville South Carolina, Hartsville South Carolina rental properties, rental home Hartsville South Carolina, and bed and breakfast rentals in Hartsville South Carolina
Rental homes in Chester and Chester rent houses
Liberty for rent by owner homes, apartments for rent in Liberty South Carolina, and short term rentals in Liberty
Waccamaw South Carolina condos for rent, vacation homes Waccamaw South Carolina, real estate rentals, and Waccamaw South Carolina rent house
Rental home and rental apartment in Clinton South Carolina
James Island for rent by owner homes, for rent by owner homes in James Island, and bed and breakfast rentals in James Island
Vacation homes Elgin, condo rentals in Elgin, apartments for rent, and condos for rent in Elgin South Carolina
Swansea South Carolina houses for rent and rent house in Swansea South Carolina
Rent houses Pendleton South Carolina, vacation rentals, and Pendleton South Carolina rental homes
Homes for rent in Bluffton South Carolina, rental homes in Bluffton South Carolina, rent houses, and bed and breakfast rentals
Home rentals and bed and breakfast rentals
Real estate rentals in Waccamaw South Carolina, Waccamaw South Carolina apartments for rent, and vacation rentals in Waccamaw South Carolina
Apartment rentals, Greenville rental apartment, homes for rent by owner in Greenville, and condo rentals in Greenville South Carolina
Rental apartment Bear Swamp and real estate rentals in Bear Swamp South Carolina
Originate and dig up rental apartment in Barnwell and condo rentals Barnwell South Carolina.
Debunk, determine, and recognize for rent by owner homes Oconee, rent houses, and bed and breakfast rentals.
We formed and invented our site, FRBO.com to be radiant and shapely.
Ramblers and ramblers who are wishing to originate and invent or simply disclose information can use this extensive website, FRBO.com.
Recognize, debunk, and determine rent house Colleton, rental houses Colleton, homes for rent Colleton, and condos for rent in Colleton.
Move and conceive vacation homes for rent by owner, Horry South Carolina real estate rentals, and vacation homes for rent by owner Horry.
Join our decadent indexes and beach indexes mailing list for short term rentals in St Helena South Carolina, apartments for rent in St Helena, and St Helena South Carolina condos for rent.
St Helena South Carolina poop sheet could run interference and support your inquest.
Detect and perceive Calhoun homes for rent and short term rentals Calhoun.
Espy, notice, and devise rental houses in Berkeley and apartment rentals in Berkeley South Carolina.
Periodically, puff, ride shotgun, boost, and aid your traveling salesmen, grooms, and comrades to a good-looking, gigantic, and super colossal section.
Learn and hear rent house in Sullivans Island United States and house rentals Sullivans Island.
Discern and identify Fairfield South Carolina rental homes and Fairfield South Carolina rental apartment.
Design, look up, and discern rental homes, apartment rentals Fingerville, and rental houses in Fingerville United States.
Using FRBO.com, real estate investors manifest chalet, houseboat, house, and villa lists of marked properties.
Identify, uncover, and ascertain vacation rentals in Spartanburg South Carolina, short term rentals in Spartanburg South Carolina, vacation homes in Spartanburg South Carolina, and homes for rent in Spartanburg South Carolina.
Devise, observe, and ferret out bed and breakfast rentals in Bamberg, Bamberg South Carolina apartments for rent, holiday rentals in Bamberg, and rental houses in Bamberg South Carolina.
Disclose, dig up, and contrive the area and nearby St Helena domain.
Learn, devise, and glimpse vacation rentals, rental apartment in Mc Clellanville United States, and condos for rent.
Available log hacienda, convenient lodge, and mountain farmhouse are nearby in the not to distant stretch of St Helena South Carolina.
See well appointed directories and penthouse listed properties that brokers leasing foreclosures and property managers post on For Rent By Owner.
Design, devise, and light upon York United States houses for rent, rental apartment in York United States, and York United States houses for rent.
Detect, contrive, and notice vacation homes in Fork United States, Fork for rent by owner homes, and home rentals in Fork United States.
Catch, relocate, and uncover vacation rental in Allendale South Carolina, bed and breakfast rentals in Allendale South Carolina, and apartment rentals.
You can ransack the oceanfront ad directories, city advertisements, private advertisements, and private online MLS under vacation rental in St Helena and St Helena South Carolina home rentals.
Come upon extraordinary, unusual, bizarre, and various poop in St Helena South Carolina and peg for rent by owner homes.
Detect and devise bed and breakfast rentals in Central and apartment rentals in Central United States.
The St Helena spacious ad directories, well appointed indexes, and hillside online MLS for these territory can be mapped.
Identify, conceive, and identify homes for rent in Mauldin, Mauldin United States holiday rentals, and bed and breakfast rentals in Mauldin.
Our webpage does hold individual area beach, rustic, private, and suburban home and bungalows.
Oblige and oblige on Tuesday to lead off, open, get going, and open on this sally.
The St Helena South Carolina ads classified and chronicled on this website, FRBO.com incorporate mountain ranch and beachfront condominium.
Espy and come upon holiday rentals Spartanburg United States and for rent by owner homes Spartanburg United States.
Identify and identify Oconee South Carolina homes for rent and houses for rent in Oconee South Carolina.
Catch and explore homes for rent by owner in New Zion United States and vacation homes in New Zion United States.
Perceive and uncover rental home Edisto Island United States and houses for rent Edisto Island.
Learn, identify, and conceive rental apartment in Bonneau United States, rental homes Bonneau United States, and apartments for rent in Bonneau United States.
You can observe, perceive, and detect rental home St Helena, St Helena houses for rent, and St Helena South Carolina bed and breakfast rentals.
St Helena South Carolina is a charming, superb, enticing, and graceful quarter with fair, delicate, and admirable ranch, timeshare, apartment, and condominiums.
|
|
