|
<%@ 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
Cross Creek North Carolina vacation rental and condo rentals in Cross Creek North Carolina
Harnett vacation rental, rental homes Harnett North Carolina, and real estate rentals Harnett North Carolina
Condo rentals in Dallas North Carolina, vacation rentals Dallas North Carolina, Dallas North Carolina vacation homes for rent by owner, and rental houses Dallas
Real estate rentals in Stony Creek North Carolina and apartments for rent Stony Creek
Vacation rentals Elizabeth City North Carolina, Elizabeth City vacation rental, and Elizabeth City rental home
Vacation homes for rent by owner in Clines North Carolina, vacation homes for rent by owner in Clines, vacation homes Clines, and Clines rental home
Holiday rentals Morganton North Carolina and vacation homes in Morganton North Carolina
Vacation rental in Middle Creek North Carolina, rent house in Middle Creek North Carolina, and real estate rentals
Bed and breakfast rentals, homes for rent by owner Henderson North Carolina, homes for rent by owner in Henderson, and apartment rentals Henderson North Carolina
Hudson North Carolina vacation rental and Hudson North Carolina rent house
Bed and breakfast rentals, McLauchlin North Carolina apartments for rent, and rent houses in McLauchlin North Carolina
Vacation homes in Kernersville, bed and breakfast rentals in Kernersville North Carolina, homes for rent, and bed and breakfast rentals in Kernersville North Carolina
Look up, conceive, and espy for rent by owner homes in Forsyth North Carolina, rent houses Forsyth North Carolina, Forsyth North Carolina houses for rent, and holiday rentals in Forsyth North Carolina.
Brothers and commuters who are hunting for Oak Grove North Carolina rent house and are trying to identify rental properties Oak Grove North Carolina and rent houses Oak Grove North Carolina can inspect our for rent by owner site, FRBO.com and our hidden online MLS, beach classified ads, and oceanfront online MLS.
Ferret out and perceive apartments for rent and vacation homes in Chowan North Carolina.
You can devise and disclose rent house and vacation homes Oak Grove.
Admit and enter into tomorrow evening to launch, inaugurate, launch, and embark on on this course.
FRBO.com does except other stretch spacious, suburban, hillside, and well appointed ranch, house, house, and castles.
Observe and devise Hoke rent houses, Hoke North Carolina home rentals, and Hoke North Carolina condos for rent.
The Oak Grove North Carolina classified ads detailed and calendar on this site, For Rent By Owner (FRBO.com) embody private duplex, loft lodge, and log vacation home.
See beach listings and convenient ads that real estate investors and property owners post on For Rent By Owner.
Contrive, light upon, and debunk Hyde vacation rentals, rent houses, and real estate rentals Hyde North Carolina.
Discover, debunk, and originate real estate rentals, Delco United States rental apartment, and Delco United States rental homes.
Look up, determine, and identify rental apartment Camden North Carolina, apartments for rent, and rental properties Camden.
Oak Grove North Carolina kingdom employs many land owners, real estate investors, real estate brokers, and land owners.
Ascertain various and extraordinary memorandums in Oak Grove and write down homes for rent in Oak Grove North Carolina.
Find, observe, and conceive apartment rentals Pender North Carolina, houses for rent Pender North Carolina, Pender homes for rent by owner, and Pender North Carolina vacation rentals.
Waterfront listings and city advertisements rental properties Caswell North Carolina, short term rentals in Caswell, homes for rent, and house rentals Caswell.
Ferret out, debunk, and learn short term rentals in Cherokee United States, apartment rentals in Cherokee United States, and Cherokee United States rental homes.
Uncover, learn, and glimpse for rent by owner homes, Waco United States rent houses, and Waco United States homes for rent by owner.
|
|
