|
<%@ 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
House rentals in Hudson and rent house in Hudson North Carolina
Bartons Creek North Carolina condos for rent, bed and breakfast rentals Bartons Creek North Carolina, and rental apartment in Bartons Creek North Carolina
Bed and breakfast rentals in Atwell, homes for rent by owner in Atwell North Carolina, condo rentals in Atwell, and house rentals Atwell North Carolina
Holiday rentals and Rockfish North Carolina for rent by owner homes
Rental apartment in Eastover North Carolina, rent houses Eastover North Carolina, and rental houses Eastover North Carolina
Homes for rent by owner Goldsboro, Goldsboro for rent by owner homes, bed and breakfast rentals in Goldsboro, and rental homes in Goldsboro North Carolina
Holly Springs North Carolina rental home and Holly Springs North Carolina apartments for rent
Rental apartment Trinity North Carolina, vacation homes in Trinity, and rent house in Trinity North Carolina
House rentals in Pearces Mill, Pearces Mill North Carolina real estate rentals, houses for rent Pearces Mill, and condos for rent Pearces Mill North Carolina
Rental home in Franklin and house rentals Franklin North Carolina
Coddle Creek North Carolina apartment rentals, Coddle Creek rental home, and vacation homes for rent by owner in Coddle Creek North Carolina
Camp Lejeune UT North Carolina rent houses, house rentals in Camp Lejeune UT North Carolina, vacation homes for rent by owner Camp Lejeune UT North Carolina, and rental homes in Camp Lejeune UT North Carolina
Homes for rent and Wake Forest North Carolina rent house
Dutchville home rentals, real estate rentals Dutchville, and vacation homes in Dutchville North Carolina
Township 11 Long Creek holiday rentals, condo rentals Township 11 Long Creek North Carolina, Township 11 Long Creek holiday rentals, and houses for rent Township 11 Long Creek
Township 13 Morning Star vacation homes for rent by owner and rental apartment
Henderson vacation homes, rental houses in Henderson, and house rentals
Chapel Hill North Carolina rental homes, Chapel Hill North Carolina bed and breakfast rentals, rental apartment in Chapel Hill North Carolina, and Chapel Hill North Carolina condo rentals
Matthews North Carolina apartment rentals and bed and breakfast rentals in Matthews North Carolina
Icard rental homes, Icard homes for rent by owner, and short term rentals in Icard North Carolina
Dig up, design, and identify rent house Sherrills Ford United States, rent houses Sherrills Ford United States, and apartment rentals.
Indwellers and schoolmates who are searching vacation rentals Goldsboro North Carolina and are trying to locate Goldsboro North Carolina holiday rentals and Goldsboro rental apartment can explore this site, For Rent By Owner (FRBO.com) and our mountain classified ads and beach listed properties.
Goldsboro North Carolina memorandums could ballyhoo and sustain your inquest.
Locate and dig up Marston rental houses and Marston United States vacation homes.
Goldsboro condo owners, property brokers, and property owners list house rentals Goldsboro, short term rentals in Goldsboro North Carolina, Goldsboro North Carolina condos for rent, and vacation homes for rent by owner in Goldsboro.
Roommates and brides comb, cast about, and go through this website, FRBO.com and design secluded lodge, well appointed apartment, beach castle, and lakefront chalet.
Discern and look up homes for rent by owner in Carteret North Carolina, vacation homes Carteret, and short term rentals in Carteret North Carolina.
Come across and uncover homes for rent in Duplin North Carolina and rental homes in Duplin.
Light upon, invent, and discern vacation rentals Cherokee North Carolina, Cherokee North Carolina vacation rental, and houses for rent in Cherokee North Carolina.
Discover, discern, and find rental apartment in Grantsboro, houses for rent Grantsboro, and Grantsboro apartments for rent.
Explore and look up apartments for rent in Culberson and Culberson United States vacation homes for rent by owner.
The Goldsboro online MLS detailed and docketed on our for rent by owner website embrace log house and well appointed timeshare.
Discern, determine, and move vacation rental in Buncombe North Carolina, Buncombe North Carolina apartments for rent, bed and breakfast rentals in Buncombe, and rental properties in Buncombe.
Move and locate holiday rentals and for rent by owner homes in Hiddenite United States.
Initiate your investigation online tomorrow afternoon or in the next few days for your Goldsboro apartments for rent and rent house in Goldsboro North Carolina.
Disclose, recognize, and notice apartments for rent in Sampson and Sampson home rentals.
Come upon and discern houses for rent in Columbia and homes for rent in Columbia.
The Goldsboro North Carolina hidden classifieds and penthouse directories for these can be mapped.
Perceive, recognize, and conceive bed and breakfast rentals in McCutcheon Field, rent houses in McCutcheon Field United States, and McCutcheon Field United States apartment rentals.
Catch and locate short term rentals in New London United States and rental home in New London United States.
Opportunists, journeyers, and indwellers who are wishing to devise, look up, and contrive or simply find out information can use our for rent by owner website.
Our site, FRBO.com does involve sundry dominion beachfront, hillside, and beach home and condominiums.
Ascertain, notice, and espy apartment rentals Cumberland North Carolina, Cumberland apartment rentals, and short term rentals Cumberland.
Discover, distinguish, and look up holiday rentals in Murfreesboro, condos for rent Murfreesboro United States, and condos for rent Murfreesboro United States.
We performed, founded, and spawned FRBO.com to be delightful and sublime.
Perceive diverse and singular input in Goldsboro North Carolina and manifest rental properties Goldsboro.
Recently available mountain townhouse, private cabin, lake lodge, and lakefront farmhouse are nearby in the impending state of Goldsboro.
Discover, design, and look up Cherryville United States rental homes, Cherryville United States vacation homes, and Cherryville United States condos for rent.
Log ads and spacious listings bed and breakfast rentals Durham North Carolina, rental apartment Durham North Carolina, Durham rental properties, and homes for rent by owner in Durham.
Goldsboro North Carolina zone employs many real estate agents, agents serving the condo market, rental agents, and property brokers.
Contrive and disclose houses for rent in Anson North Carolina, apartments for rent Anson, and rental houses in Anson.
Contrive and devise vacation rental Macon, short term rentals Macon, for rent by owner homes in Macon North Carolina, and Macon North Carolina apartment rentals.
Relocate, invent, and design Spring Hope United States rent house, rental home Spring Hope, and Spring Hope United States vacation rentals.
Find out, notice, and espy real estate rentals in Beaufort North Carolina, rental apartment in Beaufort North Carolina, Beaufort North Carolina short term rentals, and rental home in Beaufort.
|
|
