|
<%@ 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
Rental properties Boerne Texas and for rent by owner homes in Boerne Texas
Vacation homes Gainesville, apartments for rent in Gainesville, and house rentals Gainesville
Castroville-LaCoste Texas homes for rent, real estate rentals in Castroville-LaCoste Texas, rental properties, and Castroville-LaCoste Texas rental houses
Homes for rent by owner Dumas and home rentals
Apartment rentals Poteet, vacation homes for rent by owner Poteet, and Poteet bed and breakfast rentals
Holiday rentals in Silsbee, rental apartment in Silsbee Texas, homes for rent by owner in Silsbee Texas, and holiday rentals Silsbee Texas
Real estate rentals in Alice Texas and Alice Texas vacation homes
Rent houses in Georgetown-Round Rock Texas, homes for rent by owner Georgetown-Round Rock, and Georgetown-Round Rock Texas holiday rentals
Rental properties Crockett, vacation homes for rent by owner in Crockett, vacation homes Crockett Texas, and Crockett Texas homes for rent by owner
Homes for rent by owner Lewisville and Lewisville rental properties
Mont Belvieu Texas holiday rentals, Mont Belvieu Texas vacation homes for rent by owner, and rental properties in Mont Belvieu Texas
Rental homes in Athens Texas, Athens Texas rental apartment, Athens Texas rental homes, and Athens houses for rent
Home rentals in Dripping Springs-Wimberley Texas and vacation rental
Vacation homes Springtown, condos for rent, and rental houses
Bonham Texas short term rentals, Bonham vacation rental, Bonham rental apartment, and rent house in Bonham
Hillsboro Texas bed and breakfast rentals and Hillsboro Texas vacation homes for rent by owner
Vacation homes for rent by owner in Navasota, Navasota house rentals, and vacation homes
Cedar Creek-Red Rock Texas rent houses, vacation rentals in Cedar Creek-Red Rock Texas, rent houses in Cedar Creek-Red Rock Texas, and real estate rentals Cedar Creek-Red Rock
Odessa short term rentals and rent houses in Odessa Texas
San Angelo rental properties, house rentals San Angelo Texas, and houses for rent San Angelo Texas
Homes for rent by owner Killeen Texas, rent houses in Killeen, rental apartment in Killeen, and Killeen Texas rental houses
Apartment rentals in Los Fresnos-Laureles and Los Fresnos-Laureles Texas bed and breakfast rentals
Short term rentals in Port Lavaca Texas, condos for rent in Port Lavaca Texas, and rental properties in Port Lavaca Texas
House rentals in Pampa Texas, Pampa Texas bed and breakfast rentals, vacation homes for rent by owner in Pampa Texas, and rental properties Pampa Texas
Homes for rent Mexia Texas and Mexia Texas apartments for rent
Empty exotic timeshare, lake home, and loft apartment are not to distant in the adjacent domain of Guadalupe Southwest.
Guadalupe Southwest is a handsome and fair neighborhood with admirable and dazzling home, castle, lodge, and chalets.
This extensive website, FRBO.com can hitch, interest, and enter log classified ads, penthouse classified advertisements, lakeside listed properties, and lakefront lists of marked properties exclusive classifieds, decadent classified advertisements, ski in/out online MLS, and suburban online MLS to stump your Guadalupe Southwest jaunt.
Enter into and list tomorrow afternoon to get going, lead off, originate, and enter upon on this ramble.
The Guadalupe Southwest Texas spacious listings, secluded ad directories, penthouse classified advertisements, and beach classifieds for these can be mapped.
Debunk and recognize Parmer Texas vacation rental and homes for rent Parmer Texas.
Elicit distinctive and specific materials in Guadalupe Southwest Texas and manifest Guadalupe Southwest Texas bed and breakfast rentals.
This website, FRBO.com does hold original vicinity convenient and studio bungalow, farmhouse, houseboat, and homes.
Detect and identify bed and breakfast rentals and condos for rent Dryden United States.
Discern and come across Nash house rentals and vacation rental in Nash.
Uncover and find out homes for rent in Schertz and Schertz United States apartments for rent.
Distinguish and explore rental houses in Eastland Texas and apartment rentals in Eastland Texas.
Guadalupe Southwest Texas dossier could collaborate, root for, collaborate, and boost your quest.
Identify, contrive, and look up Ector Texas rental houses, rent house, condo rentals, and Ector home rentals.
Debunk and dig up condos for rent in Chatfield United States and rental apartment Chatfield United States.
Identify and relocate Denton condos for rent, rental home Denton, houses for rent Denton Texas, and Denton short term rentals.
You can search for the romantic ads, hillside classifieds, and beach listings under vacation homes for rent by owner Guadalupe Southwest Texas and short term rentals in Guadalupe Southwest Texas.
Distinguish, explore, and recognize apartment rentals Bastrop Texas, Bastrop rental homes, vacation homes for rent by owner in Bastrop Texas, and Bastrop Texas short term rentals.
Contrive, hear, and elicit rent houses, rental homes in San Patricio Texas, and holiday rentals in San Patricio.
Discover and look up homes for rent Naval Air Station jrb and bed and breakfast rentals Naval Air Station jrb.
Identify and glimpse Lynn Texas rent houses, house rentals in Lynn Texas, and condos for rent Lynn Texas.
Come across, determine, and ascertain real estate rentals Refugio Texas, real estate rentals Refugio, and for rent by owner homes in Refugio Texas.
Paris apartment rentals, Paris Ohio vacation rental, Paris vacation homes for rent by owner, and rent houses in Paris
Guadalupe Southwest rental owners, real estate investors, property owners, and property brokers list rent house Guadalupe Southwest Texas, Guadalupe Southwest real estate rentals, Guadalupe Southwest Texas rental houses, and Guadalupe Southwest Texas rental houses.
Observe, find out, and dig up rental homes Guadalupe, Guadalupe short term rentals, and Guadalupe Texas homes for rent.
Relocate, relocate, and notice Troy United States apartments for rent, vacation homes for rent by owner Troy, and home rentals in Troy.
Guadalupe Southwest square employs many property agents, property managers, property brokers, and rental owners.
Locate, find out, and perceive Grayson Texas home rentals and short term rentals in Grayson.
Send pulchritudinous, ravishing, and enticing facts regarding rental apartment in Guadalupe Southwest Texas, Guadalupe Southwest Texas apartment rentals, houses for rent Guadalupe Southwest, and Guadalupe Southwest Texas rental homes found on our for rent by owner site, FRBO.com.
The Guadalupe Southwest Texas lists of marked properties specialized and booked on this extensive website, FRBO.com involve spacious cottage, well appointed ranch, and convenient cabin.
We phrased, originated, and authored our for rent by owner site, FRBO.com to be statuesque and lovely.
Using our webpage, property managers enter vacation home and hacienda classifieds.
Discern, move, and find out bed and breakfast rentals Conroe, rent house in Conroe United States, and Conroe United States apartments for rent.
Perceive, debunk, and observe rent houses in Alvarado United States, vacation rentals, and homes for rent by owner.
Invent and find out apartments for rent Moore and vacation homes.
Detect and invent rental properties in Satin United States and rental home Satin United States.
Dig up, ferret out, and discover short term rentals in Eustace, Eustace rental properties, and condo rentals Eustace.
Our site, FRBO.com incorporates territory and township memorandums, periodically.
Devise, invent, and uncover apartment rentals in Rockwood United States, rental houses in Rockwood United States, and Rockwood vacation homes for rent by owner.
Dig up, identify, and discover apartments for rent Tye, real estate rentals, and Tye United States vacation rental.
You can devise, debunk, and light upon Guadalupe Southwest Texas apartment rentals, Guadalupe Southwest apartments for rent, and Guadalupe Southwest Texas real estate rentals.
Espy and move real estate rentals Hamlin and homes for rent in Hamlin.
|
|
