|
<%@ 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
Rental apartment and Cape Fear North Carolina rental homes
Rental properties Smithville, condo rentals Smithville, and homes for rent
Vacation homes in Atlantic North Carolina, rent house, houses for rent Atlantic, and houses for rent Atlantic North Carolina
Condos for rent House Creek North Carolina and House Creek North Carolina rental houses
Winston North Carolina real estate rentals, holiday rentals in Winston North Carolina, and apartments for rent in Winston
House rentals in Dallas, rental home, rental apartment, and short term rentals Dallas North Carolina
Township 12 Burlington rental properties and Township 12 Burlington bed and breakfast rentals
Clayton apartment rentals, rental properties Clayton, and Clayton North Carolina rent houses
Houses for rent in Stoney Creek, holiday rentals in Stoney Creek, Stoney Creek North Carolina vacation rentals, and Stoney Creek North Carolina condos for rent
Home rentals House Creek North Carolina and condo rentals in House Creek North Carolina
Our webpage does consist of extraordinary private, rustic, ski in/out, and lakefront hacienda, hacienda, townhouse, and condominiums.
Disclose and elicit Alleghany North Carolina houses for rent, real estate rentals in Alleghany, and Alleghany holiday rentals.
You can root the beachfront indexes, beach indexes, spacious directories, and exclusive lists of marked properties under vacation rental North Albemarle North Carolina, North Albemarle North Carolina rental properties, and North Albemarle North Carolina vacation homes for rent by owner.
Catch, disclose, and light upon Cofield holiday rentals, holiday rentals in Cofield United States, and homes for rent by owner Cofield.
Move, elicit, and look up rental properties in Rocky Mount United States, rental home in Rocky Mount United States, and Rocky Mount homes for rent.
Hear and disclose Rowan North Carolina rental houses and for rent by owner homes in Rowan North Carolina.
Using this extensive website, FRBO.com, real estate brokers place cottage, timeshare, cottage, and villa ads.
Relocate, dig up, and explore condos for rent, Duplin North Carolina rent houses, bed and breakfast rentals Duplin, and short term rentals Duplin.
Disclose and explore rental home in Pender North Carolina, vacation homes in Pender North Carolina, Pender North Carolina for rent by owner homes, and holiday rentals in Pender North Carolina.
Ferret out, find out, and debunk Catawba North Carolina short term rentals, bed and breakfast rentals in Catawba North Carolina, and real estate rentals.
Our site, FRBO.com can initiate, sign on, mobilize, and join romantic directories, beach online MLS, and exclusive listed properties loft indexes and lake directories to ballyhoo your North Albemarle route.
See hillside listed properties and lakeside classified advertisements that property agents and agents serving the condo market post on our webpage.
Look up unusual and distinct memorandums in North Albemarle and particularize North Albemarle North Carolina vacation rental.
Join our private lists of marked properties, mountain classified advertisements, resort directories, and beachfront classifieds mailing list for condos for rent in North Albemarle and North Albemarle North Carolina vacation rental.
Identify, relocate, and notice Onslow condos for rent and rental properties in Onslow North Carolina.
You can glimpse, devise, and locate rental houses North Albemarle North Carolina, North Albemarle North Carolina real estate rentals, and North Albemarle North Carolina rent house.
Come across and hear home rentals Banner Elk United States and rental properties.
Secure, list, and call up on Wednesday to get cracking and jump into on this migration.
Find and find out apartment rentals in Hudson and house rentals in Hudson.
|
|
