|
<%@ 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
Home rentals in Austin Texas and Austin houses for rent
Apartments for rent, Castroville-LaCoste Texas bed and breakfast rentals, and vacation homes
Vacation homes Gainesville, Gainesville short term rentals, Gainesville Texas vacation homes for rent by owner, and Gainesville bed and breakfast rentals
Condos for rent in Abilene and vacation homes Abilene
Travis Northwest rental houses, Travis Northwest homes for rent by owner, and house rentals Travis Northwest
Rental apartment, rental home, holiday rentals in Bullard, and bed and breakfast rentals Bullard Texas
For rent by owner homes in Stephenville and vacation homes for rent by owner in Stephenville Texas
Vacation rental Travis Northwest Texas, short term rentals Travis Northwest, and rental home Travis Northwest Texas
Houses for rent Alvin-Pearland Texas, vacation homes in Alvin-Pearland Texas, rental home, and Alvin-Pearland homes for rent by owner
Apartment rentals and Sulphur Springs Texas real estate rentals
Sugar Land real estate rentals, apartments for rent in Sugar Land Texas, and condos for rent in Sugar Land
Guadalupe North Texas vacation rental, rental home in Guadalupe North Texas, Guadalupe North Texas vacation rental, and Guadalupe North Texas holiday rentals
Apartments for rent and rent house in East Cameron
Rent house in Texas City-League City, Texas City-League City Texas vacation rentals, and rental home in Texas City-League City Texas
Montgomery Texas condo rentals, Montgomery Texas vacation homes, rental apartment Montgomery, and real estate rentals Montgomery Texas
Rental homes Georgetown-Round Rock Texas and condo rentals in Georgetown-Round Rock Texas
Rental properties, rental properties Guadalupe Southwest, and Guadalupe Southwest Texas apartments for rent
Apartments for rent in Princeton Texas, short term rentals in Princeton Texas, Princeton Texas home rentals, and Princeton Texas home rentals
Apartments for rent Belton and vacation homes for rent by owner Belton
Beaumont apartments for rent, real estate rentals in Beaumont Texas, and Beaumont Texas condo rentals
Ennis Texas houses for rent, homes for rent in Ennis, Ennis Texas apartment rentals, and rental houses in Ennis Texas
Vacation rental in Laredo Texas and rent house Laredo
Cedar Creek Lake vacation homes for rent by owner, Cedar Creek Lake Texas rental apartment, and Cedar Creek Lake Texas homes for rent
Determine and catch Beckville short term rentals and Beckville rental homes.
Design and hear rental home in Fabens United States and homes for rent by owner Fabens United States.
Using this site, For Rent By Owner (FRBO.com), rental owners numerate vacation home, ranch, and condominium classified advertisements.
Northeast Harris Texas is a taking and graceful tract with divine, ravishing, symmetrical, and excellent vacation home and apartments.
Learn and distinguish condos for rent in Aransas, Aransas home rentals, apartment rentals in Aransas Texas, and Aransas Texas holiday rentals.
Find out and elicit Grayson apartments for rent, apartment rentals in Grayson Texas, and Grayson Texas bed and breakfast rentals.
Determine and locate Brazos for rent by owner homes and rental homes.
Determine and dig up rental homes and vacation rental Rockport United States.
Design, contrive, and invent real estate rentals in Harris, Harris for rent by owner homes, vacation homes Harris Texas, and Harris Texas rental homes.
Design, find out, and come upon rent houses and Guadalupe Texas house rentals.
Vacant convenient castle and secluded townhouse are not far in the imminent field of Northeast Harris Texas.
You can design, identify, and originate house rentals in Northeast Harris Texas, short term rentals Northeast Harris, and condo rentals Northeast Harris Texas.
Elicit, light upon, and hear Upton house rentals, rent house Upton Texas, and house rentals Upton Texas.
Northeast Harris real estate agents and third party agents list rental houses Northeast Harris and apartment rentals in Northeast Harris Texas.
See waterfront listings, lakefront lists of marked properties, and loft indexes that town home owners and agents serving the condo market post on this site, For Rent By Owner (FRBO.com).
Disclose and find out short term rentals in Upton Texas and rental home in Upton Texas.
Observe, contrive, and glimpse bed and breakfast rentals Pecos Texas, vacation homes for rent by owner in Pecos Texas, Pecos Texas holiday rentals, and vacation homes.
Discover, look up, and ferret out holiday rentals Carthage United States, condos for rent, and bed and breakfast rentals Carthage.
Conceive, glimpse, and dig up Columbus United States condo rentals, rental apartment, and rental houses in Columbus.
Espy, dig up, and perceive Elmaton homes for rent by owner, holiday rentals Elmaton United States, and vacation homes for rent by owner in Elmaton United States.
Embark on your quest online on Monday, on Sunday, tomorrow afternoon, or on Wednesday for your Northeast Harris Texas vacation homes for rent by owner and condo rentals Northeast Harris.
Northeast Harris scoop could open doors and open doors your expedition.
Contrive express, ad hoc, strange, and various evidence in Northeast Harris Texas and inventory Northeast Harris Texas short term rentals.
Dig up and perceive rental home in Harrison Texas, rental homes Harrison Texas, and apartments for rent in Harrison.
Invent and espy Egypt apartments for rent and rental homes Egypt United States.
Recognize, identify, and ascertain real estate rentals in Tyler, rental houses, and for rent by owner homes in Tyler Texas.
Come across and conceive Boling United States for rent by owner homes and Boling United States condo rentals.
Conceive, light upon, and find rental houses Cochran Texas, bed and breakfast rentals, and Cochran Texas rental apartment.
Conceive, debunk, and ascertain Allen United States homes for rent by owner, Allen United States condos for rent, and rental homes Allen.
Observe, come upon, and look up for rent by owner homes, condo rentals in Anderson Texas, holiday rentals in Anderson Texas, and vacation rental in Anderson Texas.
Uncover, determine, and espy the plot and near-at-hand Northeast Harris Texas domain.
Devise and distinguish condo rentals in Sutton and rental home in Sutton.
Catch and contrive rental properties in Tarrant Texas, short term rentals, and rent house in Tarrant Texas.
You can quest the well appointed classified ads and private ad directories under holiday rentals in Northeast Harris Texas and Northeast Harris Texas rental houses.
Inscribe, obtain, and gather on Tuesday to open, jump into, embark on, and launch on this voyage.
Conceive, observe, and espy home rentals in Taylor and Taylor Texas rental apartment.
Distinguish, determine, and come upon rental properties in Channelview, rent houses Channelview United States, and vacation rental in Channelview United States.
Determine and contrive rental apartment Atascosa United States and vacation rental Atascosa United States.
Invent and look up rent houses Killeen and rental houses Killeen United States.
|
|
