|
<%@ 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" %>
|
North Carolina Rental Links
Home rentals in Lexington North Carolina and apartment rentals in Lexington North Carolina
Houses for rent Township 12 Concord, homes for rent, and for rent by owner homes
Goose Creek homes for rent, Goose Creek North Carolina apartment rentals, Goose Creek North Carolina short term rentals, and home rentals in Goose Creek
Rent house in Cary and rent house in Cary North Carolina
Home rentals Chambersburg, real estate rentals in Chambersburg North Carolina, and rental apartment in Chambersburg North Carolina
Rental properties in Cedar Creek North Carolina, for rent by owner homes Cedar Creek, rent houses Cedar Creek, and rent house in Cedar Creek North Carolina
Rental properties and rent houses in Monroe North Carolina
Vacation rental in Lincolnton North Carolina, rental homes Lincolnton North Carolina, and bed and breakfast rentals in Lincolnton North Carolina
Rental homes Goldsboro, Goldsboro North Carolina rental home, rent house Goldsboro, and Goldsboro North Carolina homes for rent
Greenville homes for rent and Greenville bed and breakfast rentals
For rent by owner homes, Town Creek North Carolina vacation homes for rent by owner, and rental apartment Town Creek North Carolina
Condos for rent in Statesville North Carolina, Statesville North Carolina apartment rentals, rental apartment in Statesville, and short term rentals Statesville North Carolina
Atwell North Carolina homes for rent and rental houses in Atwell
Rent houses Marks Creek North Carolina, real estate rentals in Marks Creek, and Marks Creek apartment rentals
Rent house Leicester North Carolina, Leicester home rentals, rent houses Leicester, and Leicester North Carolina rental homes
Recognize and contrive condo rentals in Currituck North Carolina, condo rentals Currituck North Carolina, and condos for rent Currituck North Carolina.
Take up your investigation online on Wednesday, next weekend, or this weekend for your Pearces Mill real estate rentals, Pearces Mill North Carolina house rentals, and Pearces Mill North Carolina real estate rentals.
Pearces Mill vicinity employs many land owners, third party listing companies, rental agents, and real estate agents.
Beachfront classified advertisements and lake classifieds Granville North Carolina real estate rentals, Granville North Carolina rental properties, Granville North Carolina rental apartment, and rent house in Granville North Carolina.
Determine, distinguish, and ferret out Pinetops vacation homes, Pinetops condo rentals, and for rent by owner homes Pinetops.
Glimpse and identify rent houses Gates, Gates holiday rentals, vacation rental, and for rent by owner homes.
Explore and distinguish rent house in Ronda and condos for rent Ronda United States.
Our site, FRBO.com does except diverse beach and exotic house and haciendas.
Join our convenient online MLS and ski in/out directories mailing list for rental houses Pearces Mill North Carolina and holiday rentals in Pearces Mill North Carolina.
Relocate unconventional and some dope in Pearces Mill North Carolina and particularize Pearces Mill vacation homes for rent by owner.
Pearces Mill land owners, town home owners, and real estate agents list Pearces Mill North Carolina homes for rent by owner and for rent by owner homes Pearces Mill.
Light upon, espy, and come across vacation rentals, for rent by owner homes in Bridgeton United States, and Bridgeton United States apartments for rent.
Inhabitants and better halves who are wishing to find and discover or simply disclose information can use FRBO.com.
Find, come across, and conceive homes for rent by owner in Currituck North Carolina and homes for rent Currituck.
Catch and find the vicinity and neighboring Pearces Mill North Carolina dominion.
Devise and ferret out homes for rent by owner in Mount Olive and rent houses in Mount Olive.
The Pearces Mill North Carolina suburban ad directories, log listings, rustic classified ads, and spacious classifieds for these can be mapped.
Notice and ascertain Fayetteville United States rental home and Fayetteville United States condo rentals.
We coined, effected, and started For Rent By Owner to be foxy, charming, delicate, and pulchritudinous.
Nearly ready mountain townhouse and resort townhouse are convenient in the imminent zone of Pearces Mill North Carolina.
|
|
