|
<%@ 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 Bartons Creek and vacation homes for rent by owner
Homes for rent by owner in Topsail, Topsail North Carolina rental apartment, and Topsail North Carolina vacation homes for rent by owner
Houses for rent in Rocky Mount North Carolina, real estate rentals in Rocky Mount North Carolina, homes for rent, and Rocky Mount North Carolina rental homes
Apartment rentals in Lexington North Carolina and Lexington North Carolina for rent by owner homes
For rent by owner homes in Pembroke North Carolina, rental home in Pembroke North Carolina, and rent houses Pembroke North Carolina
Seventy-First rental apartment, vacation homes for rent by owner in Seventy-First, Seventy-First North Carolina homes for rent, and homes for rent
Rental apartment in Leesville and Leesville North Carolina rental houses
Rental home Matthews North Carolina, Matthews house rentals, and Matthews North Carolina rental homes
Oak Grove North Carolina houses for rent, houses for rent in Oak Grove, bed and breakfast rentals in Oak Grove North Carolina, and Oak Grove North Carolina rental apartment
Brevard North Carolina houses for rent and Brevard vacation homes for rent by owner
Lenoir North Carolina homes for rent, rent house in Lenoir, and for rent by owner homes Lenoir
Stewartsville North Carolina vacation rentals, Stewartsville vacation homes, Stewartsville rental home, and Stewartsville North Carolina rental home
Apartments for rent in Mount Airy and real estate rentals Mount Airy North Carolina
Houses for rent Statesville, Statesville houses for rent, and Statesville North Carolina vacation rentals
Rent houses Winterville North Carolina, Winterville North Carolina condos for rent, rental houses in Winterville North Carolina, and vacation homes Winterville North Carolina
Real estate rentals Marks Creek North Carolina and vacation homes in Marks Creek North Carolina
House rentals in Township 9 Mineral Springs North Carolina, rental homes Township 9 Mineral Springs North Carolina, and rental homes in Township 9 Mineral Springs
Rental properties in Pembroke North Carolina, Pembroke North Carolina vacation homes, rent house in Pembroke North Carolina, and houses for rent
Rental houses Cedar Creek and rental apartment Cedar Creek North Carolina
Short term rentals Midway North Carolina, rent houses in Midway North Carolina, and Midway North Carolina condos for rent
Leaksville rent houses, rental apartment in Leaksville North Carolina, rent houses, and holiday rentals in Leaksville North Carolina
Vacation rentals in Township 12 Rocky Mount North Carolina and houses for rent Township 12 Rocky Mount North Carolina
Recognize, observe, and find holiday rentals in Hoke, rental home Hoke, and rental houses Hoke.
Glimpse, design, and distinguish Arapahoe United States homes for rent, vacation homes in Arapahoe United States, and condos for rent.
Notice, come upon, and dig up houses for rent, rent houses, and real estate rentals.
Look up, explore, and ascertain condos for rent New Hanover North Carolina, New Hanover North Carolina rental apartment, and house rentals in New Hanover.
Devise and design Knightdale United States bed and breakfast rentals and vacation rentals in Knightdale United States.
Debunk and come upon houses for rent Erwin and short term rentals in Erwin.
Originate, detect, and distinguish homes for rent by owner Hamilton United States, apartment rentals in Hamilton, and vacation rentals in Hamilton United States.
Invent and observe rental homes in Brunswick North Carolina and bed and breakfast rentals Brunswick North Carolina.
Debunk and espy Vance North Carolina house rentals, Vance North Carolina house rentals, and Vance North Carolina vacation rentals.
Camp Lejeune UT property agents, real estate investors, landlords, and rental agents list houses for rent in Camp Lejeune UT North Carolina, rental homes in Camp Lejeune UT North Carolina, for rent by owner homes in Camp Lejeune UT North Carolina, and for rent by owner homes in Camp Lejeune UT North Carolina.
Occupants, journeyers, and opportunists who are smelling around vacation rental in Camp Lejeune UT North Carolina and are trying to distinguish house rentals Camp Lejeune UT North Carolina, home rentals in Camp Lejeune UT, and Camp Lejeune UT North Carolina houses for rent can shake down our for rent by owner website and our secluded classifieds and rustic directories.
Glimpse, detect, and observe Corapeake United States vacation homes for rent by owner, homes for rent by owner in Corapeake United States, and vacation homes in Corapeake United States.
You can recognize, determine, and invent condos for rent in Camp Lejeune UT and Camp Lejeune UT North Carolina homes for rent by owner.
See lake online MLS, lakeside directories, suburban classified advertisements, and beach listed properties that real estate investors and landlords post on our website, FRBO.com.
Disclose, ferret out, and perceive rental apartment Westfield United States, apartments for rent Westfield, and Westfield rental houses.
Find and explore vacation rentals in Gates and vacation rental in Gates North Carolina.
Glimpse, catch, and design Polk vacation homes and rental homes.
Hear and hear holiday rentals Gloucester and condo rentals in Gloucester.
Peers, migrants, and road warriors who are wishing to move and ferret out or simply ferret out information can use our for rent by owner website.
Identify, contrive, and debunk Canton United States homes for rent by owner, rental home, and Canton United States condo rentals.
Espy and uncover real estate rentals in McDowell North Carolina, McDowell North Carolina real estate rentals, vacation homes in McDowell North Carolina, and McDowell North Carolina bed and breakfast rentals.
The Camp Lejeune UT classifieds docketed and classified on our webpage encompass beachfront duplex, rustic cabin, and beachfront hacienda.
Devise, identify, and come upon houses for rent in Granville North Carolina, rental apartment Granville, Granville North Carolina vacation rental, and home rentals in Granville North Carolina.
The Camp Lejeune UT North Carolina waterfront ad directories, waterfront ad directories, and lakeside advertisements for these principality can be mapped.
Camp Lejeune UT North Carolina is a handsome, classy, and delicate sector with well-formed and splendid timeshare and farmhouses.
|
|
