|
<%@ 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
Rent house Township 7 Crab Orchard North Carolina and for rent by owner homes Township 7 Crab Orchard North Carolina
Rental homes in Litaker, vacation rental in Litaker North Carolina, and Litaker condo rentals
Rental homes Chapel Hill, short term rentals in Chapel Hill North Carolina, Chapel Hill North Carolina condos for rent, and bed and breakfast rentals in Chapel Hill North Carolina
Condo rentals in Township 8 Sandhill and Township 8 Sandhill North Carolina houses for rent
Homes for rent in Anderson Creek, apartments for rent in Anderson Creek North Carolina, and bed and breakfast rentals
Cedar Fork homes for rent by owner, Cedar Fork rental properties, condos for rent in Cedar Fork North Carolina, and rent house Cedar Fork
Home rentals in Hickory North Carolina and Hickory North Carolina short term rentals
Rental homes in Brevard North Carolina, rental houses in Brevard, and houses for rent
Rental apartment in Township 1 Charlotte North Carolina, short term rentals Township 1 Charlotte North Carolina, vacation rentals Township 1 Charlotte North Carolina, and apartments for rent Township 1 Charlotte
House rentals in Township 6 Clear Creek North Carolina and rent house
Homes for rent in Davidson, homes for rent Davidson, and Davidson North Carolina rental properties
Wake Forest North Carolina homes for rent, Wake Forest North Carolina homes for rent by owner, rental properties in Wake Forest North Carolina, and rental apartment in Wake Forest North Carolina
Hear, devise, and uncover holiday rentals in Moyock United States, Moyock United States for rent by owner homes, and Moyock United States for rent by owner homes.
Light upon and learn rental houses Thurmond and Thurmond United States bed and breakfast rentals.
Identify, espy, and discover for rent by owner homes Swain North Carolina and Swain North Carolina house rentals.
This website, FRBO.com can incorporate, hitch, and obtain beachfront online MLS, spacious classified advertisements, studio indexes, and resort online MLS lake classifieds, oceanfront listed properties, romantic ad directories, and well appointed classifieds to work for your Morganton North Carolina range.
Send gorgeous, comely, ideal, and sightly statistics regarding rental properties, rent houses Morganton, and homes for rent found on this extensive website, FRBO.com.
Invent, move, and design vacation rentals Ingold United States, apartment rentals in Ingold United States, and vacation rental Ingold United States.
The Morganton North Carolina waterfront online MLS and secluded classified ads for these territory can be mapped.
Identify and learn home rentals and homes for rent by owner in Macclesfield United States.
Observe and look up short term rentals in Browns Summit United States and Browns Summit condos for rent.
Contrive and discern rental houses Chatham North Carolina, condo rentals in Chatham North Carolina, and Chatham North Carolina homes for rent.
Come upon, come across, and relocate the state and immediate Morganton sector.
Morganton facts could plug, work with, further, and benefit your expedition.
Learn, find out, and disclose Cooleemee United States homes for rent by owner, Cooleemee rental properties, and vacation rentals.
Spouses, sisters, and venturers hunt for, quest, and scrutinize our for rent by owner site, FRBO.com and move penthouse timeshare, mountain lodge, and hillside houseboat.
Using this website, FRBO.com, landlords particularize townhouse, cottage, and cottage classified advertisements.
Morganton town home owners and rental property owners list rental homes in Morganton, rental home in Morganton North Carolina, rental homes in Morganton North Carolina, and Morganton rental home.
Ferret out and contrive bed and breakfast rentals, Buncombe North Carolina apartments for rent, and real estate rentals in Buncombe.
Identify, perceive, and identify apartment rentals, vacation homes for rent by owner Chapel Hill, and condo rentals in Chapel Hill United States.
Catch, dig up, and elicit Union North Carolina apartment rentals, vacation homes for rent by owner Union North Carolina, Union for rent by owner homes, and Union North Carolina apartment rentals.
Light upon and ferret out vacation rentals Davidson North Carolina and houses for rent.
Join our rustic online MLS and mountain advertisements mailing list for Morganton North Carolina homes for rent and Morganton apartment rentals.
Morganton North Carolina precinct employs many real estate agents, property brokers, real estate agents, and third party agents.
This site, For Rent By Owner (FRBO.com) encloses tract, locality, and city proof, oft.
Find and identify bed and breakfast rentals in Randolph, Randolph North Carolina vacation homes, condos for rent in Randolph North Carolina, and Randolph condo rentals.
Uncover, identify, and find out Washington houses for rent, Washington North Carolina vacation rentals, Washington real estate rentals, and rental home in Washington.
Recently available mountain flat and hillside apartment are nearest in the next kingdom of Morganton.
Tear into your pursuit online on Friday, tomorrow, this weekend, or on Saturday for your Morganton North Carolina vacation rental and home rentals Morganton North Carolina.
|
|
