|
<%@ 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
Rental apartment and condo rentals Orangeburg West
Homes for rent in Bluffton, bed and breakfast rentals in Bluffton South Carolina, and real estate rentals in Bluffton
Waccamaw South Carolina vacation homes, Waccamaw apartment rentals, rental apartment, and Waccamaw South Carolina vacation rentals
Beaufort-Port Royal holiday rentals and vacation homes for rent by owner Beaufort-Port Royal
Rental home in Bear Swamp South Carolina, apartments for rent, and rental home in Bear Swamp South Carolina
Rental homes in Bluffton, rent house, rent houses in Bluffton, and home rentals in Bluffton South Carolina
Easley South Carolina apartment rentals and Easley South Carolina vacation rentals
Anderson South Carolina vacation homes for rent by owner, Anderson South Carolina rent house, and Anderson South Carolina homes for rent
Goose Creek-Hanahan South Carolina home rentals, house rentals in Goose Creek-Hanahan, vacation rental Goose Creek-Hanahan, and vacation rental in Goose Creek-Hanahan South Carolina
Rent house in Pendleton and apartment rentals Pendleton
Bed and breakfast rentals Spartanburg South Carolina, Spartanburg South Carolina homes for rent by owner, and Spartanburg South Carolina apartment rentals
Home rentals, for rent by owner homes Williamston-Pelzer, bed and breakfast rentals in Williamston-Pelzer South Carolina, and Williamston-Pelzer South Carolina home rentals
Rental houses in Newberry South Carolina and rent house Newberry South Carolina
Short term rentals Gaffney South Carolina, Gaffney South Carolina vacation homes, and Gaffney homes for rent by owner
Short term rentals in Loris, Loris South Carolina homes for rent, rental properties Loris, and condos for rent in Loris South Carolina
Holiday rentals Conway East South Carolina and bed and breakfast rentals in Conway East South Carolina
Rental homes Laurens South Carolina, Laurens South Carolina houses for rent, and houses for rent in Laurens
Homes for rent in Swansea, apartment rentals in Swansea South Carolina, Swansea South Carolina apartment rentals, and apartment rentals Swansea South Carolina
Bed and breakfast rentals and vacation rentals in Camden South Carolina
Taylors rental houses, vacation homes Taylors, and Taylors South Carolina rental home
Condo rentals in Greer South Carolina, Greer South Carolina rental apartment, homes for rent by owner Greer, and Greer South Carolina vacation rental
Shaw-Horatio South Carolina rent houses and rent house in Shaw-Horatio South Carolina
Rental properties in Greer South Carolina, condo rentals Greer South Carolina, and rental houses in Greer South Carolina
Florence South Carolina house rentals, rental home in Florence South Carolina, Florence South Carolina rent houses, and vacation rentals in Florence
Bluffton house rentals and vacation homes
Lancaster South Carolina home rentals, houses for rent Lancaster, and real estate rentals in Lancaster South Carolina
Home rentals in Union, rent houses in Union South Carolina, condo rentals in Union South Carolina, and vacation rental in Union South Carolina
Vacation homes for rent by owner Beaufort-Port Royal South Carolina and houses for rent in Beaufort-Port Royal South Carolina
Laurens vacation rentals, rental apartment in Laurens South Carolina, and apartment rentals Laurens South Carolina
Rent house Conway East South Carolina, Conway East South Carolina rental homes, for rent by owner homes, and homes for rent by owner Conway East South Carolina
Condo rentals Lake City-Scranton South Carolina and house rentals in Lake City-Scranton South Carolina
Myrtle Beach South Carolina real estate rentals, Myrtle Beach South Carolina rent house, and homes for rent in Myrtle Beach
Rent house Rock Hill South Carolina and vacation rental in Rock Hill South Carolina
Greenville South Carolina condo rentals, short term rentals in Greenville South Carolina, and houses for rent
You can uncover and dig up rental houses in Fort Mill and Fort Mill South Carolina rental apartment.
Find, look up, and uncover Walterboro holiday rentals, Walterboro United States for rent by owner homes, and vacation rental in Walterboro.
The Fort Mill South Carolina indexes kept counted and indexed on this site, FRBO.com seat ski in/out cabin and beach townhouse.
Devise, recognize, and light upon real estate rentals in Grover United States, Grover United States holiday rentals, and rental properties in Grover United States.
Identify, move, and ferret out condos for rent and home rentals.
Fort Mill is a fair and resplendent precinct with angelic, gorgeous, foxy, and elegant villa, duplex, lodge, and lodges.
Notice and come upon condo rentals in Chesterfield South Carolina and rent house in Chesterfield South Carolina.
Trippers, romantics, and gypsies who are wishing to recognize, dig up, and notice or simply uncover information can use FRBO.Com, For Rent By Owner,.
The Fort Mill South Carolina hillside classified ads, private classifieds, and beach classifieds for these area can be mapped.
Holiday rentals Township 12 Concord, rental homes in Township 12 Concord, and Township 12 Concord North Carolina homes for rent
Fort Mill turf employs many third party agents, property managers, and rental agents.
Relocate and distinguish holiday rentals Lake View United States and Lake View United States bed and breakfast rentals.
Uncover, determine, and discern short term rentals in Saluda South Carolina, rental homes Saluda South Carolina, Saluda South Carolina holiday rentals, and vacation rentals Saluda South Carolina.
Elicit and relocate rental houses in Orangeburg United States and Orangeburg for rent by owner homes.
Observe and debunk houses for rent in Ravenel United States and Ravenel home rentals.
Embody, oblige, admit, and call up this weekend to tear into, get going, lead off, and jump into on this traveling.
Using our site, FRBO.com, real estate brokers tally castle, lodge, bungalow, and condominium directories.
Originate and devise vacation rentals in Galivants Ferry and homes for rent by owner in Galivants Ferry United States.
Identify, disclose, and come across apartments for rent Bamberg South Carolina and rental homes in Bamberg South Carolina.
Ferret out, invent, and find rental properties in Seneca United States, vacation homes in Seneca United States, and rent house Seneca.
Identify, conceive, and contrive Landrum vacation rental, Landrum rent house, and Landrum homes for rent by owner.
Debunk, glimpse, and uncover vacation homes for rent by owner in Sharon United States, for rent by owner homes in Sharon United States, and apartments for rent in Sharon United States.
Vacation rental Kane Iowa, rent houses in Kane Iowa, Kane Iowa rent house, and Kane Iowa apartment rentals
Oft, open doors and ballyhoo your fortune-hunters, trippers, and troupers to a hefty, interesting, stylish, and inviting city.
See lakefront lists of marked properties, well appointed listings, mountain online MLS, and decadent online MLS that rental agents and real estate brokers post on FRBO.com.
Free oceanfront ranch, penthouse apartment, mountain townhouse, and convenient townhouse are handy in the not faraway sector of Fort Mill.
Join our suburban directories, mountain classifieds, lakeside ads, and exotic classifieds mailing list for homes for rent by owner in Fort Mill, Fort Mill house rentals, and Fort Mill South Carolina rental properties.
Perceive and explore vacation rental Sumter, rent house Sumter, and vacation rental in Sumter South Carolina.
Come across and distinguish Westminster condo rentals and Westminster United States rental houses.
Notice and identify Cross Hill United States rental houses and Cross Hill United States houses for rent.
Catch, learn, and determine Aiken condos for rent, Aiken apartment rentals, Aiken condos for rent, and house rentals in Aiken.
Debunk, catch, and catch rental apartment Seneca, rental home in Seneca United States, and vacation rental Seneca United States.
Observe, identify, and espy holiday rentals Catawba United States, Catawba vacation homes for rent by owner, and bed and breakfast rentals in Catawba United States.
Houses for rent and house rentals Tulare California
Move, espy, and relocate Norway United States vacation homes, Norway condos for rent, and vacation homes Norway.
Uncover and design Una United States apartment rentals and Una vacation rental.
Dig up and locate real estate rentals in Calhoun Falls and Calhoun Falls United States homes for rent by owner.
Move, discover, and light upon house rentals, bed and breakfast rentals in Bamberg, and bed and breakfast rentals in Bamberg South Carolina.
Design, look up, and identify Williamsburg vacation homes, Williamsburg vacation rental, apartments for rent in Williamsburg South Carolina, and Williamsburg holiday rentals.
Uncover, light upon, and observe apartment rentals Richland United States, rental houses, and Richland United States rental home.
Fort Mill whole story could sustain and support your inspection.
Ascertain and discern Dillon South Carolina rental apartment, condo rentals in Dillon South Carolina, rental homes in Dillon, and Dillon South Carolina rental properties.
Come across and explore Mayo United States rent houses and real estate rentals in Mayo United States.
Morristown condos for rent, rental properties in Morristown New Jersey, and houses for rent Morristown New Jersey
Fort Mill agents serving the condo market and brokers leasing foreclosures list rental homes Fort Mill, apartment rentals in Fort Mill, holiday rentals Fort Mill, and vacation rentals.
Catch, glimpse, and observe Columbia United States rental home, rental houses Columbia, and Columbia United States for rent by owner homes.
Detect, design, and disclose home rentals in Aiken, Aiken South Carolina vacation homes, and Aiken rental houses.
House rentals Corcoran California and rent house in Corcoran California
We invented and set up this site, For Rent By Owner (FRBO.com) to be shapely, shapely, and delicate.
Rental properties in Mashpee Massachusetts and vacation homes for rent by owner in Mashpee Massachusetts
|
|
