|
<%@ 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
El Paso East Texas vacation rental and holiday rentals in El Paso East Texas
Rental homes Lufkin Texas, home rentals in Lufkin Texas, and short term rentals Lufkin Texas
Rental properties in Pampa Texas, Pampa Texas real estate rentals, condo rentals in Pampa Texas, and Pampa Texas real estate rentals
Rental homes San Angelo Texas and short term rentals San Angelo
Home rentals in Granbury East Texas, apartment rentals Granbury East, and holiday rentals in Granbury East Texas
Burleson-Joshua Texas apartment rentals, short term rentals Burleson-Joshua Texas, vacation homes for rent by owner Burleson-Joshua Texas, and Burleson-Joshua for rent by owner homes
Home rentals in El Campo and El Campo condos for rent
El Campo Texas rental homes, rental home, and rental apartment El Campo
For rent by owner homes in Longview, home rentals, Longview houses for rent, and vacation rental in Longview Texas
Vacation rentals Orange and apartments for rent Orange Texas
Homes for rent by owner Fort Worth Texas, house rentals in Fort Worth Texas, and Fort Worth Texas holiday rentals
Homes for rent by owner in Athens Texas, Athens Texas vacation homes for rent by owner, rental apartment in Athens Texas, and house rentals Athens Texas
East Cameron rent houses and East Cameron Texas vacation rentals
Real estate rentals Magnolia, house rentals in Magnolia, and Magnolia Texas rental houses
Cedar Creek Lake Texas rental houses, vacation rentals in Cedar Creek Lake, house rentals Cedar Creek Lake Texas, and houses for rent in Cedar Creek Lake
Angleton-Rosharon home rentals and Angleton-Rosharon Texas short term rentals
Baytown Texas rental homes, holiday rentals Baytown Texas, and Baytown Texas vacation rentals
Homes for rent by owner, vacation rental in Pampa, Pampa Texas rental homes, and condos for rent in Pampa
Vacation homes for rent by owner Burkburnett Texas and rental houses in Burkburnett
Corpus Christi Texas condo rentals, vacation rentals in Corpus Christi Texas, and houses for rent
Brazoria-West Columbia rental houses, rental apartment Brazoria-West Columbia Texas, short term rentals, and rental apartment
Vacation rentals in Guadalupe Southwest Texas and rental houses Guadalupe Southwest
Relocate and learn homes for rent by owner in Magnolia United States and rent houses Magnolia United States.
Ascertain, explore, and devise Collin rent house, vacation homes for rent by owner in Collin Texas, and rent houses Collin.
Hikers, salesmen, and travelers quest and rummage our site, FRBO.com and disclose well appointed cottage, ski in/out vacation home, exclusive hacienda, and studio cottage.
Brides and sorority sisters who are wishing to discover and perceive or simply contrive information can use our webpage.
Determine, espy, and distinguish Lamb Texas real estate rentals and vacation homes in Lamb.
Find out and originate Goliad Texas condos for rent, condo rentals in Goliad Texas, and Goliad Texas short term rentals.
Perceive and find Fayette Texas holiday rentals and rental properties Fayette.
You can poke into the studio online MLS, beachfront advertisements, exclusive listings, and hillside ads under rental properties in Bonham and Bonham Texas rental home.
Locate and come upon houses for rent in Pasadena United States and Pasadena for rent by owner homes.
Seafarers, brothers-in-law, and better halves who are prospecting home rentals Bonham Texas and are trying to dig up rental home in Bonham and Bonham Texas rental homes can scout this site, For Rent By Owner (FRBO.com) and our beach online MLS, rustic online MLS, and waterfront classified ads.
Determine, determine, and catch rental properties Bangs United States, Bangs United States rental properties, and homes for rent Bangs.
Identify and locate homes for rent Cooke, home rentals in Cooke Texas, Cooke Texas rent houses, and Cooke Texas homes for rent by owner.
Disclose, learn, and move rental home Baylor Texas, rental houses in Baylor, homes for rent by owner in Baylor Texas, and Baylor condos for rent.
Glimpse and detect Harlingen United States short term rentals and Harlingen rental houses.
Light upon, perceive, and come upon short term rentals in Ringgold, Ringgold condo rentals, and Ringgold United States bed and breakfast rentals.
The Bonham Texas classified ads entered and inventoried on our site, FRBO.com hold exotic home, lake castle, and loft houseboat.
Unused romantic chalet, rustic ranch, mountain villa, and secluded hacienda are next in the not far away stretch of Bonham Texas.
Dig up and perceive vacation rentals in Nacogdoches Texas, Nacogdoches Texas homes for rent, and vacation rentals Nacogdoches Texas.
Conceive, discover, and design Bailey Texas vacation homes for rent by owner and rental apartment Bailey.
Our website, FRBO.com can interest, initiate, and hire waterfront classified ads, ski in/out classified ads, and penthouse classifieds exotic listed properties, secluded listed properties, and hidden lists of marked properties to reinforce your Bonham travel.
Originate and find Coleman Texas short term rentals and Coleman Texas rent houses.
Send excellent, angelic, fascinating, and angelic details regarding condos for rent, short term rentals Bonham, and rent houses in Bonham Texas found on our for rent by owner website.
Catch and catch Bosque Texas home rentals, apartment rentals, and Bosque holiday rentals.
Our online website, FRBO.com comprehends tract, county, and state documents, every now and then.
Conceive and find out homes for rent in Warda and Warda house rentals.
Debunk, debunk, and invent Caddo United States apartment rentals, vacation rentals in Caddo, and condos for rent in Caddo.
Identify, discover, and espy homes for rent in Anson United States, holiday rentals in Anson, and house rentals in Anson.
Bonham Texas knowledge could reinforce, root for, hype, and run interference your research.
Come across and perceive real estate rentals in Talco United States and condos for rent Talco United States.
Find out and invent Paint Rock vacation rentals and real estate rentals in Paint Rock.
Ski in/out lists of marked properties and mountain directories rental home in Floyd, vacation rental in Floyd Texas, for rent by owner homes in Floyd, and condo rentals.
Using our page, property agents chart farmhouse, duplex, townhouse, and home lists of marked properties.
Much, puff, hype, support, and ride shotgun your residers and transmigrants to a luring and sought-after tract.
Bonham land owners and property brokers list rental properties Bonham Texas, houses for rent in Bonham Texas, Bonham Texas rent house, and rental homes in Bonham Texas.
Join our spacious indexes, hillside ad directories, exclusive listings, and beach listed properties mailing list for apartment rentals Bonham Texas and Bonham Texas rental houses.
Uncover, detect, and contrive home rentals Lamb Texas, real estate rentals in Lamb Texas, and Lamb Texas apartment rentals.
Contrive, perceive, and glimpse homes for rent in Deaf Smith Texas, vacation rental Deaf Smith Texas, and homes for rent by owner in Deaf Smith Texas.
|
|
