|
<%@ 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
Charleston North Carolina condo rentals and Charleston North Carolina homes for rent
Winterville North Carolina for rent by owner homes, bed and breakfast rentals Winterville, and Winterville bed and breakfast rentals
Rutherfordton North Carolina apartments for rent, Rutherfordton short term rentals, short term rentals Rutherfordton North Carolina, and rental homes Rutherfordton North Carolina
St Matthews North Carolina apartments for rent and rent house St Matthews
For rent by owner homes in Dutchville, for rent by owner homes in Dutchville North Carolina, and Dutchville North Carolina rental apartment
Cedar Fork bed and breakfast rentals, Cedar Fork North Carolina homes for rent, rental homes Cedar Fork North Carolina, and condos for rent in Cedar Fork
Condo rentals in Asheville North Carolina and vacation rentals Asheville
Real estate rentals, McLauchlin North Carolina vacation rentals, and houses for rent in McLauchlin
Homes for rent by owner, Township 11 Long Creek vacation rentals, Township 11 Long Creek home rentals, and Township 11 Long Creek holiday rentals
Lovelady North Carolina apartments for rent and condo rentals
Yadkin North Carolina for rent by owner homes, homes for rent by owner in Yadkin, and Yadkin North Carolina apartment rentals
For rent by owner homes, Marion North Carolina real estate rentals, Marion North Carolina vacation homes for rent by owner, and Marion houses for rent
Short term rentals and rental home
South Point North Carolina rental properties, homes for rent, and South Point rental home
Rent houses Cedar Fork, bed and breakfast rentals Cedar Fork, rent house in Cedar Fork, and apartments for rent Cedar Fork
Rent house in Gold Hill North Carolina and homes for rent
Disclose, originate, and look up Candor United States bed and breakfast rentals, Candor United States real estate rentals, and Candor United States apartment rentals.
The Atlantic North Carolina listed properties posted and chronicled on this extensive website, FRBO.com except decadent cottage, suburban cottage, and beach duplex.
Conceive and dig up real estate rentals Iron Station and apartments for rent Iron Station United States.
Ferret out and distinguish homes for rent by owner Brunswick North Carolina, real estate rentals in Brunswick North Carolina, vacation homes Brunswick, and rent house in Brunswick North Carolina.
This webpage does encompass original area resort, loft, and city cottage, duplex, and cottages.
Disclose and uncover Nash North Carolina home rentals, apartment rentals in Nash North Carolina, and Nash vacation rentals.
Notice and light upon rental apartment and Maiden United States rental home.
Ferret out and relocate condo rentals in Yadkinville and Yadkinville vacation homes for rent by owner.
Determine and ascertain vacation homes for rent by owner in Duplin North Carolina and rental houses in Duplin.
Find, debunk, and detect rent house in Craven North Carolina and short term rentals Craven North Carolina.
Atlantic North Carolina is a stunning, excellent, and charming sector with comely, alluring, and statuesque hacienda, cabin, and bungalows.
Find, elicit, and glimpse vacation homes, real estate rentals, vacation homes for rent by owner Henderson, and real estate rentals in Henderson North Carolina.
Determine, come upon, and locate real estate rentals in Tyner United States, Tyner United States rental houses, and rental home Tyner United States.
Hidden ads and loft classified advertisements Burke North Carolina vacation rentals, for rent by owner homes in Burke North Carolina, Burke North Carolina rental properties, and vacation homes for rent by owner in Burke North Carolina.
Devise, uncover, and conceive Creedmoor United States house rentals, homes for rent by owner Creedmoor United States, and Creedmoor rental home.
Determine, catch, and come across Yancey North Carolina rental home and Yancey North Carolina rent houses.
Recognize, distinguish, and recognize holiday rentals in Hoke, Hoke North Carolina rental houses, and rental home in Hoke North Carolina.
See oceanfront listed properties, resort classified ads, beach directories, and beach lists of marked properties that property owners and rental agents post on this site, FRBO.com.
You can determine and elicit bed and breakfast rentals in Atlantic, house rentals in Atlantic North Carolina, and Atlantic North Carolina for rent by owner homes.
This site, FRBO.com holds domain and dominion knowledge, at times.
Join our exotic lists of marked properties, mountain online MLS, resort listings, and hillside listings mailing list for short term rentals in Atlantic North Carolina, bed and breakfast rentals Atlantic, and apartments for rent Atlantic North Carolina.
Ferret out and determine Culberson United States houses for rent and rental properties in Culberson United States.
Move and light upon Yancey North Carolina real estate rentals, vacation rentals Yancey North Carolina, and Yancey North Carolina rent houses.
|
|
