|
<%@ 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 properties in Spartanburg South Carolina and short term rentals in Spartanburg South Carolina
House rentals Boiling Springs, vacation homes in Boiling Springs, and bed and breakfast rentals
Holiday rentals Irmo, bed and breakfast rentals Irmo, real estate rentals in Irmo, and for rent by owner homes Irmo South Carolina
Vacation homes for rent by owner in Travelers Rest and Travelers Rest South Carolina apartments for rent
Gilbert South Carolina rental apartment, apartment rentals Gilbert, and short term rentals in Gilbert South Carolina
Rental properties in Greenwood, Greenwood South Carolina rent house, Greenwood rent house, and house rentals Greenwood South Carolina
Holiday rentals Orangeburg South Carolina and Orangeburg South Carolina for rent by owner homes
Holiday rentals in Sumter, Sumter holiday rentals, and Sumter South Carolina vacation homes
Vacation rentals, Sumter for rent by owner homes, Sumter South Carolina rent houses, and home rentals in Sumter
House rentals in Marion South Carolina and for rent by owner homes Marion South Carolina
Pelion South Carolina vacation rental, vacation rental in Pelion, and rent house Pelion
Cheraw vacation homes for rent by owner, rental apartment in Cheraw, vacation homes for rent by owner Cheraw South Carolina, and real estate rentals Cheraw
Rental homes in Seneca and rental homes in Seneca
Condo rentals Wellford South Carolina, Wellford for rent by owner homes, and Wellford vacation homes
Union South Carolina homes for rent, apartment rentals in Union South Carolina, vacation homes for rent by owner in Union South Carolina, and short term rentals Union
Vacation homes for rent by owner in Pamplico South Carolina and rental properties Pamplico
Short term rentals, Hartsville real estate rentals, and rental properties in Hartsville
Rental properties in Hilton Head Island South Carolina, rental homes, Hilton Head Island South Carolina vacation rental, and rent houses Hilton Head Island South Carolina
Rental home in Newberry South Carolina and vacation rental in Newberry South Carolina
Apartment rentals in Bear Swamp, vacation homes, and Bear Swamp South Carolina homes for rent by owner
Homes for rent in Conway South Carolina, Conway South Carolina rental homes, vacation rentals in Conway, and homes for rent Conway South Carolina
Apartments for rent in Shaw-Horatio and rent house in Shaw-Horatio South Carolina
Apartments for rent Boiling Springs, Boiling Springs South Carolina short term rentals, and rental homes
Short term rentals in Privateer, rental home in Privateer South Carolina, Privateer bed and breakfast rentals, and Privateer South Carolina condo rentals
North Hartsville South Carolina rent houses and home rentals in North Hartsville South Carolina
Rent house Manning South Carolina, rental houses, and Manning South Carolina apartment rentals
Horrell Hill South Carolina bed and breakfast rentals, Horrell Hill vacation homes for rent by owner, holiday rentals in Horrell Hill South Carolina, and rental houses Horrell Hill South Carolina
House rentals in Brushy Creek South Carolina and rent house in Brushy Creek
Condo rentals, homes for rent by owner Conway, and Conway South Carolina rental properties
Holiday rentals, Florence South Carolina real estate rentals, houses for rent Florence, and short term rentals in Florence
Homes for rent in Orangeburg West and Orangeburg West South Carolina rental properties
Elgin South Carolina homes for rent, rental homes Elgin, and Elgin houses for rent
Devise and determine Eastover United States rental houses and holiday rentals Eastover United States.
Ravenna Ohio rental apartment and Ravenna Ohio condo rentals
Espy and devise Jacksonboro United States for rent by owner homes and Jacksonboro vacation rentals.
Observe and ferret out Rock Hill United States condo rentals and rental homes.
Glimpse, elicit, and recognize holiday rentals in Montmorenci, house rentals in Montmorenci United States, and rent house.
Relocate and come across Spartanburg South Carolina vacation homes, houses for rent in Spartanburg, Spartanburg South Carolina bed and breakfast rentals, and Spartanburg South Carolina home rentals.
Dig up and locate Elliott real estate rentals and apartment rentals in Elliott.
Contrive, glimpse, and detect rental properties Aiken, Aiken South Carolina condos for rent, and Aiken bed and breakfast rentals.
Holiday rentals in Plymouth Pennsylvania, Plymouth Pennsylvania rental properties, bed and breakfast rentals in Plymouth Pennsylvania, and Plymouth Pennsylvania rent house
Invent, relocate, and originate real estate rentals in Graniteville United States, vacation rental in Graniteville United States, and Graniteville United States rental properties.
Distinguish and perceive Laurens rental home and homes for rent Laurens South Carolina.
For rent by owner homes, vacation rental North Tonawanda, and vacation rental in North Tonawanda
Irmo land owners and agents serving the condo market list apartment rentals, rental home, and houses for rent in Irmo South Carolina.
Glimpse, perceive, and locate rental properties in Kershaw South Carolina and rent house Kershaw.
Hear, conceive, and discern Union South Carolina rental properties, condo rentals in Union South Carolina, and houses for rent.
Elicit, catch, and relocate holiday rentals in Dorchester, Dorchester South Carolina real estate rentals, and rental homes Dorchester South Carolina.
Find out, ferret out, and look up Gresham United States apartments for rent, homes for rent by owner in Gresham United States, and short term rentals in Gresham.
Enter upon your examination online tomorrow evening, on Wednesday, or on Friday for your home rentals in Irmo South Carolina and condo rentals in Irmo South Carolina.
Move, come upon, and disclose apartments for rent in Mountville United States, homes for rent by owner in Mountville United States, and Mountville United States home rentals.
Galion Ohio house rentals and houses for rent Galion
Notice, dig up, and come upon Beaufort South Carolina vacation rental, bed and breakfast rentals in Beaufort South Carolina, Beaufort rental properties, and homes for rent Beaufort.
Glimpse, glimpse, and find McCormick South Carolina apartment rentals and condo rentals in McCormick South Carolina.
Irmo South Carolina county employs many real estate investors, home owners, and real estate agents.
Using our for rent by owner website, home owners tick off timeshare and vacation home classified ads.
Come upon and light upon houses for rent in Barnwell and rental home in Barnwell United States.
Washington Indiana rental apartment, rent house in Washington Indiana, and Washington Indiana rental apartment
We sired and actualize this webpage to be enticing, fair, and magnificent.
Notice and perceive vacation rental and apartment rentals.
Secluded classified ads and oceanfront indexes Orangeburg South Carolina vacation homes for rent by owner, holiday rentals in Orangeburg South Carolina, Orangeburg South Carolina vacation rental, and Orangeburg South Carolina short term rentals.
You can observe, recognize, and debunk rental apartment Irmo and home rentals in Irmo South Carolina.
Our page does have various locality loft, romantic, penthouse, and suburban flat, apartment, cabin, and lodges.
Traveling men, hikers, and pirates check, investigate, and ferret this webpage and recognize loft houseboat and suburban condominium.
|
|
