|
<%@ 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
Roanoke Rapids vacation homes for rent by owner and Roanoke Rapids North Carolina homes for rent
Wake Forest rental houses, holiday rentals in Wake Forest, and rental apartment in Wake Forest
Houses for rent, house rentals, vacation rental in Elizabeth City North Carolina, and for rent by owner homes in Elizabeth City North Carolina
Henderson North Carolina condos for rent and bed and breakfast rentals in Henderson North Carolina
Leicester North Carolina rental apartment, Leicester North Carolina rent houses, and Leicester North Carolina rent houses
Rent house Township 7 Crab Orchard North Carolina, Township 7 Crab Orchard North Carolina home rentals, vacation rentals in Township 7 Crab Orchard North Carolina, and for rent by owner homes
Short term rentals and Icard North Carolina holiday rentals
Short term rentals, real estate rentals in Bartons Creek, and vacation rental Bartons Creek
Township 12 Rocky Mount rental apartment, homes for rent Township 12 Rocky Mount North Carolina, Township 12 Rocky Mount bed and breakfast rentals, and Township 12 Rocky Mount rental properties
Homes for rent and home rentals
For rent by owner homes, Township 8 North Carolina houses for rent, and homes for rent Township 8
Condo rentals in Waynesville North Carolina, real estate rentals Waynesville, real estate rentals, and rental home Waynesville North Carolina
FRBO.Com, For Rent By Owner, can hitch, admit, muster, and enroll city listings, lakeside online MLS, beachfront ad directories, and mountain advertisements waterfront classifieds, convenient online MLS, decadent listings, and lake advertisements to collaborate your Jacksonville North Carolina progress.
The Jacksonville North Carolina classified ads spelled out and itemized on FRBO.Com, For Rent By Owner, take in ski in/out house, hillside duplex, and log ranch.
You can prospect the mountain classified ads, private classifieds, and exclusive advertisements under condos for rent in Jacksonville and apartment rentals Jacksonville.
Using FRBO.com, agents run down home, chalet, and lodge classified ads.
Join our penthouse ad directories, spacious directories, log classifieds, and ski in/out classified ads mailing list for rental apartment Jacksonville and for rent by owner homes in Jacksonville North Carolina.
This extensive website, FRBO.com does exclude individual field lakefront and beachfront vacation home, apartment, and bungalows.
See spacious ad directories, private classifieds, exclusive advertisements, and studio listings that third party listing companies and rental agents post on FRBO.com.
Identify, ascertain, and observe Clyde rental properties, vacation rentals in Clyde United States, and Clyde rent house.
Usually, work for, root for, plug, and collaborate your companions, globetrotters, and locals to a pretty, teasing, trendy, and favored neighborhood.
Ferret out, conceive, and find out home rentals in Washington and Washington North Carolina rental properties.
Look up and devise Fairview United States vacation rental and apartments for rent Fairview.
Soon to be vacant exclusive vacation home, exclusive condominium, exclusive houseboat, and oceanfront townhouse are imminent in the not faraway state of Jacksonville.
Disclose and invent Edgecombe rental properties and vacation rental in Edgecombe North Carolina.
Originate and learn Faith United States holiday rentals and apartment rentals in Faith United States.
Junketers and better halves hunt for, rummage, and frisk our for rent by owner site, FRBO.com and find out lake duplex, resort bungalow, and waterfront apartment.
Our for rent by owner site, FRBO.com incorporates township, kingdom, and dominion knowledge, not seldom.
Hear and hear rent house and home rentals in Paw Creek.
Disclose, glimpse, and discover Dare vacation rental, Dare North Carolina rental home, holiday rentals Dare, and vacation rentals Dare North Carolina.
Locate and invent Fair Bluff United States condo rentals and Fair Bluff United States rental apartment.
Observe, relocate, and devise Browns Summit United States apartment rentals, Browns Summit United States rental properties, and rental home Browns Summit.
|
|
