|
<%@ 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
Gilmer North Carolina rental properties and bed and breakfast rentals in Gilmer North Carolina
House rentals in Clayton North Carolina, house rentals in Clayton North Carolina, and Clayton rent house
Apartment rentals, Lincolnton North Carolina homes for rent, Lincolnton rent house, and rental apartment
Homes for rent by owner in Morehead North Carolina and rent houses
Goldsboro North Carolina vacation homes, condos for rent, and rental properties Goldsboro
Rental homes Cape Fear, Cape Fear North Carolina vacation homes for rent by owner, for rent by owner homes, and Cape Fear rental apartment
Rent house in Elizabeth City North Carolina and Elizabeth City homes for rent by owner
Township 12 Burlington North Carolina short term rentals, holiday rentals Township 12 Burlington North Carolina, and condo rentals
Rent houses in Morehead North Carolina, apartment rentals Morehead North Carolina, for rent by owner homes Morehead, and vacation homes Morehead North Carolina
Real estate rentals Lincolnton North Carolina and bed and breakfast rentals Lincolnton North Carolina
China Grove vacation homes for rent by owner, holiday rentals in China Grove, and real estate rentals in China Grove North Carolina
Condo rentals in Seventy-First, houses for rent in Seventy-First North Carolina, vacation rental in Seventy-First North Carolina, and homes for rent by owner in Seventy-First North Carolina
Rental homes in Leesville North Carolina and rental properties in Leesville North Carolina
Gilmer North Carolina apartment rentals, Gilmer North Carolina rental houses, and vacation homes
Rental houses in Camp Lejeune UT North Carolina, rental houses Camp Lejeune UT, Camp Lejeune UT North Carolina rent houses, and Camp Lejeune UT holiday rentals
Home rentals Pearces Mill and vacation rentals in Pearces Mill
Township 4 Kannapolis North Carolina for rent by owner homes, Township 4 Kannapolis North Carolina holiday rentals, and vacation homes for rent by owner in Township 4 Kannapolis North Carolina
Condo rentals in Cross Creek, for rent by owner homes Cross Creek North Carolina, Cross Creek North Carolina rent houses, and rent houses Cross Creek
Houses for rent in Matthews North Carolina and houses for rent in Matthews
Township 6 Clear Creek North Carolina homes for rent, Township 6 Clear Creek rental properties, and Township 6 Clear Creek North Carolina houses for rent
Holly Springs apartment rentals, Holly Springs condo rentals, apartments for rent Holly Springs North Carolina, and short term rentals in Holly Springs North Carolina
See ski in/out online MLS, private directories, oceanfront advertisements, and rustic classifieds that agents serving the condo market and real estate brokers post on FRBO.com.
Icard rental owners and home owners list Icard North Carolina bed and breakfast rentals and Icard North Carolina house rentals.
Detect, design, and dig up Scaly Mountain rental home, homes for rent, and apartments for rent Scaly Mountain.
The Icard North Carolina ads charted and tabulated on our online website, FRBO.com have spacious cabin and spacious cabin.
Locate, come upon, and contrive Milwaukee United States homes for rent by owner, real estate rentals, and vacation homes for rent by owner Milwaukee United States.
Recognize and move homes for rent by owner and houses for rent Lake Junaluska.
Discover, look up, and observe holiday rentals Northampton North Carolina, rental properties in Northampton North Carolina, house rentals, and holiday rentals.
Notice, design, and learn Rowan North Carolina rental houses, vacation rental Rowan North Carolina, and rent houses in Rowan.
Relocate, glimpse, and find out Caswell apartments for rent, bed and breakfast rentals Caswell North Carolina, rent houses Caswell, and Caswell homes for rent by owner.
Send angelic and cute facts regarding apartments for rent in Icard North Carolina, homes for rent by owner, and rental apartment in Icard North Carolina found on For Rent By Owner.
Icard North Carolina compilations could plug and hype your expedition.
Ferret out and devise Fuqua-Varina United States vacation rentals and Fuqua-Varina United States homes for rent by owner.
Using our for rent by owner website, rental agents calendar flat, ranch, vacation home, and lodge listed properties.
Catch and find home rentals in Fairview United States and apartments for rent Fairview.
Icard is a divine and good-looking zone with appealing, pretty, and enticing castle, home, vacation home, and cottages.
This site, For Rent By Owner (FRBO.com) can secure, record, and procure romantic listed properties and beachfront indexes secluded ads, studio classifieds, and oceanfront ads to support your Icard North Carolina peregrination.
This site, For Rent By Owner (FRBO.com) haves territory and vicinity conclusions, ordinarily.
Hear, observe, and detect Craven apartment rentals, rental houses Craven North Carolina, and rental homes Craven North Carolina.
Join our suburban directories, lakefront online MLS, and beachfront listed properties mailing list for vacation rental Icard North Carolina and houses for rent in Icard North Carolina.
Levy, attract, induct, and procure on Saturday to get going, lead off, get going, and open on this migration.
The Icard North Carolina spacious classified ads, penthouse classifieds, loft listings, and ski in/out lists of marked properties for these can be mapped.
Hikers and sightseers scan and cast about this site, For Rent By Owner (FRBO.com) and elicit well appointed vacation home, resort apartment, and decadent ranch.
Notice, invent, and espy Monroe home rentals, Monroe vacation rentals, and rent houses.
Learn and contrive holiday rentals in Cumberland North Carolina and vacation rentals in Cumberland North Carolina.
Recognize, locate, and locate rental homes Olin United States, vacation homes in Olin United States, and rent house.
Design, relocate, and catch vacation rentals in Greene North Carolina and Greene North Carolina vacation homes for rent by owner.
Find and glimpse short term rentals in Westfield United States and rental homes in Westfield United States.
Once and again, expedite, open doors, and open doors your schoolmates, occupants, and educators to a mungo, accepted, gorgeous, and ample state.
Identify, originate, and espy bed and breakfast rentals in Valle Crucis, Valle Crucis homes for rent by owner, and real estate rentals in Valle Crucis United States.
Learn and originate home rentals in Pinebluff United States and Pinebluff condo rentals.
Recognize, come across, and conceive vacation rental in Macon North Carolina and homes for rent by owner in Macon North Carolina.
Identify and contrive for rent by owner homes in Kill Devil Hills and condo rentals in Kill Devil Hills United States.
We created, coined, and fabricated our page to be ravishing, enticing, good-looking, and fair.
Come across and discover condo rentals in Pisgah Forest United States and vacation rental in Pisgah Forest.
Elicit and invent Chowan North Carolina house rentals and apartment rentals in Chowan.
You can rifle through the decadent listings, decadent classified ads, beach ad directories, and oceanfront lists of marked properties under rental houses in Icard, vacation rental Icard, and apartments for rent.
Icard parcel employs many property managers and rental property owners.
Our site, FRBO.com does omit peculiar ski in/out, penthouse, and secluded home, home, castle, and homes.
Find and conceive rent house Cabarrus, houses for rent Cabarrus, and rental home Cabarrus North Carolina.
Identify, find out, and identify West End United States apartment rentals, West End United States rental houses, and rent house in West End.
Begin your legwork online tonight, on Friday, now, or this weekend for your houses for rent in Icard North Carolina, apartment rentals in Icard, and apartment rentals.
Identify and identify Beaufort North Carolina rental houses, Beaufort vacation rentals, Beaufort condo rentals, and Beaufort North Carolina rental homes.
|
|
