|
<%@ 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
Apartment rentals Kernersville and house rentals
Houses for rent in Bartons Creek, home rentals Bartons Creek, and homes for rent by owner Bartons Creek
Atlantic North Carolina apartments for rent, apartments for rent in Atlantic, homes for rent by owner in Atlantic North Carolina, and rent houses in Atlantic
Home rentals Marks Creek and short term rentals in Marks Creek
Rent house, rent houses in Pearces Mill, and for rent by owner homes
Fentress North Carolina house rentals, rental home Fentress, homes for rent in Fentress North Carolina, and rental home in Fentress North Carolina
Apartment rentals in Kernersville North Carolina and Kernersville North Carolina rental properties
Vacation rental in Township 6 Clear Creek North Carolina, short term rentals Township 6 Clear Creek, and Township 6 Clear Creek North Carolina rental houses
Bed and breakfast rentals in Federal Point, real estate rentals Federal Point, Federal Point North Carolina rent houses, and Federal Point North Carolina houses for rent
Atlantic North Carolina vacation rentals and Atlantic North Carolina condos for rent
Originate your exploration online tomorrow afternoon, on Monday, in the morning, or on Tuesday for your house rentals in Lockwoods Folly and rental home Lockwoods Folly.
Using our page, third party agents run down duplex, bungalow, home, and duplex listed properties.
Educators and honeymooners who are rummaging apartment rentals in Lockwoods Folly North Carolina and are trying to originate vacation homes for rent by owner in Lockwoods Folly, Lockwoods Folly North Carolina rental home, and short term rentals in Lockwoods Folly can smell around this website, FRBO.com and our mountain classified advertisements and secluded online MLS.
Invent and devise Clay North Carolina house rentals, Clay North Carolina apartment rentals, house rentals Clay North Carolina, and Clay North Carolina vacation rental.
The Lockwoods Folly North Carolina secluded listings, lake ad directories, and mountain ads for these can be mapped.
See lakeside online MLS, suburban ads, lakefront lists of marked properties, and beachfront ad directories that agents serving the condo market and agents serving the condo market post on FRBO.com.
Originate and observe Farmville United States rent house and Farmville United States condos for rent.
Tourists, voyagers, and companions who are wishing to debunk, conceive, and distinguish or simply recognize information can use this site, FRBO.com.
Detect, devise, and originate short term rentals in Clay North Carolina, vacation homes for rent by owner Clay North Carolina, and houses for rent Clay North Carolina.
Notice, recognize, and uncover rental home in New Hill, New Hill United States rental homes, and New Hill United States vacation homes.
Light upon, determine, and notice Columbus United States for rent by owner homes, rent house Columbus United States, and rent house in Columbus.
Devise, learn, and detect vacation rental, holiday rentals Hertford North Carolina, homes for rent by owner, and real estate rentals Hertford.
Elicit and observe vacation homes in Kelly United States and real estate rentals Kelly.
Ferret out and conceive holiday rentals in Macon North Carolina and rental properties in Macon North Carolina.
Ascertain, dig up, and invent holiday rentals in Swain North Carolina, home rentals, and Swain North Carolina short term rentals.
You can ferret out and observe holiday rentals in Lockwoods Folly North Carolina, condo rentals, and Lockwoods Folly North Carolina rent house.
Send enticing and classy evidence regarding short term rentals, rental home Lockwoods Folly North Carolina, apartment rentals, and Lockwoods Folly North Carolina rental homes found on this site, For Rent By Owner (FRBO.com).
Detect and recognize the sector and immediate Lockwoods Folly zone.
|
|
