Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T05:49:35.913' ,`MLSNumber` = '37958865' ,`ListAgentFullName` = 'Johnny Schiro' ,`ListOfficeName` = 'Icon Realty Group, L.L.C.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.094970' ,`Longitude` = '-95.451579' ,`PhotoCount` = '36' ,`PostalCode` = '77389' ,`RoomCount` = '10' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Dobbs View' ,`StreetNumber` = '70' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2031' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HUGE BACK YARD - with no rear neighbors! LUXURY new construction from Sullivan Brothers - Literally 30 seconds from Grand Parkway 99 and I-45, and STEPS from the Exxon Campus, HP, and the HOTTEST NEW RETAIL in Houston - CityPlace (much like City Centre, with 400,000 SQ FT of top-tier shopping & dining!!!) Wide-open main living space (up) with absolutely gorgeous double balcony doors overlooking the reserve - awesome natural light and a gorgeous view! Huge master suite with his & hers closets, soaking tub + oversized shower, and a private balcony! 10’ ceilings upstairs and down, generous secondary bedrooms, covered patio, and upgraded finishes throughout! All of this just 10 minutes from Market Street, 20 minutes from IAH, and 35 minutes from Downtown! Luxury lifestyle, true convenience...and HUGE APPRECIATION POTENTIAL. Limited homesites remain - come visit Harper Woods before we\'re sold out!' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Sullivan Brothers' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 Harper Woods Partial Replat 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '6197' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'NORTHGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harper Woods at Springwoods Village' ,`TaxAmount` = '' ,`TaxRate` = '3.087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667304587' WHERE `Matrix_Unique_ID` = '209321381' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T05:49:05.823' ,`MLSNumber` = '29621348' ,`ListAgentFullName` = 'Johnny Schiro' ,`ListOfficeName` = 'Icon Realty Group, L.L.C.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.092779' ,`Longitude` = '-95.450521' ,`PhotoCount` = '33' ,`PostalCode` = '77389' ,`RoomCount` = '10' ,`ListPrice` = '479000.00' ,`Status` = 'Active' ,`StreetName` = 'Thorpe' ,`StreetNumber` = '15' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2031' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Builder Close-out!! Last Opportunities from Sullivan Brothers in Harper Woods! LUXURY lifestyle, PRIME location, and no rear neighbors! Hard flooring throughout! Literally 30 seconds from Grand Parkway 99 and I-45, and STEPS from the Exxon Campus, HP, and the HOTTEST NEW RETAIL in Houston - CityPlace (much like City Centre, with 400,000 SQ FT of top-tier shopping & dining!!!) Wide-open main living space (up) with absolutely gorgeous double balcony doors overlooking the reserve - awesome natural light and a gorgeous view! Huge master suite with his & hers closets, soaking tub + oversized shower, and a private balcony! 10’ ceilings upstairs and down, generous secondary bedrooms, covered patio, and upgraded finishes throughout! All of this just 10 minutes from Market Street, 20 minutes from IAH, and 35 minutes from Downtown! Luxury lifestyle, true convenience...and HUGE APPRECIATION POTENTIAL. Limited homesites remain - come visit Harper Woods before we\'re sold out!' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Sullivan Brothers' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 Harper Woods Partial Replat 2' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '2629' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'NORTHGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harper Woods at Springwoods Village' ,`TaxAmount` = '' ,`TaxRate` = '3.087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667304587' WHERE `Matrix_Unique_ID` = '209321551' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T05:50:08.080' ,`MLSNumber` = '5511238' ,`ListAgentFullName` = 'Johnny Schiro' ,`ListOfficeName` = 'Icon Realty Group, L.L.C.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.092850' ,`Longitude` = '-95.451886' ,`PhotoCount` = '30' ,`PostalCode` = '77389' ,`RoomCount` = '7' ,`ListPrice` = '479000.00' ,`Status` = 'Active' ,`StreetName` = 'Thorpe' ,`StreetNumber` = '55' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1913' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Model Home - Builder CLOSING OUT! New LUXURY in Harper Woods at Springwoods Village - 30 seconds from Grand Parkway 99 and I-45, and STEPS from the Exxon Campus, HP, and the HOTTEST NEW RETAIL in Houston - CityPlace!! Pure charm & charisma from Sullivan Brothers - it’s that French Quarter style that you just can’t find elsewhere in North Houston! 3 bedrooms up including a HUGE primary bedroom with a PRIVATE BALCONY, open-concept island kitchen w/ gorgeous Quartz counter tops, a HUGE family room, and over 160 SF of covered patio! First class finishes throughout: 10’ ceilings up & down, gorgeous hardwoods, 8\' doors, elegant trim work, and upgraded fixtures & hardware. All of this just a short walk from Houston\'s newest and HOTTEST retail development! Don\'t miss YOUR OPPORTUNITY for one of the last homesites in the coveted Harper Woods! Luxury and convenience...with HUGE APPRECIATION POTENTIAL. Limited homesites remain - come visit Harper Woods before we\'re sold out!' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Sullivan Brothers' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 HARPER WOODS REPLAT 1' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '2667' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'NORTHGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harper Woods Springwoods Village' ,`TaxAmount` = '' ,`TaxRate` = '3.087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667304588' WHERE `Matrix_Unique_ID` = '209321707' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T05:24:59.030' ,`MLSNumber` = '40221222' ,`ListAgentFullName` = 'Claudia Hellmund' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747455' ,`Longitude` = '-95.519626' ,`PhotoCount` = '50' ,`PostalCode` = '77024' ,`RoomCount` = '14' ,`ListPrice` = '3200000.00' ,`Status` = 'Active' ,`StreetName` = 'MOTT' ,`StreetNumber` = '39' ,`StreetSuffix` = 'Lane' ,`City` = 'Piney Point Village' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6234' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Every once in a while you come across a very special home that makes your heart skip a beat...Opportunity awaits at one of the most private coveted streets at 39 Mott Lane, located in highly sought after Piney Point. This unique property offers expansive clean lines with a sophisticated contemporary sleek design that features modern geometry with the warmth of a sleek elegant architecture. Sits on an acre and a quarter elevated lot with a crisp mid century feel throughout. With it\'s stunning architecture and breathtaking views through the floor to ceiling glass windows and doors to the extensive lush grounds, reflective pool and bayou, this property stands out from the rest. Presents a front motor court, impressive gallery entry, formal living and dining with seamless fluidity to the outdoors. Gourmet kitchen open to breakfast area & family room catered for today\'s lifestyle. At second level offers 4 ensuite bedrooms plus luxurious primary retreat with grand bath, game room & laundry.' ,`Acres` = '1.2659' ,`Area` = '23' ,`BuilderName` = 'Woodmark Constructio' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 EVERGREEN POINT' ,`LotDesciption` = 'Ravine,Water View,Wooded' ,`LotSize` = '55143' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Evergreen Point' ,`TaxAmount` = '45615' ,`TaxRate` = '2.1721' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667304588' WHERE `Matrix_Unique_ID` = '210483994' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T05:29:55.833' ,`MLSNumber` = '2396434' ,`ListAgentFullName` = 'Adriana Perez' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = 'Adriana Perez' ,`SellingOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`Latitude` = '29.607354' ,`Longitude` = '-95.357275' ,`PhotoCount` = '31' ,`PostalCode` = '77047' ,`RoomCount` = '4' ,`ListPrice` = '330000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Kelsey Trail' ,`StreetNumber` = '3919' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2721' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 2 story home located in the sought-after Brunswick Lakes near the Medical center and Beltway 8. This 4-bedroom, 2 1/2 - bathroom home with a two car garage boasts an inviting floor plan and spaciousness in all of the living areas, kitchen, bedrooms, and game room. As you walk into the home you will notice the convenient and open floor plan and tile throughout the living areas. The exterior features a beautifully manicured front lawn and backyard. Call today to schedule your viewing appointment!' ,`Acres` = '0.132' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 BRUNSWICK LAKES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5751' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brunswick Lakes' ,`TaxAmount` = '6017' ,`TaxRate` = '2.6498' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667304588' WHERE `Matrix_Unique_ID` = '210657286' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T05:17:54.310' ,`MLSNumber` = '81849716' ,`ListAgentFullName` = 'Edward McClintick' ,`ListOfficeName` = 'Joseph Walter Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.004686' ,`Longitude` = '-95.194070' ,`PhotoCount` = '21' ,`PostalCode` = '77346' ,`RoomCount` = '6' ,`ListPrice` = '174999.00' ,`Status` = 'Active' ,`StreetName` = 'Leaning Timbers' ,`StreetNumber` = '19510' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1538' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DONT MISS THIS ONE!!!!!! \r\nWant to be close to everything - this is your place! This Humble one-story home is an open canvas for you to make your own, this home offers 4 beds, 2 baths, 1,538 SqFt, a large patio, and a spacious garage. A great house in an amazing neighborhood. Showings have started so don\'t miss your chance to BranchOut to Humble, Texas!' ,`Acres` = '0.1722' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 8 ATASCOCITA WEST SEC 2' ,`LotDesciption` = 'Other' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Atascocita West Sec 02' ,`TaxAmount` = '3859' ,`TaxRate` = '2.613' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667304588' WHERE `Matrix_Unique_ID` = '212309885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T05:52:56.450' ,`MLSNumber` = '8260431' ,`ListAgentFullName` = 'Angela Wills' ,`ListOfficeName` = 'Heritage Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.378386' ,`Longitude` = '-95.078471' ,`PhotoCount` = '27' ,`PostalCode` = '77510' ,`RoomCount` = '4' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Old Spanish' ,`StreetNumber` = '11826' ,`StreetSuffix` = 'Trail' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1374' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated 3 Bedroom 2 Bath home located in Santa Fe Trails. This open concept home offers may windows to allow natural light. Wood laminate flooring in all bedrooms and Closets. Updated paint throughout home with stylish accent wall in breakfast area. Large kitchen that overlooks the family room. Large primary bedroom. Primary bathroom with double sinks and shower with a built-in seat. The backyard has a covered patio and fully fenced back yard. New garage door and nice landscaping. This home is a must see.' ,`Acres` = '0.1515' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE TRAILS PHASE TWO (2003) ABST 149, BLOCK 3, LOT 7, A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '161' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'WILLIAM F BARNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe Trails Ph Two' ,`TaxAmount` = '4975' ,`TaxRate` = '2.6465' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667304588' WHERE `Matrix_Unique_ID` = '213018122' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T05:25:58.093' ,`MLSNumber` = '48409946' ,`ListAgentFullName` = 'Claudia Hellmund' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749755' ,`Longitude` = '-95.629645' ,`PhotoCount` = '50' ,`PostalCode` = '77077' ,`RoomCount` = '12' ,`ListPrice` = '969000.00' ,`Status` = 'Active' ,`StreetName` = 'NEILS BRANCH' ,`StreetNumber` = '13614' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4559' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous Mediterranean Residence at a prestigious corner lot location just steps away from the lake & walking trails.Nestled at sought after Lakes of Parkway manned gated community. This home exudes elegance, provides you more of what you want most... private settings, gorgeous & exquisite attention to detail- resulting in a design with an amazing easy flow floor plan with stunning tile flooring, handsome wood-paneled study, formal living, spacious dining room with splendid views of backyard-pool oasis, wine room with a capacity for over 200 bottles,a chef\'s kitchen open to breakfast room and spacious family room with a beautiful fireplace and views of the breathtaking outdoor space with covered patio, summer kitchen, magnificent pool & awesome garden & a three car garage, round out this home. Presents a Primary bedroom and sought after second ensuite down & offers two ensuite bedrooms up and game room. A wonderful entertaining home that has been impeccably maintained. Click Video Icon' ,`Acres` = '0.2684' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 2 LAKES OF PARKWAY SEC 1 R/P' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11692' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'LAKES OF PARKWAY' ,`TaxAmount` = '17037' ,`TaxRate` = '2.3907' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667304589' WHERE `Matrix_Unique_ID` = '213077425' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T05:45:21.560' ,`MLSNumber` = '74230967' ,`ListAgentFullName` = 'Derek Lewis' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.772125' ,`Longitude` = '-95.317104' ,`PhotoCount` = '6' ,`PostalCode` = '77020' ,`RoomCount` = '4' ,`ListPrice` = '238000.00' ,`Status` = 'Active' ,`StreetName` = 'San Jose' ,`StreetNumber` = '5406' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1152' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Prime! Prime!! Prime!!! Location!!!!\r\n\r\nJust 5 minutes from Downtown and a Block over from I-10\r\nCome & take ownership of this Jewel of a property (Location Wise)\r\nThe placement of this property is just great, enjoy the gorgeous Skyline, it\'s extremely close to the upcoming Mall, it\'s also not far from the upcoming over $300 Million dollar expansion of Buffalo Bayou Park\r\nWe believe that this will be one of the most sought after areas within Houston in the coming future, come and build your DREAM home.. It\'s waiting for you.' ,`Acres` = '0.1814' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 2 & 3 BLK 1 BUENA VISTA' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HENDERSON N ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Buena Vista' ,`TaxAmount` = '822' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667304589' WHERE `Matrix_Unique_ID` = '213180014' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T05:22:35.543' ,`MLSNumber` = '7177669' ,`ListAgentFullName` = 'Mariam Hejazi' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.640759' ,`Longitude` = '-95.193960' ,`PhotoCount` = '46' ,`PostalCode` = '77504' ,`RoomCount` = '7' ,`ListPrice` = '469000.00' ,`Status` = 'Active' ,`StreetName` = 'Young' ,`StreetNumber` = '4617' ,`StreetSuffix` = 'Street' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1903' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This little home has held a lot of love over the years and is now ready for a new journey in life. House has great bones, two barns, an oversized two car garage, and a sparkling pool. Tons and tons of potential: perfect for the buyer needing a wood or mechanical shop, or with additional vehicles, a boat, ATVs, FFA projects, or couple of horses. Per survey, lot dimensions are 85.5ft wide x 660ft long. Room dimensions approximate, buyer to independently verify.' ,`Acres` = '1.25' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 114A N 1/2 OF S 1/2 OF LT 114 HIGHLAND ACRES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '54450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'MILLER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Acres' ,`TaxAmount` = '6375' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667304589' WHERE `Matrix_Unique_ID` = '213222621' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T05:53:50.503' ,`MLSNumber` = '31270755' ,`ListAgentFullName` = 'Lily Jang' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.810350' ,`Longitude` = '-95.391375' ,`PhotoCount` = '27' ,`PostalCode` = '77008' ,`RoomCount` = '4' ,`ListPrice` = '770000.00' ,`Status` = 'Active' ,`StreetName` = '26th' ,`StreetNumber` = '626' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2808' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out the newest gem on the market in one of Houston\'s most sought-after neighborhoods. Near 610, 45, I-10 and walking distance to ample restaurants and grocery stores. This immaculate, Victorian style home *w/ a built out garage apartment* has only been loved by one owner. The beautiful curb appeal leads you up to the charming front porch and into the house, where you are greeted by hardwood floors. Main house features open-concept, highly-desirable floor plan w/ all bedrooms up. The sizable garage apartment with full bathroom can be accessed by side gate or through main house. Kitchenette can easily be added, making this the perfect rental or private quarters for friends & family. Backyard is fully fenced and pet friendly. Upgrades: 2022 tankless gas water heater in garage apartment, 2022 GE range w/ wifi, full exterior/interior painting & 2022 evaporator coils in both HVAC units. Welcome home.' ,`Acres` = '0.0689' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 40 SUNSET HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional,Victorian' ,`Subdivision` = 'Sunset Heights' ,`TaxAmount` = '14688' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667304589' WHERE `Matrix_Unique_ID` = '213326943' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T05:08:35.587' ,`MLSNumber` = '6343128' ,`ListAgentFullName` = 'Robert Griffith' ,`ListOfficeName` = 'Circa Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.769744' ,`Longitude` = '-95.412712' ,`PhotoCount` = '48' ,`PostalCode` = '77007' ,`RoomCount` = '6' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Lillian' ,`StreetNumber` = '5104' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2386' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great new price!! STUNNING contemporary home with private driveway, gated entry and fenced yard! No expense was spared in this TOTAL to the studs remodel! Everything was replaced and updated including windows, floors, custom cabinets, custom LED lighting, HVAC and more! True gourmet kitchen with high-end stainless KitchenAid appliances, gas cooking, warmer oven, wine fridge, pantry, large island with LOTS of storage and seating, quiet close doors and drawers galore! Luxurious primary suite with HUGE walk-in closet, soaker tub, separate shower and water closet. With a beautiful modern fireplace as its focal point, the HUGE living room is full of natural light, high ceilings, wood floors and lots of flexible space. NO CARPET, NO HOA, PRIVATE, DOUBLE-WIDE DRIVEWAY, FENCED YARD. Very walkable, centrally located area with restaurants, bike trails, shopping, bars, gyms and more. Buffalo Bayou and Memorial Parks are both close by. Perfect location no matter where you work or need to be!.' ,`Acres` = '0.0425' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 ROY TRIPLES' ,`LotDesciption` = 'Corner,Patio Lot,Subdivision Lot' ,`LotSize` = '1850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Other Style,Split Level' ,`Subdivision` = 'Rice Military/West End/Memorial Park' ,`TaxAmount` = '10832' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667304589' WHERE `Matrix_Unique_ID` = '213410849' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T05:26:38.387' ,`MLSNumber` = '50618688' ,`ListAgentFullName` = 'Claudia Hellmund' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749354' ,`Longitude` = '-95.634436' ,`PhotoCount` = '50' ,`PostalCode` = '77077' ,`RoomCount` = '10' ,`ListPrice` = '960000.00' ,`Status` = 'Active' ,`StreetName` = 'BARNHART' ,`StreetNumber` = '14118' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4236' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled amongst the trees of Lakes of Parkway lies this amazing Mediterranean Style Home offering a beautiful resort style pool, amazing floorplan, energy efficient tile roof, 4 bed/3 1/2 baths and a clean crisp fresh feel throughout. Offers an elegant entry and a front drawing-study room, spacious formal dining room with wide wood flooring, a chef\'s kitchen that overlooks the breakfast area & family room with amazing breathtaking views of the fantastic backyard and sparkling pool. At second level presents a huge game room and 3 very spacious secondary bedrooms and 2 baths. This is a fabulous property with an Amazing location just steps away from lakes and walking trails it is zoned to highly sought after schools. Never flooded! See it today! and come and fall in love. Please click on the movie icon to immerse on a 3D Video and floorplan.' ,`Acres` = '0.25' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 11 LAKES OF PARKWAY 5 R/P & AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10890' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'LAKES OF PARKWAY' ,`TaxAmount` = '21191' ,`TaxRate` = '2.3907' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667304590' WHERE `Matrix_Unique_ID` = '213647014' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T05:43:02.987' ,`MLSNumber` = '36430191' ,`ListAgentFullName` = 'Anisa Hoxha' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801453' ,`Longitude` = '-95.554534' ,`PhotoCount` = '50' ,`PostalCode` = '77043' ,`RoomCount` = '8' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'Haddington' ,`StreetNumber` = '10410' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2069' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully fully remodeled home located in the sought-after neighborhood of Shadow Oaks features charm, character and many updates! The updates include fresh new exterior paint, custom kitchen cabinetry, updated bathrooms, raised ceilings, tile flooring and so much more. Throughout the home, you will find beautiful wood look tile flooring and well as double pane windows offering sunlight and a gorgeous view to the backyard garden. The garden truly is one of a kind and a must see!! The primary suite is as big as you will find in any home! Only minutes away from I-10, Memorial Mall, Town & Country City Center and the Energy Corridor makes this home a trendy and convenient location. Schedule your appointment today!' ,`Acres` = '0.2009' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 14 SHADOW OAKS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Oaks Sec 05' ,`TaxAmount` = '9736' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667304590' WHERE `Matrix_Unique_ID` = '213671863' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T05:07:31.457' ,`MLSNumber` = '84056171' ,`ListAgentFullName` = 'Erica Alvarez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.380737' ,`Longitude` = '-95.479594' ,`PhotoCount` = '23' ,`PostalCode` = '77303' ,`RoomCount` = '5' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Rain' ,`StreetNumber` = '4914' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2675' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Thank you for your interest in Summer Wood. We are excited to showcase this beautiful home that’s truly been cared for by its owners. \r\nThe living room is spacious with an open concept, high ceilings and excellent lighting throughout the house. The kitchen boasts granite top counters, a breakfast area and plenty of cabinet space for your cooking needs. The game room upstairs has an additional storage and can easily be used as an office. The back yard is its own private oasis with its own private HEATED pool and beautiful landscaping including fruit bearing trees! \r\nYou won’t want to miss this gem! Room sizes are approximate and HOA information needs to be verified. Survey attached and warrenty information will be provided upon request. Make your appointment today....It won\'t last!' ,`Acres` = '0.1366' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S906400 - SUMMER WOOD 01, BLOCK 2, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'A.R. TURNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level' ,`Subdivision` = 'Summer Wood' ,`TaxAmount` = '5631' ,`TaxRate` = '2.1823' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667304590' WHERE `Matrix_Unique_ID` = '213829230' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T04:58:57.770' ,`MLSNumber` = '43826338' ,`ListAgentFullName` = 'Carolyn Payton' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Carolyn Payton' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.669681' ,`Longitude` = '-95.485160' ,`PhotoCount` = '14' ,`PostalCode` = '77096' ,`RoomCount` = '6' ,`ListPrice` = '399999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wigton' ,`StreetNumber` = '5642' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '3433' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pre-forclosure . All Offers must be approved by Lender. NEVER FLOODED. This 4/2 & Garage Apt 2/1 has been remodeled. Professionally Renovated Kitchen & Baths! Spacious & Flexible Floorplan Offers a Game Room/Flex Room, Mud Room,& Full Quarters (above the Garage).Spacious Formal Dining Room w/ Brushed Nickel Chandelier & Bltin Serving Buffet.Remodeled & Expanded Kitchen Boasts Custom Style Raised Panel Wood Cabinets (with Glass Front),SS Gas Range,SS Double Ovens,SS Vent Hood,Granite Counters,Tile Backsplash,Custom Designed Breakfast Bar, & Butlers Pantry with Bltin Wine Rack.Den Opens to Gameroom/Flex Room - Open Flowing Floorplan.' ,`Acres` = '0.1983' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Pre-Foreclosure,Sellers Disclosure,Short Sale' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 5 BARKLEY SQUARE SOUTH SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Barkley Square South Sec 01 R/' ,`TaxAmount` = '8184' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667304590' WHERE `Matrix_Unique_ID` = '214162436' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T05:59:59.470' ,`MLSNumber` = '85209563' ,`ListAgentFullName` = 'Lily Jang' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.218298' ,`Longitude` = '-95.572045' ,`PhotoCount` = '28' ,`PostalCode` = '77354' ,`RoomCount` = '3' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Creek' ,`StreetNumber` = '32911' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1744' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful, meticulously maintained 1-story brick home situated on 21,000 SF of land in the Westwood Subdivision of Magnolia. Close to grocery, restaurants, and shopping, but also tucked away on a peaceful, tree-lined street. The expansive, fully-fenced backyard is an entertainer\'s dream w/ a 2017 custom built-in covered patio/deck w/ full electrical wiring. Perfect for hosting cookouts on football weekends. Inside, freshly painted walls greet you. Upon entry to the left is your formal dining. To the right are two secondary bedrooms and a full bathroom. Just ahead of the entry is your family room that seamlessly opens up to the breakfast nook and kitchen with a breakfast counter that seats up to 6. The primary bedroom is in the back of the home and overlooks the quiet backyard. Primary bath features dual vanities, a separate soaking tub and standup shower with an amazing customized walk-in closet. New 2022 roof, new 2022 HVAC, new paint and ready for new owners.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD 01, BLOCK 6, LOT 41' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '21000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '230' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'WESTWOOD 01' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667304590' WHERE `Matrix_Unique_ID` = '214166411' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214233874','1667304591','214233874','2022-11-01T05:57:29.400','12511373','Rory Higgins','Castle Team','','','29.740603','-95.470224','42','77056','8','774900.00','Active','Milan','14','Estates','Houston','3','1','4','3405','Single-Family','Gorgeous home in an exclusive gated enclave in the heart of the Galleria. Stunning hardwoods, high ceilings, 2 fireplaces, and custom plantation shutters are just a few of the features that make this home special. Tastefully updated kitchen features honed granite, stainless steel appliances including a wine fridge. The second floor includes 3 spacious bedrooms and the laundry room. All bedrooms are large, but the primary bedroom is truly oversized. The primary bath is beautifully appointed and features an enormous walk-in closet. The fourth bedroom is located privately on the third flood and would make a perfect home office. This quiet complex includes a dog walk area. Located minutes from the world famous Galleria, you are truly minutes from the finest shopping and restaurants in Houston.','0.0592','22','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','2','Galleria','Central Gas','1','TR 11 BLK 1 MILAN PLACE','Subdivision Lot','2580','Appraisal District','','14218','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','BRIARGROVE ELEMENTARY SCHOOL','WISDOM HIGH SCHOOL','TANGLEWOOD MIDDLE SCHOOL','Appointment Required,Controlled Access,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','3','Mediterranean,Traditional','Milan Place','14218','2.33066','Public Sewer,Public Water','1997','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214263811','1667304591','214263811','2022-11-01T04:53:57.287','98364892','Salvador Martinez','Texas Properties & Associates','','','29.633569','-95.359002','0','77047','4','169900.00','Active','Tavenor','4402','Lane','Houston','1','0','3','912','Single-Family','1 STORY BRICK HOME,3 BEDROOM,1 BATHROOM,LARGE LIVINGROOM,KITCHEN WITH DINING AREA,1 CAR GARAGE ATTACHED,SPACIOUS BACKYARD WITH WOOD PRIVACY FENCE.','0.1567','3','','','Gas Dryer Connections','','No Disclosures','0','','','Medical Center South','Central Electric','0','LT 7 BLK 14 CLOVERLAND SEC 3','Subdivision Lot','6825','Appraisal District','','','0','','1','Gas Oven','0','','','Electric Range','','Composition','27 - Houston','LAW ELEMENTARY SCHOOL','WORTHING HIGH SCHOOL','THOMAS MIDDLE SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Ranch,Traditional','Cloverland Sec 03','2220','2.3307','Public Sewer,Public Water','1957','Appraisal District'); --> New record created successfully