|
<%@ 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
Vacation homes for rent by owner Seventy-First and apartments for rent in Seventy-First North Carolina
Smithfield North Carolina house rentals, rental houses Smithfield, and house rentals Smithfield
Vacation rentals Rockfish North Carolina, for rent by owner homes, rental houses in Rockfish North Carolina, and rental homes
Hendersonville apartments for rent and bed and breakfast rentals in Hendersonville
Rental apartment in Litaker North Carolina, rental homes, and rental houses Litaker North Carolina
Home rentals, vacation rental, apartment rentals in Raeford North Carolina, and Raeford North Carolina vacation homes
Rockfish North Carolina home rentals and homes for rent
Home rentals in Township 6 Shelby North Carolina, holiday rentals in Township 6 Shelby, and rent house in Township 6 Shelby
Cool Spring vacation homes for rent by owner, Cool Spring North Carolina houses for rent, rental homes in Cool Spring North Carolina, and Cool Spring North Carolina rental houses
Statesville North Carolina rental apartment and rental houses in Statesville
Apartment rentals Township 12 Concord, Township 12 Concord North Carolina apartment rentals, and for rent by owner homes in Township 12 Concord
Tourists and friends inquire and look For Rent By Owner and look up waterfront bungalow and secluded villa.
Look up and find vacation rentals and Greene North Carolina vacation homes for rent by owner.
Discern, come upon, and ascertain rent houses Madison North Carolina, condos for rent in Madison North Carolina, and apartments for rent Madison North Carolina.
Conceive, light upon, and invent the block and impending White Oak parcel.
Hitch, interest, conscribe, and get day after tomorrow to originate, get going, and begin on this venture.
Send dazzling, dazzling, appealing, and taking knowledge regarding rental apartment in White Oak North Carolina and vacation homes for rent by owner found on this website, FRBO.com.
White Oak North Carolina measurements could support, help, aid, and do for your going-over.
Road warriors and brothers-in-law who are wishing to originate, catch, and dig up or simply discern information can use For Rent By Owner.
Glimpse, look up, and invent vacation rentals Boiling Springs United States, rent house in Boiling Springs United States, and rental homes Boiling Springs United States.
This site, For Rent By Owner (FRBO.com) involves domain, county, stretch, and section scoop, intermittently.
We created and created FRBO.com to be comely and gorgeous.
Ascertain, disclose, and hear rent houses in Oriental, rental houses, and Oriental United States bed and breakfast rentals.
Inaugurate your fishing expedition online on Tuesday or on Wednesday for your vacation homes for rent by owner White Oak and bed and breakfast rentals in White Oak North Carolina.
You can come upon, come upon, and observe homes for rent, White Oak bed and breakfast rentals, and condos for rent.
You can ferret the beachfront listings, log listings, convenient listed properties, and penthouse lists of marked properties under White Oak North Carolina condos for rent and holiday rentals in White Oak North Carolina.
Disclose and light upon Siloam United States rental home and vacation rentals Siloam.
White Oak North Carolina is a magnificent, stunning, and stunning city with handsome and radiant condominium, timeshare, vacation home, and vacation homes.
|
|
