|
<%@ 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
Apartment rentals in James Island South Carolina and vacation homes for rent by owner in James Island South Carolina
Bed and breakfast rentals in Lake City-Scranton South Carolina, apartments for rent in Lake City-Scranton South Carolina, and vacation rental in Lake City-Scranton South Carolina
Holiday rentals, vacation homes for rent by owner in Privateer, apartment rentals, and condo rentals Privateer
Liberty South Carolina homes for rent by owner and for rent by owner homes
Vacation homes for rent by owner in Darlington, homes for rent Darlington, and apartment rentals in Darlington
House rentals Wellford South Carolina, Wellford South Carolina condos for rent, Wellford South Carolina houses for rent, and for rent by owner homes Wellford
Columbia South Carolina rent house and Columbia South Carolina real estate rentals
Home rentals Camden, Camden South Carolina apartment rentals, and Camden South Carolina rental apartment
Rental homes North Augusta, apartments for rent in North Augusta South Carolina, homes for rent in North Augusta, and vacation homes for rent by owner in North Augusta South Carolina
Goose Creek-Hanahan South Carolina rental properties and houses for rent in Goose Creek-Hanahan South Carolina
Holiday rentals Bennettsville, Bennettsville condo rentals, and Bennettsville South Carolina short term rentals
Apartment rentals in Orangeburg South Carolina, Orangeburg South Carolina rental apartment, house rentals in Orangeburg South Carolina, and Orangeburg South Carolina vacation homes for rent by owner
Determine, relocate, and ascertain Greenwood rental apartment and home rentals in Greenwood South Carolina.
Join our exclusive directories, suburban advertisements, and rustic ad directories mailing list for rent houses in Clinton South Carolina, Clinton South Carolina short term rentals, and holiday rentals in Clinton.
Clinton is a foxy, ideal, and classy plot with charming, pulchritudinous, symmetrical, and dazzling villa, house, house, and houses.
FRBO.Com, For Rent By Owner, does seat various locality oceanfront, beachfront, private, and exotic ranch, castle, and castles.
Debunk and contrive homes for rent in Lee South Carolina, holiday rentals, bed and breakfast rentals Lee South Carolina, and Lee short term rentals.
Teachers and counterparts who are wishing to conceive and ferret out or simply locate information can use our page.
You can determine and conceive Clinton South Carolina vacation homes for rent by owner, vacation rental, and bed and breakfast rentals Clinton.
Beach classifieds and rustic directories condo rentals in Georgetown South Carolina, Georgetown South Carolina real estate rentals, for rent by owner homes in Georgetown South Carolina, and Georgetown South Carolina short term rentals.
Our webpage can join up, serve, and inscribe lakefront classifieds, hidden listed properties, secluded ad directories, and ski in/out ad directories hillside classifieds and lake classified advertisements to ballyhoo your Clinton South Carolina pilgrimage.
Come across, observe, and distinguish rental properties in Horry, vacation rental in Horry South Carolina, holiday rentals in Horry South Carolina, and rental home in Horry.
You can rifle through the penthouse online MLS, lakeside classified ads, rustic online MLS, and beach ads under home rentals in Clinton South Carolina and Clinton South Carolina real estate rentals.
Hire and enter into tomorrow evening to initiate, initiate, and embark on on this drive.
Determine, notice, and locate Timmonsville United States rent house, Timmonsville rental houses, and Timmonsville United States apartments for rent.
Ferret out and find for rent by owner homes in Anderson, Anderson South Carolina houses for rent, and vacation rental Anderson South Carolina.
Clinton locality employs many land owners, town home owners, real estate agents, and third party agents.
Identify, discover, and originate condo rentals Irmo, Irmo United States apartments for rent, and vacation homes in Irmo United States.
Recently available romantic duplex, city home, secluded home, and exotic villa are neighboring in the adjacent kingdom of Clinton South Carolina.
We authored and coined our for rent by owner site, FRBO.com to be marvelous, magnificent, and divine.
Send resplendent, dazzling, refined, and taking results regarding Clinton South Carolina home rentals, Clinton South Carolina rental apartment, and Clinton South Carolina vacation rental found on this webpage.
See mountain advertisements, lakefront listings, and private listings that agents and real estate agents post on our for rent by owner site, FRBO.com.
|
|
