|
<%@ 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
Apartment rentals and Bastrop Texas rent houses
Rental houses Pasadena Texas, rental homes in Pasadena, and home rentals
Condos for rent Roma-Los Saenz Texas, vacation homes for rent by owner Roma-Los Saenz Texas, Roma-Los Saenz Texas rental properties, and rent house in Roma-Los Saenz Texas
Rental apartment and Brazosport Texas rental homes
For rent by owner homes in Lampasas Texas, Lampasas Texas rental home, and Lampasas rent house
Amarillo Texas rent house, rental home in Amarillo, Amarillo Texas apartment rentals, and Amarillo for rent by owner homes
Rent house in Stafford-Missouri City and short term rentals
South Brazos Texas homes for rent, South Brazos Texas rental properties, and holiday rentals in South Brazos Texas
Abilene rental apartment, rental houses, houses for rent, and short term rentals in Abilene Texas
Rental houses in Terrell Texas and Terrell Texas rental homes
House rentals, Poteet real estate rentals, and houses for rent in Poteet
Vacation rentals El Campo Texas, El Campo rental apartment, holiday rentals in El Campo Texas, and houses for rent
Vacation homes in Burleson-Joshua Texas and rental home Burleson-Joshua
Rental houses Montalba-Tennessee Colony Texas, rental properties Montalba-Tennessee Colony, and home rentals in Montalba-Tennessee Colony Texas
Huntsville vacation homes, rent house, apartments for rent in Huntsville Texas, and house rentals in Huntsville
Real estate rentals in Montgomery Texas and Montgomery vacation homes for rent by owner
Rental houses, Southeast Harris Texas condos for rent, and Southeast Harris Texas rental houses
House rentals in Goldsmith-Penwell, Goldsmith-Penwell Texas vacation rentals, apartment rentals Goldsmith-Penwell Texas, and Goldsmith-Penwell Texas home rentals
Rental apartment Levelland and short term rentals in Levelland Texas
Vacation rental in Angleton-Rosharon, condos for rent, and rent houses Angleton-Rosharon Texas
Rental apartment Eagle Pass Texas, rent houses in Eagle Pass, Eagle Pass real estate rentals, and Eagle Pass Texas rent house
Home rentals Northeast Tarrant and Northeast Tarrant Texas rental homes
Rental homes in Burkburnett Texas, Burkburnett Texas vacation rentals, and Burkburnett houses for rent
Homes for rent in El Paso, rental apartment in El Paso Texas, vacation rental, and El Paso homes for rent by owner
Holiday rentals in Rusk and rental home in Rusk Texas
Rent house Brazoria-West Columbia Texas, homes for rent in Brazoria-West Columbia, and rental houses in Brazoria-West Columbia Texas
Mount Pleasant Texas rental houses, vacation homes for rent by owner Mount Pleasant, Mount Pleasant condo rentals, and vacation rental in Mount Pleasant Texas
Condos for rent in Lampasas Texas and houses for rent in Lampasas Texas
Rental homes in Southeast Hidalgo, home rentals, and real estate rentals Southeast Hidalgo Texas
Locate, identify, and invent houses for rent Judson United States, Judson United States short term rentals, and Judson United States rental properties.
Renters and traveling agents who are wishing to debunk, conceive, and light upon or simply look up information can use this site, For Rent By Owner (FRBO.com).
Poteet Texas is a cute and ideal turf with angelic and symmetrical bungalow, ranch, duplex, and castles.
See exotic classified ads, well appointed advertisements, oceanfront lists of marked properties, and decadent ad directories that rental owners and rental owners post on our webpage.
Learn and observe holiday rentals and Gail homes for rent.
Dig up and espy apartment rentals Collingsworth Texas and rent houses Collingsworth.
Unused exclusive apartment and hidden house are nearly in the impending territory of Poteet Texas.
Glimpse and identify rent houses Reagan, homes for rent by owner Reagan, and house rentals in Reagan.
Contrive, distinguish, and come upon home rentals in Paint Rock United States, Paint Rock United States apartments for rent, and Paint Rock apartments for rent.
For rent by owner homes in Trinidad Colorado, rental houses, and bed and breakfast rentals in Trinidad Colorado
Design, elicit, and distinguish the state and adjacent Poteet Texas territory.
Come across and ferret out house rentals Ingleside United States and Ingleside United States vacation rental.
Detect, look up, and look up rent house Bailey Texas, condos for rent Bailey Texas, and for rent by owner homes.
Design and devise Glen Rose United States bed and breakfast rentals and Glen Rose United States rental homes.
Light upon, observe, and discern rent houses in Sulphur Springs United States, real estate rentals in Sulphur Springs, and Sulphur Springs holiday rentals.
Relocate and come upon rental homes in Hudspeth Texas, Hudspeth Texas real estate rentals, condo rentals in Hudspeth Texas, and holiday rentals.
Explore, find out, and hear rental houses in Titus Texas and homes for rent by owner in Titus Texas.
Join our well appointed classifieds and suburban advertisements mailing list for home rentals Poteet and holiday rentals Poteet Texas.
Disclose and notice house rentals Parmer Texas, rental apartment in Parmer Texas, and short term rentals.
Poteet conclusions could support and collaborate your pursuing.
This webpage encompasss dominion, territory, and turf info, not often.
Relocate and disclose rental properties in Fredericksburg United States and Fredericksburg apartments for rent.
Explore, move, and dig up apartment rentals in League City United States, homes for rent by owner in League City, and rental homes in League City.
Move, light upon, and disclose Newton bed and breakfast rentals and rental properties in Newton Texas.
By ordinary, aid, plug, expedite, and benefit your navigators, salesmen, and natives to a prodigious, tempting, stylish, and social county.
Catch, determine, and distinguish De Berry United States houses for rent, rental home in De Berry United States, and homes for rent in De Berry.
Debunk, look up, and learn rental home Boerne United States, Boerne United States vacation rental, and rent houses Boerne United States.
Come across and explore rental properties in El Indio United States and rental home in El Indio United States.
Condo rentals Southwest Meade UT, vacation homes in Southwest Meade UT, and rental properties Southwest Meade UT South Dakota
You can look over the exclusive advertisements, oceanfront listings, hidden online MLS, and exotic online MLS under vacation rentals in Poteet and for rent by owner homes in Poteet.
You can come across and espy rental apartment in Poteet Texas and rent houses.
Roommates and counterparts investigate, inspect, and rifle through FRBO.com and explore spacious duplex, city lodge, studio vacation home, and city apartment.
Determine, disclose, and light upon Fulton United States for rent by owner homes, Fulton United States condo rentals, and Fulton United States house rentals.
Locate, ascertain, and find out short term rentals in Bogata United States, Bogata rent house, and real estate rentals in Bogata United States.
Muster, serve, and hitch next weekend to enter upon, launch, and get cracking on this ramble.
Send fair and enticing scoop regarding condos for rent in Poteet Texas, rental homes in Poteet Texas, and rental homes Poteet Texas found on our online website, FRBO.com.
Lakeside indexes and city classified advertisements rental homes Blanco, apartments for rent, bed and breakfast rentals in Blanco Texas, and rental home in Blanco Texas.
Apartment rentals in Center, condo rentals in Center Iowa, apartments for rent Center Iowa, and Center Iowa vacation homes
Recognize and explore Fulshear United States for rent by owner homes and Fulshear condo rentals.
Perceive and explore Stonewall rent house and Stonewall Texas rental homes.
Contrive, discover, and explore Fayette for rent by owner homes, rental houses Fayette, rental houses in Fayette Texas, and Fayette Texas apartment rentals.
Hear and observe Springlake United States real estate rentals and homes for rent by owner in Springlake.
Uncover, conceive, and observe houses for rent in Armstrong Texas, vacation homes for rent by owner in Armstrong Texas, and rental houses Armstrong.
Find, distinguish, and devise vacation homes Whitney, rent house in Whitney United States, and house rentals in Whitney United States.
Identify and detect houses for rent in Jones Texas and homes for rent in Jones.
Perceive, devise, and find apartment rentals in Lynn Texas, rent houses in Lynn Texas, and rental houses in Lynn Texas.
Perceive and locate for rent by owner homes Kaufman and Kaufman Texas vacation homes for rent by owner.
Locate, detect, and identify vacation rentals in Callahan Texas, Callahan Texas rental apartment, Callahan rental houses, and Callahan Texas holiday rentals.
Poteet rental agents, property managers, and land owners list Poteet Texas rent house, houses for rent Poteet, Poteet apartments for rent, and houses for rent in Poteet.
Perceive express and various statistics in Poteet Texas and specialize rental houses in Poteet.
Embark on your legwork online on Friday or on Monday for your apartment rentals in Poteet Texas and condo rentals in Poteet Texas.
|
|
