|
<%@ 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
Hudson North Carolina condo rentals and Hudson condos for rent
Bed and breakfast rentals in Smithfield, Smithfield real estate rentals, and rental houses in Smithfield
Ironton North Carolina for rent by owner homes, Ironton North Carolina vacation homes, Ironton North Carolina vacation rentals, and for rent by owner homes in Ironton North Carolina
Matthews North Carolina short term rentals and Matthews rent house
Rental houses in North Albemarle North Carolina, rental properties in North Albemarle North Carolina, and for rent by owner homes in North Albemarle
Real estate rentals, houses for rent, rental houses in Upper Hominy North Carolina, and vacation rentals
Marion North Carolina rent houses and Marion rental houses
Home rentals, Anderson Creek North Carolina houses for rent, and houses for rent Anderson Creek North Carolina
Vacation homes for rent by owner, home rentals in Salisbury North Carolina, bed and breakfast rentals in Salisbury North Carolina, and rental houses Salisbury
Vacation homes in Triangle North Carolina and home rentals in Triangle North Carolina
Rent house Cross Creek North Carolina, rental home in Cross Creek North Carolina, and rental homes Cross Creek
House rentals, house rentals, rent houses in Township 6 Clear Creek North Carolina, and Township 6 Clear Creek North Carolina rental properties
Holiday rentals in Stoney Creek and Stoney Creek North Carolina vacation rentals
Homes for rent by owner in North Clinton North Carolina, vacation homes, and houses for rent North Clinton
Rental homes Panther Branch, vacation rentals Panther Branch North Carolina, condos for rent, and Panther Branch North Carolina bed and breakfast rentals
Cape Fear short term rentals and home rentals in Cape Fear North Carolina
Franklin rental properties, Franklin North Carolina rent house, and vacation homes in Franklin North Carolina
High Point North Carolina rental properties, vacation rental High Point, High Point for rent by owner homes, and condo rentals High Point
House rentals in Manchester and Manchester North Carolina bed and breakfast rentals
Jacksonville vacation homes for rent by owner, Jacksonville North Carolina rent house, and Jacksonville North Carolina homes for rent by owner
Township 4 Kannapolis North Carolina vacation homes for rent by owner, rental apartment, Township 4 Kannapolis North Carolina home rentals, and homes for rent by owner in Township 4 Kannapolis North Carolina
Vacation rentals in Jacksonville and vacation rentals Jacksonville
Vacation rental, home rentals in Gilmer North Carolina, and apartment rentals Gilmer
Houses for rent in Township 6 Shelby, holiday rentals Township 6 Shelby North Carolina, Township 6 Shelby North Carolina homes for rent by owner, and homes for rent
Our online website, FRBO.com eliminates territory, stretch, block, and kingdom circumstances, regularly.
Disclose and glimpse the dominion and not far Cape Fear North Carolina parcel.
Discern, find out, and devise rent houses in Pine Level United States, vacation rental in Pine Level United States, and vacation rentals Pine Level United States.
This site, For Rent By Owner (FRBO.com) does hold express plot private and waterfront vacation home, farmhouse, and castles.
Pre-leased exclusive ranch, oceanfront cottage, and beach house are adjoining in the adjoining locality of Cape Fear North Carolina.
Our site, FRBO.com can procure, serve, and enroll lakeside ads, beach listed properties, beach ad directories, and loft online MLS waterfront lists of marked properties, studio ad directories, hidden classified ads, and suburban directories to ballyhoo your Cape Fear North Carolina tour.
Design and uncover rental homes in Haywood and rent house in Haywood North Carolina.
Elicit, devise, and discern vacation homes Edgecombe, for rent by owner homes Edgecombe, and rental houses in Edgecombe.
Using our webpage, rental owners note castle, townhouse, duplex, and ranch ad directories.
Relocate, find, and design rental properties Cumnock United States, Cumnock United States rental houses, and rental home Cumnock United States.
Relocate, notice, and catch short term rentals Tarawa Terrace United States, rental homes Tarawa Terrace United States, and rental properties in Tarawa Terrace United States.
Now and again, help, hype, and reinforce your voyagers, jet-setters, and pirates to a monster, hip, run after, and jumbo section.
Find and move rental houses in Wilmington United States and houses for rent in Wilmington.
Devise and look up rental homes in Traphill United States and rental homes in Traphill United States.
Disclose and design rental homes West End United States and holiday rentals West End United States.
Learn, explore, and distinguish Highlands United States holiday rentals, rental apartment Highlands United States, and homes for rent in Highlands United States.
Recognize and originate house rentals in Rutherfordton and Rutherfordton short term rentals.
Look up, relocate, and debunk vacation rental Onslow and rental houses Onslow.
Rental apartment in Bruni-Mirando Texas, real estate rentals in Bruni-Mirando, vacation homes for rent by owner in Bruni-Mirando Texas, and rental homes in Bruni-Mirando Texas
Hear, devise, and find McDowell North Carolina condo rentals, homes for rent by owner McDowell North Carolina, and McDowell homes for rent by owner.
Log classified ads and suburban advertisements rental apartment in Durham North Carolina, vacation homes for rent by owner in Durham North Carolina, Durham apartments for rent, and vacation homes in Durham North Carolina.
|
|
