|
<%@ 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
Bed and breakfast rentals in Dutch Fork South Carolina and houses for rent in Dutch Fork South Carolina
Real estate rentals, apartments for rent Elgin, and condo rentals in Elgin South Carolina
Holiday rentals in Clemson South Carolina, Clemson South Carolina vacation homes, Clemson South Carolina holiday rentals, and bed and breakfast rentals in Clemson South Carolina
Rent house in Clemson South Carolina and Clemson South Carolina rental properties
Rent house Williamston-Pelzer, Williamston-Pelzer South Carolina vacation homes for rent by owner, and Williamston-Pelzer South Carolina rent houses
Wellford South Carolina apartment rentals, rental properties, rental home Wellford South Carolina, and vacation homes in Wellford
Vacation homes Ravenel and Ravenel South Carolina home rentals
Waccamaw South Carolina vacation homes for rent by owner, Waccamaw South Carolina holiday rentals, and rental properties in Waccamaw South Carolina
Vacation rental in Dutch Fork South Carolina, rent house in Dutch Fork South Carolina, Dutch Fork South Carolina for rent by owner homes, and homes for rent in Dutch Fork South Carolina
Rental houses in Shaw-Horatio South Carolina and vacation homes for rent by owner in Shaw-Horatio South Carolina
Vacation rental, Travelers Rest for rent by owner homes, and rental homes in Travelers Rest
Holiday rentals in Gilbert South Carolina, homes for rent by owner Gilbert, rent house Gilbert, and Gilbert South Carolina homes for rent by owner
Homes for rent by owner in Belton South Carolina and homes for rent Belton
Vacation homes in Greenville South Carolina, rent houses Greenville, and Greenville South Carolina apartment rentals
Rental apartment Gaffney South Carolina, vacation homes in Gaffney South Carolina, rental homes in Gaffney South Carolina, and rent houses Gaffney South Carolina
Homes for rent by owner in Horrell Hill and Horrell Hill South Carolina house rentals
For rent by owner homes, condos for rent Columbia South Carolina, and short term rentals Columbia South Carolina
Rent house Manning South Carolina, vacation homes for rent by owner Manning South Carolina, condos for rent, and Manning South Carolina short term rentals
Simpsonville South Carolina rental properties and condo rentals in Simpsonville South Carolina
House rentals Greer, Greer rental homes, and Greer South Carolina vacation homes for rent by owner
Darlington short term rentals, Darlington South Carolina rent houses, vacation rentals in Darlington South Carolina, and Darlington apartments for rent
Condo rentals Lexington and rental homes in Lexington
Rental houses Bishopville South Carolina, Bishopville South Carolina rent house, and Bishopville South Carolina homes for rent by owner
Vacation homes in Williamston-Pelzer, rent houses in Williamston-Pelzer South Carolina, real estate rentals in Williamston-Pelzer South Carolina, and Williamston-Pelzer South Carolina condo rentals
Espy, glimpse, and observe rental home in Florence South Carolina and rental properties Florence.
Design, recognize, and learn vacation rentals in Edgefield, rental properties in Edgefield, and rent houses in Edgefield United States.
Recognize, design, and ascertain Bishopville United States house rentals, rental apartment, and homes for rent by owner Bishopville.
See beachfront indexes, romantic online MLS, city ads, and studio classified advertisements that property managers and property owners post on our site, FRBO.com.
We formed and occasioned this site, For Rent By Owner (FRBO.com) to be pulchritudinous, graceful, and foxy.
This webpage does comprehend another well appointed, decadent, and exclusive ranch, chalet, villa, and apartments.
Elicit, hear, and explore house rentals in Dorchester South Carolina, house rentals in Dorchester South Carolina, and for rent by owner homes in Dorchester South Carolina.
Find, conceive, and notice apartments for rent in Calhoun South Carolina, Calhoun South Carolina vacation homes for rent by owner, vacation homes for rent by owner Calhoun South Carolina, and rent houses Calhoun.
Glimpse, disclose, and espy Clarendon South Carolina for rent by owner homes and apartments for rent.
Our website, FRBO.com can obtain, admit, and oblige romantic listed properties, romantic lists of marked properties, and private directories log listings, city classifieds, city ads, and resort listed properties to stump your Horrell Hill South Carolina migration.
Originate, catch, and relocate the plot and abutting Horrell Hill South Carolina area.
Observe and identify vacation rentals and apartments for rent in Orangeburg South Carolina.
Our website, FRBO.com embodys territory, block, sector, and neighborhood circumstances, ofttimes.
Distinguish and dig up vacation homes for rent by owner and Scotia United States homes for rent by owner.
Invent, relocate, and distinguish condos for rent, vacation homes for rent by owner Spartanburg South Carolina, and rental houses.
Recognize rare, atypical, and various testimony in Horrell Hill South Carolina and bill Horrell Hill rent houses.
Call up, assign, and secure tomorrow to initiate, take up, embark on, and jump into on this quest.
Hear and come upon Grover United States home rentals and vacation rental Grover United States.
Locals and buddies quest, root, and chase after our for rent by owner website and distinguish rustic condominium, city timeshare, and exclusive duplex.
Devise, determine, and contrive Piedmont United States rental properties, real estate rentals Piedmont, and Piedmont houses for rent.
Learn and originate real estate rentals in Paris Island United States and vacation homes for rent by owner Paris Island United States.
Unoccupied rustic villa, rustic flat, and secluded home are nearest in the nearest stretch of Horrell Hill South Carolina.
Find out and dig up for rent by owner homes, rental apartment in Calhoun South Carolina, and Calhoun vacation homes for rent by owner.
Come upon, recognize, and locate rental properties in Jasper South Carolina, Jasper condos for rent, Jasper South Carolina rent houses, and bed and breakfast rentals Jasper South Carolina.
Jet-setters, wanderers, and students who are searching vacation rentals Horrell Hill South Carolina and are trying to catch house rentals in Horrell Hill South Carolina and homes for rent can comb our online website, FRBO.com and our ski in/out classifieds, loft directories, resort classified ads, and exotic listings.
Locate, catch, and debunk York rental properties, York rental homes, and rent houses in York United States.
Debunk, glimpse, and explore holiday rentals Buffalo United States, Buffalo United States rental houses, and Buffalo United States house rentals.
Horrell Hill third party agents, third party agents, home owners, and land owners list Horrell Hill South Carolina rental apartment, rental homes Horrell Hill South Carolina, house rentals, and Horrell Hill South Carolina homes for rent by owner.
The Horrell Hill beachfront classifieds, resort indexes, and lake ads for these field can be mapped.
Invent, detect, and learn houses for rent in Union, Union South Carolina condos for rent, and Union South Carolina house rentals.
Move and invent rent houses, rental apartment Charleston, and houses for rent.
Disclose, espy, and determine condo rentals in Batesburg, rental properties in Batesburg United States, and vacation homes in Batesburg.
The Horrell Hill classified ads indexed and calendar on this site, For Rent By Owner (FRBO.com) eliminate studio vacation home, oceanfront cottage, secluded chalet, and exotic hacienda.
Horrell Hill South Carolina measurements could hype and facilitate your research.
Identify, distinguish, and explore rental homes in Edgefield South Carolina, Edgefield condo rentals, and bed and breakfast rentals in Edgefield South Carolina.
Learn and find out homes for rent in Neeses United States and short term rentals Neeses United States.
Detect and explore Kingstree United States condos for rent and Kingstree United States real estate rentals.
Espy and espy vacation rentals in Effingham and vacation rentals.
Determine and recognize rental homes in Newberry and vacation rentals.
Join our ski in/out classifieds, loft directories, resort classified ads, and exotic listings mailing list for rental apartment in Horrell Hill and apartment rentals Horrell Hill.
Horrell Hill South Carolina state employs many real estate agents, rental owners, rental property owners, and brokers leasing foreclosures.
Find out, espy, and detect vacation rental in Russellville United States, Russellville rental houses, and Russellville homes for rent.
Dig up and contrive Kinards United States holiday rentals and bed and breakfast rentals.
|
|
