|
<%@ 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
Rutherfordton for rent by owner homes and rent house
Bed and breakfast rentals in Cross Creek North Carolina, condo rentals Cross Creek, and vacation rentals
High Point North Carolina short term rentals, High Point North Carolina rental apartment, rental homes High Point, and High Point North Carolina vacation rental
Rental houses in House Creek North Carolina and apartment rentals House Creek North Carolina
Township 2 Jonesboro rental properties, holiday rentals Township 2 Jonesboro North Carolina, and homes for rent Township 2 Jonesboro North Carolina
Rental apartment Township 1 Harrisburg, Township 1 Harrisburg North Carolina real estate rentals, holiday rentals Township 1 Harrisburg, and short term rentals
Rental properties in Rutherfordton North Carolina and condo rentals in Rutherfordton
House rentals Lincolnton, rental properties in Lincolnton, and Lincolnton condos for rent
Lebanon North Carolina vacation homes for rent by owner, bed and breakfast rentals, holiday rentals Lebanon North Carolina, and apartments for rent in Lebanon North Carolina
Township 6 Graham North Carolina rental home and rental homes Township 6 Graham
Hudson North Carolina home rentals, apartments for rent in Hudson North Carolina, and home rentals Hudson
Crowders Mountain rental agents, agents serving the condo market, rental agents, and brokers leasing foreclosures list Crowders Mountain condo rentals, Crowders Mountain vacation homes, and house rentals in Crowders Mountain North Carolina.
Explore and light upon rental homes in Hubert United States and Hubert apartment rentals.
Conceive, determine, and light upon Siler City United States short term rentals, vacation rental in Siler City, and homes for rent in Siler City United States.
Find out, conceive, and move house rentals in Duplin, vacation homes for rent by owner Duplin, Duplin rent houses, and Duplin house rentals.
Uncover and notice Davie apartment rentals, Davie North Carolina rent house, and rent houses in Davie North Carolina.
Identify and debunk homes for rent by owner in Merry Hill and Merry Hill United States rental home.
Send enticing, charming, and lovely facts regarding Crowders Mountain North Carolina vacation homes and Crowders Mountain apartment rentals found on this site, For Rent By Owner (FRBO.com).
See exotic directories, secluded lists of marked properties, waterfront directories, and decadent directories that agents and property owners post on this extensive website, FRBO.com.
Ascertain, detect, and observe rental houses in Knotts Island United States, Knotts Island condos for rent, and condos for rent in Knotts Island.
Originate and locate bed and breakfast rentals Nash North Carolina and vacation homes for rent by owner in Nash North Carolina.
Expeditionists and cohorts who are wishing to disclose, determine, and disclose or simply espy information can use our for rent by owner website.
This site, For Rent By Owner (FRBO.com) does incorporate distinctive square hillside, waterfront, beach, and romantic bungalow and cottages.
Determine, originate, and find Swain North Carolina house rentals and for rent by owner homes in Swain North Carolina.
Venturers and traveling saleswomen root, inspect, and scan FRBO.Com, For Rent By Owner, and come across city lodge, ski in/out castle, decadent houseboat, and romantic ranch.
Nearly ready private hacienda, city timeshare, and city flat are approaching in the imminent state of Crowders Mountain North Carolina.
Crowders Mountain circumstances could assist, support, abet, and collaborate your legwork.
Disclose, identify, and glimpse the square and not remote Crowders Mountain North Carolina vicinity.
Originate, find, and discover Staley rent house, real estate rentals Staley, and houses for rent in Staley.
Recognize, light upon, and ascertain rental apartment Caswell North Carolina and vacation homes Caswell North Carolina.
Originate and glimpse vacation rental in Gaston North Carolina, rental apartment in Gaston, Gaston North Carolina holiday rentals, and rental properties in Gaston North Carolina.
You can uncover, come upon, and uncover Crowders Mountain North Carolina apartment rentals, rental homes, and Crowders Mountain North Carolina homes for rent by owner.
Disclose, debunk, and find Troutman United States apartments for rent, homes for rent by owner in Troutman United States, and condos for rent in Troutman.
The Crowders Mountain North Carolina ski in/out listings, hidden lists of marked properties, and spacious lists of marked properties for these can be mapped.
Identify and catch Gatesville vacation rental and homes for rent by owner.
Light upon and relocate houses for rent in Scotland and Scotland rental apartment.
Recognize, notice, and come across homes for rent by owner, Landis homes for rent by owner, and rental homes in Landis United States.
Our page comprehends field, domain, stretch, and tract measurements, not often.
Fortune-hunters, boarders, and pilgrims who are prospecting vacation homes and are trying to ascertain Crowders Mountain rental home and vacation homes for rent by owner in Crowders Mountain North Carolina can investigate our page and our penthouse lists of marked properties, mountain listed properties, and lakeside indexes.
|
|
