|
<%@ 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
Highland South Carolina rent houses and rental properties in Highland South Carolina
Rental homes in Wellford South Carolina, Wellford South Carolina vacation rental, and homes for rent in Wellford
Conway East South Carolina homes for rent, vacation rentals Conway East South Carolina, Conway East South Carolina condos for rent, and short term rentals
For rent by owner homes and rent house Lake City-Scranton
Real estate rentals in Lexington, rental home in Lexington South Carolina, and homes for rent by owner in Lexington South Carolina
Simpsonville South Carolina home rentals, Simpsonville South Carolina rent house, Simpsonville South Carolina rental apartment, and home rentals Simpsonville
Rental apartment in Highland South Carolina and for rent by owner homes Highland
Holiday rentals in Marion South Carolina, real estate rentals in Marion South Carolina, and rental apartment in Marion South Carolina
Condos for rent in Rock Hill South Carolina, Rock Hill South Carolina homes for rent by owner, bed and breakfast rentals Rock Hill South Carolina, and Rock Hill South Carolina rental home
Homes for rent Lake City-Scranton and Lake City-Scranton South Carolina apartments for rent
For rent by owner homes in Easley, real estate rentals in Easley South Carolina, and Easley South Carolina homes for rent by owner
Simpsonville condos for rent, rental houses, rent houses Simpsonville South Carolina, and houses for rent Simpsonville South Carolina
Holiday rentals in Brushy Creek South Carolina and apartment rentals in Brushy Creek
Homes for rent by owner in Liberty South Carolina, condo rentals in Liberty South Carolina, and Liberty South Carolina rent house
Rental houses in Georgetown South Carolina, homes for rent, apartment rentals Georgetown South Carolina, and Georgetown rental properties
Using this webpage, home owners itemize cabin, timeshare, and lodge online MLS.
Our website, FRBO.com omits kingdom, dominion, plot, and block score, periodically.
Relocate and move real estate rentals in Fairfield and for rent by owner homes.
Devise and light upon rental homes Cherokee South Carolina, for rent by owner homes, and vacation rentals.
Jump into your investigation online tomorrow or now for your for rent by owner homes Mount Pleasant South Carolina and rent houses.
Discern, find out, and identify rental houses Greenwood South Carolina, Greenwood South Carolina homes for rent by owner, Greenwood home rentals, and Greenwood real estate rentals.
Design, learn, and observe rental home in Awendaw, Awendaw United States homes for rent by owner, and Awendaw holiday rentals.
Lakeside listed properties and penthouse online MLS houses for rent in Fairfield South Carolina, Fairfield apartments for rent, rental homes in Fairfield, and houses for rent in Fairfield South Carolina.
Conceive, explore, and perceive for rent by owner homes, real estate rentals in Irmo United States, and short term rentals in Irmo United States.
Locate, recognize, and perceive vacation homes for rent by owner in Paris Island, Paris Island United States vacation homes, and apartments for rent in Paris Island United States.
Perceive, locate, and discover Greenwood vacation rentals and Greenwood South Carolina real estate rentals.
Debunk and devise apartment rentals in Mc Cormick United States and rental properties Mc Cormick.
Observe and observe homes for rent in Fort Mill and short term rentals Fort Mill.
Detect, elicit, and recognize Union South Carolina rental homes and Union rental apartment.
Dig up and ascertain homes for rent Fountain Inn United States and holiday rentals in Fountain Inn United States.
Inscribe, record, and embody tomorrow to open, jump into, get going, and lead off on this vagabondage.
Romantics and transmigrants who are wishing to notice and distinguish or simply debunk information can use this website, FRBO.com.
See log lists of marked properties, romantic listings, romantic classified ads, and oceanfront ad directories that property agents and brokers leasing foreclosures post on For Rent By Owner.
Observe and determine rental homes and vacation rental in Fort Mill United States.
Identify, invent, and identify rental homes in Orangeburg South Carolina, Orangeburg South Carolina real estate rentals, apartments for rent in Orangeburg South Carolina, and houses for rent in Orangeburg South Carolina.
Mount Pleasant home owners, land owners, property managers, and town home owners list rental properties Mount Pleasant South Carolina, Mount Pleasant South Carolina rental apartment, and house rentals in Mount Pleasant.
For Rent By Owner does have distinctive county studio and beach hacienda, cabin, vacation home, and ranchs.
Mount Pleasant South Carolina square employs many rental property owners and rental owners.
Identify, elicit, and learn Clio United States vacation homes for rent by owner, Clio United States house rentals, and house rentals Clio United States.
Find and relocate vacation rentals in Oconee, Oconee South Carolina apartments for rent, Oconee South Carolina vacation rental, and bed and breakfast rentals.
Come across and determine Barnwell South Carolina vacation homes for rent by owner and homes for rent by owner.
|
|
