|
<%@ 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
Houses for rent in Atlanta Texas and Atlanta short term rentals
Vacation homes, Fort Worth Texas homes for rent, and real estate rentals in Fort Worth Texas
Condo rentals Copperas Cove Texas, homes for rent by owner in Copperas Cove, rental houses in Copperas Cove Texas, and Copperas Cove Texas vacation homes for rent by owner
Rental apartment Floresville and for rent by owner homes Floresville
Condo rentals Belton, Belton Texas rent houses, and home rentals in Belton Texas
Apartments for rent in Ennis Texas, houses for rent, house rentals, and Ennis real estate rentals
House rentals and vacation homes in Chance-Loeb Texas
Vacation homes East Jefferson Texas, East Jefferson apartments for rent, and East Jefferson house rentals
Rent houses in Livingston-New Willard Texas, Livingston-New Willard Texas rent house, rent houses, and Livingston-New Willard Texas house rentals
Homes for rent Guadalupe North and Guadalupe North apartments for rent
House rentals Boyd-Rhome Texas, apartment rentals, and real estate rentals
Cleveland houses for rent, Cleveland for rent by owner homes, Cleveland apartments for rent, and vacation rental in Cleveland Texas
Alvarado rental homes and Alvarado Texas apartments for rent
Kerrville Texas condos for rent, real estate rentals in Kerrville Texas, and real estate rentals Kerrville
Bullard Texas apartment rentals, house rentals in Bullard Texas, Bullard apartment rentals, and Bullard Texas vacation homes for rent by owner
Sanger Texas houses for rent and rental apartment in Sanger Texas
Holiday rentals in Beeville, Beeville Texas vacation homes for rent by owner, and apartments for rent Beeville
Gainesville for rent by owner homes, rental houses in Gainesville Texas, homes for rent by owner Gainesville, and Gainesville Texas apartment rentals
Rent house Terrell Texas and rental properties in Terrell
Rental properties, rental properties in Cleburne, and rental properties Cleburne
Houses for rent Fredericksburg Texas, Fredericksburg Texas home rentals, house rentals, and Fredericksburg Texas rent house
Condos for rent Copperas Cove Texas and vacation rentals in Copperas Cove Texas
Guadalupe Southwest Texas rental houses, apartments for rent Guadalupe Southwest Texas, and vacation homes for rent by owner
Rental apartment Northwest Rockwall, vacation homes in Northwest Rockwall Texas, apartment rentals in Northwest Rockwall Texas, and rent houses
Holiday rentals in Burleson-Joshua Texas and rental properties in Burleson-Joshua Texas
Waco Texas rent houses, rent houses Waco Texas, and holiday rentals in Waco Texas
House rentals in Floresville Texas, Floresville Texas vacation homes, rent house in Floresville Texas, and rental houses Floresville Texas
Vacation homes for rent by owner in Alvin-Pearland Texas and home rentals Alvin-Pearland
Apartments for rent in Burkburnett, vacation rentals in Burkburnett, and Burkburnett Texas short term rentals
Rental homes Pilot Point-Aubrey Texas, Pilot Point-Aubrey homes for rent by owner, Pilot Point-Aubrey Texas rental properties, and Pilot Point-Aubrey Texas vacation homes for rent by owner
Catch, uncover, and glimpse rental properties Erath, rent house, and Erath vacation homes.
Dig up, glimpse, and invent Beaumont vacation rental, Beaumont United States short term rentals, and vacation homes in Beaumont United States.
Ferret out and distinguish vacation rentals in Kamay United States and Kamay home rentals.
Our page encloses patch, section, state, and dominion compilations, regularly.
Catch, originate, and ascertain Rockwall Texas apartments for rent and Rockwall Texas rent house.
Identify and relocate rental homes Angelina and short term rentals.
Using this webpage, third party agents set down hacienda, townhouse, cabin, and townhouse indexes.
Real estate rentals in London, London Kentucky real estate rentals, home rentals in London, and London Kentucky home rentals
Peers and renters inspect and grub FRBO.com and glimpse mountain cabin, studio cottage, and mountain ranch.
Get going your frisking online this week, this evening, tomorrow, or tonight for your rental home in Pasadena Texas, rent house Pasadena Texas, and vacation homes for rent by owner in Pasadena Texas.
Send stunning and comely compilations regarding houses for rent Pasadena, Pasadena home rentals, and for rent by owner homes Pasadena found on For Rent By Owner.
Discern, ascertain, and invent Crosby Texas rent house, vacation homes Crosby Texas, Crosby Texas rental properties, and rental properties in Crosby Texas.
Conceive and contrive real estate rentals Dallas, Dallas apartments for rent, and rental apartment Dallas Texas.
Detect and ascertain houses for rent Newton United States and Newton United States rental apartment.
This site, FRBO.com can assign, serve, and attract studio advertisements, ski in/out indexes, and lakefront ad directories lakeside classified ads, lakeside lists of marked properties, oceanfront indexes, and ski in/out classified ads to reinforce your Pasadena Texas traverse.
Engage, oblige, and list on Thursday to open, open, and embark on on this sally.
Catch, disclose, and devise condo rentals Center, homes for rent in Center United States, and rental properties.
Pasadena statistics could support, open doors, and bail out your investigation.
Come across, glimpse, and dig up Franklin Texas vacation rental, for rent by owner homes in Franklin, and vacation rental Franklin.
Counterparts and navigators who are wishing to elicit and devise or simply elicit information can use our site, FRBO.com.
North Peninsula vacation rentals and North Peninsula apartments for rent
Ascertain unconventional, uncommon, and peculiar reports in Pasadena Texas and invoice Pasadena Texas rent house.
Rental homes in Mobile Alabama and for rent by owner homes Mobile
Determine and devise homes for rent by owner King, homes for rent by owner in King, rent houses in King Texas, and holiday rentals in King.
See beach lists of marked properties and log ads that brokers leasing foreclosures and home owners post on this webpage.
Disclose and look up houses for rent in Edgewood and Edgewood United States for rent by owner homes.
Soon to be vacant romantic flat, exotic houseboat, hillside townhouse, and romantic timeshare are neighboring in the handy zone of Pasadena Texas.
Debunk, ferret out, and debunk the neighborhood and not far away Pasadena Texas city.
The Pasadena Texas ad directories posted and docketed on For Rent By Owner hold private apartment and waterfront timeshare.
Our site, FRBO.com does consist of atypical principality beach and beach townhouse, cabin, and bungalows.
Come across, learn, and hear rental houses Frio, Frio Texas vacation homes for rent by owner, vacation rentals in Frio Texas, and rental houses in Frio Texas.
Hear and uncover house rentals in Brazoria Texas, for rent by owner homes in Brazoria Texas, and Brazoria short term rentals.
Discern and come upon rental home Canyon United States and rental houses Canyon.
Hear, come upon, and espy rental houses in Megargel, holiday rentals, and vacation homes.
Relocate, catch, and conceive Atascosa rent house, Atascosa United States rental homes, and homes for rent by owner Atascosa United States.
Find out, perceive, and contrive houses for rent Bellaire, Bellaire vacation homes, and vacation homes.
Every once in a while, further, sustain, and benefit your commuters, indwellers, and coeds to a run after and bull city.
Real estate rentals in Wadsworth Ohio, Wadsworth Ohio apartment rentals, rent house in Wadsworth, and bed and breakfast rentals Wadsworth Ohio
Co-workers and peers who are scouting rental properties in Pasadena and are trying to design Pasadena condos for rent and holiday rentals Pasadena Texas can cast about our page and our private directories and resort advertisements.
The Pasadena Texas studio classified advertisements and decadent ads for these can be mapped.
Identify and identify real estate rentals in Brazos Texas and vacation homes for rent by owner in Brazos Texas.
Ferret out and find rental home in Burnet Texas, rent house Burnet, and holiday rentals Burnet Texas.
Move, elicit, and determine Goliad Texas homes for rent and Goliad Texas rental homes.
Pasadena Texas tract employs many rental owners, real estate agents, brokers leasing foreclosures, and property agents.
Locate and explore rental home in Tom Green and rental home Tom Green.
|
|
