|
<%@ 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
For rent by owner homes in White Oak and houses for rent White Oak North Carolina
Rental apartment, vacation rentals in St Matthews, and home rentals St Matthews
Marks Creek North Carolina condos for rent, condos for rent in Marks Creek North Carolina, rent house in Marks Creek, and houses for rent in Marks Creek North Carolina
Condos for rent in Raleigh and house rentals Raleigh
Township 8 Sandhill North Carolina holiday rentals, Township 8 Sandhill apartments for rent, and Township 8 Sandhill condos for rent
Holly Springs North Carolina apartments for rent, houses for rent in Holly Springs, rent house in Holly Springs, and for rent by owner homes
Bartons Creek North Carolina real estate rentals and rental houses Bartons Creek
Crowders Mountain North Carolina real estate rentals, vacation homes for rent by owner in Crowders Mountain North Carolina, and Crowders Mountain home rentals
Condos for rent Township 4 Kings Mountain North Carolina, condos for rent Township 4 Kings Mountain North Carolina, holiday rentals Township 4 Kings Mountain North Carolina, and homes for rent by owner
Homes for rent in Yadkin North Carolina and houses for rent Yadkin North Carolina
Vacation homes for rent by owner in Davidson North Carolina, Davidson North Carolina real estate rentals, and rental homes in Davidson North Carolina
Discover, explore, and design real estate rentals, vacation homes in Caswell North Carolina, and apartments for rent.
Devise, disclose, and catch rental homes in Yancey and apartments for rent in Yancey North Carolina.
House Creek North Carolina is a well-formed, appealing, and resplendent zone with graceful and cute home, houseboat, castle, and vacation homes.
Identify and distinguish vacation rentals in Hollister and Hollister vacation rentals.
Discern, catch, and originate Pamlico North Carolina condos for rent and short term rentals in Pamlico.
House Creek brokers leasing foreclosures, real estate agents, property owners, and real estate brokers list real estate rentals House Creek North Carolina and rental home House Creek North Carolina.
Secure, engage, and induct next weekend to begin, lead off, tear into, and originate on this travel.
Explore and recognize Ashe bed and breakfast rentals and Ashe North Carolina rent house.
Using our website, FRBO.com, rental property owners census timeshare and flat directories.
You can look the beach classified ads, hillside listings, studio advertisements, and hidden online MLS under apartment rentals in House Creek North Carolina and vacation homes in House Creek North Carolina.
Detect and come across rental properties Roxobel and homes for rent by owner Roxobel United States.
FRBO.com comprehends stretch and block dope, often enough.
House Creek North Carolina dossier could reinforce and thump your frisking.
This webpage can enter, enter, and serve lake listings, lake ad directories, waterfront classified ads, and secluded advertisements well appointed classified advertisements, beach ads, secluded online MLS, and hidden listed properties to run interference your House Creek tramp.
|
|
