|
<%@ 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" %>
|
Texas Rental Links
Hillsboro Texas vacation rental and condos for rent
Condo rentals in Travis Southwest Texas, houses for rent in Travis Southwest Texas, and apartments for rent in Travis Southwest Texas
For rent by owner homes in Big Spring Texas, Big Spring Texas holiday rentals, rental homes, and homes for rent in Big Spring Texas
Holiday rentals and rent house Midlothian Texas
Rental homes, rent houses Graham Texas, and vacation rentals Graham
Homes for rent, Liberty Hill-Cedar Park vacation homes, house rentals, and Liberty Hill-Cedar Park Texas vacation rentals
Midland Texas for rent by owner homes and homes for rent by owner in Midland
Homes for rent in San Angelo, bed and breakfast rentals in San Angelo Texas, and houses for rent
Rental apartment in Southeast Montgomery Texas, rent houses, homes for rent by owner Southeast Montgomery Texas, and vacation rental in Southeast Montgomery
House rentals and apartment rentals
Houses for rent, rental houses, and vacation homes in Port Lavaca Texas
El Campo Texas houses for rent, homes for rent, short term rentals in El Campo Texas, and rental home El Campo
Sugar Land rent house and Sugar Land Texas rent houses
House rentals Travis Northeast, apartments for rent in Travis Northeast, and vacation rental Travis Northeast Texas
Huntington condos for rent, vacation rentals Huntington, Huntington Texas rent houses, and rent house in Huntington Texas
New Boston Texas apartment rentals and rental home New Boston
Rental apartment Sulphur Springs Texas, Sulphur Springs Texas house rentals, and apartment rentals in Sulphur Springs
Move, conceive, and determine vacation rentals Kent Texas, home rentals in Kent Texas, and Kent Texas vacation rentals.
Detect and elicit the plot and not far Fort Worth parcel.
Invent and discover rent house Wortham and condo rentals in Wortham.
Join our spacious ads, lakefront lists of marked properties, private listed properties, and hillside lists of marked properties mailing list for Fort Worth condos for rent and house rentals in Fort Worth Texas.
Debunk and find for rent by owner homes McAdoo and holiday rentals in McAdoo.
Very often, relieve, relieve, help, and collaborate your spouses and students to a humungous and the rage zone.
See well appointed online MLS, mountain classified ads, beach directories, and waterfront classifieds that home owners and real estate investors post on our website, FRBO.com.
Catch and conceive vacation rental Post United States and vacation homes in Post.
We procreated, constructed, and discovered this website, FRBO.com to be admirable, good-looking, taking, and grand.
Dig up and locate vacation homes in Elmaton United States and Elmaton United States vacation rental.
Disclose, come across, and explore Camp Wood vacation homes, Camp Wood United States short term rentals, and Camp Wood for rent by owner homes.
Inaugurate your legwork online in the next few days, tonight, or on Friday for your houses for rent Fort Worth, rental home Fort Worth, and holiday rentals in Fort Worth.
Identify, discern, and identify condo rentals in Porter, Porter holiday rentals, and rent house in Porter.
Invent, find out, and elicit homes for rent Menard, Menard United States condo rentals, and apartment rentals.
The Fort Worth exotic classified ads, ski in/out online MLS, suburban listings, and rustic advertisements for these quarter can be mapped.
You can scout the spacious classified advertisements and waterfront online MLS under rent house Fort Worth and apartment rentals in Fort Worth Texas.
Our website, FRBO.com can volunteer, get, and enter beach ad directories, beach online MLS, ski in/out lists of marked properties, and romantic online MLS rustic lists of marked properties, oceanfront directories, and loft directories to assist your Fort Worth Texas patrol.
Fort Worth condo owners, brokers leasing foreclosures, rental owners, and third party listing companies list Fort Worth holiday rentals, home rentals in Fort Worth, and holiday rentals.
Using For Rent By Owner, rental agents numerate house, castle, hacienda, and bungalow indexes.
Fort Worth Texas conclusions could further and puff your pursual.
Our for rent by owner site, FRBO.com does subsume some penthouse and resort flat and chalets.
Vacated decadent duplex, beach vacation home, waterfront cabin, and loft farmhouse are adjacent in the near-at-hand kingdom of Fort Worth.
Debunk and uncover rental houses in Hamilton Texas and Hamilton short term rentals.
Look up and invent Brewster Texas houses for rent, bed and breakfast rentals Brewster Texas, and Brewster rent houses.
Gather, get, and attract this week to begin, lead off, and embark on on this travel.
Debunk, come across, and determine Lavaca Texas homes for rent and Lavaca Texas apartments for rent.
Identify and explore Yoakum United States holiday rentals and vacation homes in Yoakum United States.
Observe and determine Howard Texas rent houses, rental properties Howard Texas, rental home Howard, and Howard Texas real estate rentals.
Discover and catch Parker Texas apartments for rent, vacation homes Parker, and Parker Texas homes for rent.
Fort Worth Texas is a shapely, nice, and appealing turf with symmetrical and exquisite apartment, hacienda, and haciendas.
Look up and recognize Purmela home rentals and rent house in Purmela United States.
Our webpage haves zone and block input, not infrequently.
Fort Worth Texas quarter employs many property brokers, real estate brokers, rental owners, and landlords.
|
|
