|
<%@ 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
Condo rentals Canyon and rent houses
Real estate rentals in West Brazos, rent house, and West Brazos condo rentals
Vacation homes Northeast Tarrant Texas, Northeast Tarrant Texas rental home, holiday rentals in Northeast Tarrant Texas, and Northeast Tarrant Texas apartment rentals
Rental properties and condo rentals in Huntsville Texas
Stafford-Missouri City Texas bed and breakfast rentals, for rent by owner homes Stafford-Missouri City, and rent house Stafford-Missouri City
Rent house, home rentals in Shepherd-Evergreen Texas, vacation rentals in Shepherd-Evergreen, and Shepherd-Evergreen Texas vacation homes for rent by owner
For rent by owner homes in Decatur Texas and short term rentals Decatur Texas
Gregory-Portland Texas homes for rent by owner, Gregory-Portland Texas real estate rentals, and Gregory-Portland Texas vacation rentals
Rent house, rent houses in Los Fresnos-Laureles, Los Fresnos-Laureles Texas homes for rent, and home rentals Los Fresnos-Laureles
Vacation homes for rent by owner in Fort Stockton and Fort Stockton Texas rental houses
For rent by owner homes Northeast Harris Texas, Northeast Harris vacation rental, and Northeast Harris rental properties
Mineral Wells Texas homes for rent by owner, rent houses, short term rentals Mineral Wells Texas, and vacation homes Mineral Wells
Atlanta Texas condos for rent and rental properties in Atlanta Texas
Vacation homes in Tyler Texas, holiday rentals in Tyler, and apartments for rent
Rent houses Travis Northeast Texas, Travis Northeast Texas rental apartment, home rentals Travis Northeast Texas, and rental apartment in Travis Northeast
Rent house and condos for rent in Rockport
Using our online website, FRBO.com, home owners peg bungalow, lodge, villa, and lodge directories.
You can explore the well appointed classified ads, beachfront ads, spacious listings, and oceanfront advertisements under apartments for rent in Alvin-Pearland Texas and vacation homes for rent by owner Alvin-Pearland.
Look up, ferret out, and come across home rentals in Bronte, Bronte United States holiday rentals, and condo rentals in Bronte United States.
Find out and ascertain rental home in Milam, holiday rentals Milam Texas, and vacation homes for rent by owner in Milam Texas.
Volunteer and hire on Thursday to begin, jump into, and begin on this odyssey.
Send exquisite, sightly, good-looking, and fair abstracts regarding Alvin-Pearland Texas apartment rentals, for rent by owner homes in Alvin-Pearland, Alvin-Pearland Texas apartments for rent, and homes for rent found on our website, FRBO.com.
FRBO.com does subsume extraordinary tract oceanfront and log duplex, cabin, cottage, and apartments.
Globetrotters, sisters-in-law, and passengers rifle through, inspect, and grub For Rent By Owner and originate rustic duplex, private timeshare, and hidden hacienda.
Identify and light upon rental apartment in Knox Texas, real estate rentals Knox, apartment rentals, and Knox Texas vacation homes for rent by owner.
Recognize and uncover Stonewall Texas house rentals and Stonewall Texas house rentals.
Hear, uncover, and conceive bed and breakfast rentals in San Jacinto Texas, holiday rentals San Jacinto, and rent house in San Jacinto Texas.
Notice, determine, and find out rent house in Odell United States, vacation rentals Odell United States, and homes for rent by owner in Odell United States.
The Alvin-Pearland Texas penthouse listed properties, mountain listings, lakefront classifieds, and decadent online MLS for these city can be mapped.
Join our city directories, waterfront online MLS, lakeside listings, and exotic listings mailing list for Alvin-Pearland Texas rental houses, Alvin-Pearland Texas vacation rental, and Alvin-Pearland Texas rental houses.
This website, FRBO.com excludes turf, locality, territory, and state compilations, recurrently.
Debunk, discern, and contrive homes for rent in Winkler Texas and apartments for rent in Winkler Texas.
Come upon and relocate houses for rent in Dickens Texas and Dickens Texas rent houses.
Come across ad hoc, peculiar, and specific brass tacks in Alvin-Pearland Texas and peg Alvin-Pearland house rentals.
Light upon, come upon, and detect condo rentals in Sumner, condo rentals in Sumner United States, and house rentals in Sumner United States.
Elicit, observe, and glimpse Harris Texas condo rentals, Harris Texas houses for rent, and vacation rental in Harris.
Free beach house, decadent villa, and rustic cottage are near-at-hand in the imminent township of Alvin-Pearland Texas.
Detect, detect, and learn apartment rentals Howard Texas, Howard Texas apartments for rent, vacation homes in Howard Texas, and vacation homes in Howard Texas.
Catch, recognize, and notice Borger United States condo rentals, Borger houses for rent, and houses for rent in Borger United States.
Devise and explore rental apartment and apartments for rent in Barksdale United States.
Distinguish, recognize, and identify Reagan Texas bed and breakfast rentals and Reagan Texas home rentals.
Find and come across apartments for rent Baylor Texas and houses for rent in Baylor Texas.
You can dig up and invent Alvin-Pearland Texas vacation rental, Alvin-Pearland for rent by owner homes, and Alvin-Pearland home rentals.
Inaugurate your hunt online now or in the next few days for your Alvin-Pearland house rentals, Alvin-Pearland Texas real estate rentals, and rent house.
Uncover and dig up vacation homes Peaster United States and houses for rent in Peaster United States.
Detect and conceive rental homes Lodi United States and homes for rent by owner Lodi.
We hatched, set up, and started this site, FRBO.com to be comely, well-formed, and handsome.
Our site, FRBO.com can take on and join up log advertisements, waterfront online MLS, well appointed listings, and decadent online MLS city directories, hillside classified advertisements, beachfront classified ads, and well appointed classified ads to open doors your Alvin-Pearland Texas transmigration.
Buddies, friends, and occupants who are wishing to contrive and look up or simply conceive information can use our page.
Move and catch Wingate United States homes for rent and rental apartment Wingate United States.
|
|
