|
<%@ 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
Real estate rentals in Guadalupe North Texas and home rentals Guadalupe North
Alice Texas rental houses, vacation homes for rent by owner Alice Texas, and homes for rent by owner in Alice
Short term rentals Alvarado, Alvarado Texas house rentals, vacation homes for rent by owner in Alvarado Texas, and Alvarado Texas holiday rentals
Houses for rent Paris Texas and Paris Texas condo rentals
Apartment rentals Eagle Pass Texas, homes for rent by owner in Eagle Pass, and vacation homes for rent by owner Eagle Pass
Home rentals in Del Rio, Del Rio Texas apartment rentals, bed and breakfast rentals in Del Rio Texas, and home rentals Del Rio
Real estate rentals in Galveston Texas and Galveston bed and breakfast rentals
Vacation rentals, vacation rental Jasper Texas, and bed and breakfast rentals in Jasper
Short term rentals in Mexia Texas, home rentals in Mexia Texas, Mexia homes for rent by owner, and bed and breakfast rentals Mexia
Rental houses in Lindale Texas and condos for rent in Lindale Texas
Forney Texas condos for rent, vacation homes in Forney Texas, and vacation homes
Hondo condos for rent, house rentals in Hondo, rental apartment Hondo, and Hondo vacation homes
Rental apartment in Zapata and condos for rent
For rent by owner homes in Hillsboro Texas, condos for rent Hillsboro Texas, and rental homes in Hillsboro Texas
West Brazos Texas homes for rent by owner, West Brazos Texas vacation rental, vacation homes in West Brazos Texas, and West Brazos Texas condos for rent
For rent by owner homes in Bowie and houses for rent
Weatherford Southeast bed and breakfast rentals, short term rentals, and vacation homes for rent by owner in Weatherford Southeast Texas
Houses for rent in Lubbock Texas, Lubbock Texas apartment rentals, Lubbock Texas rental apartment, and rental houses
Condo rentals in Palestine Texas and Palestine holiday rentals
Short term rentals Abilene Texas, condo rentals Abilene, and homes for rent by owner in Abilene Texas
Rental home Atlanta Texas, Atlanta Texas bed and breakfast rentals, Atlanta Texas houses for rent, and vacation homes for rent by owner
Midlothian Texas vacation homes and homes for rent in Midlothian Texas
Rental houses in Edinburg, Edinburg rental home, and vacation rental
Apartment rentals Silsbee Texas, Silsbee Texas vacation rentals, Silsbee apartments for rent, and Silsbee Texas apartment rentals
Homes for rent by owner and condos for rent
Homes for rent Mount Pleasant Texas, rental houses Mount Pleasant Texas, and vacation rental
Vacation rental, houses for rent in South Rockwall Texas, real estate rentals in South Rockwall Texas, and rental houses in South Rockwall Texas
Real estate rentals in Moody Texas and short term rentals in Moody Texas
Rental home in Robstown, rental home in Robstown Texas, and Robstown Texas home rentals
Northeast Harris home rentals, rental properties Northeast Harris, rental houses Northeast Harris, and Northeast Harris Texas apartment rentals
Bed and breakfast rentals in Edinburg Texas and vacation rentals Edinburg
Explore and invent bed and breakfast rentals in Covington United States and Covington apartments for rent.
Granbury East conclusions could work with, sustain, stump, and work for your perquisition.
Light upon, identify, and design short term rentals in Hockley Texas, Hockley Texas rental apartment, and Hockley homes for rent.
Every once in a while, work with, sustain, and relieve your fortune-hunters, journeyers, and transmigrants to a brimming, prodigious, oversize, and attractive square.
Uncover, ferret out, and hear vacation homes for rent by owner in Hutchinson, apartment rentals, and Hutchinson Texas rent house.
Come across, notice, and locate home rentals Mico, rental houses in Mico United States, and Mico United States homes for rent by owner.
Explore and explore Gregg Texas rent house and rental apartment Gregg Texas.
Granbury East real estate agents, landlords, real estate agents, and real estate brokers list homes for rent by owner Granbury East, rental homes in Granbury East, and rental homes in Granbury East.
Rental houses Bainbridge Ohio, Bainbridge home rentals, rent houses in Bainbridge Ohio, and rent house in Bainbridge
You can rake the ski in/out advertisements and log advertisements under rental homes in Granbury East Texas and rental homes Granbury East.
Beach ad directories and spacious directories real estate rentals, rental home, Harrison Texas house rentals, and homes for rent Harrison.
Our online website, FRBO.com omits zone and zone brass tacks, generally.
House rentals Exeter and Exeter New Hampshire rent house
Light upon, come upon, and find Jourdanton United States short term rentals, bed and breakfast rentals in Jourdanton United States, and Jourdanton United States for rent by owner homes.
The Granbury East Texas classifieds written down and registered on our online website, FRBO.com except exclusive home and penthouse villa.
Uncover, discover, and perceive La Feria United States condo rentals, La Feria condos for rent, and home rentals in La Feria.
Locate and hear rent house in De Kalb and De Kalb United States rental homes.
Recognize, explore, and look up vacation rental in Normanna, Normanna United States homes for rent, and Normanna United States vacation homes for rent by owner.
Rent house in Hempfield Pennsylvania, rent houses in Hempfield, and vacation rentals in Hempfield Pennsylvania
Detect and perceive rent houses Roby and vacation rental in Roby United States.
You can debunk and distinguish rental properties in Granbury East and Granbury East Texas rental home.
This webpage does embody rare patch waterfront and beach cabin, townhouse, hacienda, and flats.
Citizens and better halves who are rummaging apartments for rent Granbury East Texas and are trying to light upon home rentals Granbury East Texas and homes for rent in Granbury East Texas can study this site, For Rent By Owner (FRBO.com) and our resort classified ads, mountain advertisements, beach online MLS, and loft advertisements.
Drifters, entrepreneurs, and roommates who are wishing to invent and locate or simply find out information can use our for rent by owner site, FRBO.com.
We constituted and concocted this webpage to be alluring, dazzling, and sublime.
Ascertain and identify houses for rent in Zavala and rental properties in Zavala Texas.
Move and invent vacation rental and home rentals.
Identify and recognize holiday rentals Wilson Texas, Wilson Texas apartment rentals, holiday rentals in Wilson Texas, and vacation homes for rent by owner in Wilson Texas.
Come across and recognize Avoca holiday rentals and Avoca rental home.
Devise and move Liberty Texas condo rentals, homes for rent by owner, Liberty Texas condos for rent, and homes for rent in Liberty.
Look up and disclose Matagorda for rent by owner homes and Matagorda United States vacation rentals.
Homes for rent by owner in Pawtucket Rhode Island, Pawtucket Rhode Island apartment rentals, bed and breakfast rentals in Pawtucket Rhode Island, and Pawtucket Rhode Island vacation homes
Move, disclose, and notice Navarro short term rentals, rental houses Navarro, rent houses, and apartments for rent.
Send wonderful, sublime, and superb experiments regarding condo rentals Granbury East and rental homes Granbury East Texas found on this website, FRBO.com.
Elizabeth City North Carolina houses for rent, rent houses in Elizabeth City North Carolina, and rent house Elizabeth City North Carolina
Ascertain and ferret out rental homes and rental apartment.
Inaugurate your wild-goose chase online tonight or this weekend for your Granbury East Texas real estate rentals, bed and breakfast rentals, and Granbury East Texas home rentals.
Detect, detect, and observe bed and breakfast rentals in Pandora United States, rent house Pandora, and for rent by owner homes.
Come upon, conceive, and discover homes for rent by owner Hood, rent house in Hood Texas, rental apartment Hood Texas, and Hood Texas homes for rent.
Identify, recognize, and contrive holiday rentals Dickens, apartment rentals, and homes for rent by owner in Dickens Texas.
|
|
