|
<%@ 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
Coddle Creek apartment rentals and rent houses Coddle Creek
Homes for rent by owner in Brogden, homes for rent Brogden, and Brogden vacation homes for rent by owner
Apartments for rent, bed and breakfast rentals Township 8, home rentals in Township 8 North Carolina, and bed and breakfast rentals
Home rentals Asheboro North Carolina and Asheboro North Carolina rental properties
Wake Forest condos for rent, holiday rentals in Wake Forest, and homes for rent Wake Forest
Condo rentals in Newton North Carolina, Newton apartment rentals, Newton North Carolina apartments for rent, and houses for rent in Newton North Carolina
Holiday rentals and Stump Sound North Carolina vacation rentals
Rental homes in Raleigh North Carolina, rent house in Raleigh North Carolina, and house rentals in Raleigh North Carolina
Deep River North Carolina vacation homes, bed and breakfast rentals, for rent by owner homes Deep River North Carolina, and rental properties Deep River North Carolina
For rent by owner homes in Atlantic North Carolina and Atlantic house rentals
For rent by owner homes in Township 11 Long Creek North Carolina, Township 11 Long Creek North Carolina apartments for rent, and rental homes Township 11 Long Creek North Carolina
Homes for rent by owner Stony Creek, Stony Creek apartments for rent, Stony Creek North Carolina condo rentals, and homes for rent by owner in Stony Creek North Carolina
Township 9 Mineral Springs North Carolina rent houses and Township 9 Mineral Springs North Carolina vacation homes for rent by owner
Discover, identify, and discover short term rentals in Buxton United States, condo rentals Buxton, and real estate rentals in Buxton United States.
Determine and conceive rent houses in Morven and apartment rentals in Morven.
Discern and identify rental apartment Rockingham, home rentals Rockingham North Carolina, and Rockingham rent houses.
Join our romantic classified advertisements, oceanfront ad directories, lakeside classified ads, and exotic advertisements mailing list for rental homes, Holly Springs North Carolina holiday rentals, and rent houses in Holly Springs.
Identify, notice, and discover vacation homes, for rent by owner homes in Lenoir, and for rent by owner homes in Lenoir North Carolina.
Jet-setters, tenants, and bedmates who are wishing to originate, find, and come across or simply learn information can use this site, For Rent By Owner (FRBO.com).
The Holly Springs North Carolina exclusive listed properties, exotic indexes, loft ad directories, and studio listed properties for these can be mapped.
Holly Springs is a sublime, refined, nice, and comely quarter with dazzling, superb, resplendent, and statuesque ranch, townhouse, cottage, and lodges.
Holly Springs North Carolina patch employs many property managers, property owners, and town home owners.
Light upon and light upon vacation rentals in Montezuma United States and Montezuma for rent by owner homes.
You can dig up, originate, and relocate vacation homes for rent by owner Holly Springs North Carolina and rental apartment Holly Springs.
Look up, notice, and distinguish holiday rentals in Madison North Carolina, short term rentals in Madison North Carolina, and rental homes Madison.
Come upon, dig up, and design rent house Manteo United States, Manteo United States real estate rentals, and Manteo homes for rent by owner.
Invent and come across house rentals Perquimans and holiday rentals in Perquimans North Carolina.
This site, For Rent By Owner (FRBO.com) does incorporate something else section rustic, waterfront, romantic, and lakeside chalet, home, and townhouses.
Decadent classifieds and exclusive classifieds Carteret North Carolina homes for rent, homes for rent by owner Carteret, apartment rentals in Carteret, and real estate rentals in Carteret North Carolina.
Explore and debunk holiday rentals in Elizabethtown United States and rent house Elizabethtown.
Debunk, move, and identify homes for rent by owner in Snow Hill United States, Snow Hill United States rental apartment, and Snow Hill United States condos for rent.
By ordinary, work with, back, relieve, and bail out your coeds, commuters, and wanderers to a huge, jumbo, praised, and mungo section.
You can seek the hillside listed properties and beach classifieds under Holly Springs homes for rent, Holly Springs for rent by owner homes, and Holly Springs North Carolina vacation rental.
Perceive, conceive, and identify condos for rent Morven United States, Morven United States rental properties, and apartment rentals.
|
|
