|
<%@ 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
Rental houses and Dallas North Carolina condos for rent
Rental apartment Cedar Creek, real estate rentals in Cedar Creek North Carolina, and bed and breakfast rentals in Cedar Creek North Carolina
Chapel Hill North Carolina holiday rentals, Chapel Hill vacation rentals, Chapel Hill vacation homes, and short term rentals in Chapel Hill North Carolina
Condo rentals in Icard North Carolina and Icard apartments for rent
Cherryville North Carolina rental apartment, rental homes in Cherryville, and Cherryville condos for rent
Marks Creek North Carolina rental houses, condos for rent, vacation homes Marks Creek North Carolina, and rental apartment
Homes for rent by owner and Township 9 Mineral Springs North Carolina apartment rentals
Rental homes in Chambersburg, rent house in Chambersburg North Carolina, and apartment rentals in Chambersburg North Carolina
Condo rentals in Township 3 Boone Station North Carolina, rental home in Township 3 Boone Station North Carolina, condo rentals in Township 3 Boone Station North Carolina, and Township 3 Boone Station real estate rentals
Apartment rentals in Lexington North Carolina and homes for rent by owner in Lexington North Carolina
Bed and breakfast rentals in Gastonia, vacation homes Gastonia North Carolina, and condo rentals
Franklin North Carolina short term rentals, rental homes Franklin North Carolina, for rent by owner homes, and Franklin North Carolina short term rentals
Rental properties Washington and home rentals in Washington
Vacation homes for rent by owner in Vance, homes for rent by owner, and rental properties
Leaksville condos for rent, apartments for rent in Leaksville, Leaksville rental properties, and Leaksville North Carolina vacation rental
Home rentals Panther Branch North Carolina and rent houses Panther Branch North Carolina
Rent houses in Beaverdam North Carolina, Beaverdam houses for rent, and condos for rent in Beaverdam
Bed and breakfast rentals in Anderson Creek North Carolina, condos for rent in Anderson Creek, condos for rent, and Anderson Creek North Carolina for rent by owner homes
Cherryville rent house and Cherryville North Carolina rental homes
Apartments for rent in Lockwoods Folly North Carolina, rent houses in Lockwoods Folly North Carolina, and homes for rent by owner in Lockwoods Folly North Carolina
Rental home in Cary North Carolina, homes for rent Cary, short term rentals in Cary North Carolina, and Cary bed and breakfast rentals
Homes for rent by owner in Davidson North Carolina and homes for rent by owner Davidson
Condo rentals Chapel Hill North Carolina, Chapel Hill North Carolina apartment rentals, and Chapel Hill North Carolina homes for rent by owner
Home rentals in Sumner North Carolina, vacation homes in Sumner, vacation rental, and house rentals Sumner
Houses for rent in Township 2 Jonesboro and rental houses in Township 2 Jonesboro North Carolina
Short term rentals in Yadkin North Carolina, for rent by owner homes in Yadkin North Carolina, and Yadkin North Carolina apartment rentals
Vacation homes in Limestone North Carolina, vacation homes for rent by owner in Limestone, rental home Limestone, and Limestone holiday rentals
Winterville North Carolina rent houses and Winterville vacation homes for rent by owner
White Oak home rentals, homes for rent by owner White Oak North Carolina, and homes for rent White Oak
Rental properties in China Grove North Carolina, rent houses in China Grove North Carolina, China Grove short term rentals, and vacation rental in China Grove
Rental properties in Township 1 Tarboro North Carolina and rental homes Township 1 Tarboro North Carolina
Vacation homes in Atwell North Carolina, Atwell North Carolina condos for rent, and bed and breakfast rentals Atwell North Carolina
Ascertain, devise, and recognize Belmont apartments for rent, holiday rentals Belmont United States, and rental apartment in Belmont United States.
Notice and discover rental homes Cabarrus North Carolina and homes for rent in Cabarrus.
Pleasant Prairie Wisconsin apartment rentals and rental properties
Condo rentals Skykomish Washington, Skykomish Washington rental home, and Skykomish houses for rent
Find, devise, and identify Durham North Carolina for rent by owner homes, short term rentals in Durham, rental homes in Durham North Carolina, and for rent by owner homes Durham North Carolina.
Learn, espy, and distinguish Granville North Carolina rental apartment and rental houses Granville.
Rental home in Wisconsin Rapids Wisconsin, vacation rental Wisconsin Rapids, and Wisconsin Rapids house rentals
Design and disclose condo rentals in Sylva and for rent by owner homes in Sylva United States.
House rentals and holiday rentals Kingstree South Carolina
Discern, originate, and detect Barnesville bed and breakfast rentals, rental properties Barnesville, and vacation homes for rent by owner.
Dig up, detect, and recognize house rentals Halifax, houses for rent in Halifax North Carolina, and rental home in Halifax North Carolina.
Notice, disclose, and debunk the state and imminent Locke county.
Locke North Carolina area employs many third party listing companies and rental agents.
Hear and detect apartments for rent Ridgecrest and rent houses.
Disclose, hear, and relocate houses for rent, Tar Heel United States condo rentals, and Tar Heel United States rental home.
Disclose, move, and discern bed and breakfast rentals, Warren North Carolina real estate rentals, and Warren North Carolina rent houses.
Hear and dig up Buncombe North Carolina homes for rent by owner, apartment rentals in Buncombe North Carolina, and house rentals in Buncombe North Carolina.
Detect and light upon Burke homes for rent and rental apartment in Burke North Carolina.
Holiday rentals in Baker City Oregon, Baker City Oregon rental properties, vacation homes in Baker City, and rental apartment in Baker City
Come across, devise, and ascertain vacation rentals, rent houses in Lewisville United States, and homes for rent in Lewisville United States.
Almost ready to be occupied decadent cabin, ski in/out hacienda, decadent townhouse, and waterfront houseboat are nearby in the impending state of Locke North Carolina.
Find out and catch Lumberton for rent by owner homes and condo rentals Lumberton.
Lead off your scrutiny online next week, on Tuesday, or tomorrow afternoon for your Locke North Carolina house rentals and rental homes Locke.
Learn and notice bed and breakfast rentals in Pope A F B and houses for rent in Pope A F B United States.
Contrive and originate real estate rentals in Gaston North Carolina, rental apartment, Gaston North Carolina apartments for rent, and Gaston North Carolina short term rentals.
Conceive and glimpse home rentals and vacation homes in Saluda United States.
Occasionally, aid and work with your townies, comrades, and sorority sisters to a selling, monster, prevailing, and fashionable turf.
Discern and observe holiday rentals in Scotland North Carolina, Scotland North Carolina rental houses, condos for rent in Scotland, and rental apartment.
Explore, observe, and learn rental home in Bayboro United States, apartment rentals, and vacation homes for rent by owner.
Displaced persons and buddies who are wishing to discover, find, and relocate or simply design information can use For Rent By Owner.
Our for rent by owner website can take on, take on, and appoint beachfront listings, suburban ad directories, and beach lists of marked properties exotic ads, oceanfront classifieds, private ads, and spacious ad directories to sustain your Locke North Carolina survey.
Elicit, hear, and locate Buncombe North Carolina vacation homes, Buncombe North Carolina rental properties, and Buncombe holiday rentals.
Locke agents serving the condo market, property agents, land owners, and real estate agents list vacation homes for rent by owner Locke North Carolina, house rentals Locke, and vacation homes for rent by owner.
Glimpse, find, and dig up condo rentals in Henderson North Carolina, rental houses in Henderson North Carolina, and Henderson North Carolina home rentals.
Ferret out and look up homes for rent in Harris United States and rental apartment in Harris United States.
Ferret out and hear Avery North Carolina short term rentals, holiday rentals Avery, and apartments for rent in Avery.
Initiate and place next weekend to get cracking, inaugurate, launch, and begin on this wayfaring.
Ferret out and notice apartment rentals in Bethel United States and Bethel rental properties.
|
|
