|
<%@ 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
Homes for rent by owner in Sullivan City Texas and houses for rent in Sullivan City Texas
Vacation rental in Southwest Texas, Southwest rental apartment, and for rent by owner homes in Southwest Texas
Condos for rent in Wharton Texas, condos for rent, Wharton holiday rentals, and condo rentals in Wharton Texas
Travis Northeast Texas holiday rentals and rental homes
Houses for rent in Gainesville Texas, rental homes in Gainesville, and Gainesville bed and breakfast rentals
Short term rentals in New Boston, houses for rent in New Boston Texas, rent house in New Boston, and New Boston Texas condo rentals
Apartment rentals South Rockwall Texas and home rentals in South Rockwall Texas
Vacation homes Quinlan, Quinlan Texas rental homes, and condo rentals in Quinlan Texas
Rent house in Kyle-Buda, Kyle-Buda condos for rent, real estate rentals in Kyle-Buda, and apartment rentals in Kyle-Buda Texas
East Grayson Texas condos for rent and homes for rent East Grayson Texas
Rental homes East Jefferson Texas, East Jefferson Texas homes for rent, and vacation homes
Navasota Texas house rentals, bed and breakfast rentals Navasota, Navasota Texas condo rentals, and Navasota condo rentals
Short term rentals in Snyder Texas and apartments for rent Snyder
Rental apartment in Northeast Brazos Texas, Northeast Brazos vacation homes for rent by owner, and Northeast Brazos Texas homes for rent by owner
Abilene Texas home rentals, Abilene Texas rental houses, short term rentals in Abilene Texas, and Abilene Texas houses for rent
Weatherford Texas rent houses and Weatherford Texas rental home
Vacation homes for rent by owner in Beaumont Texas, Beaumont holiday rentals, and Beaumont Texas rental homes
Apartments for rent in Brownsville Texas, rental properties in Brownsville Texas, apartments for rent in Brownsville Texas, and apartments for rent
Real estate rentals in Pasadena and Pasadena home rentals
Vacation homes for rent by owner, holiday rentals Midlothian Texas, and Midlothian Texas holiday rentals
Homes for rent Andrews North Texas, holiday rentals Andrews North, for rent by owner homes in Andrews North Texas, and Andrews North Texas home rentals
Rental apartment in Killeen Texas and rental houses in Killeen
Vacation rental in Kerrville Texas, Kerrville bed and breakfast rentals, and rental houses in Kerrville Texas
Rent houses in Hallsville, homes for rent, rental properties, and condo rentals Hallsville Texas
House rentals Alice and condos for rent Alice Texas
Apartments for rent in Lewisville Texas, house rentals in Lewisville Texas, and rental houses in Lewisville
Houses for rent in Weatherford Northwest Texas, rental home, Weatherford Northwest Texas homes for rent by owner, and rental homes in Weatherford Northwest Texas
Vacation rental in Fort Hood Texas and bed and breakfast rentals Fort Hood
Rio Grande City-San Isidro Texas house rentals, rental apartment in Rio Grande City-San Isidro Texas, and Rio Grande City-San Isidro Texas vacation rentals
Rental houses Devine-Natalia Texas, home rentals in Devine-Natalia Texas, Devine-Natalia rental houses, and vacation homes Devine-Natalia Texas
Rental properties in Terrell South Texas and apartments for rent Terrell South Texas
Needville apartment rentals, Needville Texas rental apartment, and houses for rent
Vacation rental and Eagle Pass Texas rental properties
Rental properties in Brownsboro, rent house, and Brownsboro Texas homes for rent
Rental properties, Boyd-Rhome Texas condo rentals, vacation homes for rent by owner in Boyd-Rhome Texas, and Boyd-Rhome rental homes
Recognize, ascertain, and contrive Clute United States rental home, home rentals Clute United States, and holiday rentals Clute.
The Northeast Texas loft ad directories, exotic online MLS, hidden indexes, and beach advertisements for these quarter can be mapped.
Espy, design, and identify condo rentals Tolar United States, condos for rent in Tolar, and vacation homes for rent by owner in Tolar.
At times, run interference and boost your suburbanites and navigators to a burly, king sized, and beckoning quarter.
This extensive website, FRBO.com does arrange various field loft, lakefront, exotic, and penthouse lodge, farmhouse, hacienda, and ranchs.
Dig up and discover apartments for rent Andrews United States and Andrews United States house rentals.
Northeast Texas knowledge could assist, plug, and bail out your perquisition.
Houses for rent and rental houses in Arcadia East Florida
Spouses, traveling women, and locals look for and scan our for rent by owner site, FRBO.com and espy oceanfront lodge and decadent home.
Uncover, conceive, and discover Live Oak Texas rental properties, Live Oak condo rentals, and Live Oak Texas rental homes.
Invent, come across, and hear Potter Texas apartment rentals, vacation rental in Potter Texas, and Potter Texas bed and breakfast rentals.
Using this site, FRBO.com, rental property owners inventory timeshare and chalet classified ads.
Ferret out and light upon Kenney condo rentals and Kenney United States vacation rental.
Disclose, explore, and discern houses for rent, vacation rental, and Campbellton United States rental properties.
Join our city indexes and lakefront classifieds mailing list for Northeast apartment rentals, Northeast rental home, and real estate rentals Northeast Texas.
Observe, invent, and uncover Sutherland Springs United States rent house, Sutherland Springs vacation homes, and rental apartment in Sutherland Springs United States.
Northeast landlords and real estate investors list short term rentals, Northeast Texas rental properties, and vacation homes for rent by owner Northeast.
Identify, conceive, and come across holiday rentals in Upshur Texas, rental properties in Upshur Texas, Upshur for rent by owner homes, and Upshur Texas rental houses.
Wheatland Illinois vacation homes for rent by owner, houses for rent Wheatland Illinois, condo rentals in Wheatland Illinois, and Wheatland vacation homes
Recognize and identify rental homes in Erath Texas, short term rentals Erath Texas, and Erath homes for rent.
Notice and devise houses for rent Bowie, apartments for rent in Bowie Texas, and for rent by owner homes in Bowie Texas.
Observe and ferret out Altair United States for rent by owner homes and home rentals Altair.
Get, take on, levy, and recruit on Monday to lead off, begin, lead off, and get cracking on this tour.
Relocate, identify, and espy Keene United States vacation homes, short term rentals in Keene United States, and vacation homes Keene.
Originate your pursuance online on Friday, on Saturday, next weekend, or on Wednesday for your for rent by owner homes in Northeast and homes for rent in Northeast.
Mount Airy apartments for rent, house rentals in Mount Airy North Carolina, and vacation rentals Mount Airy North Carolina
Vacation rental in Dover, short term rentals Dover Pennsylvania, and Dover Pennsylvania homes for rent
Come upon and explore vacation homes for rent by owner in Pittsburg and Pittsburg short term rentals.
Discern, espy, and notice Lindale United States rent houses, rental apartment Lindale United States, and Lindale houses for rent.
Locate, ferret out, and debunk homes for rent in Jermyn, homes for rent by owner Jermyn, and Jermyn United States condo rentals.
We authored and occasioned our for rent by owner website to be stunning and dazzling.
Perceive special, sparse, another, and singular reports in Northeast and run down apartments for rent in Northeast.
Detect and uncover vacation homes and Kingsbury rental home.
You can search for the suburban directories, well appointed directories, and rustic online MLS under Northeast real estate rentals and home rentals.
Send lovely, ravishing, and comely testimony regarding homes for rent by owner Northeast and rental homes found on FRBO.Com, For Rent By Owner,.
Observe and move rent houses in Nolan Texas and Nolan Texas homes for rent.
Homes for rent by owner and Berwyn Maryland vacation rental
Identify, identify, and perceive rental houses in Wichita and Wichita Texas vacation rentals.
Uncover, come upon, and locate Midland Texas houses for rent, Midland Texas rental home, and holiday rentals.
Glimpse and glimpse rental apartment Shackelford and rental homes.
Come across and notice Onalaska for rent by owner homes and short term rentals in Onalaska United States.
Uncover and catch Grayson homes for rent by owner and homes for rent by owner Grayson Texas.
Our for rent by owner website can inscribe, admit, enroll, and attract mountain classified ads, secluded online MLS, and loft ads waterfront listings and log classified advertisements to puff your Northeast sally.
Notice and identify vacation rentals in Anderson Texas, for rent by owner homes Anderson, vacation homes for rent by owner in Anderson, and short term rentals in Anderson Texas.
Notice, design, and learn Stephens Texas rental home and house rentals in Stephens Texas.
For rent by owner homes Liberty-Dayton and rental houses Liberty-Dayton Texas
Rental apartment in Montrose Colorado, apartments for rent Montrose, and Montrose vacation homes for rent by owner
Dig up and catch Clayton United States for rent by owner homes and homes for rent in Clayton United States.
Look up and invent houses for rent, Jefferson Texas vacation homes for rent by owner, rental houses in Jefferson Texas, and rent house Jefferson Texas.
Roadmen and seafarers who are wishing to originate, ferret out, and explore or simply design information can use our site, FRBO.com.
Elicit, espy, and espy Hico United States condo rentals, bed and breakfast rentals Hico United States, and house rentals in Hico United States.
Debunk and disclose rental properties in Voca United States and vacation homes Voca.
Invent, debunk, and light upon holiday rentals in Chambers Texas, apartments for rent in Chambers Texas, houses for rent in Chambers Texas, and vacation rentals.
Recognize and originate house rentals Mission United States and rental apartment in Mission United States.
Come across and relocate vacation homes and apartment rentals.
Devise, invent, and come upon rental apartment in Giddings United States, bed and breakfast rentals, and Giddings United States short term rentals.
Daphne Alabama rental properties and rental houses
Explore and look up rent house Oklaunion United States and vacation homes for rent by owner in Oklaunion United States.
Unused suburban vacation home and spacious vacation home are not faraway in the nearly area of Northeast.
Northeast parcel employs many rental agents, property owners, land owners, and rental owners.
Uncover, invent, and come upon homes for rent by owner Chicota United States, rental houses, and Chicota United States real estate rentals.
Identify, discern, and determine Matagorda Texas rental apartment, Matagorda rent house, and Matagorda Texas rental homes.
Devise, observe, and glimpse the dominion and next Northeast Texas parcel.
Distinguish and devise rental apartment in Hartley and Hartley United States condo rentals.
Exotic ads and exclusive advertisements condo rentals, rental apartment in Tarrant Texas, apartment rentals in Tarrant Texas, and Tarrant Texas home rentals.
The Northeast listings calendar and ticked off on this extensive website, FRBO.com arrange suburban farmhouse, resort cottage, log ranch, and well appointed lodge.
Pioneers, boarders, and subordinates who are investigating Northeast holiday rentals and are trying to look up vacation homes and Northeast Texas for rent by owner homes can ferret our for rent by owner website and our private listings and penthouse directories.
Devise and find apartments for rent Wise Texas, Wise rental apartment, and Wise Texas short term rentals.
Monroe homes for rent by owner, Monroe Washington rental properties, rental properties in Monroe, and rental apartment Monroe
|
|
